Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
GenxTab : Is it possible?
Message
From
18/09/1997 09:22:06
 
 
To
18/09/1997 00:40:24
Shihchau Tai
Apic Systems Pte Ltd
Singapore, Singapore
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00050454
Message ID:
00050547
Views:
23
>>>Hi all,
>>>
>>>I have a genxTab query here which I want to display in the grid. My query results have customer name in rows and days of months in columns. I require row as well as column TOTALS. The genXTab does the row totals for me.
>>>
>>>I would like to know if there is a way for getting the column totals.
>>>
>>>Thanks
>>
>>You can easily total columns in grid, adding one more column with expression (sum of other fields) as controlsource.
>
>Sorry to intrude. I don't have a problem with the totals but I am not sure about saving the result.
>
>I am also trying to use GenxTab but I need to save the information back to the original table. Do I have to scan each cell and update or I can use an updatable view to save?
>
>Any opinion? Which is the best way?

I didn't here about cross-tab updatable views. You can do something with scanning, though croos-tabulation usually involves some summarizations and usually it will be difficult to retrieve changes back to original tables. Basically, cross-tabulations is for viewing data in user-friendly form.
Edward Pikman
Independent Consultant
Previous
Reply
Map
View

Click here to load this message in the networking platform