Report Studio New Page??

[Sidney786]

Hi

I am writing a report in which i would like to display sales rep's sales on different separate pages in a report studio report.

I have listed below a really basic example of how i would like to report to look.

Each page will share the same header date range.

E.G
Page 1
John Smith
Tents 30 £1800
Taps 40 £1000


Page 2
Sally Anne
Glasses 30 £ 160
Heaters 2 £ 30

Page 3
John Barns
barrels 10 £40

Etc

Can anyone suggest how to do this?

Sid

 

[blom0344]

There is only one acceptable way to generate a new page for each new value and that is by using page-sets. The page-set is used through a master-detail relationship based on 1 (= the same) or 2 seperate queries.

We usually use a stripped query for the master (in your case just the user names) and a detail query that fetches both user names and 'real' fact data.

Read up on page sets from the help menu; then come back for more info if required..

Ties Blom