Wednesday, March 21, 2012

Problem Plz Help

I have made a report with 2 parameters.

Parameters are

1. Compay_ID Integer

2. Resource ID Integer

There parameters are automatically added because i am using a stored procedure that have these 2 parameters.

When i call the report and give it parameter having values 1 ,1 . page give me error

The value of parameter 'Parameters' is not valid. Check the documentation for information about valid values. --> The value of parameter 'Parameters' is not valid. Check the documentation for information about valid values.

Description:An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details:System.Web.Services.Protocols.SoapException: The value of parameter 'Parameters' is not valid. Check the documentation for information about valid values. --> The value of parameter 'Parameters' is not valid. Check the documentation for information about valid values.

I am very much worried about it and unable to understand what is the problem .

I am new to these reporting services and dont know so much about it

PLz help

Thanks

Hi,
I think that the problem is the Parameters' name.
You can check their exact name in Report Parameters (Name that's the name of the parameter expected by store proc).|||plus. you might also want to change the datatype of the parameters to integer. You can do this from Report -> Parameters
|||Well, just by looking at the exception handlers there are two things I would consider!
It is not necessary to define the parameter from Reporting Services "parameters" as an integer. Just define it as a string... I am not even sure why an Integer Parameter type was defined within MSRS - maybe the developers have an answer. All keys in my database are integers - but I never pass an Integer Parm.
CREATE PROCEDURE ????(Whatever) @.Parm_Allergic_Group nvarchar(5) as

-- SETUP RUNTIME OPTIONS / DECLARE VARIABLES --
set nocount on
Just make sure you define the parameter list within the stored procedure in the sequence you provide the parameter selections within Reporting Services.....
If you have a "string" passed from reporting services and you use to compare against an "Integer" key - you wil get a hit - so once again - just define as a string and make sure the syntax on the Create Procedure is correct with the expected variables.
# 2:
So are you displaying the available selection list within MS RS from a query - then the user selects a parameter from the selection list --- If so, if you define as a "string" there should be no problems!
# 3
Can you execute the SQL from the data set you defined within MS RS - create a TEST application within MS RS copy the SQL from the stored procedure - paste into a data set within the TEST application and see if it runs! If you run from reporting services the parameter list will present itself and - you as a user cannot enter "INTEGER" characters - so why define the "integers" Notice Integer CHARACTERS - Integer are not Characters!!!!
I have discovered that it is just best to define your parameters as "strings" and then everything will work as planned.
Best regrads.
Joe Harris

No comments:

Post a Comment