April 1, 2014 at 10:34 am
In an SSRS 2008 R2 existing report, I am passing a new parameter called 'SchoolYear' to an existing report. I obtain the value for SchoolYear from the following statement =(Fields!SchoolYear.Value) that is used against the dataset DS_Main.
I am getting the error message, "The 'SchoolYear' parameter is missing a value" when the called SSRS report is running. When I 'hard-code' the school year value in the called ssrs report, the called report runs.
When I run the sql in the dataset DS_Main, I get all kinds of rows and all the rows contains data.
Thus I do not know how the 'SchoolYear' parameter is not passing a value. Would you tell me what I can do to determine
what is causding this problem?
April 1, 2014 at 4:39 pm
Is the parameter being passed to a subreport? If so do you have the parameter defined in the subreport properties on the main report?
May 7, 2014 at 3:26 pm
Do you have anything configured under report properties for available values and default values that might cause this behavior?
----------------------------------------------------
May 8, 2014 at 9:29 pm
Verify the parameter in each of your queries. Beware that parameters are cap sensitive and you could be running into it passing to not all of your queries.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply