Good process to pass an explicit prefiltering to a sub report
Hi I try to pass my parameter CRM_FilteredSystemUser from my main report to the sub report. So it's working fine in the main report. And it's working fine as parameter entered by myself testing straight in the subreport. But I don't know how to set this parameter in the subreport to make this work. In my main report I pass the CRM_FilteredSystemUser =Fields!systemuserid.Value to the sub report. My main report has as report parameters : CRM_FilteredSystemUser, Non-queried : SELECT systemuserid,eu_securityrole, eu_reporthubname, fullname, businessunitidname FROM FilteredSystemUser I'm using as well this parameter in my subreport : ...SELECT businessunitidname, EU_attendanceentry.* FROM EU_attendanceentry INNER JOIN ('+@CRM_FilteredSystemUser+') .... In my subreport I've a report parameter : CRM_FilteredSystemUser / Non-queried : =Parameters!CRM_FilteredSystemUser.Value But doint that I've the error: An error occurred while executing the subreport ‘subreport1’: The definition of the report '/Calls per field Day_SubReport' is invalid. I'm very confused there, thanks for your help, I tried to detail it properly.
October 20th, 2010 4:50pm
I THINK I VE FOUND :))) My issue was in the main report to pass as paramater : CRM_FilteredSystemUser =Fields!systemuserid.Value to the sub report. should be : CRM_FilteredSystemUser =Parameters!CRM_FilteredSystemUser.Value
October 20th, 2010 5:02pm