Is it possible to ASK AT RUNTIME in a Query for a date range?
For example dates between 01/01/2009 to 12/01/2009?
If this is covered elsewhere in the forums please point me to the right direction.
Many thanks.
Query ASK AT RUNTIME date range
It has been awhile since I did this and I forgot to mention the following:
After doing the above, go to the 'Rule Form' tab.
It should display something like:
FIND DateSearches WHERE DateSearches.EndDate<=?'End Date' AND DateSearches.EndDate>=?'End Date'
Change it to something like (change in bold):
FIND DateSearches WHERE DateSearches.EndDate<=?'Start Date' AND DateSearches.EndDate>=?'End Date'
I just guessing, but I think you need two different values for the labels.
After doing the above, go to the 'Rule Form' tab.
It should display something like:
FIND DateSearches WHERE DateSearches.EndDate<=?'End Date' AND DateSearches.EndDate>=?'End Date'
Change it to something like (change in bold):
FIND DateSearches WHERE DateSearches.EndDate<=?'Start Date' AND DateSearches.EndDate>=?'End Date'
I just guessing, but I think you need two different values for the labels.
Bob
That would be a bit more complicated, but possible.
1) Use attributes in RegularUser BO
2) When running a process to print the reports, have a form that allows input of the dates in the RegularUser BO
3) Use the RegularUser attributes on the query that generates the report & in the title are of the report.
1) Use attributes in RegularUser BO
2) When running a process to print the reports, have a form that allows input of the dates in the RegularUser BO
3) Use the RegularUser attributes on the query that generates the report & in the title are of the report.
Tom - V8.8 build 3137 - MySql / PostGres
I solved this problem by basically doing what Tom suggests.
The only difference is that I do not like clogging up the RegularUser BO with attributes that are not needed by the RegularUser. I have a MiscObject BO that I use for these types of attributes. Since my MiscObject is not needed after the process that creates the report, the Persistence is set to 'Not persisted'
The only difference is that I do not like clogging up the RegularUser BO with attributes that are not needed by the RegularUser. I have a MiscObject BO that I use for these types of attributes. Since my MiscObject is not needed after the process that creates the report, the Persistence is set to 'Not persisted'
Bob