I built a telerik bar chart, it displays properly when I don't use any IN parameters, however when I call at least one IN parameter, then the procedure gets called twice. Once with the valid parameter values and the second time with null values. The breakpoint hits all lines only once. I am not sure why it is calling the database procedure twice (only with IN parameters).
Additional information: C#, Telerik Q3 Reporting in Visual Studio 2012, SqlDataSource, The report is called from the DLL report library.
(Also, I tried with one string IN parameter, and with two: string and int64. I hardcoded the parameters and it still did not fix the issue)
What may cause this additional call?
Additional information: C#, Telerik Q3 Reporting in Visual Studio 2012, SqlDataSource, The report is called from the DLL report library.
(Also, I tried with one string IN parameter, and with two: string and int64. I hardcoded the parameters and it still did not fix the issue)
What may cause this additional call?
3 Answers, 1 is accepted
0
KS
Top achievements
Rank 1
Rank 1
answered on 25 Feb 2014, 08:21 PM
Hi,
Stored procedure executes twice.. one to get the schema, two to get the data. Test loading a Datatable with adapter and the procedure a command.
-KS
Stored procedure executes twice.. one to get the schema, two to get the data. Test loading a Datatable with adapter and the procedure a command.
-KS
0
Joan
Top achievements
Rank 1
Rank 1
answered on 27 Feb 2014, 04:35 PM
KS, I should have mentioned that this report worked at one point for about two days. Suddenly it stopped working and started causing this issue for no valid issue. I checked out the same revision that previously worked from subversion and it still fails. Would you have any ideas what might have caused the report to stop working?
Also, we tried with graph chart. Again, the same thing happened. It worked for two days and now it does not. We are using the same C# code and the same procedure. The graph calls procedure only once with valid values in the parameters. We could see the axis and data, now we can only see a long string of data, no axis.
Another clue is that the graph works in the IE9 compatibility view but it does not if I disable compatibility. It also displays data with axis when we export it to PDF, but it won't load properly to the page.
Also, we tried with graph chart. Again, the same thing happened. It worked for two days and now it does not. We are using the same C# code and the same procedure. The graph calls procedure only once with valid values in the parameters. We could see the axis and data, now we can only see a long string of data, no axis.
Another clue is that the graph works in the IE9 compatibility view but it does not if I disable compatibility. It also displays data with axis when we export it to PDF, but it won't load properly to the page.
0
Accepted
KS
Top achievements
Rank 1
Rank 1
answered on 27 Feb 2014, 05:52 PM
Hi,
The Graph is rendered as an SVG, means IE9+(due to the HTML5 support). Check this setting to have the graph in older browsers - http://www.telerik.com/help/reporting/device-information-settings-html.html
One more thing, Compatibility View is no good, add meta tag to use the normal rendering - IE=edge will be OK.
-KS
The Graph is rendered as an SVG, means IE9+(due to the HTML5 support). Check this setting to have the graph in older browsers - http://www.telerik.com/help/reporting/device-information-settings-html.html
One more thing, Compatibility View is no good, add meta tag to use the normal rendering - IE=edge will be OK.
-KS