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

avatar image

140 15 15 19

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

1 answer: sort voted first

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

more ▼

answered Sep 14, 2011 at 12:34 PM

avatar image

2.6k 24 27 31

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.

Follow this question

By Email:

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



Answers and Comments

SQL Server Central

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



asked: Sep 13, 2011 at 03:24 PM

Seen: 1967 times

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

Copyright 2018 Redgate Software. Privacy Policy