You are not logged in.
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.
Offline
Hi Patryx,
I raised ticket RS-3641 for this.
Regards,
Eduardo
Online
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
Online
Hi Patryx,
this is corrected and will be fixed in 3.1.0.
Regards,
Eduardo
Online
Hi Patryx,
this was fixed in 3.1.0.
Regards,
Eduardo
Online