December 10, 2009 at 9:26 am
Hi,
I have got a main report. The report shows the top level details of a schools performance. There are two parameters linking to
[Dim Date Time SA].[AC YEAR].&[AC 08-09]
[Current School].[SCH NAME].&[Test School]
Within this report I have a text box that says ‘Show Pupils’
I go to Navigation’Jump to Report’ and then choose the report I want to go to.
This report also has the parameters
[Dim Date Time SA].[AC YEAR].&[AC 08-09]
[Current School].[SCH NAME].&[Test School]
I then go to parameters and for each of my parameters I choose expression, then go to dataset and choose the Parameter value.
=First(Fields!SCH_NAME,”SessionalSchoolName”)
=First(Fields!AC_YEAR,”DimDateTimeAACYEAR”)
Deploy and run and I get the error message
The 'SessionalSchoolSCHNAME' parameter is missing a value
I have tried adding different things into Paramter value. E.g. =First(Fields!SCH_NAME.Value, "Section1")
=First(Fields!AC_YEAR.Value, "Section1")
But again The 'SessionalSchoolSCHNAME' parameter is missing a value.
Could anyone suggest anything else I could try or what I am doing wrong?
BTW if I go and preview the report it always goes to a blank screen where you have to choose from the drop down list.
I am really struggling with this one
Thanks
Debbie
December 16, 2009 at 8:10 am
I've had similar problem with reports that use an AS dataset. The parameters in the second report are expecting MDX so make sure the parameter values that are being passed to it are formatted that way.
You can check this by dragging a textbox on your report with the value you're passing to the linked report and make sure it looks like MDX.
December 17, 2009 at 6:45 am
I then go to parameters and for each of my parameters I choose expression, then go to dataset and choose the Parameter value.
=First(Fields!SCH_NAME,”SessionalSchoolName”)
=First(Fields!AC_YEAR,”DimDateTimeAACYEAR”)
Looks like your parameters have dataset values in them. If you're referencing a parameter it should look like =Parameters!SessionalSchoolSCHNAME.value. Are you trying to pass the same parameter values in the top level report to the lower level report?
(is this by chance the 'Students Achieve' software?)
January 26, 2010 at 4:50 am
Sorry for the late reply. Its not Students Achieve software. Im going on a course next week in regards to business intelligence so Im going to take the issue there to see if they can solve it. I will let you know what I find!
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply