Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 Crosstab in VB Application

Author  Topic 

anjan
Starting Member

21 Posts

Posted - 2005-10-25 : 14:33:36
How can i assign crosstab result set to a herarchical flexigrid.
Plz help me. it's urgent

i am using sql server 2000 as backend vb 6.0 as front end.
and using ADO.

waiting for ur reply

blindman
Master Smack Fu Yak Hacker

2365 Posts

Posted - 2005-10-25 : 16:51:55
No experience with flexigrid, but database application best practices suggest that cross-tabbing is a presentation issue and is best handled by the applicatio or reporting interface. So I would suggest that you export your data in a flat format and let flexigrid do your pivoting, if possible.
One of my colleagues tells me that flexigrid is "light weight", and you might want to try using True DB Grid instead.
Go to Top of Page

jsmith8858
Dr. Cross Join

7423 Posts

Posted - 2005-10-25 : 17:37:58
This might help you out; the code is in ASP/ADO which is pretty close to how you would do in VB:

http://weblogs.sqlteam.com/jeffs/archive/2005/05/15/5175.aspx
Go to Top of Page
   

- Advertisement -