Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Multiple cursors within a report???
Message
 
To
21/08/1998 17:09:04
General information
Forum:
Visual FoxPro
Category:
Reports & Report designer
Miscellaneous
Thread ID:
00128928
Message ID:
00128945
Views:
37
Hmmm...seems to me the bottom line is going to be that you need to combine them into a single cursor before running the report. Though not having all the details I couldn't say for sure. Could you make the story a little longer, by telling us what tables these fields are in? Perhaps posting one, or both of your SQL statements would shed more light.

>To make a long story short. We have a table that requires records to be subtotaled and printed twice and in different order on the report using two different sorting criteria to make two different columns. Something like this:
>
>
>A/C#     Description                         Debit             Credit
>----     ------------------------------   ----------         ----------
>560      Expense  - Furniture & Fixtures      26.20
>562      Expense  - Buildings              1,941.36
>564      Expense  - Autos                    117.14
>
>160      Acc/Depr - Furniture & Fixtures                         26.20
>162      Acc/Depr - Buildings                                 1,941.36
>164      Acc/Depr - Autos                                       117.14
>
>                                           ---------         -----------
>                                            2,084.70          2,084.70
>
>We are hoping that we could produce the report using two separate cursors. What do you think?
>
>Thanks for the response,
>
>Tom
kenweber
GCom2 Solutions
Microsoft Certified Professional

Previous
Reply
Map
View

Click here to load this message in the networking platform