Hidden Parameter Problem - 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)

Hidden Parameter Problem

Author

Topic

rcr69er
Constraint Violating Yak Guru

327 Posts

Posted - 2010-04-09 : 09:55:38

Hi Guys

I currently have a hidden parameter which is used to pass a string into one of the data sets that I have.
It currently has a default value of:

=JOIN(Parameters!DivisionId.Value,",")

This will be passed on to a dataset which includes the following sql:

SELECT DISTINCT
Department as Department
FROM dbo.Department WHERE
BrandedOBid in (
SELECT BrandedOBid
FROM dbo.BrandedOB
WHERE divisionid in (SELECT Item FROM dbo.Split(@Division, ',')))

The report is going to be using cascading parameters in which the query above will produce the final parameter.

The problem I am having is that when I set the parameter to be hidden the default value doesn’t seem to work and not populate the final parameter. However when the parameter is set to visible the default value works and populates the final parameter selection drop down.

Anyone have any ideas why this might be happening?

Thanks

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2010-04-11 : 03:25:56

did you try printing out value of join in a textbox and see its getting your correct expected value?

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

rcr69er
Constraint Violating Yak Guru

327 Posts

Posted - 2010-04-12 : 04:15:57

Hey

Yep tried that and its showing the expected values.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources