drill-through on crosstab's data

Hello, I'm a new BIRT user and I'd like to know if it's possible to build an interactive report doing a sort of drill-down on data.
The only result I obtain is to explode all data in a new report (Salesdetails.rptdesign), but I would display in the new report just the data of itself. (sorry for my english...I mean just a productline with all productname and just a year with the quarter, i attached my examples).
I've tried with filters and parameters on Salesdetails.rptdesign without success, but i'm not expert.
Is it possible to do it with BIRT?
Can someone help me please?

Find more posts tagged with

Comments

mwilliams

Hi Zoso,

Maybe I'm not sure exactly what you're asking, but if you're just wanting to know how to set up a drill through.... You can set up a drill through for data elements in a crosstab by clicking on the data element you want the drill through on. Go to the hyperlink section on the property editor tab, click on the [...] button and set up your drill-through there. Let me know if you're wanting to know something different.

zoso

Thanks mwilliams, but I know this procedure.

what i'd like to do is to have a report where I click on a data of the first report (Sales_Tot.rptdesign) and I drill through the other report just viewing the referring year and productline (with their own subcategories).

For example (see the attached files) I click on the data in first row and first column (1374755: Classic Cars - 2003) and I just want all the "productname" of classic cars for all the 2003's quarter.

mwilliams

Zoso,

I think it has to do with the design of the second report. Let me work on it a little and see if I can come up with a solution for you.

mwilliams

Zoso, 
 
I haven't had time to look at this as of yet. However, this example from the devshare could give you an idea of how to solve your problem. If not, let me know. 
 
<a class='bbc_url' href='http://www.birt-exchange.com/devshare/designing-birt-reports/392-conditional-drill-through/'>http://www.birt-exchange.com/devshare/designing-birt-reports/392-conditional-drill-through/</a>

zoso

really thank you mwilliams for your support, but i've already seen that example and it's not useful for my problem. 
I'd like to know if it's possible to solve this problem... 
I think you were right when you wrote 
<blockquote class='ipsBlockquote' data-author="mwilliams">
I think it has to do with the design of the second report.</blockquote>
I'm almost sure of this.... 
see you soon

zoso

I've build two images of what I'd like to view in my reports:
the first one is ok in reality too, the second is built ad-hoc.
clicking on 65815 (Trains in 2003) in the first report, I'd like a report like in image reportB.jpeg

mwilliams

Zoso,

Ok... I took a look at the second report design. The thing you needed was a couple filters set up to filter by the parameter values passed in by clicking in the first report. You can see the filters I put on your second report design's crosstab in the attached file. This should get it done for you. Let me know.

zoso

Thank you so much Michael!
It works perfectly!
This is what I tried to do!
The only thing I don't understand is where are the two filters: aren't in dataset?
Where I have to set up the couple of filters for parameters?

zoso

I was becoming crazy! But now I've found the filters on the crosstab!
Really thank you mwilliams and sorry for my english!
I think this example will be really useful