Hi...
Create Report with Region in details section and Country as Group
Right Click the Details Section and Select Hide (Drill Down...Ok)
Then when you click on County Heading you will get the region details....
it will open a new tab with the country name .....
Ok now fancy stuff
Go to Report -->Group Expert -->Select Group Country Options the Option Tab Customize Group Name Field Select x+2 use formula as group name enter
"(+)" + {Customer.Country} in that
this will display + in front of country name...
Step2
Create a Text Object and Place it in Group Header Country
Right Click TextObject select formnat text then in common Tab
X+2 suppress enter drilldowngrouplevel= 0
Step 3
Create a formula say hidecountry name
enter
if DRILLDOWNGROUPLEVEL > 0 then
{Customer.Country}
else
{Customer.Country}
place that in the above text object
Step4
right click the text object and in then select the SIZE AND POSITION then select X+2 next to x axis and enter
if drilldowngrouplevel =1 then
-3480
Cheers
Rahul
IP Logged
