Display different data on different pages of same report 2

[jan11]

I have crystal 8.5. I am using ODBC to connect to FXP database through .NET. I want to create a crystal report which will display Jan-Mar values on 1st page, Apr to Jun on 2nd page,Jul to Sep on 3rd page and so on...
My FXP table has structure as below:
Fields:-
ClientName Jan Feb Mar..........Dec

 

[Madawc]

Group by those time-periods - totext(Year({your.date})) & "/" & totext(DatePart("q",{your.date}), which will show 2004/2 etc.

Crystal 8.5 will give you a value in the grou header, which you can remove if you like. In any case, right-click on the detail section and choose Format Section. Then choose the formula icon (x+2 and a pencil) for New Page Before. Suppress when pagenumber=1, to avoid a page-skip at the start.

Madawc Williams (East Anglia, UK)

 

[synapsevampire]

Your example leaves too much to the imagination. Do you have just one row? Are you wanting to divide the data which represents each quarter into it's own set of rows?

Understand that the design is bad for relational data, if you have a time period, there should be a row for each period, not pivoted as you have, so try to get the data in a more normalized fashion.

Working with the existing dtaa I fear that you'd have to create subreports for each quarter.

If the above doesn't help, try posting example data and expected output.

-k

 

[jan11]

Thank you Madawc and synapsevampire.
Madawc i did not completely understand your solution,and as synapsevampire correclty pointed out, i had very less information. Hope the following will help.
My table structure and data are as below:
ClientName, Jan, Feb, Mar,......,Dec(these are field names)
Ashley, $1,$0,$5,................$10 (this is one data row)

My expected report output is:
on 1st page i need to display -
ClientName, Jan, Feb, Mar, YTD(upto march)
Ashley , $1, $0, $5, $6 (data)

on the 2nd page of the report i need to display -
ClientName, Apr, May, Jun, YTD(from apr to Jun)
Ashley , $5, $5, $0, $10 (data)

and so on on the other pages till dec.
Thanks in advance.

 

[synapsevampire]

OK, this seems simple in theory.

Group by the Clientname.

Right click the details section and select Insert Section 3 different times to create multiple detail sections.

In the first details place the fields for the Jan-Mar.

Then right click that section and select Section Expert and check the New Page After

Repeat the same thing for the other quarters.

-k