Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Report problem in 5.0a
Message
De
11/12/1997 12:10:17
Cetin Basoz
Engineerica Inc.
Izmir, Turquie
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Divers
Thread ID:
00064997
Message ID:
00065293
Vues:
29
>I've got a report being generated from a parent/child table where one record in the parent composes the header info, and all of the children belonging to that parent appear as details...
>
>The report gets called by clicking a button on the form. The problem is, if the user has the corsor positioned anywhere in the child grid, the only records which print are the records under that record. For example, if there are 6 children, and the cursor is in record # 3, you will lose records 1&2 on the form.
>
>Here's the code which calls the report:
>
>LOCAL lcCurrArea, lcDesa, lcAsset
>
>THISFORM.requeryMainViewAlias()
>lcDesa = lv_desa.desa_number
>
>lcCurrArea = SELECT()
>
>SET PRINTER TO GETPRINTER()
>
>SELECT 'lv_desa'
>SCATTER MEMVAR
>
>SELECT * from assets where assets.desa_number = lcDesa into cursor temp
>select temp
>GO TOP IN TEMP
>
>REPORT form 'desa' TO PRINTER ALL NOCONSOLE NOEJECT
>
>SELECT (lcCurrArea)
>
>Thanks...
>
>-Craig
Hi Craig,
Check if your report has child table in its data env. so using it instead of cursor.
Cetin
Çetin Basöz

The way to Go
Flutter - For mobile, web and desktop.
World's most advanced open source relational database.
.Net for foxheads - Blog (main)
FoxSharp - Blog (mirror)
Welcome to FoxyClasses

LinqPad - C#,VB,F#,SQL,eSQL ... scratchpad
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform