Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Using a cursor for data groups and field sources
Message
From
09/05/2001 08:50:05
Cetin Basoz
Engineerica Inc.
Izmir, Turkey
 
General information
Forum:
Visual FoxPro
Category:
Reports & Report designer
Miscellaneous
Thread ID:
00505202
Message ID:
00505215
Views:
19
>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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform