The Multi-valued Parameters problem in Reporting Services

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss Content Posted by Alex Grinberg » The Multi-valued Parameters problem in...

66 posts, Page 7 of 7

«««3 4 5 6 7

The Multi-valued Parameters problem in Reporting Services

Rate Topic

Display Mode

Topic Options

Author

Message

Jeff Moden

Posted Tuesday, August 17, 2010 2:36 PM

SSC-Dedicated

Group: General Forum Members
Last Login: Yesterday @ 9:01 PM
Points: 33,111, Visits: 27,037

gary.bland (8/17/2010)

What I am trying to accomplish is when I choose a parameter I need to pass the result into another parameter in order to limit the number of available selections. An example would be State and City. Selecting a State would then limit the selection of Cities.

In your example, you'd simply have a two columns... one for city, one for state. Can't do this unless you can relate a city to a state.

--Jeff Moden

"RBAR is pronounced "ree-bar" and is a "Modenism" for "Row-By-Agonizing-Row".

First step towards the paradigm shift of writing Set Based code:
Stop thinking about what you want to do to a row... think, instead, of what you want to do to a column."

For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/

For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

Post #970724

gary.bland

Posted Wednesday, August 18, 2010 11:35 AM

Forum Newbie

Group: General Forum Members
Last Login: Wednesday, May 11, 2011 12:24 PM
Points: 5, Visits: 16

Thanks so much. After sleeping on it last night I finally got it to work. The problem lie within Reporting Services not the function. Thanks again!

Post #971335

drickus

Posted Tuesday, September 11, 2012 3:27 AM

Forum Newbie

Group: General Forum Members
Last Login: Monday, October 22, 2012 1:46 AM
Points: 5, Visits: 44

Hi

Is the above code compatible in the SSRS 2012.

I get the following error.

Unable to cast object of type 'System.Object[]' to type 'Microsoft.ReportingServices.ReportProcessing.ReportObjectModel.Parameter'

Post #1357229

Lucky's

Posted Thursday, October 04, 2012 1:24 AM

Valued Member

Group: General Forum Members
Last Login: Tuesday, January 29, 2013 8:09 PM
Points: 62, Visits: 97

Hi,
Please let me know how to use this function in report.

Post #1368196

Lucky's

Posted Thursday, October 04, 2012 3:29 AM

Valued Member

Group: General Forum Members
Last Login: Tuesday, January 29, 2013 8:09 PM
Points: 62, Visits: 97

Am getting the below error in Report when i used the above functions:
UNABLE TO CAST object of type 'system.object[]' to type 'microsoft.reporting services.reporting processes.ReportobjectModel.parameter'

Post #1368259

Lucky's

Posted Thursday, October 04, 2012 7:09 PM

Valued Member

Group: General Forum Members
Last Login: Tuesday, January 29, 2013 8:09 PM
Points: 62, Visits: 97

Hi ,
Tried using the above code
Am getting the error in report as
UNABLE TO CAST object of type 'system.object[]' to type 'microsoft.reporting services.reporting processes.ReportobjectModel.parameter'

Could you please explain how to use these functions /where to call these fns.

Post #1368795

« Prev Topic | Next Topic »

66 posts, Page 7 of 7

«««3 4 5 6 7

Permissions