Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Analysis Server and Reporting Services (2005)
 Report Parameter

Author  Topic 

Beginer2012
Starting Member

45 Posts

Posted - 2012-06-19 : 10:38:29
Hello,
I need help in report parameters. I'm trying to store one value from one tablix to use it in another tablix within the same report. However, when I create my parameter and run the report I'm getting an error message saying :
A value expression used for the report parameter 'Par' refers to a field. Fields cannot be used in report parameters expressions.

Any suggestions ?

Thank you

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2012-06-19 : 15:41:13
you dont need parameters for that. provided tablixes are in same scope you can use

=ReportItems!textboxname.value
in second tablix to point to first tablix textbox

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Go to Top of Page

Beginer2012
Starting Member

45 Posts

Posted - 2012-06-22 : 10:26:05
Thank You Very Much visakhm16
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2012-06-22 : 23:29:12
wc

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Go to Top of Page
   

- Advertisement -