How to pass parameter to a hyperlink to link to another report

I) How to pass parameter to a hyperlink to link to another report.
Example: I have report called “cars by city” which will take a parameter "car model" and gives number of cars by city for that model.

Say I gave input car model “camry” it will out put something like this

City Number of cars
San Francisco 1000
Oakland 200
San Jose 3000

And “Number of cars” columns values are hyper links to other report which should take ideally city and car model as input (if not possible to pass city as parameter at least car model should be passed ) and give a detailed report of customers who bought the car.

Example when one click on 1000 (number of cars in city san francisco) it should go to a detailed report giving customer name and year they bought (which is another report “customer details”):

Customer name year bought
Raj 1989
John 2000
…..

Is there a way to have such reports using Actuate? I greatly appreciate help.

Find more posts tagged with

Comments

JustME

HI Rajkal, 
 
Check out these two devshare posts regarding drill down reports. I think the examples in these posts do essentially what you are looking for. 
 
<a class='bbc_url' href='http://www.birt-exchange.org/devshare/designing-birt-reports/1132-single-page-drill-down-with-collapsible-tables/#description'>Single Page Drill Down with Collapsible Tables - Designs & Code - BIRT Exchange</a> 
 
<a class='bbc_url' href='http://www.birt-exchange.org/devshare/designing-birt-reports/1124-drill-down-report-with-sortable-tables/#description'>Drill Down Report with Sortable Tables - Designs & Code - BIRT Exchange</a>

RajKal

thanks it worked