have a report that groups on models and has a formula for each month. I have a subreport in the detail that has parameters for model and month. I would like to send field name clicked to sub report so that I can filter the data based on the "month column" chosen. Is this possible?
Month 1 Month 2 Month 3 Total Rank
Model 1 1% 3% 1% 1.6% 3
Model 2 2% 3% 1% 2% 2
Model 3 3% 3% 1% 2.3% 1
--------------------------------------
Total 2% 3% 1%
Rank 2 1 3
count > 2% 2 3 0
Rank > 1% 2 1 3
The reason I am not using a cross tab is that I also have complex ranking formulas for each column and row.
Thanks for anyones help.
Kevin McManus
kevin_mcmanus@ureach.com
Month 1 Month 2 Month 3 Total Rank
Model 1 1% 3% 1% 1.6% 3
Model 2 2% 3% 1% 2% 2
Model 3 3% 3% 1% 2.3% 1
--------------------------------------
Total 2% 3% 1%
Rank 2 1 3
count > 2% 2 3 0
Rank > 1% 2 1 3
The reason I am not using a cross tab is that I also have complex ranking formulas for each column and row.
Thanks for anyones help.
Kevin McManus
kevin_mcmanus@ureach.com