Hi, the report is run and viewed by the user community. There is a datetime prompt value (shows the last 24 hour, by the date/hour) which the user can select as criteria to run the report. If user runs the report a a few minutes after the hour, they get new information. Then there is this other group of users who only want to see the report with the latest datetime data sent to them in an email (to be run in the morning).
Do I need 2 similar reports? 1st report - user can select the time. 2nd report to be scheduled in the morning - only contains the latest time data (since I cannot use a dynamic parameter to only select the latest time data).
Is there a method to achieve both using 1 report? Thank you
You could probably get away with using 1 report.
Update the filter (I assume already exists) to first check if the Datetime parameter has been set. If the parm has not been set (IS NULL) then filter the report on the maximum([query subject].[datetime_field]), else filter on the Parameter value when it isn't NULL
HTH .... M