|
Hi guys,
I'm working on a VB report with the use of the VB Report Tool (VB6 Pro). I have a recordset that contains one column with data. (+/- 10.000 records.
Now i need a report with this one column recordset, the problem is that the data is is shown in the report like within the recordset. This is a lot off paper, that rolls out the printer ..... shit....
Example :
xxxxxxxx
xxxxxxxx
xxxxxxxx
xxxxx
xx
xxxxx
I would like the see that the columns in the report filling up the pages like in the example below :
xxxxxxxxxx xxxxxxxxxx xxxxxxxxxx xxxxxxxxxx xxxxxxxxxx
xxxxxxxxxx xxxxxxxxxx xxxxxxxxxx xxxxxxxxxx xxxxxxxxxx
xxxxxxxxxx xxxxxxxxxx xxxxxxxxxx xxxxxxxxxx xxxxxxxxxx
xxxxxxxxxx xxxxxxxxxx xxxxxxxxxx xxxxxxxxxx xxxxxxxxxx
xxxxxxxxxx xxxxxxxxxx xxxxxxxxxx xxxxxxxxxx xxxxxxxxxx
I hope somebody can help me with this, to use a Excel spreadsheet or Word are NO OPTION !! Must stay within the VB Apps. !!
Greetings,
Andre (d'r Juud)
|
|
|
What is the code you are using to print the report? By using semi-colins ";" between variables, it will make fields look like columns.
Example your printout:
Print #1 strRec1
Print #1 strRec2
Print #1 strRec3
Print #1 strRec4
will be columns if done like:
Print #1 strRec1; strRec2; strRec3; strRec4
To get them to line up you will have to use RSET command
|
|
|
|
|
|
|
// |