Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Is it possible to embed javascript into an SSRS Report?

SQL Server reports can embed vbscript and execute client side, but can the same be done with javascript? I think there would be great utility to be able to execute jQuery and CSS manipulation client side to create a more interactive drill down experience.

like image 439
David Robbins Avatar asked Apr 25 '09 16:04

David Robbins


2 Answers

It sounds to me like Reporting Services is the wrong front end for your job. The RDL (report definition) files are basically XML. I don't know of a way to add code to XML.

If you consider the RDL output to be your "data" then it doesn't really make sense to house any behavior here any way. Instead, you may want to build a front end which can consume the final report output then provide the experience you are looking for.

like image 116
Rob Allen Avatar answered Sep 22 '22 15:09

Rob Allen


Are we talking about SQL Server Reporting Services?

If so, I have not ever seen a method to do it. I will admit that the notion makes my skin crawl, though.

Edit

Here is a small example of using JavaScript to open a separate window in a hyperlink.

This blog article may contain even better information for some interesting JavaScript techniques in reporting services.

like image 31
TheTXI Avatar answered Sep 19 '22 15:09

TheTXI