Problem with the drill through hyperlink with parameters

evgeny

Hello and thank you for reading,

I created a report which shows a list of regions with the sublist of countries of the currently chosen region. By clicking on a different region I want to show the respective list of countries. In order to realize this I created a drill-though hyperlink on the region cell, which refers to the same report and takes into account the parameter "region".

The report works just fine if I execute it the first time. If I change the region-parameter manually (by clicking the "Show Report Parameters" Tab) the report is showing the anticipated list as well. However, if I CLICK on a region link, then the result shown seem to follow no logic. The first time it shows the expected list of regions with the sublist of countries for the chosen region, the second time the list of the regions is smaller than before and there is no sublist and the third time there are no results at all.

I also aggregate on the number of countries in each region and this number is changing each time as well.

Is there some kind of debugging mechanism for BIRT. So that it is possible to see which values the parameters currently have?

Thanks you for your help

Evgeny

evgeny

ok, I figured it out. The problem was that I had another two parameters which were setting the time frame. After removing this two parameters from the drill-through options the exception did not occur anymore.

However I have a new, similar, problem. I have established the following structure for my report.

Group1
Group2
Group3
Detail

For each group I have established a drill-through hyperlink and passed each time the parameters. So that I have a list Group1 values, then the chosen value from Group1 shows a sub-list of Group2 values belonging to Group1. And again the chosen Group2 value has a sub-list of Group3 values, and again if one clicks on a Group3 value, the details of this group are shown. The result is looking like this:

Group1_Value1
Group1_Value2
Group1_Value3
...Group2_Value1
...Group2_Value2
...Group2_Value3
...Group2_Value4
.......Group3_Value1
.......Group3_Value2
.............Detail1
.............Detail5
.............Detail3
.......Group3_Value3
...Group2_Value5
Group1_Value4
Group1_Value5
Group1_Value6
Group1_Value7
Group1_Value8

This structure works without problems in generally. Just when clicking on certain Group3 values, the details are not loaded. This are always the same values and next to the detail values I have an aggregation on the number of containing values. This number is the same as the number of values which the equivalent sql query returns.
However, if I go to the "Show Report Parameters" Tab, and type in the parameters for the required values, the report shows the details which were not shown when clicking on the respective Group3 value.

Is there something which is blocking the execution of the query? Is it possible to look which parameter birt is currently using?

Thank you for any help.

Evgeny