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