This is a migrated thread and some comments may be shown as answers.

ConnectionString Report Parameter and Binding

4 Answers 973 Views
General Discussions
This is a migrated thread and some comments may be shown as answers.
Curt Rabon
Top achievements
Rank 1
Veteran
Curt Rabon asked on 09 May 2020, 01:53 PM

I need to dynamically provide a ConnectionString to a .trdp at runtime.
I've tried to use a parameter and a binding as stated here: https://docs.telerik.com/reporting/knowledge-base/how-to-pass-connectionstring-to-report-dynamically-through-report-parameter
but I can't get it to work. Without the parameter and binding, the existing dataSource works fine in preview. I'm using Standalone Report Designer 13.2.19.1213. When I add the parameter and binding, and put the connection string value in the parameter input box during preview, I get an error. See the attached picture that shows all settings.

4 Answers, 1 is accepted

Sort by
0
Neli
Telerik team
answered on 13 May 2020, 06:38 AM

Hello Curt,

I have already answered the same questions in Binding "DataSource" Property forum post.

Regards,
Neli
Progress Telerik

Progress is here for your business, like always. Read more about the measures we are taking to ensure business continuity and help fight the COVID-19 pandemic.
Our thoughts here at Progress are with those affected by the outbreak.
1
Curt Rabon
Top achievements
Rank 1
Veteran
answered on 13 May 2020, 02:31 PM

After looking carefully at https://docs.telerik.com/reporting/expressions-bindings, I noticed that I did not start the binding's expression value with an equal sign, so instead of =Parameters.ConnectionStringParam.Value, I only had Parameters.ConnectionString.Value. I fell into this trap because your page at https://docs.telerik.com/reporting/knowledge-base/how-to-pass-connectionstring-to-report-dynamically-through-report-parameter does not show the equal sign in your example. I suggest showing the equal sign or reminding people that it's needed.

After using the equal sign, the report parameter works fine, and I can dynamically switch the connection string.

0
Remco
Top achievements
Rank 1
answered on 21 Oct 2020, 04:53 AM
Thanks for your suggestion to prefix the binding with an equal sign, that solved my problem too. Unfortunately after 5 months this Telerik documentation post is still not updated. 
0
Latha
Top achievements
Rank 1
Iron
answered on 22 Sep 2022, 03:30 PM

i get the same error

Neli
Telerik team
commented on 27 Sep 2022, 09:15 AM

Hi Latha,

I noticed that a similar problem is discussed in the Missing operand before '=' operator forum thread. I would recommend sending me the problematic application, so I can inspect it on my end.

Tags
General Discussions
Asked by
Curt Rabon
Top achievements
Rank 1
Veteran
Answers by
Neli
Telerik team
Curt Rabon
Top achievements
Rank 1
Veteran
Remco
Top achievements
Rank 1
Latha
Top achievements
Rank 1
Iron
Share this question
or