Dan
Create a tempoary table by using the project command.
R:>PROJECT TEMPORARY tmpTableName FROM ReportTableName +
USI ALL WHE COUNT = 0
COPY the report and base it on tmpTableName.
Rename the original report to somethingelse.
Rename the report you just copied to the original report name
Now in your code do the following
PROJECT TEMPORARY tmpTableName FROM ReportTableName +
USI ALL WHE whereclausehere
SEL COUNT(*) INTO VRows INDIC IVRows FROM tmpTableName
IF VRows = 0 THEN
INSERT INTO tmpTableName (somecolumn) VALUES NULL
ENDIF
PRINT reporthere
Buddy
-----Original Message-----
From: Dan Goldberg [mailto:[EMAIL PROTECTED]]
Sent: Thursday, August 29, 2002 11:35 AM
To: Rbase-L
Subject: PRINTING A REPORT THAT HAS NO DATA
I have a daily report that I print out and sometimes it has no rows that
exist. So nothing prints out.
In order to make sure that they are not missing a report, they want a report
every day whether it has data in it or not. The only way I could see to do
this is to make a separate report that has no data.
I tried using the following command:
PRINT reportname where limit = 0
It did not work. I know in Acce** that if no rows exist you can still print
a report.
Does anybody know a way around this or do I just have to create a separate
report??
Dan Goldberg
================================================
TO SEE MESSAGE POSTING GUIDELINES:
Send a plain text email to [EMAIL PROTECTED]
In the message body, put just two words: INTRO rbase-l
================================================
TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED]
In the message body, put just two words: UNSUBSCRIBE rbase-l
================================================
TO SEARCH ARCHIVES:
http://www.mail-archive.com/rbase-l%40sonetmail.com/
================================================
TO SEE MESSAGE POSTING GUIDELINES:
Send a plain text email to [EMAIL PROTECTED]
In the message body, put just two words: INTRO rbase-l
================================================
TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED]
In the message body, put just two words: UNSUBSCRIBE rbase-l
================================================
TO SEARCH ARCHIVES:
http://www.mail-archive.com/rbase-l%40sonetmail.com/
