passing 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 muchon the subreport properties->parameters give
"=Join(Parameters! <ParameterName> .Value,", ") so that the multi value is
passed to the subreport as well.
Amarnath, MCTS
"roy@.mgk.com" wrote:
> 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 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
> passed to the subreport as well.
> Amarnath, MCTS
>
> "r...@.mgk.com" wrote:
> > 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- Hide quoted text -
> - 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:
>
>
> > on the subreport properties->parameters give
> > "=Join(Parameters! <ParameterName> .Value,", ") so that the multi value is
> > passed to the subreport as well.
> > Amarnath, MCTS
> > "r...@.mgk.com" wrote:
> > > 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- Hide quoted text -
> > - 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'......- Hide quoted text -
> - 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.
"roy@.mgk.com" wrote:
> On Mar 22, 8:07 am, r...@.mgk.com wrote:
> > 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
> > > passed to the subreport as well.
> >
> > > Amarnath, MCTS
> >
> > > "r...@.mgk.com" wrote:
> > > > 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- Hide quoted text -
> >
> > > - 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'......- Hide quoted text -
> >
> > - 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......
>|||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
> 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.
>
> "r...@.mgk.com" wrote:
> > On Mar 22, 8:07 am, r...@.mgk.com wrote:
> > > 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
> > > > passed to the subreport as well.
> > > > Amarnath, MCTS
> > > > "r...@.mgk.com" wrote:
> > > > > 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- Hide quoted text -
> > > > - 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'......- Hide quoted text -
> > > - 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......- Hide quoted text -
> - 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:
>
>
> > 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.
> > "r...@.mgk.com" wrote:
> > > On Mar 22, 8:07 am, r...@.mgk.com wrote:
> > > > 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
> > > > > passed to the subreport as well.
> > > > > Amarnath, MCTS
> > > > > "r...@.mgk.com" wrote:
> > > > > > 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- Hide quoted text -
> > > > > - 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'......- Hide quoted text -
> > > > - 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......- Hide quoted text -
> > - Show quoted text -
> ((
> tried but not working...have logged incident with microsoft on this..- Hide quoted text -
> - 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.
"roy@.mgk.com" wrote:
> On Mar 27, 12:53 pm, r...@.mgk.com wrote:
> > 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
> > > 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.
> >
> > > "r...@.mgk.com" wrote:
> > > > On Mar 22, 8:07 am, r...@.mgk.com wrote:
> > > > > 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
> > > > > > passed to the subreport as well.
> >
> > > > > > Amarnath, MCTS
> >
> > > > > > "r...@.mgk.com" wrote:
> > > > > > > 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- Hide quoted text -
> >
> > > > > > - 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'......- Hide quoted text -
> >
> > > > > - 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......- Hide quoted text -
> >
> > > - Show quoted text -
> >
> > ((
> >
> > tried but not working...have logged incident with microsoft on this..- Hide quoted text -
> >
> > - 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.
>|||On Mar 29, 1:24 am, Amarnath <Amarn...@.discussions.microsoft.com>
wrote:
> I simulated your problem , it perfectly works for me..
> Amarnath, MCTS.
>
> "r...@.mgk.com" wrote:
> > On Mar 27, 12:53 pm, r...@.mgk.com wrote:
> > > 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
> > > > 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.
> > > > "r...@.mgk.com" wrote:
> > > > > On Mar 22, 8:07 am, r...@.mgk.com wrote:
> > > > > > 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
> > > > > > > passed to the subreport as well.
> > > > > > > Amarnath, MCTS
> > > > > > > "r...@.mgk.com" wrote:
> > > > > > > > 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- Hide quoted text -
> > > > > > > - 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'......- Hide quoted text -
> > > > > > - 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......- Hide quoted text -
> > > > - Show quoted text -
> > > ((
> > > tried but not working...have logged incident with microsoft on this..- Hide quoted text -
> > > - 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.- Hide quoted text -
> - Show quoted text -
ok - this works when you have different names for the same parameter
in the parent and sub reports.......