[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index]
[Date Index]
[Thread Index]
[SQR-USERS Info]
[SQRUG Home Page]
Re: [sqr-users] No Data
- Subject: Re: [sqr-users] No Data
- From: Rick_Creel@aoncons.com
- Date: Wed, 20 Nov 2002 15:47:26 -0500
- List-id: This list is for discussion about the SQR database reporting language from Brio Software. <sqr-users.sqrug.org>
What I've done for this is to establish a #rec_ctr field with an initial
value of 0.
Everytime I issue a PRINT command, I add one to the counter.
At the end of the program if the #rec_ctr = 0, then I will print a bogus
detail line that essentially says "No Data To Report". Printing this one
detail line will cause all page headings to be invoked.
Ryan_Paul@aismail
.wustl.edu To: sqr-users@sqrug.org
cc: (bcc: Rick
Creel/IT/Aon Consulting)
11/20/2002 03:30 Subject: [sqr-users] No Data
PM
Please respond to
sqr-users
Hello again!
I was wondering if anyone had any suggestions on how to handle a
report that has no data. If a report runs and there is no data I want to
print a page (preferrably with headings) that says there was no data for
the report. Is this a situation where I should check the sql stats to see
if any data is retrieved, or should this be a .sqc of some sort? Any
suggestions or ideas? Thanks!
Ryan
_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users
_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users