A1VBCode Forums

Reports with MSFlexGrid Data


http://www.a1vbcode.com/vbforums/Topic24079.aspx

By Smartchap - 2/2/2008

In VB6 in a form there are 10 labels and associated 10 textboxes and 2 MSFlexGrids. There are 5 columns in the first MSFGrid  and 7 in the second MSFGrid. There are 3 rows in the first grid and 4 in the second. I want to generate a report (may be using DataEnvironment and DataReport, as I don’t have Crystal Report) in such a way the its output should be as follows:

7 Labels and associated 7 textboxes

Data in First MSFlexGrid (first row showing headings of columns and next 3 rows data)

Data in second MSFlexGrid (in similar fashion as for first grid)

Remaining 3 labels and 3 textboxes in the form

 

Please help me, if possible by attaching an example program.

Thanks in advance.

 

By Smartchap - 9/21/2009

You can search on Google for SQL in VB6. Also u can search on www.bigresource.com and get some code for using SQL database in VB.