Report creation questions 1

[keepingbusy]

Hi all

I have a couple of questions regarding the creation of a report:

1: My report has title, page header, group header 1 (Containing Parent records), detail (containing child records) and page footer. When the report is printed or previewed the child record or records show one line below the linked parent record. How do I get the first child record to line up with the parent record?

2: The report itself is in landscape mode but only prints or previews about two thirds down the page (There are about 2000 records in the parent table). I have looked for the setting to extend the page and I'm sure it's staring me in the face, can someone please advise where this setitng is so the whole page will print? I have changed the print area without success.

Happy new year to you all.


Lee

 

[JRB-Bldr]

First, if you are not already doing so for your report, set up your Parent-Child relationship in a reverse order. That means that the Child table becomes the Parent in the relation and vice versa.

In that way when the record pointer is at ANY record of the Child table the application can 'see' through the relation into the Parent record fields.

NOTE - Your Report Form GROUP can still work off of the Parent (original Parent) contents.

Next, where anything appears on your VFP Report Form is dependent on how you lay out the Report Form's textboxes. If you want things to appear differently, (not one line below) set it up that way.

Report Layout - if you have already done so, I apologize, but have you set the Report Form's Page Setup / Print Setup to Landscape?

If no, then do so.
If so, then have you 'hacked' the Report Form to eliminate the 'inherited' printer values?

If you have, did you leave the one line in the Expr field?
ORIENTATION=1
All other values should be removed and all those in the Tag & Tag2 fields for RECNO() = 1

Good Luck,
JRB-Bldr

 

[keepingbusy]

JRB-Bldr

Thank you for the post.

First, if you are not already doing so for your report, set up your Parent-Child relationship in a reverse order. That means that the Child table becomes the Parent in the relation and vice versa.

How do I find out which way around they are?

Next, where anything appears on your VFP Report Form is dependent on how you lay out the Report Form's textboxes. If you want things to appear differently, (not one line below) set it up that way.

I have moved the relevant child text box to line up with the parent text boxes and this causes only one linked record to be shown (In most cases there are more than one).

Report Layout - if you have already done so, I apologize, but have you set the Report Form's Page Setup / Print Setup to Landscape?

Yes, this was the first thing I did when creating the report and also I have also unchecked the "Save printer enviroment" option.

If you have, did you leave the one line in the Expr field? ORIENTATION=1
All other values should be removed and all those in the Tag & Tag2 fields for RECNO() = 1

I'm sorry but I don't understand the last paragraph, could you please explain?

Many thanks

Lee

 

[keepingbusy]

I forgot to mention we are using Version 9.

Lee

 

[jimstarr]

Hi Lee,

Regarding your question #2 am wondering if perhaps you're going only 2/3 down the page because your page footer is taking up the rest of the space.

Jim

 

[keepingbusy]

Hi Jim

The only content in the page footer is a page counter using a small part of the report.

Lee

 

[keepingbusy]

Ok, I found the problem with the length of the landscape page.

On the reports properties > Data grouping tab there is a "Start group on new page less than:"

If you change the setting to 0.00cm this resolves the page length issue.

Just need to sort out the line up issue.

Lee

 

[TamarGranor]

I have moved the relevant child text box to line up with the parent text boxes and this causes only one linked record to be shown (In most cases there are more than one).

Sounds like you moved the child text box into the group header. Instead, move both the parent and child data into the detail band. If you only want the parent info to show up next to the first child record, in Print When, set Show Repeated Values to No.

Tamar

 

[keepingbusy]

Hi Tamor,

Thank you for your post. Both issues have now been resolved.

1. The parent and related child records now line up by using Tamor's suggestion of putting the text boxes in the detail band and setting the text box fields from the parent table to "Show Repeated Values to No" in the Print When Tab. This now works perfectly.

2. The length of the landscape report was resolved by changing the reports properties > Data grouping tab and setting the "Start group on new page less than:" to 0.00cm

My sincerest thanks to all on this thread for your help.

Kind regards

Lee