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

How to remove invisible procedure call with null parameters in Telerik bar chart report

3 Answers 27 Views
General Discussions
This is a migrated thread and some comments may be shown as answers.
Joan
Top achievements
Rank 1
Joan asked on 25 Feb 2014, 01:37 PM
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?

3 Answers, 1 is accepted

Sort by
0
KS
Top achievements
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
0
Joan
Top achievements
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.

0
Accepted
KS
Top achievements
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
Tags
General Discussions
Asked by
Joan
Top achievements
Rank 1
Answers by
KS
Top achievements
Rank 1
Joan
Top achievements
Rank 1
Share this question
or