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
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