SSRS 2005 - public shared variable losing scope on export to PDF

sbornstein2
sbornstein2 used Ask the Experts™
on
Hello all,

I have a SSRS 2005 report that of course does not easily handle getting a dataset value in the header of the report.  SSRS 2008 handles this but we had to do a work around and create a SET function in the code and then using public shared variable to write the value to a textbox in the header.   It is not easily reproducible but on occassion the shared variable seems to lose scope when exporting the report to PDF.  Does anyone know a better way to handle this or is there another method like Friend etc. that is needed?

Thanks for any information.  We are also looking at hidden params and hashtable but the more options we have the better.

Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
If you want to use a value from the main table body all you have to do is this in the header area
Example:   =ReportsItems!Textbox10.value)
 The MyTextbox/fieldName  is the name of the textbox/field name.
So lets say you have a textbox that has theTitle Name in it and the textbox name is TextBox10. Use the above code in the Header Textbox that you want in the header.
If you have to you can hide the textbox in the main table body /detail and you still will be able to view it in the header.

Author

Commented:
will that work in SSRS 2005 and will it persist across all pages?

Author

Commented:
thanks sorry for the delay

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial