Solved

# Difference between First and last record

Posted on 2008-06-25
970 Views
Could any one tell me how to find the difference between first and last record in crystal reports
0
Question by:P_Ramprathap
[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
• 5
• 5
• 3

LVL 5

Expert Comment

ID: 21868585
what is the field type
0

LVL 100

Expert Comment

ID: 21869417
I assume you mean the difference between the value of a field in the first record and the same field in the last record.

Try this idea.  I assume it is a numeric field?
Name - GetFirstValue
WhilePrintingRecords;
GLobal NumberVar FirstRecordValue := {YourFIeld};

In the report footer
WhilePrintingRecords;
GLobal NumberVar FirstRecordValue;
FirstRecordValue - {YourFIeld}

mlmcc
0

LVL 100

Expert Comment

ID: 21869434
If you mean between the whole records then you would need to use a variable for each field and do the appropriate comparison in the report footer

mlmcc
0

LVL 5

Author Comment

ID: 21871602
Hi mlmcc

iam new to crystal reports , i got what your saying , but the think is how to i add a formula field in Header and footer , do we have formula field seprate for Header and footer , if so , could you please tell me how to do it .
0

LVL 5

Expert Comment

ID: 21871633
Formulas are created the smae way regadless where they are being used.

just create 2 formula, first
Name - GetFirstValue
WhilePrintingRecords;
GLobal NumberVar FirstRecordValue := {YourFIeld};
then
second
WhilePrintingRecords;
GLobal NumberVar FirstRecordValue;
FirstRecordValue - {YourFIeld}

Now just drag your first formula and drop it in the header and the second formula in the footer...

How to create a formula?
on your report field, left or right depends.. you should see formula in the tree...right click and choose new formula
0

LVL 5

Author Comment

ID: 21871832
Do you mean , i drag the formula field into Header and hide it if i dont require to show it right ? am i correct
0

LVL 5

Expert Comment

ID: 21874945
Yes
0

LVL 5

Author Comment

ID: 21875464
Great , it worked thanks a lot
0

LVL 5

Author Comment

ID: 21875826
How do i do the same if i nee to insert the section 2 into page header ?
0

LVL 5

Expert Comment

ID: 21877077
0

LVL 5

Expert Comment

ID: 21877084
If you have a screen shot of your design view that would be great. or just attach your report and change the extension to .doc
0

LVL 100

Accepted Solution

mlmcc earned 500 total points
ID: 21879990
You can add a "second" report header section (if that is what you mean) by right clicking the report header in the left margin and clicking INSERT SECTION BELOW

mlmcc
0

LVL 5

Author Closing Comment

ID: 31470678
Thanks a lot , it worked
0

## Featured Post

Question has a verified solution.

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

Crystal Reports: 5 Tests for Top Performance It is complete, your masterpiece report.  Not only does it meet your customerâ€™s expectations, it blows them out the water, all they want is beautifully summarised and displayed in a myriad of ways. â€¦
Hello everyone, Hope you find this as helpful as we did. We have on the company I work for an application built in Delphi V with Crystal Reports 8. We all know that Crystal & Delphi can be temperamental sometimes and the worst thing is, nearlyâ€¦
In a recent question (https://www.experts-exchange.com/questions/29004105/Run-AutoHotkey-script-directly-from-Notepad.html) here at Experts Exchange, a member asked how to run an AutoHotkey script (.AHK) directly from Notepad++ (aka NPP). This videoâ€¦
I've attached the XLSM Excel spreadsheet I used in the video and also text files containing the macros used below. https://filedb.experts-exchange.com/incoming/2017/03_w12/1151775/Permutations.txt https://filedb.experts-exchange.com/incoming/201â€¦
###### Suggested Courses
Course of the Month9 days, 8 hours left to enroll