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

Repeater tables and list - repeat columns in a page

Started by Papave, 26 Mar 2015 07:12:40 AM

Previous topic - Next topic

Papave

Hi everyone,

I'm struggling with a list in a repeater table. 
I want to display data about user connexions in the application.
The report should look like a phone bill (phone number / datetime, grouped by week and month).

I'm satisfied with what I have, but my report is repeated on 2 pages (it's not that big of an issue but still annoying...)

(i attached a doc with the details I'm referring to)
A :
-   Repeater table, based on Query1, containing month (mois) and week (semaine)
-   Repeater direction 4 horizontally and 1 vertically

B :
List, based on Query2, containing a list with month/week/user name/datetime
- Sections on Month (B1), and Week (B2), and the « rest » of the list (B3)
- Master detail relationship between Query1 and 2 on week = week and month = month

Within the month section (B1)
- Both default boxes "Allow content to break across pages" and "Allow horizontal break"  unchecked
- Box "Repeat every page" checked

I have 4 columns, 1 per month/week -> That's what I want  :)

But the whole report page is repeated twice (same data). When I run it, it have « Next page » at the bottom, and when i click, I get exactly the same data...and I can't figure out why.

Any idea (I'm using version 10.2.1). I tried to check/uncheck other boxes but it didn't seem to have any effect. I'll keep looking though.
I have no filter in my queries, and am using dimensional data.

Papave

Papave

Hi,

I finally figured out what was wrong. Table and list are ok.

I tried a lot of possibilities when developping my report and did not realize I created a "page set" (within the month). I've never used this functionnality before... but removing the page from the page set solved it.

Marion