By using this website, you agree to our Terms of Use (click here)
I created a report using a number of custom attributes as well as other standard fields in the VendorR table. I would like to sort the data by one of my custom attributes however when I enter the custom field as the Data Field in the Sorting and Grouping table of the schema builder, it doesn't actually work. The custom field is set up as a text field but only numbers are entered into the field on the vendor. Any suggestions on how to get the report to sort by this custom field?
Can you attach the RPX?
@lauracarpenter Two things:
1. Can you show a screenshot of the sorting area?
2. Is the Attribute a Combo Box and, if so, could it be sorting on the IDs rather than the displayed values?
@timrodman I think this is what you are looking for.
As far as the type on the Attribute, I have it set up as text control on the attribute, not a combo box.
Here is what I'm getting when I run the report.
I also notice when I run the report and look at the Additional Sort & Filters tab, my sorting property doesn't show up.
@timrodman That worked perfectly!!! I figured there was a link to another table that I was missing but I never would have guessed it was the CSAnswers tables.
I just tried this as well and it worked! Thank you for the video, it really helped