VB6: Outputting multiple columns with Report Designer

I have a VB6 application that uses the report designer.  In the detail section of the report designer I would like to output the records in a 2-column format.  Say my current report looks like this:

Report Header
  ::::Detail::::
  ::::Detail::::
  ......

I would like it to look like this:

Report Header                            Report Header
   ::::Detail::::                                  ::::Detail::::
   ::::Detail::::                                  ::::Detail::::
  .......                                              .........


Of course, I don't want to just output each record twice on the same line; I want the second column to output the next record.   Can anyone help please?

LVL 1
Krash_ioAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Valliappan ANSenior Tech ConsultantCommented:
I think this would be possible in Crystal Reports, but not sure if its possible in Report Designer in VB.

Cheers.
0
Krash_ioAuthor Commented:
Crystal Reports is a great tool, unfortunately, not available for this project.  Can anyone else offer any ideas please?  I’ve increased this topic’s points to 400.
0
Valliappan ANSenior Tech ConsultantCommented:
One option, could be use a temporary table, and fill it as you need, and then display from Report Designer. The alignment etc. need to be coded by you, when filling the temporary table. May, be, you can also have multiple fields in temp. table for n-columns, and fill it, accordingly.

This is one option. I could not think other option(s).

Cheers.            
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

Krash_ioAuthor Commented:
Sorry, I don't understand how that would solve my problem. The report designer, by default, can only output one record per row, I'm looking for a way to output two database records per row of the report designer.  

Can anyone help?
0
Valliappan ANSenior Tech ConsultantCommented:
You can also user Word for reporting and do printing with as you like. Hope it has all flexibility.

Cheers
0
Valliappan ANSenior Tech ConsultantCommented:
Hope, To use Word, you  need to use Word object model.
0
Krash_ioAuthor Commented:
I don't really want to use Word.  If I did, all computers that this application would be deployed on would be required to have a compatible version of Word, which is unlikely.

I think I’ve came to the conclusion that doing this is impossible with the Visual Basic intrinsic Data Report Designer.  I just installed Crystal Reports 4.6 from my Visual Studio CD, but I can’t find any tutorials on using it.  Does anyone know of any tutorials for Crystal Reports 4.6 in Visual Basic 6 SP5?


Thanks
0
Krash_ioAuthor Commented:
Well, the help file works best, maybe I should just end this topic.

Thanks to everyone!
0
Krash_ioAuthor Commented:
Alright, Crystal Reports just isn't cutting it.  I have to get this done tonight so I've increased the points to 525 for anyone who can give me the correct answer by 8:00 am central time on 12/3/2003.  Here's what I would like help with:

1:  My original question.  I need to be able to output two database records per row in the detail section of the report designer.

2. I would like to construct a report that shows an employee's gas usage per vehicle.  Basically, I want to output a group for every employee, and ouput a row for every unique vehicle per employee.  The report would look something like this:

----------------------------------------------
[Unique Employee]
      [Unique Vehicle] (record has same employee ID)
            [Gas Usage]
            [Gas Usage]

      [Another Unique Vehicle] (record has same employee ID)
            [Gas Usage]
            [Gas Usage]
            [Gas Usage]


[Another Unique Employee]
      [Unique Vehicle] (record has same employee ID)
            [Gas Usage]
            [Gas Usage]

      [Another Unique Vehicle] (record has same employee ID)
            [Gas Usage]
            [Gas Usage]
            [Gas Usage]

----------------------------------------------

I'm having problems doing this "double group" (grouping on employee and then grouping on vehicle within employee) with the data environment and report designer.  I think I might need to use a child command in the data environment but I'm not sure.

PLEASEEEE anyone that can help me out, I would greatly appericate it!!!

Thanks
-Krash_io
0
Krash_ioAuthor Commented:
Point increase didn't work, i'm trying again..
0
Krash_ioAuthor Commented:
I don't get it, it says I have 125 points available still.
0
Krash_ioAuthor Commented:
Alright, I think i found my answer.  I had to pay $10 to view it in a search on this site, but hopefully it will be worth it.  I'm going to try the solutoin found here: http://www.experts-exchange.com/Programming/Programming_Languages/Visual_Basic/VB_Databases/Q_10129337.html 

If that doesn't work I don't know what I'll do.

Consider this topic closed, thanks to all who assisted!
0
Valliappan ANSenior Tech ConsultantCommented:
It is alright. BTW, if you want CR tutorials, have a look at:

http://saidghosn.tripod.com/crystal_reports_tutorial.htm

and

http://www.vbexplorer.com/VBExplorer/vb_feature/august2000/using_crystal_reports.asp

The report options, needed for you would be N-column report, if I am not mistaken.

Hope it helps.
Cheers.
0
SpazMODicCommented:
PAQed, with points refunded (400)

SpazMODic
EE Moderator
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Visual Basic Classic

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.