Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Using a cursor for data groups and field sources
Message
De
09/05/2001 08:50:05
Cetin Basoz
Engineerica Inc.
Izmir, Turquie
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Gestionnaire de rapports & Rapports
Divers
Thread ID:
00505202
Message ID:
00505215
Vues:
20
>I have a report that I want to run from a command button on a screen form and I want it to be based on a cursor (curForPrint)that is created by a method called by the Init() of the screen form. The report has field controls whose control sources are the columns of the cursor (e.g.: curForPrint.field1) -- I can type those in. I also need to have the data groupings based on the columns of the cursor, but I can't figure out how to do that in the report designer.
>
>I have placed a test BROWSE after the creation of the cursor, so I know it is there and populated with the rows I need for the report. However, when I run the report preview there are no values shown.
>
>Any ideas?
>
>TIA
>
>Jim

Jim,
Might it be that report DE has a table in it ?
I would suggest not to use DE of report nor alias the fields. Get your data in cursor and report from there. You could do somthing like this :
select * from ... order by ... into cursor myCursor
*Development time only
if !file('myReport.frx')
 create report myReport from (alias()) form
endif
modi report myReport
*Development time only
report form myReport ...
Not aliasing report fields make same report runnable with different cursors.
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
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform