PDA

Click to See Complete Forum and Search --> : Multiple columns in data report


koma
Jul 4th, 2000, 01:52 AM
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?

Gary.Lowe
Jul 4th, 2000, 06:17 AM
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.

koma
Jul 4th, 2000, 06:42 AM
Thanks for your reply.
I have VB6 Enterprise edition. Is crystal reports shipped with VB6 EE? I can't seem to find it!

Gary.Lowe
Jul 4th, 2000, 06:47 AM
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

koma
Jul 4th, 2000, 06:51 AM
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?

Gary.Lowe
Jul 4th, 2000, 06:56 AM
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

koma
Jul 4th, 2000, 07:11 AM
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?

Gary.Lowe
Jul 4th, 2000, 07:15 AM
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