Help please!
Hai all,
I need your help for one of my requirement. It's is like i hve to create a coss tab report with year and month value in row and column respectively and I have amount in the measure.
Each measure celll is drill through enabled such that when the user clicks on the value the corresponding year n month will be passed to retrieve the detailed report that show how the amount has been summed up. The detailed report contains various rows that sum up to the amount value.
Now the challenging part where exactly I need your help is...detail report might contain numerous sub fields../rows ,so I have retrieve the row count for the detailed report in advance and based on that I have to define my definition...more.clearly...if the row count in the detailed report is <1000 then show the detailed report as report itself - a live report.or if > 1000 send a link of the report to the user instead of popping the report as such .
Hope my question is clear...please guide ...any help appreciated!
Thank you..
I don't see how that could work - the source report won't have any way of knowing how many rows there are in the target report.
thanks for your response.. if I can get it someway through my db. is that possible to conditionally drill down based on that numerical value of row count ? as in if row count <1000 ,show the detailed report as such or if >1000 just send the link of the report as an email .
thank you.