ReportServer Forum

tok

Member

From: Finland

Registered: 2016-03-22

Problem with parameters of BIRT report in RS 3

Hello!

I noticed a strange behavior of BIRT report under RS3. I have a BIRT report with 3 text parameters. I've specified all 3 parameters in Administrator - Reports - Parameters as Datasource Parameters. Under each parameter, in Edit - Specific Properties, I have defined each parameter as PARAMETER of BIRT-report datasource (datasource is the report itself). Selection mode is Single selection and Selection style is Dropdown. At this point Default Values list shows all available values correctly for each parameter.

When I run the report I'll get the Parameter selection screen. There dowpdown list of parameters is correct only for the first parameter. The second and third parameter have the same list of values than the first parameter!

I hope you understood the problem. Can you reproduce it?

Arno Mittelbach

datenwerke

Registered: 2012-02-14

Re: Problem with parameters of BIRT report in RS 3

Hi,

what is the cache setting of your datasource?

Cheers,
Arno

tok

Member

From: Finland

Registered: 2016-03-22

Re: Problem with parameters of BIRT report in RS 3

Hi Arno!

Database cache is set to 0.

Below are few images how the problem looks like:

1st parameter - properties

2nd parameter - properties. Here Default Values list shows correct values.

Executing the report. Default values are correct

Executing the report. Selection list of parameter 1 is correct

Executing the report. Selection list of parameter 2 is taken from parameter 1!

Arno Mittelbach

datenwerke

Registered: 2012-02-14

Re: Problem with parameters of BIRT report in RS 3

Hi Tok,

thank you for the detailed description. We'll look into this as [RS-2221].

Cheers,
Arno

Arno Mittelbach

datenwerke

Registered: 2012-02-14

Re: Problem with parameters of BIRT report in RS 3

Hi Tok,

could you try using three independent Birt datasources for the report. Does that solve the problem?

Cheers,
Arno

tok

Member

From: Finland

Registered: 2016-03-22

Re: Problem with parameters of BIRT report in RS 3

Thanks Arno! It worked!

I defined an independent datasource to the same BIRT report for each parameter. This is a good workaround although I think there's still a bug to fix.

Arno Mittelbach

datenwerke

Registered: 2012-02-14

Re: Problem with parameters of BIRT report in RS 3

Just to update this, we've fixed the issue and the fix will be part of the next maintenance release.