Hi all,
I m trying to build a report with a date prompt feature.
my sql table is something like that
id,object,kpi1,kpi2,kpi3,date
for each date, I have for each object a list of kpi
a select object,date from table can give that
storage1,date1
storage2,date1
storage1,date2
storage2,date2
storage1,date3
storage2,date3
storage1,date4
storage2,date4
I 'd like to have by default the report to use the latest date ( max(date) ) and the ability to use the dateprompt to select on specific date.
I guess I have to use a parameter to the query, and set this parameter at the latest date by default ...
but I don't know how.
Thanks a lot for your help
Fox