April 23, 2010 at 6:27 pm
I created a main report which contains the bar charts,When I click on the bar in the main chart it takes me to subreports which is related to that bar chart. I clicked on the barchart went into properties ------>Data------->Edit-------->Action--->jump to report-->added child report.then clicked on the parameters next to the jump to report and added the parameters.i.e I added three parameters in that list
Now I went back to the child report and in dataset I added the parameters for eg(column name=@column name).Then went into the layout view the added parameters.Whn I went back to child dataset and click on run the query
I am passing parameters through "Text" not through the "Stored Procedure"
I am able to see the parameter which are passed to the child report but when I click on the view report I am getting following error
Must declare a Scalar variable "@" (Microsoft sql server error: 137)
May 10, 2010 at 9:42 am
I had a similar problem. Verify that the Data Source Type of the data source that your report is using is set to Microsoft SQL Server and not OLE DB.
May 10, 2010 at 11:30 am
Can I get the text you provided for the datasource.
Also just check in the where condition you have given @parametername same as the name you have given for the report prameter.
Thanks & Regards,
MC
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply