x

ReportBuilder 3 - Update a Parameter with an Action

Hello all, I am building a financial overview report for project managers, in one section I have monthly expenditure data. In another section I'd like to have the details of the expenditures (specifics)...

I can get the subreport to display, but what I am trying to do is update the parameter automatically (when the PM clicks on June 2011 for example, detail for June 2011 would appear in the subreport)... however I don't see any way of making the "textbox action" for the period be able to update the parameter...

The only options I could have is to go to other report (which I don't want, as I'd like to have this on the same page), or go to URL (no), or go to bookmark (? probably not)

.. I would think that this is possible, anybody have any advice on how I could do this, any help would be appreciated... Thanks, Sheep
more ▼

asked Sep 13, 2011 at 03:24 PM in Default

TelepathicSheep2 gravatar image

TelepathicSheep2
140 14 15 17

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

1 answer: sort newest

I don't know how to tell you the specifics, but [Simon Sabin's recent PASS presentation][1] on Slicers was amazing and shows how to make SSRS interactive. You could probably glean how to accomplish that by using his techniques.

[1]: http://sqlblogcasts.com/blogs/simons/archive/2011/09/09/adding-slicers-to-reporting-services-downloads.aspx
more ▼

answered Sep 14, 2011 at 12:34 PM

Mark gravatar image

Mark
2.6k 23 25 27

Thanks for your help, the demo file regarding button selection looks like it contains everything that I need - amazing resource - thanks again!
Sep 14, 2011 at 02:17 PM TelepathicSheep2
You're welcome, I was glad I was able to catch his webinar. I was impressed.
Sep 14, 2011 at 03:01 PM Mark
(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:

x72
x15

asked: Sep 13, 2011 at 03:24 PM

Seen: 1501 times

Last Updated: Sep 13, 2011 at 03:24 PM