Last post Jul 06, 2011 12:08 PM by Ashutosh Pathak
Jul 06, 2011 09:43 AM|MyronCope|LINK
using report builder 2.0
I have a subreport where I am passing a text value as a parameter.
The problem is that when I test hardcode the value in the subreport
SELECT * FROM myTable WHERE myDog='Fido'
this returns values ok but when I run it like this:
SELECT * FROM myTable WHERE myDog=@paramDogName
when I run this I am getting no values returned despite passing in the dogname value to subreport.
do I need to include single quotes in the value I pass to the subreport?
Jul 06, 2011 09:50 AM|MyronCope|LINK
update: the problem is that I am returning values from the main report and passing the dogName value to the subreport but I just checked the main report and there is no value being passed even though I am selecting the value from the dropdownlist on the
params properties. I am selecting the value:
but when I run the report I get the dreaded "error: subreport could not be shown" error, not very descriptive.
I realize part of my problem is that I am returning one record for the main report so I need to get a static value to pass to the sub report. I wil use this one static value (not a value from each record) to pass to the subreport.
Jul 06, 2011 12:08 PM|Ashutosh Pathak|LINK
Why dont you pass the data from the parameter, i mean let the user select dog name from the parameter and pass this parameter to your subreport because there must be a static value for the subreport, you cannot have multiple fieldset and pass them as a sub