Page Break

[yogeswari]

Hi,
The scenario is like this: REPORT BREAK EACH 2 QTRS - When more than 2 quarters are being processed, the report shall automatically be broken into separate reports containing up to 2 consecutive quarters each.

I tried by using [for draft] GoSales and Datawarehouse Package.  In that there are 4(Q1,Q2,Q3,Q4) quarters for a year.  I did page break based on "Quater" field.  I am getting 1 quater in a page.  But the scenario is to get 2 quater in a page.

How to achieve this??

Please help me.

Thanks,
Yogeswari. T

[blom0344]

Add a calculated item that groups Q1 and Q2 to Q1_2 and Q3 / Q4  to Q3_4 by using a CASE construct, then use this item to enforce the break:

example using a date:

Code Select Expand


CASE WHEN extract(month,[somedate]) < 7 then  cast(extract(year,[somedate]),varchar(4))||'-Q1_2'
ELSE cast(extract(year,[somedate]),varchar(4))||'-Q3_4' END


[yogeswari]

First of all, thanks for your reply.

I could not understand the answer you provided :( :( :(.
What is [somedate] fields refers?

Could you explain it clearly.  I am using sample gosales and datawarehouse(query) package.  Could you come up with example.

Thanks,
Yogeswari.

[blom0344]

I just provided a general  example (no reference to the gosales package)  [somedate]  was meant as example of any dataitem representing a date. Perhaps you do not have a date to work with, but draw the actual quarter from the package.
I do not know the package well enough, so no idea how temporal data is formatted. That was the reason to show a generally applicable example using a date