what If I'm passing a parameter which is null ?? and if the parameter is an integer?
My subreport query is :
SELECT ...FROM ... WHERE ...
and (CRMAF_FilteredContact.ownerid = @ownerid OR @ownerid IS NULL)
ORDER BY CRMAF_FilteredContact.OwnerIDname
When I try it with a null value in the subreport, it works fine, but when I try it from the main report, so I tried to remove the ownerid parameter, I tried to put it at blank, I tried to put NULL but I've always an error, the report start fine but
then, on the total, i've the error "error subreport could not be shown".
I've the error :
[rsErrorExecutingSubreport] An error occurred while executing the subreport subreport3: One or more parameters required to run the report have not been specified.
But then I don't know how to fixe it. I put the @ownerid as blank, but obviously it doesn't like it.
I've done that because i'm using the same sub report above but grouping with this parameter. How can I manage this ?
Thanks a lot,
View Complete Post