HELP!
I am trying to link a full-client report to another full-client report based on the values contained within a particular cell. (ex. VP Name)
The first report shows all the VP's in columns (cross-tab report). Based on the VP name it will take you to another report and refresh it based on the VP's name. The report will show the Directors (and their sales) that report to that particular VP.
Example:
If the VP cell reads "John Smith" and you click on it, it will take you to report #628 and refresh the query and only show the Directors for John Smith.
1ST REPORT:
VP's----> JOHN SMITH | PERRY MASON
Sales Margin | Sales Margin
7/1/03 $1200 5.5% | $1400 6.2%
7/2/03 $1300 4.5% | $1500 7.7%
Any help would be greatly appreciated!
Thanks!
dizaba
I am trying to link a full-client report to another full-client report based on the values contained within a particular cell. (ex. VP Name)
The first report shows all the VP's in columns (cross-tab report). Based on the VP name it will take you to another report and refresh it based on the VP's name. The report will show the Directors (and their sales) that report to that particular VP.
Example:
If the VP cell reads "John Smith" and you click on it, it will take you to report #628 and refresh the query and only show the Directors for John Smith.
1ST REPORT:
VP's----> JOHN SMITH | PERRY MASON
Sales Margin | Sales Margin
7/1/03 $1200 5.5% | $1400 6.2%
7/2/03 $1300 4.5% | $1500 7.7%
Any help would be greatly appreciated!
Thanks!
dizaba