Topic
IC4NOTICE: developerWorks Community will be offline May 29-30, 2015 while we upgrade to the latest version of IBM Connections. For more information, read our upgrade FAQ.
1 reply Latest Post - ‏2013-01-10T18:26:37Z by Rick_J
Rick_J
Rick_J
138 Posts
ACCEPTED ANSWER

Pinned topic Create a Page Set Within a Crosstab Report Using Calendar Month Level

‏2013-01-09T20:53:28Z |
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:

Crosstab:
Rows:
Product_Description

Columns:
Location

Measures:
Net_Sales

List Report:
GroupBy/Section:
Month

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.
Calendar.Calendar.Calendar YMD.Month
How to create Page Break for a Crosstab
http://www-01.ibm.com/support/docview.wss?uid=swg21417813

Any help would be greatly appreciated..
Updated on 2013-01-10T18:26:37Z at 2013-01-10T18:26:37Z by Rick_J
  • Rick_J
    Rick_J
    138 Posts
    ACCEPTED ANSWER

    Re: Create a Page Set Within a Crosstab Report Using Calendar Month Level

    ‏2013-01-10T18:26:37Z  in response to Rick_J
    I got this to work by creating a new report in a different environment. I tested this approach in production and it works.