Dynamic data in Cross Tab of Birt Tool

Question

how to hide cross tab columns runtimely based on user selection in birt Tool

Probably need to add some javascript to do it – Chetter Hummin Mar 30 '12 at 03:34 — Chetter Hummin, Mar 30 '12 at 03:34

score 0 · Answer 1 · answered May 28 '17 at 07:28

0

Use cross-tab to tabulate dynamic columned data. Follow this tutorial to create dynamic columned cross-tab report

answered May 28 '17 at 07:28

Akila

score 0 · Answer 2 · answered Mar 30 '12 at 09:21

0

See the attached image... enter image description here

answered Mar 30 '12 at 09:21

Tom Seidel

score 0 · Answer 3 · answered Mar 30 '12 at 10:48

0

Rows and columns can be removed from visibility in BIRT cross tabs by filtering the cross tab.

To do this:

Select the crosstab object in the Layout window.
In the Property Editor for the cross tab, select the Filters tab.
Click the Add... button to the right of the Filter by: list.
- In the New Filter Condition dialog, select the desired column from the Target: section and the relevant conditions in the Filter Condition: section. Remember that filter conditions are conditions for showing the data, not hiding it, so your condition will need to be the converse of a condition for hiding it (such as would be used in a table column visibility condition).

answered Mar 30 '12 at 10:48

hi mark its good, but my Quesition is based on user input like report parameters ,i want to hide rows or columns of cross tab – venkat ch Mar 30 '12 at 11:54
@venkatch: Yes, to include groups that match the entered parameter, specify the `Filter Condition:` match condition as `Equal to` (or `In`, for multi-valued parameters) and the `Filter Condition:` Value as the parameter using the `fx` button, in the New Filter Condition dialog. – Mar 30 '12 at 12:04
HI mark i have multiple Rows and I dont have specific names to that rows, how can i hide that rows based user inputs – venkat ch Mar 30 '12 at 13:14
Expand your question to include the data structure of your dataset, the structure of your cubes and which rows/columns you want the users to be able to include/exclude. – Mar 30 '12 at 13:29
hi mark, my cross tab contains (year,state,model) rows, for example i am displaing data like year wise states,state wise models , model wise cost and state wise sub totals – venkat ch Mar 31 '12 at 11:46

3 Answers3