Solved

Crystal Reports 8 - newbie

Posted on 2002-05-22
8
168 Views
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
0
Comment
Question by:philipstewart
[X]
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
8 Comments
 
LVL 3

Expert Comment

by:Elmo_
ID: 7026674
philipstewart,

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.

Cheers,

Ed.
0
 

Author Comment

by:philipstewart
ID: 7026894
Hi,

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
0
 
LVL 3

Expert Comment

by:Elmo_
ID: 7026958
Philip

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
                                Address2
                                Address3
                                Address4

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.

Cheers,

Ed.
0
SharePoint Admin?

Enable Your Employees To Focus On The Core With Intuitive Onscreen Guidance That is With You At The Moment of Need.

 
LVL 101

Accepted Solution

by:
mlmcc earned 100 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

mlmcc
0
 

Author Comment

by:philipstewart
ID: 7027079
Thanks, so far,
but....
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?

Philip

0
 
LVL 3

Expert Comment

by:Elmo_
ID: 7027093
Philip,

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.
0
 
LVL 3

Expert Comment

by:Elmo_
ID: 7039577
philipstewart,

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.

Cheers.
0
 
LVL 3

Expert Comment

by:Elmo_
ID: 7087309
philipstewart,

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.

Cheers,

Ed.
0

Featured Post

Instantly Create Instructional Tutorials

Contextual Guidance at the moment of need helps your employees adopt to new software or processes instantly. Boost knowledge retention and employee engagement step-by-step with one easy solution.

Question has a verified solution.

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

Most everyone who has done any programming in VB6 knows that you can do something in code like Debug.Print MyVar and that when the program runs from the IDE, the value of MyVar will be displayed in the Immediate Window. Less well known is Debug.Asse…
Enums (shorthand for ‘enumerations’) are not often used by programmers but they can be quite valuable when they are.  What are they? An Enum is just a type of variable like a string or an Integer, but in this case one that you create that contains…
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…
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…

695 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