Creating a dynamic value list with a show all option
I want to find out if there is an easy way to do a select drop down list for a subsummary report page that I have. What I do is I have a global field with a static value list attached to display the name of the report groups plus an "All" option. For example,
Then the user will use the drop down list to select either all the reports, or just the one report type they need to see. This choice is then sorted for the subsummary report.
I have now run into a snag where I have had to change a lot of the report headings. This is not really a problem but I was wondering if there could be a way of creating a dynamic value list based on Report::ReportType field instead of having to type in the report names manually into the custom value list which has the "All" option. Would it jsut be simpler to rather have the value list based on the field ReportType and then placing a show all button on the layout instead. Would this be an easier solution?
Got the answer :) I had to create a field in the DB as " All¶ -¶" & ValueListItems(get(FileName); "ReportType"