DataReport - Different Pages 1

[GerardMcL]

Hi,

I have a system, that when an order is complete a summary is printed for the customer. Now each Order can contain up to eight different products. And the company would like a list of pricing for each individual product not the whole order. The VB I can work out to get these figures but Im having trouble showing them on a report. I am using the report designer in VB6.

Can I structure it so that Page One has the details for product One, then a page break and Product two is on page two.

Usually I have tried to fit it all on one page but this wont work with this example and I cant place the information in the "Detail" section.

Any help is very appreciated.
Cheers

 

[comaboy]

Yes you can.

Open your report in Design View. Click into the Detail Section. You'll see the Detail Properties pop up. Change ForcePageBreak to 2 - PageBreakAfter. Job done!

 

[Hiccup]

comaboy - I'm having trouble getting my DataReport to work also; hopefully you might have a suggestion.

In my case the database table has so many fields that I can't fit them all on one page of the VB6 DataReport. Is there a way to split up a single page into two parts so that Record one will print on page 1 and 2 and then Record 2 will print on pages 3 and 4, Record 3 on pages 5 and 6 and so on?

 

[GerardMcL]

Comaboy you are a gentleman and a scholar.

Cheers!

 

[comaboy]

Thanks, Gerard, glad to help!

Hiccup, You're trying to display HOW MANY fields on a report? In all honesty I'd reckon that you'll end up with so much data, you'll never be able to read any information. "Wood for the trees" and all that! If you really MUST display such a vast quantity of data, all I can really suggest is a) use a very small font.(heh) or b) print A3 (and make it a system requirement for the System). Not really helpful, I know but, hey, it's something to think about!

Best of luck!

PS (just a thought) If you're reporting statistical info or lots of numerics, may a Chart per Record approach could be a way forward?

 

[Hiccup]

Thanks, comaboy, but unfortunately my report is a typical report used by apartment managers called the "Monthly Rent Roll" report, which has about 25 fields (columns.) It usually requires a 11X17" landscaped sheet of paper to show such a report.

I thought that there might be a way with the VB DataReport utility where the information could be continued onto a second page of the DataReport. It would require them to lay the two sheets of paper side-by-side, but I've seen them do this.

Also, I've already tried your idea of using really small font and still couldn't get all of the fields on the VB DataReport page.

Oh well, thanks anyway! Here's a star for your help!!

 

[johnwm]

The VB Datareport is a fairly limited tool. For more sophisticated reports try Crystal reports. There is an old but free version included in VB6. The current modern version is a commercial product. There are several Crystal reports forums on the site.

________________________________________________________________
If you want to get the best response to a question, please check out FAQ222-2244 first

'If we're supposed to work in Hex, why have we only got A fingers?'

http://www.essexsteam.co.uk

for steam enthusiasts

 

[comaboy]

johnwm,

Very good point, however, I only used CR once and (and usual) as the power goes in the complexity goes up and the ease of use goes down... also, I seem remember that there could be licencing issues (though it's all so foggy now, heh). Could you just clear that up for us... You may well have spotted the answer!

Thanks,

Comaboy

 

[johnwm]

The developer versions contain all the (redistributable) bits that you need for client stand-alone apps. I'm several versions behind the current one (now owned by Business Objects I believe) but the drag'n'drop interface makes using it a breeze

________________________________________________________________
If you want to get the best response to a question, please check out FAQ222-2244 first

'If we're supposed to work in Hex, why have we only got A fingers?'

http://www.essexsteam.co.uk

for steam enthusiasts

 

[comaboy]

Looks like the way forward for Hiccup, then!