Crystal Reports line items

4 Oct 2006 12:58 AM

Aaron

Hi,

I am using VS 2003 and have some Crystal reports questions.

1.
I am trying to do a shipper document. How do I setup so that no two
groups will share a page, each group may span 1 or many pages. Or
maybe a better way of stating the question is "how do I make a group
header a page header?"

Is this something best resolved by including a subreport? In other
words have header data in the main report and line item data in the
subreport. I don't know how to synchronize the report with the
subreport and cannot find any relevent examples online (each is being
driven by different yet directly related tables).

2.
How do I setup so that if a field is blank, the fields beneath it will
be "bumped" upwards the height of 1 field. For example, this is done
automatically in MS Access: if you are setting up a Ship To address
field, and if, for example, on some addresses, Address3 is blank then
the City, State, and Zip line will be bumped up rather than having a
blank line appear between Address2 and City, State, and Zip.

Thank you,
Aaron

4 Oct 2006 2:54 AM

Charlie Brown

1. Use the section expert and choose the section you want to start a
new page after. Check the "New Page After" check box to the right.

2. To remove blank fields from the Details section, use the section
expoert again and this time select "Details" from the lst and check the
"Suppress Blank Section" checkbox.

Charlie B
cbr***@duclaw.com

Aaron wrote:
Show quoteHide quote

> Hi,
>
> I am using VS 2003 and have some Crystal reports questions.
>
> 1.
> I am trying to do a shipper document. How do I setup so that no two
> groups will share a page, each group may span 1 or many pages. Or
> maybe a better way of stating the question is "how do I make a group
> header a page header?"
>
> Is this something best resolved by including a subreport? In other
> words have header data in the main report and line item data in the
> subreport. I don't know how to synchronize the report with the
> subreport and cannot find any relevent examples online (each is being
> driven by different yet directly related tables).
>
> 2.
> How do I setup so that if a field is blank, the fields beneath it will
> be "bumped" upwards the height of 1 field. For example, this is done
> automatically in MS Access: if you are setting up a Ship To address
> field, and if, for example, on some addresses, Address3 is blank then
> the City, State, and Zip line will be bumped up rather than having a
> blank line appear between Address2 and City, State, and Zip.
>
> Thank you,
> Aaron