 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
SQL Server Forum / Services / Reporting Services / March 2007passing multi-value parameter to subreport
ok - i've googled this and have tried everything to no avail.... parent report has multi-value parameter: part_code this gets passed to subreport which has part_code setup as multi- valued paramter what is the syntax in the parent...subreport properties/parameters box and what is the syntax in the child report parameters form? thanks very much on the subreport properties->parameters give "=Join(Parameters! <ParameterName> .Value,", ") so that the multi value is passed to the subreport as well. Amarnath, MCTS > ok - i've googled this and have tried everything to no avail.... > [quoted text clipped - 10 lines] > > thanks very much On Mar 21, 9:10 am, Amarnath <Amarn...@discussions.microsoft.com> wrote: > on the subreport properties->parameters give > "=Join(Parameters! <ParameterName> .Value,", ") so that the multi value is [quoted text clipped - 19 lines] > > - Show quoted text - did that Amarnath ))....and i have in the parent the subreport properties/parameters: "=Parameters!PART_CODE" all i get is 'error - subreport could not be shown'........ On Mar 22, 8:07 am, r...@mgk.com wrote: > On Mar 21, 9:10 am, Amarnath <Amarn...@discussions.microsoft.com> > wrote: [quoted text clipped - 29 lines] > > - Show quoted text - i should've said i implemented that....as well as the "=Parameters! PART_CODE" in my previous reply... is there some change in the SQL?...i'm just using the ".....part_code in (@PART_CODE)" with the paramter setup normailly in the subreport's report parameter properties....... To be very clear, The problem is due to parameters only. First go to the report which you include as "Subreport" in the main report. open the report properties, check for multi-value. close that remaining same. (ie string, non queried or queried, default null.) Go to the main report where you have placed subreport. on the subreport right click for properties and the parameter, this is the main culprit for not working. Parameter Name: select from the drop down. Parameter Value: "=Parameters!cn.Value" here just include value instead of Value(0) This should work. Let me know if it works. Amarnath, MCTS. > On Mar 22, 8:07 am, r...@mgk.com wrote: > > On Mar 21, 9:10 am, Amarnath <Amarn...@discussions.microsoft.com> [quoted text clipped - 37 lines] > in (@PART_CODE)" with the paramter setup normailly in the subreport's > report parameter properties....... On Mar 23, 1:21 am, Amarnath <Amarn...@discussions.microsoft.com> wrote: > To be very clear, The problem is due to parameters only. First go to the > report which you include as "Subreport" in the main report. open the report [quoted text clipped - 57 lines] > > - Show quoted text - (( tried but not working...have logged incident with microsoft on this.. On Mar 27, 12:53 pm, r...@mgk.com wrote: > On Mar 23, 1:21 am, Amarnath <Amarn...@discussions.microsoft.com> > wrote: [quoted text clipped - 66 lines] > > - Show quoted text - i've spoken to microsoft tech support - and they could not get it to work....i'm assuming at this point we cannot reference a multi-value paramenter in a subreport that rerferences it in the SQL statement with the 'IN (@MYPARAM) manner...too bad...will have to figure out a work-around. I simulated your problem , it perfectly works for me.. Amarnath, MCTS. > On Mar 27, 12:53 pm, r...@mgk.com wrote: > > On Mar 23, 1:21 am, Amarnath <Amarn...@discussions.microsoft.com> [quoted text clipped - 73 lines] > with the 'IN (@MYPARAM) manner...too bad...will have to figure out a > work-around. On Mar 29, 1:24 am, Amarnath <Amarn...@discussions.microsoft.com> wrote: > I simulated your problem , it perfectly works for me.. > [quoted text clipped - 80 lines] > > - Show quoted text - ok - this works when you have different names for the same parameter in the parent and sub reports......... |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2009 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.