refer to report parameters in code

Last Post 26 Feb 2008 03:04 PM by dlsnb. 3 Replies.
AddThis - Bookmarking and Sharing Button
Author Messages
dlsnb
New Member
New Member

--
26 Feb 2008 02:59 PM
Hi All: I would like to use the value AND label of a parameter in a text box. I've tried to refer to it as something like =ReportItems!Parameters!dtDate.value or variants thereof, but haven't had any luck. Does anyone know how? Also, is it possible to get the label as well as the value? Finally, is there an object model somewhere of reporting services' ReportItems, etc? Many thanks. D. Lewis
dlsnb
New Member
New Member

--
26 Feb 2008 03:04 PM

Found the answer:

=Parameters!dateid.Value + " Blah Blah"
SQLUSA
New Member
New Member

--
26 Feb 2008 11:54 PM
Nice!

Trick referencing first >!< then >.<

All about our job security! Enjoy.

Kalman Toth - Database, Data Warehouse & Business Intelligence Architect
SQLUSA: http://www.sqlusa.com/sql-server-2008-training/ The Best SQL Server 2008 Training in the World!
davidmcf
New Member
New Member

--
19 Mar 2008 08:00 AM
As for parameter labels, just use the label property in place of the value property, such as ReportItems!Parameters!dtDate.label.


Acceptable Use Policy
---