In the past I have not had any issues creating page sets or creating sections within a crosstab sourced by dimensional model. However I need to create a page set by month based on the year value selected on the prompt page. My sample report contains the following fields:
Master Detail Relationship was created automattically using the Month data item.
I've followed the instructions from the link below and I have also tried serveral other methods but when I run the report, the page is blank.
I've also tried creating just the section using the month data item without creating the page set and the page still returns blank. This will work in a list report perfectly because I tested it but I need a crosstab.
I'm using the Month level from our Calendar Hierarchy but I also tried using the calendar month name and calendar month number members with no luck.
How to create Page Break for a Crosstab
Any help would be greatly appreciated..
Pinned topic Create a Page Set Within a Crosstab Report Using Calendar Month Level
Answered question This question has been answered.
Unanswered question This question has not been answered yet.
Updated on 2013-01-10T18:26:37Z at 2013-01-10T18:26:37Z by Rick_J
Rick_J 270002BAVE138 Posts
Re: Create a Page Set Within a Crosstab Report Using Calendar Month Level2013-01-10T18:26:37ZThis is the accepted answer. This is the accepted answer.I got this to work by creating a new report in a different environment. I tested this approach in production and it works.