Jay,
Try limiting your report to one line of data (print ... where limit=1)
If it works then you probably have some bad data in another row.
Bernie Lis
----- Original Message -----
From: "Jay Ward" <[EMAIL PROTECTED]>
To: "RBG7-L Mailing List" <[email protected]>
Sent: Wednesday, June 15, 2005 7:59 PM
Subject: [RBG7-L] - Print problems
I am in the middle of creating a very small database for use with a
homeowners association. I have had no problems creating the forms etc. I
have two reports and one label printing routines. One report, a simple
listing of just two columns works just fine. The more complex report has
a
number of variable that are calculated to be printed, i.e., combining
honorifics and names and doing "if exists" to clean up the lack of a
second
line of street address and putting together city, state and zip. I do the
same on the label run. The report preview works fine and the results are
what I desire. However, when I place them in the application and attempt
to
run them my system freezes. I have tried doing a single line list
somewhat
like the one that works but it fails also. Since the two use different
tables I assume that's the problem but an unload and reload failed to
clear
up the problem. Any direction would be appreciated - using 7.1.80.30421
on
this one.
