How do I display from date and to date without using a parameter. I have a monthly report job that runs each month for data from the 1st to last day of each month. I have hard coded the beginning of month and end of month date into my report. How do I display this on the report heading to show this date range(1st of month to last of month).
Thanks!
Create two query expressions like...
minimum(date) and maximum(date)
This will display the first/last dates of the range?
Thank You. The issue is that I want to display the entire month that the report is ran for regardless if there is any data for the last day of the month. Using the maxdate will only give me the last data date. I need the last day of the month regardless.