Solved

VB6: Outputting multiple columns with Report Designer

Posted on 2003-11-07
15
741 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
 
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
What Security Threats Are You Missing?

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

 
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

Find Ransomware Secrets With All-Source Analysis

Ransomware has become a major concern for organizations; its prevalence has grown due to past successes achieved by threat actors. While each ransomware variant is different, we’ve seen some common tactics and trends used among the authors of the malware.

Join & Write a Comment

When designing a form there are several BorderStyles to choose from, all of which can be classified as either 'Fixed' or 'Sizable' and I'd guess that 'Fixed Single' or one of the other fixed types is the most popular choice. I assume it's the most p…
Enums (shorthand for ‘enumerations’) are not often used by programmers but they can be quite valuable when they are.  What are they? An Enum is just a type of variable like a string or an Integer, but in this case one that you create that contains…
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…
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…

706 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

19 Experts available now in Live!

Get 1:1 Help Now