|
-
Jul 4th, 2000, 01:52 AM
#1
Thread Starter
Junior Member
How can I put multiple columns in a data report? I want to have two columns on a page where each coulmn contains the same fields (but with different values).
Any ideas?
-
Jul 4th, 2000, 06:17 AM
#2
Fanatic Member
Koma
I am not sure if you can on the data report.
microsoft seem to have rushed this option as it is similar to access reports but has nowhere near the same functionality.
I have started to use crystal reports as this is similar to access reports and has a lot more functionality in VB.
In access the option for the report to contain multiple colums is in the page set up, as of yet I have not been able to find the same thing on the data report.
Gary Lowe 
VB6 (Enterprise) SP5
ADO 2.6
SQL Server 7 SP3
OK I know my spelling and grammer is crap so don't quote me on it!
To err is human to take the P! is only natural !!
Click on the top section of image for Marcus Miller website and bottom section of image for 'Run For Cover' sound clip

-
Jul 4th, 2000, 06:42 AM
#3
Thread Starter
Junior Member
Thanks for your reply.
I have VB6 Enterprise edition. Is crystal reports shipped with VB6 EE? I can't seem to find it!
-
Jul 4th, 2000, 06:47 AM
#4
Fanatic Member
Koma
You can get the Report Designer Component from Seagate.
It contains some good examples as well.
I downloaded it from the site a while ago but could not find it recently. I phoned them up and told them I had used it previously and they sent me a new one.
Hope this helps
Gary Lowe 
VB6 (Enterprise) SP5
ADO 2.6
SQL Server 7 SP3
OK I know my spelling and grammer is crap so don't quote me on it!
To err is human to take the P! is only natural !!
Click on the top section of image for Marcus Miller website and bottom section of image for 'Run For Cover' sound clip

-
Jul 4th, 2000, 06:51 AM
#5
Thread Starter
Junior Member
Thanks, I'll check it out.
By the way, using data report, is there any way to improve readability by inserting a blank line after every five lines of data from the recordset?
-
Jul 4th, 2000, 06:56 AM
#6
Fanatic Member
Koma
The best method for readability I have come up with is to contain a record in a box or frame. This enables the user to clearly define between different records.
Also use bold font for the infomation in the records
Gary Lowe 
VB6 (Enterprise) SP5
ADO 2.6
SQL Server 7 SP3
OK I know my spelling and grammer is crap so don't quote me on it!
To err is human to take the P! is only natural !!
Click on the top section of image for Marcus Miller website and bottom section of image for 'Run For Cover' sound clip

-
Jul 4th, 2000, 07:11 AM
#7
Thread Starter
Junior Member
Ok, that's a good advice.
The thing is that I'm creating a report that is just for printing, not for viewing on screen. I found the data report object which seemed to be nice but apparently can't do what I want. (That is: a two column report with a blank line in between every five lines of data.)
Maybe the VB printer object is the only way to go?
-
Jul 4th, 2000, 07:15 AM
#8
Fanatic Member
Could'nt comment on that as I have not really used it.
If Microsoft get the data report together and make it as good as Access reports I will go back to that
Gary Lowe 
VB6 (Enterprise) SP5
ADO 2.6
SQL Server 7 SP3
OK I know my spelling and grammer is crap so don't quote me on it!
To err is human to take the P! is only natural !!
Click on the top section of image for Marcus Miller website and bottom section of image for 'Run For Cover' sound clip

Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|