If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Report PageBreak Issue

Started by sudhajan, 23 Dec 2008 12:52:56 AM

Previous topic - Next topic

sudhajan


I have a c8 report with a list table as well as pie chart on it.
and I have an 'OR' prompt . One is Country and other is State ( any one is selected ).
(its one - many relationship ::  one Country --> many States ]
I am using a Pageset for showing data on different pages.

For example , If i select Country , then the page should break for each country and list data and pie chart should be for the country on each page.

Similarly if State is selected, then the page should break for each State and List data and Pie chart should be for State on each page.

My problem here is,

1) In the pageset Grouping properties , if i specify Country and if i select State in the prompt then the report is breaking on Country,
Similarly if grouping is selected as State, then if Country is selected in prompt, The report is breaking on State.

2) And what should be the master detail relationship for the Pie chart as its 'OR' prompt. Should the link be on Country or State?


Thanks in Advance ...

Sunchaser

Hi,

I would say that you should use a conditionnal layout based on a variable coming from the choice in the prompt.
If countries are selected, then the page set with a page break on country will come out, if it's the states then the page set with the page break on states.

May be its not the better one, but i think it could be a solution.

sudhajan


Thanks for replying ..

i am getting another issue ...

I took conditional layout and created 2 pages one based on country and another based on state.
and i am able to get data in both reports according to the prompts selected
I took boolean variable based on the prompts values ( if country not missing or state not missing) and used in page properties render variable to show the page. 

There are two pages in
      page explorer --> report pages --> page1
                      --> page2

page1 is for country and page2 is for state.
when state is selected , The page2 is comming up fine , getting data according to the state selected and one state on each page, since i rendered the page1, its not showing the page1.

Similary the page1 is also fine with data displayed when country is selected, showing data one country on each page, BUT at the last of the report I am getting blank pages.

Looks like the empty pages are due to the other page rendered is also comming up.

Any solution/idea for removing the empty pages pls.

Thanks in advance.


Sunchaser

Hi,

As I can't see for real how the report is structured, I'll say that you should check all the master-details relationships that may be necessary for your pages.
You should check some points like:
. do the query for the Page-Set is the same than the query from the page itself ?, and what sort of relation between them ?
. do the query for the page is the same than what is used in the page (List or Crosstab, for example) ?, and what sort of relation between them ?
Etc ...

I don't think yo're far from the solution, so you should keep on testing this way.

Hope it could help you.
vinc.