I'm creating a report and I need so 1

[gbcpastor]

I'm creating a report and I need some help. I can only get about 6 inches of the report to print and it then creates a page two. I need this to be a full page report and keep it to one page.

I've attached the report and the sample data.

Please help...

Thanks in advance.

 

[mjcmkrsr]

Hi,

You did not specify the variables we need to run this report - it generates errors when PrintPreviewing it
hth
MarK

 

[gbcpastor]

They can have any value, it makes no difference.
cJobNumber = "19M182"
cJobName = "Test Job"
cClient = "ASPCA"
cMailDate = "07/21/2019"
cAcctMgr = "Steve"

That should cover it.
Thanks Mark

 

[Koen Piller]

Hi mr. GbcPastor,

Your data is lacking of content. Lots of fields have no data at all.
Also I notice you have constructed the field information as a field or you include this in your field value. Consider to make use of labels.
Enclosed a report of your data, please note the layout may not comply with your requirements, you can easily change this with "modify report" Than invoke print print preview from the VFP menu to see how your changes look like and only if you are satisfied save it.

Regards,
Koen

 

[gbcpastor]

In the image above you can see what the reports currently looks like. It's printing correct with the exception that it only prints about 6" of the report then creates a second page. I need to print the full page and keep it to one.

 

[mjcmkrsr]

HI GBPastor,

Same remarks as Koen, Please find attached slightly pimped up FRX/FRT files

hth

Mark

 

[mjcmkrsr]

and the frx file

 

[mjcmkrsr]

and a PrinPreview

 

[gbcpastor]

That's definitely full page Mark but the info needs to be stacked as in the supplied image. The report you have here looks like it's grouped by jobnumber. That won't work. I wish it would, that would be the easy way out for me.

 

[mjcmkrsr]

Hi,

Please find attached the picture of FormDesigner - just a plain listing, no grouping, no filter, nothing special

hth
Mark

 

[Koen Piller]

Mr. GbcPastor,

I whish you would have uploaded a workable data to produce the by your requested report. The data here is either incomplete or duplicated.
And if you are indeed working with that data, it could very well be the reason why your report only prints half page who knows.
Regards,
Koen

 

[gbcpastor]

Folks, is there a way to change data sources within the report?

 

[Olaf Doschke]

gbcpastor. I see what you do here, using all the "print when" conditions and "remove line if blank" to let the single detail band print multiple lists as only some of its fields are printing per record and the others are then removed.

But that causes the unwanted page break because the report engine doesn't see if a band can be printed after all the "remove line if blanks" are taken into account triggered by most fields not printing due to their "print when" condition. Instead, it just looks if the full detail band height fits and decides for page breaks on the basis that this height is necessary.

I'd not go that route for so many different things that are "asking for" multiple groups or detail bands.

But as you're that far in, you can shrink the band by putting controls on top of each other, that never print at the same time anyway. Then the band height will allow to print more on each page. Yes, it's less easy to maintain in that overlapping fields state, but that's the price to pay.

Bye, Olaf.

Olaf Doschke Software Engineering

https://www.doschke.name

 

[gbcpastor]

Thanks Olaf, I'll give that a try.