Skip to Content
0
Former Member
Dec 29, 2009 at 06:09 PM

number of records returned

69 Views

hi,

i have to display No Data Found message in the report when there is no data returned from DB.

here is my report structure

Gh1

Gh2

Gh3

D

GF3

GF2

GF1

RFa

RFb

RFc

I've to display the user entered parameter values on the last page and used RFa, RFb, RFc and used New Page Before option.

Now, when there is no data returned,I have 2 pages; 1 blank as there will be no data and the second to display the parameter values entered by user.

I need to display No Data Found just above the Report Footer. I've tried creating the formula Count({tbl.field}) and placed in GF1 and tried the conditional New Page Before for RFa like Count({tbl.fd})>0, but it's not working.

Please help me if this is correct approach or is there a simple approach.

Thanks

Naresh