Subreport error

• malavika.ramanathan

  SSCrazy

  Points: 2790

  More actions

  April 19, 2010 at 1:17 am

  #139682

  Hi All,

  I have a master detail report. the subreport was working fine. but the reqmnt changed and few more columns were added.

  now it is not shown. i have given the parameters correctly.

  both master and detail (subreport) run individually, but i am not able to call the subreport.

  what may be the reason?

  i got this soln in google:

  change the vsible property of the subreport item in the calling property to Expression so that it handles it if there is no data.

  it was something like:

  =iif (First(some field of the subreport) is Nothing,True, False)

  it run only once with this but since second time m getting error.

  please help.

  Thanks

• malavika.ramanathan

  SSCrazy

  Points: 2790

  More actions

  April 19, 2010 at 2:54 am

  #1153654

  Hi All,

  I found one more point here. the main report has 4 parameters: user location, fromdate,todate.

  I am passing only @rid(user) to the subreport.

  May be this is causing error. In the subreport i use from and todate along with @rid as parameters.

  I should pass them too to the subreport isn't it?

  Could any one tell me how to do that?

  I need those parameters so that the corresponding result sets are got in the subreport to that of main report.

  Please help. its a bit urgent.

  Thanks in adv.....