?
Solved

VB6: Outputting multiple columns with Report Designer

Posted on 2003-11-07
15
Medium Priority
?
805 Views
Last Modified: 2011-10-03
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?

0
Comment
Question by:Krash_io
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 8
  • 5
15 Comments
 
LVL 9

Expert Comment

by:Valliappan AN
ID: 9705175
I think this would be possible in Crystal Reports, but not sure if its possible in Report Designer in VB.

Cheers.
0
 
LVL 1

Author Comment

by:Krash_io
ID: 9711021
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
 
LVL 9

Expert Comment

by:Valliappan AN
ID: 9711106
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
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
LVL 1

Author Comment

by:Krash_io
ID: 9855995
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
 
LVL 9

Expert Comment

by:Valliappan AN
ID: 9863277
You can also user Word for reporting and do printing with as you like. Hope it has all flexibility.

Cheers
0
 
LVL 9

Expert Comment

by:Valliappan AN
ID: 9863329
Hope, To use Word, you  need to use Word object model.
0
 
LVL 1

Author Comment

by:Krash_io
ID: 9863404
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
 
LVL 1

Author Comment

by:Krash_io
ID: 9863435
Well, the help file works best, maybe I should just end this topic.

Thanks to everyone!
0
 
LVL 1

Author Comment

by:Krash_io
ID: 9864973
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
 
LVL 1

Author Comment

by:Krash_io
ID: 9864984
Point increase didn't work, i'm trying again..
0
 
LVL 1

Author Comment

by:Krash_io
ID: 9864987
I don't get it, it says I have 125 points available still.
0
 
LVL 1

Author Comment

by:Krash_io
ID: 9867418
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
 
LVL 9

Expert Comment

by:Valliappan AN
ID: 9878876
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
 

Accepted Solution

by:
SpazMODic earned 0 total points
ID: 9892252
PAQed, with points refunded (400)

SpazMODic
EE Moderator
0

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction While answering a recent question (http://www.experts-exchange.com/Q_27402310.html) in the VB classic zone, I wrote some VB code in the (Office) VBA environment, rather than fire up my older PC.  I didn't post completely correct code o…
Introduction While answering a recent question about filtering a custom class collection, I realized that this could be accomplished with very little code by using the ScriptControl (SC) library.  This article will introduce you to the SC library a…
Get people started with the process of using Access VBA to control Outlook using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Microsoft Outlook. Using automation, an Access applic…
This lesson covers basic error handling code in Microsoft Excel using VBA. This is the first lesson in a 3-part series that uses code to loop through an Excel spreadsheet in VBA and then fix errors, taking advantage of error handling code. This l…
Suggested Courses
Course of the Month9 days, 15 hours left to enroll

762 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question