second dynamic table, depending on values of first table

Hi,

I have to create a report which shows a list of spare parts with some details like part no., name and manufacturer.

The values inside the table are depending on some optional parameters. So I can enter parts of the part no., or parts of the name, or parts of the manufacturer's name. This works well.

Now I want to create a second table in the same report which only is visible when I click i.e. on the part no., and it only should show spare parts with the same part no., but with more details like serial no., end of guarantee, status etc.

Creating two reports and linking between them via drill down is not a problem but I don't want to have two reports for this.

Is it possible to create such a second 'dynamic' table, and - if yes - how can I do this?

Thanks in advance,

jsOpa

Find more posts tagged with

Comments

mwilliams

Hi jsOpa,

You could create a second table in your report and use a hidden parameter to drill through to the same report and only show it when a value has been clicked on. The first time you run the report, you'd just drop or hide the table since there is no value in your hidden paramter. Once they click on a link within your report that drills down to the same report, it'll pass a value through your hidden parameter and then not drop or not hide the extra table which you'll then use your parameter value to filter the table or limit your dataSet so that the correct data shows.

Hope this helps.

jsOpa

Hi Michael, 
 
<blockquote class='ipsBlockquote' data-author="'mwilliams'" data-cid="74751" data-time="1300306994" data-date="16 March 2011 - 01:23 PM">
Hope this helps. </blockquote>
 
thanks, it helped a lot. I use a hidden boolean parameter, and another data set for more detailed information about the spare parts. For this second data set I also use other parameters so that the first table shows the same information as after first run. 
 
The one and only handicap is the time the report needs to rerun after selecting the part no. but this is a thing I can live with. 
 
Thanks again, 
 
jsOpa

mwilliams

Not a problem, glad to help!

jsOpa

Hi again,

the report works well and fast, now it contains 4 tables, connected via hidden parameters.
By selecting the part no. in first table, one of two tables opens, depending on a special part parameter. The fourth table opens after selecting the serial in one of these two tables.

That's why now I have another problem: selecting some parts with a special part no. leads to a very long second table, around 50 pages in BIRT Viewer, and the fourth table appears after this long table.

Is it possible to shorten the second table in this way that it only shows the previous 5 and the following 5 items, and if yes,
how can I realize it?

Thanks for your hints,

regards, jsOpa

mwilliams

I'm not certain how your data is set up, so I don't know exactly how to suggest trying. Can you explain more about the setup or provide a PDF copy of what your report looks like, so I can know what we're working with? Or just a small example of what each table represent?

jsOpa

Ok, pdf file added.
It shows something like a flow chart, I'm not allowed to create files with real data included (company restrictions).

Table 1 shows all articles available in stock or somewhere in the company, it is possible to limit the length of the table with the optional parameters.

If the table is generated, and a part no. is selected, table 2 or table 3 appears below table 1, depending on the value of the attribute 'exchange part".

In table 2 you can select a single part by selecting its serial to open table 4 which shows the part history.

Table 2 is the problematic one. The selection of some part numbers leads to a very long table 2. This is ok until a single part is selected and table 4 appears. It is not user friendly to scroll through a very long table to see the table 4 below table 2.

That's why my idea is to show only the previous 5 and the following 5 parts in table 2, with the selected part in the middle.

I hope now it is more clear what I want to do.

But on second thought it could be better to use a sub table inside table 2 which opens and closes when the single part is selected and shows the part history directly below the selected part and above the next single part.

What is your opinion about the sub table? Is it feasible? And in comparision to an 'external' table 4, what is the better way to get a userfriendly report?

Thanks for your thoughts,

regards, jsOpa

mwilliams

You can definitely "expand and collapse" subtables. The way to do this would be similar to what you're doing already, but you'd group table 2 by the key value and then embed the detail table in there. The detail table's dataSet would just have to have a parameter that you'd pass through the value of what was clicked on. Then, you'd just hide the row the subtable was in for all the other "non-clicked" values. Hope this makes sense. Let me know.

jsOpa

Hi Michael,

sorry for my very very late answer, I had a lot of things to do...

I tried it in the way you suggested, it was a little bit tricky, but the result works well.

Thanks for your help.

jsOpa

keerthimea19@gmail.com

<blockquote class="ipsBlockquote" data-author="mwilliams" data-cid="74751" data-time="1300306994">
<div>
Hi jsOpa, You could create a second table in your report and use a hidden parameter to drill through to the same report and only show it when a value has been clicked on. The first time you run the report, you'd just drop or hide the table since there is no value in your hidden paramter. Once they click on a link within your report that drills down to the same report, it'll pass a value through your hidden parameter and then not drop or not hide the extra table which you'll then use your parameter value to filter the table or limit your dataSet so that the correct data shows. Hope this helps.
</div>
</blockquote>
Can you please explain this in detail