ReportServer Forum

Vlad

Member

Registered: 2018-10-17

Column selection is not dynamically updating

In Report Manager for the dynamic list report, we have a SQL query with different "inner joins" depends on script parameter value.
For example:
SELECT *
FROM table1
$!{key1 =="1" ? " INNER JOIN  table2 on table1.col1=table2.col2 " : ""}
key1 is a script parameter with possible value 1 or 0

The problem is that after changing key1 from 0 to 1(or vice versa), without saving variant, and go to the "configure list"->"Select columns" we can see only columns from table1(or from both table1, table2). After a saving variant, the columns list are updated correctly.
It is not user-friendly as we need to resave variant each time we need update columns for the report. And looks like a bug because 'preview section' and exports are updating dynamically without saving variant.
Could you please advise.
Thanks in advance
Vlad

eduardo

Administrator

Registered: 2016-11-01

Website

Re: Column selection is not dynamically updating

Hi Vlad,

I raised issue RS-3094 for looking into this. I will update here when I have more information.

Regards,
Eduardo

fnbajwa

Member

Registered: 2018-07-04

Re: Column selection is not dynamically updating

Hi Eduardo,

Can you please update here status of issue RS-3094?
Is there any way of dynamically selecting columns to be displayed in report (in community edition)?