I was trying to figure out how to hide that information when a report will be showing more than one month.
how do you display the mont and year for the report ? Il suggest that you use a Merge variable (last option in the Insert menu in Layout mode). Make the merge variable field large enough at the top and then set that variable to:
- one month only "For March 2016"
- for a range of months "For January through March 2016
for example. In this way you do not need to hide anything and the person reading the report knows exactly the period of time of the report.
I currently have calculation fields in the table. One to get the month of the selected date and one for the year. I used those at the top of the report. It works fine obviously when it is filtered for just one month(which will be the norm). But as any good developer needs to do, plan for other scenarios. I will have to lookup how to create the merge variables to show/pull the information properly. But that sounds like it would be a good idea. Thank you.