Expression Syntax Jump to report

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)

Expression Syntax Jump to report

Author

Topic

mvanwyk
Yak Posting Veteran

99 Posts

Posted - 2009-08-28 : 09:46:19

Hi Team.

I'm still having issues with the jump to report function in SSRS 2005.

I have 2 reports.

RPT 1 Customers
The 1st report requires a parameter @SapDB
This report display 4 fields.
Customer Code
Customer Name
Invoiced Amount
Payment Amount
Outstanding Balance

RPT 2 Invoices
This report requires 2 parameters
@SapDB
@CutomerCode

On each row for Invoiced amount in RPT 1 i right click and select "Properties"
The navigate over to Navigation and then enable "Jump to report" radio button.

I then select the report it needs to jump to RPT 2 and complete the parameter settings as follows.

SapDB = parameters!SapDB.Value
@CutomerCode = =Fields!CardCode.Value (ignore the 1st = sign)

Everytime i try and apply the setting a get an error.
"The property for the current select item are not valid"

Can someone please help me....

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources