Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All ,
We are having one of the report requirement which is sub report of main report .
We are unable to get sub reports form main reports , by giving links to data inside our Pivot / Straight table .
Here we are attaching exact sub report structure , we need for our client.
Looking for best support as usual . 🙂
Main Report-1 :
Region | Customer Count | Total Spend |
East | 15 | 100010 |
West | 5 | 50000 |
North | 35 | 60000 |
South | 24 | 75000 |
Sub Report -1
Region | Customer Name | Revenue | Total Visits |
West | John | 8000 | 2 |
West | Allan | 12000 | 3 |
West | Mark | 6000 | 1 |
West | Smith | 14000 | 2 |
West | Peter | 10000 | 3 |
Sub Report -2
Region | Customer Name | Bill Date | Bill No | Product_Code | Qty | Price | Total Spend | Visit |
West | John | 21/10/2008 | A_101 | PR_001 | 4 | 150 | 600 | 1 |
West | John | 21/10/2008 | A_101 | PR_006 | 2 | 500 | 1000 | 1 |
West | John | 18/12/2008 | C_225 | PR_011 | 3 | 600 | 1800 | 2 |
West | John | 18/12/2008 | C_225 | PR_015 | 7 | 200 | 1400 | 2 |
West | John | 18/12/2008 | C_225 | PR_021 | 8 | 400 | 3200 | 2 |
And we need to export these charts to excel if requried .
Bhushan N
Please help me in getting below requirement or any alternative way to get sub reports .
Its one of major requirement from our client .
Bhushan N
I guess I don't understand the question, or maybe you're making it harder than it needs to be. Build all three reports. When you select Region = West from your main report, you'll see sub report 1 for West. When you select Customer Name = John, you'll see sub report 2 for West and John. I don't see why you would need or want actual links when mere selections will produce the same result. If you don't even want to see the sub reports until the user selects a Region and then Customer Name, use a conditional show on the layout tab, getselectedcount("Region")=1 for sub report 1, and getselectedcount("Region")=1 and getselectedcount("Customer Name")=1 for sub report 2. You might consider getpossiblecount() instead so that if other selections have narrowed you down to one region and customer, you don't have to still explicitly selected them. But maybe I'm not understanding what you want.