I'm curious if this is version specific; i am using vsw2005 and do not see an options button when adding my datasource to the reports so used the report parameters but get an error that "a value expression used for report parameter 'ID' refers to a field.
Fields cannot be used in report parameter expressions." As a result, the subreport property doesn't find a parameter 'ID'.
This response was very helpful (thank you), but I just want to add one thing.
In the parent report you have to right click on the subreport control and add the parameters to the subreport properties just as was done on the subreport itself. Without the parameters in both places it will not work.
I'm making this note for anybody in the future who may be having trouble.
Can you please tell me how can i this achieve in vs2010?There is different concept in it.I have 3 tables. which is related to it.Quote,QuoteConfiguration,QuoteProducts.
Quote is parent table and QuoteCOnfiguration is child table of Quote and QuoteProduct is child table of QuoteConfiguration.
In Quote i need quotenumber and created date,in quoteconfiguration i need its name and in product table i need products name,qty,price quoteconfiguration name wise.
Now can you please ealaborate how can i generate the report.
How can i create subreport for the same,or is there any other solution to achieve this.
reply me soon
thanks
sam
rdlcreportasp .net 2. 0vs.net 2010
Samir Mistry
Please Mark as Answer if you satisfied
ejowens
Member
183 Points
277 Posts
Re: Sub report query based on main report (Microsoft Report Viewer)
Feb 05, 2010 04:58 PM|LINK
I'm curious if this is version specific; i am using vsw2005 and do not see an options button when adding my datasource to the reports so used the report parameters but get an error that "a value expression used for report parameter 'ID' refers to a field. Fields cannot be used in report parameter expressions." As a result, the subreport property doesn't find a parameter 'ID'.
Thanks!
ejo
darshanthack...
Member
38 Points
51 Posts
Re: Sub report query based on main report (Microsoft Report Viewer)
Sep 20, 2010 02:26 PM|LINK
how to display page header for report viewer ? any suggestion ?
its not getting displayed.
asus3000
Member
41 Points
39 Posts
Re: Sub report query based on main report (Microsoft Report Viewer)
Nov 28, 2010 03:53 AM|LINK
This response was very helpful (thank you), but I just want to add one thing.
In the parent report you have to right click on the subreport control and add the parameters to the subreport properties just as was done on the subreport itself. Without the parameters in both places it will not work.
I'm making this note for anybody in the future who may be having trouble.
Victor Del Prete
samirindiani...
Member
128 Points
66 Posts
Re: Sub report query based on main report (Microsoft Report Viewer)
Dec 20, 2010 11:16 AM|LINK
Hello,
Can you please tell me how can i this achieve in vs2010?There is different concept in it.I have 3 tables. which is related to it.Quote,QuoteConfiguration,QuoteProducts.
Quote is parent table and QuoteCOnfiguration is child table of Quote and QuoteProduct is child table of QuoteConfiguration.
In Quote i need quotenumber and created date,in quoteconfiguration i need its name and in product table i need products name,qty,price quoteconfiguration name wise.
Now can you please ealaborate how can i generate the report.
How can i create subreport for the same,or is there any other solution to achieve this.
reply me soon
thanks
sam
rdlc report asp .net 2. 0 vs.net 2010
Please Mark as Answer if you satisfied