subreport pass a blank parameter

• bugs-bunny-race

  Grasshopper

  Points: 16

  More actions

  September 2, 2010 at 3:23 am

  #223301

  HI

  Is it possible to use a subreport with three parameters passed to it (i tried it, it works fine) but then I want to make the count of this subreport, so i need in the group below to add this subreport again inside again, but passing less parameters, so i modify my query like that :

  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 always have 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 ?

  Maybe I don't need to add a subreport cell but just link this cell with the other cell containing the subreport ???

  Thanks for your help,

• H4K

  Hall of Fame

  Points: 3374

  More actions

  September 9, 2010 at 1:28 am

  #1218409

  Hi,

  i didn't get the problem ur facing. Try to use some images to show ur problem and also be specific ?? what r u trying to achieve ??

  BI Developer
  SSRS, SSIS, SSAS, IBM Cognos, IBM Infosphere Cubing services, Crystal reports, IBM DB2, SQL Server, T-SQL
  Please visit... ApplyBI