January 4th, 2010, 10:21 AM
Sub-Report - Repeated input parameter prompt.
I have 2 sub reports in detail section of the main report. They all have the same i/p parameter(date) and i have linked the i/p param of the main report with the sub report thro the change links of the sub-report command. The problem is once i run the report it prompts for the i/p again and again.....
Does anyody have a solution to this problem
thanks in advance
January 5th, 2010, 06:56 AM
Re: Sub-Report - Repeated input parameter prompt.
Check your selection formulas in the subreports. For some reason it looks like the subreports are not actually getting the parameter, and I usually find that the selection formula got messed up. Another reason could be that the link could be used in another formula somewhere, and then was changed. I had this happen once, after setting up all of the formulas on the subreport, I changed the parameter name. The formulas however did not automatically change the parameter name. Finally, recheck that the links to the subreports, just in case.
Click Here to Expand Forum to Full Width