x

How to call Aspx page function through SSRS report.

I've an Aspx page on which i'm showing an SSRS Report using Report Viewer, now i've a function in that Aspx page that i need to call. Report consist of a table and i need to be able to invoke this function by clicking the elements in the first column of the table. Is there a way to do this by using javascript in the navigation property of that column?? How to do this, Pls suggest??
more ▼

asked Nov 21, 2012 at 09:16 AM in Default

pjoshi gravatar image

pjoshi
10 1 1 1

(comments are locked)
10|1200 characters needed characters left

1 answer: sort voted first

There are two possibilities that I can think of: javascript injection (which might work) or URLs (which should work).

There is a little bit out there on Javascript injection into SSRS, and it's definitely an advanced topic. You might be able to inject script to call Javascript methods which could perform the functionality you need, but do be aware that if you use the Microsoft Ajax toolkit, there are some compatibility issues with Report Viewer, so this might not even work the way you want.

The other option I could think of is using URLs with querystring parameters and feeding them into your report. The downside to this is that you would get a full page refresh any time somebody clicked on the report link. You might be able to put in your own Javascript on the page here as well, creating a hybrid of the two options.

Honestly, if you need an interactive grid, you'd probably be better off dropping in a GridView (or nested Repeaters if it's a matrix) and setting it up similar to your report. That way, you can keep within the web forms postback model and implement the functionality you need. The Report Viewer control was meant to be a window, not something which affects the rest of your page.

more ▼

answered Nov 21, 2012 at 12:33 PM

Kevin Feasel gravatar image

Kevin Feasel
6.1k 3 5 11

(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

New code box

There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.

Topics:

x555

asked: Nov 21, 2012 at 09:16 AM

Seen: 836 times

Last Updated: Nov 21, 2012 at 12:33 PM