nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Birt Cross Tab Report

viveks

We have made a cross tab report and hyperlink to next report by using drill through and i want how we can filter and link specific cell ,hide particular row.

Thanks in advance for your help!

Find more posts tagged with

Comments

mwilliams

Hi viveks,

Can you explain a little more in detail? Are you wanting to filter the crosstab and have links on all the remaining cells or are you wanting to have links on only some cells and have the rest with no link? Or am I missing what you're trying to do entirely? Let me know!

viveks

<blockquote class='ipsBlockquote' data-author="'mwilliams'" data-cid="83479" data-time="1317239422" data-date="28 September 2011 - 12:50 PM">
Hi viveks, 
 
Can you explain a little more in detail? Are you wanting to filter the crosstab and have links on all the remaining cells or are you wanting to have links on only some cells and have the rest with no link? Or am I missing what you're trying to do entirely? Let me know!

</blockquote>

viveks

hi ,actually i made a cross tab report regionwise,how i can link particular parameter in region and filter them .
e.g. suppose that we create a cross tab report region r1 and link to another report r2 by using drill through, but i want when we click on row North only North related data show , and when we click on south only south related data open. is it possible in cross tab report using birt

thanks in advance!

viveks

hi how i can link particular parameter in cross tab report

Yogesh Maharwade

For that u have to create parameter on r2 report that will filter the dataset values which comes from r1 report.

let me know if u have any problem .

mwilliams

Like piwya said, if you create a report parameter on the second report, you can pass the clicked value through this parameter in your drill through. When you're setting up the drill through hyperlink, you'll see the parameters section. You'll just need to select your report parameter from the list and choose the value to pass through. Then, in your second report, you'd set it up so that your data is limited by the report parameter. Let us know if you have issues setting this up. I'm sure either piwya or I can make a simple example that shows you how if necessary!

viveks

<blockquote class='ipsBlockquote' data-author="'mwilliams'" data-cid="83601" data-time="1317332400" data-date="29 September 2011 - 02:40 PM">
Like piwya said, if you create a report parameter on the second report, you can pass the clicked value through this parameter in your drill through. When you're setting up the drill through hyperlink, you'll see the parameters section. You'll just need to select your report parameter from the list and choose the value to pass through. Then, in your second report, you'd set it up so that your data is limited by the report parameter. Let us know if you have issues setting this up. I'm sure either piwya or I can make a simple example that shows you how if necessary!

</blockquote>
 
thanks i got the solution by using this method ,but how we can set date time parameter in cross tab drill report

viveks

thanks i got the solution by using this method ,but how we can set date time parameter in cross tab drill report

mwilliams

Can you explain more about what you mean? Are you asking if you click on a measure cell in the crosstab, how do you pass the date from the dimensions? If so, what dimension groupings are you showing from the date? What version of BIRT are you using so I can check it out in your version?

Let me know.