I created a main report and made 2 sub reports (copying the main report and made into sub report.) The report is a sales & comm report with one subreport analyse sales by customers and the other sales by commodity group. All reports worked fine and numbers correct but when running the report the main and the sub reports parameters all shows and need input values. I've done the sub report link but still not able to pass. The main and subreport have the same report selection formulae. the selection formula require input of month end date (the start date are specified in the selection as 2 years before the month end date so extract also comparative values for last year todate. then a pararmeter for selecting sales agent (discrete) and in the selection specify the territory code(s) for the agent, other selection criteria are exclusion of certain account type, zero dollar invoices etc.
Your help in Anyone advising me the right way in handling this would be much appreciated.
Thanks
EW