Print in EXCEL Per Month By Using Report Studio Report

[gosoccer]

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.

[hespora]

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

Code Select Expand


extract(year,[date])*100 + extract(month,[date])