How to verify that I am on the first record of a group 2

[skiabox]

Is there any way I can enter in a formula a condition that it will be true when I am in the first record of a group?(It is placed in Group Footer).
I have a formula that display a calculation but it repeats itself across all group records.
I want to have the calculation displayed only in the first record of the group.
Thank you.

 

[lbass]

if onfirstrecord or
{table.groupfield} <> previous({table.groupfield}) then//etc.

-LB

 

[skiabox]

It doesn't work in footer of the group.
In header of the group it prints a string that I put after then in the formula but in all group records of the report.
Thnx for answering.

 

[skiabox]

I take it back.It worked!Can it work in the footer?If it doesn't I will move all the other fields of the footer in the header.

 

[dgillz]

Any field reference in the footer will return the last record in the group, so the previous() function will refer to the next-to-last record in the group.

So in the footer it will not work unless the group has only 1 record.

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz

"What version of URGENT!!! are you using?

 

[skiabox]

Now that I moved my formulas to the group header they procude zeros instead of values.Any ideas how to solve this one?
Thnx for your help.

 

[skiabox]

Can the Group Header appear in the same line as the group footer in the report?This could solve the problem.

 

[lbass]

No, of course not. Please show the content of your formula so we can see what you are trying to do. I thought you meant you wanted something on the first detail record within the group. Please clarify--do you mean you only want the formula to appear in the first group instance? If so, then use this:

if groupnumber = 1 then //etc.

-LB

 

[skiabox]

lbass your formula worked fine.
I have two groupings in my report and it works in any of the two group headers.
It display a string every time the outer group changes which is exactly what I wanted it to do.
The problem is that my formulas are placed in the footer of the inner group.
I have placed your formula in the inner group(header).
Can I have both your formula and mines in the same line?
Thank you!

 

[lbass]

I have no idea what you mean. Please try again, and show the content of the formulas and explain the results you expect to see.

-LB

 

[skiabox]

http://rapidshare.com/files/93411057/crystal_reports.rar.html

you can see all the formulas and their position in the report.

 

[lbass]

Doesn't work for me.

-LB

 

[skiabox]

can't you see the video?

 

[skiabox]

You can use this program to see the video :

http://downloads.sourceforge.net/camstudio/Camstudio-2.0-w32.zip?modtime=1112831484&big_mirror=0

 

[lbass]

Not planning on doing that--maybe someone else will.

-LB

 

[skiabox]

I can post the formulas if you want.I just thought that the video would visualize the problem and could make it easier to conseive.Just tell me if you want me to post the formulas.Thnx!