Skip to Content
avatar image
Former Member

help on a crystal report design

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

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

1 Answer

  • Best Answer
    avatar image
    Former Member
    Sep 02, 2008 at 03:36 PM

    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

    Add comment
    10|10000 characters needed characters exceeded