not to prompt subreport 1

[unknownly]

Hi All,

I have a SQL Query(which uses bind varaibles) where I have 6 parameters. I create a report which shows all dtl fitlering based on the Parameters. I also include a subreport to summary for that report at the bottom in report footer and using the same query as the main report. when I run the report it ask for prompt values 2 times once for the main report and once for subreport. How can I advoid the prompting for the subreport. Any advice is greatly apericated.

Thanks in advance,
Sweetie

 

[lbass]

Link each of the subreport parameters to the corresponding main report parameter. Use the dropdown in the bottom left corner to select
{?parameter} instead of the default {?pm-?parameter}.

-LB

 

[unknownly]

LB,
First, thank you for the sub report hint I was using ?Pm-?parameter which was why it was it was prompting me second time for the subreport.




Facing another trouble in the main report Users leave blank to run for 'ALL values' or enter a prompt value for 2 of the ?parameters I tried doing this in the record selection but it doesn't work properely can you correct me? please... how does this work in the subreport toooo..



if ({?prompt4} = '' ) and ({?prompt5} = '') then true
else
if ({?prompt4} = '' ) or ({?prompt5} <> '') then
({table.field5} = {?prompt5})
else
if ({?prompt4} <> '' ) or (?prompt5} = '') then
({table.field4} = {?prompt4})
else
if ({?prompt4} <> '' ) and (?prompt5} <> '') then
({table.field4} = {?prompt4});
({table.field5} = {?prompt5});


Thank you,
Sweetie

 

[lbass]

Try:

(
if {?prompt4} <> "" then
{table.field4} = {?prompt4} else
if {?prompt4} = "" then true
) and
(
if {?prompt5} <> "" then
{table.field5} = {?prompt5} else
if {?prompt5} = "" then true
)

-LB

 

[unknownly]

Thank you, LB. You are so good...