Problem in getting SUM of Running Total Field

Hi buddy...

i m creating a report as below

--------------------------
Report Head ==>>> | Field1 |
--------------------------
Field2 Field3 Field4 Field5 Field6 Field7
--------------------------

Detail Section Here.....

--------------------------
sum(Field7)
--------------------------

Field7 is my Running Formula Field. i.e. Field7= (Field1 + Field5 - Field6)
nd thats working well.

Working ::

i m generating a report that nd gets the sum of Field7 as far as there is some record in details.

but when there is no record in the details section Sum of Field7 shows me nothing,
where as i am required to display the value of Field1 in it if there is nothing in the details section.

He who give solution will be considered a well qualified person.

with thanks nd admiration in advance

Silly StarCreate another formula with this :

If IsNull(Field7) then
Field1
else
Field7|||Hey KristyW

You Are Real Genius

Thats Worked Perfectly.

Thank u So much Sir but there r more Problems regarding Crystal Report
May i ask them

Silly Star|||u r a real "Silly Star"|||Hi ...

i m creating a report as below

--------------------------
GroupHeader ==>>> | Field1 |
--------------------------
Field2 Field3 Field4 Field5 Field6 Field7
--------------------------

Detail Section Here.....

--------------------------
GroupFooter==>> sum(Field7)
--------------------------

Field7 is the Running Formula Field. i.e. Field7= (Field1 + Field5 - Field6)
and i reset this formula on GroupChange
nd thats working well.

but when a group is changed it does not work properly (Meaning the desired result is not displayed)

He who give solution will be considered a well qualified person.

with thanks nd admiration in advance

Silly Star|||hai silly star

Edit the running field as

In the summary part give field 7 as the field to summarize and typeof summary is sum

In the evaluate column check the 'for each record' and

In the reset column check the 'on chage of group'

try this and it will work for you i believe

bye

viji

Problem creating view for cube

Anyone see a problem with creating this view for a cube??

The error I get seems to be in line 8 with the sum function, but I see nothing wrong with it.

CREATE VIEW CarCube AS
SELECT CASE WHEN (GROUPING(CarType) = 1) THEN 'ALL'
ELSE ISNULL(CarType, 'Not Known')
END AS CarType,
CASE WHEN (GROUPING(Color) = 1) THEN 'ALL'
ELSE ISNULL(Color, 'Not Known')
END AS Color
SUM(Amount) AS TotalAmt
FROM Inventory
GROUP BY CarType, Color WITH CUBEYou need a comma after Color on the line before|||lol, sometimes the simplest things are the hardest to find.

Thanks|||The people who are really good at finding at simple screw ups are the ones who are really good at making them. ;-)