Jump to Report not working - SQL Server Forums

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)

Jump to Report not working

Author

Topic

mvanwyk
Yak Posting Veteran

99 Posts

Posted - 2009-08-27 : 02:34:32

Hi Team.
I have a report, this report has the following information that I have compiled.

Customer Invoiced Payments Balance
CustomerA 100.00 100.00 0.00

This report currently has 1 parameter called @SapDB this is used to determine which DB to look at.

On this report I would like to enable the "Jump to Report" function that SSRS 2005 has.

If you enable this on the 100.00 under the Invoiced column it should jump to a report called invoices.

Invoices also has a parameter called @SapDB and another called @Customer which comes from the 1st colunm in the previous report
So I right click on that field and select properties.
Then navigate to navigation.
I enabled the "Jump to report" radio button and select the Invoices report in the drop down.
I then select "Parameters"
Choose SapDB as the Parameter Name and the Parameter value = SBO_Company_2009
Choose Customer as the Parameter Name and the Parameter value = =Fields!Customer.Value

I then click OK and OK again on the last click on OK I get the following error.

Microsoft Report Designer.

“The Properties for the current selected item are not valid. Please correct all errors before continuing”.

What am I missing here?
What do I need to do in order to pass the parameter SapDB from 1 report to another without hard coding it?

Any help would be appreciated.

Thanks.

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2009-08-27 : 10:54:45

is SBO_Company_2009 hardcode value for SapDB? if yes, try giving it like,

="SBO_Company_2009"

mvanwyk
Yak Posting Veteran

99 Posts

Posted - 2009-08-28 : 05:59:51

Hi

I have tried that...

SapDB ="SBO_Company_2009" Hardcode
Customer =Fields!Customer.Value

And still get the same error.

Besides that not working how am i going to get SapDB value transfered from the 1st report to the second without hardcoding

Cheers.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources