How to increase the right margin in a Report

[crystal28]

How to increase the right margin in a Report?If i have lots of Fields its not including them all in the screen and reduces the number of fields.But i need to have all the fields and for that need the widht to be increased.

Also i want to know how to split a report into Header and Detail based on a common field.for ex i have 15 fields generated based on a query that joins 3 tables.In that the first 2 tables need to be the header and the 3table need to be the detail.There is a commom field binding them.

 

[Madawc]

In Crystal 8.5, chose [Printer Setup] under File. You can chose Landscape for extra horizontal room, and can also adjust to different paper sizes.

You can also use [Page Setup] to adjust the actual margins.

As for your second question, it sounds like you're needing a Group, an option under [Insert]. Or have I misunderstood?

Madawc Williams
East Anglia, Great Britain

 

[crystal28]

Thanks Madawc,

The Margin is fine now.Regarding groups i am half way done.I have 3 tables..all 3 have a field common.If i insert one group and place the fields in the details section of that group its fine.If i insert 2 groups including all 3 tables then the values in the 3rd group details repeats twice.how to avoid this

For example

Group 1 header has 1 record(table 1)
Group 2 detail has 2 records(table 2)
Group 3 detail has 10 records(table 3)
but it gives 20 records in group 3 and just 1 record in group 2..please let me know how to fix it..

 

[Madawc]

Maybe it's your links. Try using Left Outer when it's a record that's not always there.

Duplicates can be suppressed using a suppress formula, checking Field = previous(Field)

Madawc Williams
East Anglia, Great Britain

 

[crystal28]

Thanks again,is it necessary that the Field Size of the Fields that are linked need to be the same in order to get the Group values in the detail section.
The problem is i have a header table and a detail table and the fields that link these are the same data type but their Filed size is different,the header is Long Integer and is the detail(Group) is Double.

 

[Madawc]

You can equate them by using a Formula Field that sets its own value to one or the other. Then test for the Previous value of the formula field.

Madawc Williams
East Anglia, Great Britain