Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi there,
I have created many reports with the calendar object setting variables for search in the reports where a vToDate and vFromDate is set using the object. I however have a requirement that when nothing is found in the set date that no data should be displayed instead of all the data in the data file. Is this possible with the calendar object at all using variables and search?
Regards,
Christo Kruger
An option in order to load no data instead of all data would be to use the Calculate condition of the object, and in the calcualted condition used something along the lines of getselectedcount() function for example - this will only show if the count of your parameter within the function is greater than a count you specificy, such as
GetSelectedCount("date([Dt])") = 1 - this exampale will only load data if there is at least one date selected. You can string together using or statements to test different and/or multiple fields
Thanks Adam, this works beautifully.