help on a crystal report design

[Former Member]

Hi,

I'm in the process of designing a report where the basics of it is a simple design of a header section,details and a footer section. The data is taken from a MSSQL server and is manipulated within a c# program (using VS2005) The final dataset is then pushed to a crystal report and finally exported to a pdf format.

Currently the report prints accounting information for each mailing address (up to 5 mailing addresses) per account for each account that requires a report. (hope that makes sense!).

However, there is now a requirement for an additional page that needs to be printed after each FIRST mailing address of the account. The information will be taken from another sql table which may or not have extra information per account. If there is no data for that account then this additional page is to be supressed. (Again I hope that makes sense too!)

I've got the main report working fine but I require some suggestion about how I go about designing the extra page. For example do I need to insert a sub report, or add an additional details section or something else. The extra page has to be printed in account order sequence so cannot be done after the main report has been printed.

eg

Account 1

header : mailing address1

details : accouting info for account 1

footer: Company info

No extra info for account 1 so suppress extra page

header: mailing address 2

details : accouting info for account 1

footer: Company info

no extra page for address 2

Account 2

header : mailing address1

details : accouting info for account 2

footer: Company info

extra info for account 2 is available so print extra page

header: mailing address 2

details : accouting info for account 2

footer: Company info

no extra page for address 2

Account 3

header : mailing address1

details : accouting info for account 3

footer: Company info

No extra info for account 3 so suppress extra page

header: mailing address 2

details : accouting info for account 3

footer: Company info

no extra page for address 2

Time is of the essence here so a quick reply would be very much appreciated.

Thanking you in advance

[Former Member · Accepted solution]

Add a section to the footer. Now it should say something like "GF1b".

Put your sub report in this footer and link it to the main report.

Right click on the the sub report, find "Suppress", and enter the formula

to suppress, like Table.Field = 0, or whatever.

Go to "GF1b", Secton Expert, and select "Suppress Blank Section"

This should get you close to what you want.

The Panda