ReportServer Forum

Patryx

Member

Registered: 2019-03-25

Problem with parameter which depends on different parameter

Hi,
I will write scenario as an example to explain the problem:
I create dynamic list report. I add parameter P_USER_ID as text parameter. I mark this parameter as Editable, Mandatory and HIDDEN (this is important). I also add Default value as '468edf32-9006-477e-ae54-52e9a8d2fc44' and save.
I create another parameter P_UNITS as datasource parameter with multiselect options. I mark this parameter as Editable. I add parameter P_USER_ID as "Depends on:".
Then I connect to my datasource with query:
SELECT d.value,
       d.display
FROM units_dict d
WHERE  d.user_id::TEXT = $P{P_USER_ID}
I test this by clicking EXECUTE in parameter configuration - Great, it works and show me units filtered by user_id.
Then I save this parameter.
I go to report and do Eexecute to see Report Execution View. I open Parameters tab, click the parameter P_UNITS and...there is no data.
If I dismark Hidden from parameter P_USER_ID  and do report execute, it works perfect. I can see units filtered.

I did a test and open such a report from URL. The problem was the same. But when I add in url '&p_P_USER_ID=468edf32-9006-477e-ae54-52e9a8d2fc44' it stared to work.
As conclusion there is a problem when parameter on which other is depended is hidden - I suppose you do not refresh value of hidden parameter to get the default one, so that's why it doesn't work.

IF_Eduardo

Administrator

Registered: 2016-11-01

Website

Re: Problem with parameter which depends on different parameter

Hi Patryx,

I raised ticket RS-3641 for this.

Regards,
Eduardo

IF_Eduardo

Administrator

Registered: 2016-11-01

Website

Re: Problem with parameter which depends on different parameter

Hi Patryx,

thanks for the detailed error description.
I see the problem you mention. I will write here when I have more information.

Regards,
Eduardo

IF_Eduardo

Administrator

Registered: 2016-11-01

Website

Re: Problem with parameter which depends on different parameter

Hi Patryx,

this is corrected and will be fixed in 3.1.0.

Regards,
Eduardo

IF_Eduardo

Administrator

Registered: 2016-11-01

Website

Re: Problem with parameter which depends on different parameter

Hi Patryx,

this was fixed in 3.1.0.

Regards,
Eduardo