Blank Subreport

[pko123]

I have one main report which has one Group on field A, and there is one linked subreport that inculde detailed information and these two reports are linked with Field A,

Now I want to show , if there is no data for particular group in the subreport I want to show 'No Records Found',

I tried so many things, like using shared variable, supress blank subreport, but not able to get dersired result,

Any suggestion?

 

[lbass]

If there is a recurring field in the subreport (not the linking field) that is only null when the report is empty, you can create a formula like:

if isnull({table.field}) then "No Records"

The subreport->file->report options should NOT have "suppress printing if no records" checked, and you should not have "suppress blank subreport? checked.

Another approach would be to use a reset formula for the sub shared variable in the main report in GH_a, with the sub in GH_b, and then in GH_c you could check that the value of the shared variable was 0 or "" (depending upon the datatype.

-LB

 

[pko123]

Hi LB,
Thanks for your reply, i didn't get the first approach but i used second approach and its working perfectly.

Thanks