×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

I'm creating a report and I need so

I'm creating a report and I need so

I'm creating a report and I need so

(OP)
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.

RE: I'm creating a report and I need so

Hi,

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

RE: I'm creating a report and I need so

(OP)
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

RE: I'm creating a report and I need so

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

RE: I'm creating a report and I need so

(OP)


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.

RE: I'm creating a report and I need so

and a PrinPreview

RE: I'm creating a report and I need so

(OP)
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.

RE: I'm creating a report and I need so

Hi,

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



hth
Mark

RE: I'm creating a report and I need so

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

RE: I'm creating a report and I need so

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

RE: I'm creating a report and I need so

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

RE: I'm creating a report and I need so

(OP)
Thanks Olaf, I'll give that a try.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close