Copying notes across reports at run-time

Question

Post reply

Copying notes across reports at run-time

SSRS_fan

Grasshopper

Points: 17
More actions
January 14, 2013 at 1:50 am

#287589

I have a project in SSRS 2008 with multiple reports. Each of these reports have identical text boxes across the different reports. At the moment, users have to edit each text box individually. Is there a way to have a centralised reference point where the common text boxes are held and edited with the changes being carried across to the reports.
I considered creating a template, but I would like to be able to update changes dynamically at run-time.
I was hoping that there would be a variation on "ReportItems!Textbox3", such as "ReportName!ReportItems!Textbox2" that I could use as an expression to populate values. Considering that google has now failed me, can the forum suggest a better way forward?
Thanks in advance

Viewing 4 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Daniel Bowlin SSC-Dedicated Points: 34566 More actions · Answer 1

Can you give some examples? Users can't edit textboxes in a report once it is rendered.

SSRS_fan Grasshopper Points: 17 More actions · Answer 2

My apologies for not being clear.

The kind of thing I had in mind was

Within the same solution:

Report1: Textbox a and texbox b (with textbox a and textbox b) <---edited in design mode

Report2: Textbox c (with textbox a's content/text) <-------------------linked to Report1!ReportItems!textbox a.value <?>, and rendered. Not edited

Report3: Textbox d (with textbox a's content/text)<-------------------linked to Report1!ReportItems!textbox a.value <?>, and rendered. Not edited

Report4: Textbox e (with textbox b's content/text)<-------------------linked to Report1!ReportItems!textbox b.value <?>, and rendered. Not edited

This means that when changes are made to textboxes a and b by the report developer in design modes, when reports 2,3,4 are rendered to textboxes c,d,e without copying/pasting the same information over and over again.

Does that help clarifying what I am getting at?

Daniel Bowlin SSC-Dedicated Points: 34566 More actions · Answer 3

So if I understand, you have static content on one report that you would like other reports to use. That static content can be updated from time to time by developers and you want the other reports to refer to that updated content. The only way I can think to do this is with a linked image where the image contains your content, not a text box. That way when the content of the image is updated, all reports that call that image from the common source will be updated.