Hi ,
Can any one help me with the following problem?
I have a main report consisting of 36 subreports(on-demand). the selection criteria for main report is not available to subreports.
i tried passing parameters by 'changing sub report links'. It doesn't seem to work.
the query of main report is as shown
'Select * from view A
where
(A.Business_Unit in ({?BusinessUnit})
And A.Company IN ({?Company})
And A.Location IN ({?Location})
AND A.fl_Manager IN ({?xManagerOrg})
AND A.[Function] IN ({?mFunction}))
And A.Performance_Year = {?PerformanceYear}'
the query of subreport is
'Select * from view a
where a.Overall_How = 'CE'
And a.Overall_What = 'U'
the main report has the parameters mentioned in the query of main subreport.
no parameters is created in subreport since it creates while changing subreport link.
eg:
though the selcetion criteria is only for few locations according to the main report query, the subreport is showing data for all locations
how do i fix it?
Please help.
IP Logged
