Print Data from MSHFlexgrid in VB 6.0

[silversurf]

Hello,

I am a newbie in VB programming. I am listening, learning and developing a POS and inventory system for myself. I am using MS-Access as database and VB 6.0 in front end. I have developed few report through Data Environment and Data Report. Here is the scenario I need help very badly.

As for my products I have code and tag price (tprice) in my program. I have a from which include two combo box containing the Invoice Number and Invoice Date of my purchase stock. and a MSHFlexgrid which contain the details of my purchased product as per following 3 columns (example)

 

Code                  tprice              Quantity
21MSTABUFI38       800.00                 3
21MSTABuGE29      1200.00                5
21MSTABUJA36       680.00                 6

 

 

what I now want is to print the code and tag price (tprice) as per quantity. Like

 

21MSTABUFI38      21MSTABUFI38            21MSTABUFI38
 800.00            800.00                  800.00
________________________________________________________________
21MSTABuGE29     21MSTABuGE29         21MSTABuGE29       21MSTABuGE29
1200.00           1200.00                1200.00             1200.00  
21MSTABuGE29
1200.00               
________________________________________________________________
21MSTABUJA36     21MSTABUJA36          21MSTABUJA36       21MSTABUJA36 
  680.00           680.00                 680.00               680.00
21MSTABUJA36      21MSTABUJA36 
  680.00           680.00
________________________________________________________________

 

and so on for all the product in that certain invoice. Question is "How Could I achieve this ?" if its through Crystal report, very good also Data Report will serve my purpose i think.

 

I think I can made it clear. I need help on this very very badly. Plz help.

 

Silversurf

[silversurf]

i have attached herewith two .jpg images namely print code and data report. The first picture Print code describe the from that I have in my program to print the product code (with different data) and the second picture data report describe the way I want to print the data of that flexgrid through either crystal report or data report.

Plz help me.