I have a query that pulls a small subset of values (names of assessment forms) from a large table containing lots of names we do not need.
I am using this query to create a drop down list for a report filter that I need to build. I want to do "get from query", using this results set in specifying the filter's Available Values.
Query appears below. How can I modify the syntax to end up where the choices appear in the order I want? I am assuming I'll need a label with numbering to make the list appear as shown below.
What I want to end up with is a results set that looks like so:
1. Consumer Needs Assessment
2. Nutritional Risk Assessment
3. Caregiver Assessment
4. Individual Client Contact Form
5. Public and Media Event Recording
I don't really care about showing or having the numbers appear in the drop down this will create unless I need them to force or support the ordering.
Here's the query:
HAR_ASSESSMENTS.ASSESSFORM_NAME = N'AAA Consumer Needs Evaluation'
OR HAR_ASSESSMENTS.ASSESSFORM_NAME = N'Nutritional Risk Assessment'
OR HAR_ASSESSMENTS.ASSESSFORM_NAME = N'Caregiver Assessment Form'
OR HAR_ASSESSMENTS.ASSESSFORM_NAME = N'Individual Client Contact Form'
OR HAR_ASSESSMENTS.ASSESSFORM_NAME = N'Public and Media Activity Recording'