Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Report printing same record multiple times
Message
General information
Forum:
Visual FoxPro
Category:
Reports & Report designer
Miscellaneous
Thread ID:
00274424
Message ID:
00274433
Views:
22
>Hello:
>
>I'm having trouble with my report printing....instead of printing
>one record it prints the same record 3 times sometimes, sometimes
>four times. what could be causing this?? My code is as follows:
>
>
>
>select gisum
>Ccur_rec = recno()
>
>Csin = Client.sin
>Cname = allt(client.surname) + ", " + allt(client.firstname)
>Dstartdate = gisum.startdate
>Cstarttime = gisum.starttime
>Ctitle = gisum.title
>Creason = gidetail.reason
>Clocation1 = gisum.location1
>Clocation2 = gisum.location2
>Clocation3 = gisum.location3
>If messagebox("Do you wish to include the FAILED TO REPORT warning message?", 4, "CATS") = 6
> Printer = GetPrinter() && Displays windows dialog box
> report form letwarn noconsole to printer &&file search ascii
>Else
> Printer = GetPrinter() && Displays windows dialog box
> report form letter noconsole to printer &&file search ascii
>
>Endif
>select gisum
>go Ccur_rec
>
>Any input would be appreciated.......

It appears that your are taking the values from the first record and putting them in memory variables before calling the report. Could it be that the current work area table has more than one record? Even though you are getting your data from memory variables, if the current work area table has more than one record, the detail section of the report will repeat once for each record in the current work area table even if the data from that table is not used in the report.

HTH.
Michael P. Antonovich, MCSD
Email: mike@micmin.com
MicMin Associates - Orlando, FL


Previous
Next
Reply
Map
View

Click here to load this message in the networking platform