Hi folks, :) :)
I have a requirement to create a Report using Report Studio that will print Each Month Into a Separate Month
in EXCEL when the user runs the Report. So, if the user selects a date range of 01/01/2016 - 07/01/2016, it
should print each of the six month to a separate TAB in EXCEL.
Could you please let me know if you have been able to do this. :o :o
Thanks so much for your time.
Pages from a report are exported into tabs in an excel file. Thus, you only need a page set on your month data item. Better, on a yearmonth data item, as I suspect a user could specify a date range spanning multiple years.
If you only have date, and no month key, or yearmonth key, you can just build that yourself with
extract(year,[date])*100 + extract(month,[date])