Solved

VB6: Outputting multiple columns with Report Designer

Posted on 2003-11-07
15
750 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
  • 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
Live: Real-Time Solutions, Start Here

Receive instant 1:1 support from technology experts, using our real-time conversation and whiteboard interface. Your first 5 minutes are always free.

 
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

Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

Question has a verified solution.

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

The debugging module of the VB 6 IDE can be accessed by way of the Debug menu item. That menu item can normally be found in the IDE's main menu line as shown in this picture.   There is also a companion Debug Toolbar that looks like the followin…
You can of course define an array to hold data that is of a particular type like an array of Strings to hold customer names or an array of Doubles to hold customer sales, but what do you do if you want to coordinate that data? This article describes…
Get people started with the process of using Access VBA to control Excel using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Excel. Using automation, an Access application can laun…
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…

816 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

Need Help in Real-Time?

Connect with top rated Experts

8 Experts available now in Live!

Get 1:1 Help Now