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.
+2
A:
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
I am not sure if this is what you are looking for, but apparently this guy has some information concerning advanced javascript in reporting services.
Here is another 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.
TheTXI
2009-04-25 16:51:48
Yes - but what scares you about that?
David Robbins
2009-04-25 16:54:21
Thanks dude! Just trying to think out of the box with this question.
David Robbins
2009-04-25 16:55:02
I have weird fears. Don't mind me too much
TheTXI
2009-04-25 16:55:14
+2
A:
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.
Rob Allen
2009-04-25 16:59:42
I agree with that for the most part. I tend to want to shy away from requests that try to make a report do a lot more than it should. When I design reports in SSRS, I want something that is going to be the best when printed (since that is the primary medium they will be delivered in aside from PDF).
TheTXI
2009-04-25 17:02:37