Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win


Crystal Reports 8 - newbie

Posted on 2002-05-22
Medium Priority
Last Modified: 2012-05-04
I'm new to Crystal Reports, so please bear with me.

I have created a new report, and I have the following sections:

Report Header - My own header
Page Header - Ny own page header
Details - a few details
Report Footer - nothing
Page Footer - my own page footer

A Report Header/Fooetr will appear on every page, is this correct?
A Page Header/Footer will only appear on the current page, is this correct?

Using the above layout I now want to add a second blank page so I can add new info/details, but I can't figure out how to do this? (2 pages in total)

All help is appreciated.

Thanks Philip
Question by:philipstewart
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 5
  • 2

Expert Comment

ID: 7026674

The Report Header will appear at the Begining of the report and
The Report Footer will appear at the end of the report.

The Page Header and Footer should appear on every page.

A suggestion as to how you can add a page so that you can show info/details is (Assuming the Second Page is Going to contain the info):

1. Right Click on the Report Header and Select "Insert Section Below"
2. No Resize this to what you need
3. Enter the Info

I have never actually done this, but I have donew something similar.  It can be a bit tricky to get the layout right though.

If you need more help Tell me the exact layout you would like and I will try recreate it.



Author Comment

ID: 7026894

I'll try and explain further;

I want something like you would create in Word

Page 1
- Header(Logo)
-- Address Fields

- Letter Info/data (this may overflow to Page 2)
- Footer

Page 2
- Header <NONE>
- More info/data some overflow from Page 1
- Footer <NONE>

Thanks Philip

Expert Comment

ID: 7026958

The way I would tacke this is to

Put Your Header(Logo) into the Report Header (This will only appear once)

Then Add in your Letter info Into the Details Section. (I am assuming that your are pulling in info, record style and adding to the report.  So that you can have a varying amount of information.)

Now you should add in your footer.  Add the details to the Report footer.

The Layout of the report for 3 records, would be as follows:

------------- Report Header --------------
LOGO                            Address1

1   Joe Bloggs  Bla   Bla  Blaa
2   Jo Blogg    B     Blas Bl  
3   J Burn      Bla   Bla  Bla

Date/Time                           Page Num
------------- Report Header --------------

The Report Header will always be at the start and only at the start and the Report Footer will always be at the end and only at the end of the report.

The amount of information in the details section will determine how many pages you use.


Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

LVL 101

Accepted Solution

mlmcc earned 400 total points
ID: 7026998
To put a footer on page 1 and not on the rest of the pages create the footer.  Right click on the footer and select format.  Select SUPPRESS and then click the button to the right to enter a formula to conditionally suppress the footer.

PageNumber > 1


Author Comment

ID: 7027079
Thanks, so far,
is there no such thing as a page break in crystal reports such as those found in MS Word?

Is it harder to programmatically write a report in VB?



Expert Comment

ID: 7027093

the only way that I can see to enter a page break is to goto the section you want the break to occur on.

Right Click and Select Format Section

Then You should have a load of options two of which are New Page Before and New Page After.  

This should allow you to put in a Page Break.

Expert Comment

ID: 7039577

Could you close out the question please?

If you feel no one deserves the points you can get an EE moderator to put the question points to zero.


Expert Comment

ID: 7087309

I think that this question has been answered for you but you still have not accepted one.  Please do so.  You have not posted in nearly a month.

If you have not responded by the end of the week I will ask an EE moderator to close out the question.



Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

When trying to find the cause of a problem in VBA or VB6 it's often valuable to know what procedures were executed prior to the error. You can use the Call Stack for that but it is often inadequate because it may show procedures you aren't intereste…
You can of course define an array to hold data that is of a particular type like an array of Strings to hold customer names or an array of Doubles to hold customer sales, but what do you do if you want to coordinate that data? This article describes…
As developers, we are not limited to the functions provided by the VBA language. In addition, we can call the functions that are part of the Windows operating system. These functions are part of the Windows API (Application Programming Interface). U…
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
Suggested Courses

636 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question