Skip to Content
0
Former Member
Mar 03, 2009 at 02:24 PM

Problem on Printing Blank page when no record

23 Views

Hi

I am having some problem when I am printing a report which the data is retrieve from 2 stored procedure. Stored procedure 1 always return some data, on the other hand Stored procedure 2 may/may not product any data.

I used Section Expert to suppress all the section if count COUNT({StoredProcedure2.ID} ) = 0.

I do not think I can use "Suppress print if No record" as in the report it always has a record from Stored procedure 1.

But in this case if it has no record on Stored procedure 2, it will still print the report, which is a blank page.

I am wondering if there anyway I can stop printing a blank page?

E.g. Suppress print if No record in Stored procedure 2?

Thanks in advance

Chi