JavaScript - SQL Reporting Services - Stack Overflow

admin管理员组

文章数量:1434954

Can We insert javascript in a report rendered by sql reporting services?

eg:- when mouse over happens over a cell i would like to open a div as in case of ajax modal popup control usage.

Can We insert javascript in a report rendered by sql reporting services?

eg:- when mouse over happens over a cell i would like to open a div as in case of ajax modal popup control usage.

• javascript
• reporting-services
• reporting

Share Improve this question Follow edited Feb 20, 2009 at 16:38 Joel Coehoorn 417k114114 gold badges578578 silver badges815815 bronze badges asked Feb 20, 2009 at 16:33 praveenthondapraveenthonda

Add a ment  | 

2 Answers 2

Sorted by: Reset to default 3

Yes, adding JavaScript and jQuery is pletely doable with the results of a SQL query. We have taken the results and looped through them to build up a string that can assign a DIV or CLASS to the rows, columns, or cells. Then apply hover effects to them for the final rendering in your script. We did this for conditional highlighting and conditional hiding of data based on values, along with hover effects for fading in a color on the row/column being hovered upon.

It is not that hard, but it also may not be the most efficient way to do it considering the chance your query results may be hundreds and hundreds of rows.

I would say doable, but check for efficiency.

I've never seen it done and don't exactly like the idea, but here is some information that I dredged up concerning javascript and Reporting Services.

Link

本文标签： JavaScriptSQL Reporting ServicesStack Overflow