Formula Help...! Crystal XI

[lantis]

I want to create a report base on my data below. I have a column VLWP and SLWP. What is the formula used if IDNO 100 has no SLWP only VLWP. When i drag the fireld sumofleave_days it displays the data on both LeaveCode.

Here's my data from Table [Leave]:

IDNO LEAVECODE SUMOFLEAVE_DAYS

100 VLWP 4

101 SLWP 2

[ranganadhkodali]

Hi, can we give little bit clearly ?

if IDNO 100 has no SLWP only VLWP

What you want i was unable to understood these thing ?
You what show SLWP if leaves lessthen 100 ?


then create one formula and write down
if sum(SUMOFLEAVE_DAYS,idno) >100 then
{idno} +"VSWP" + sum(SUMOFLEAVE_DAYS,idno)
else
{idno} +"SLWP" + sum(SUMOFLEAVE_DAYS,idno)

[lantis]

IDNO 100 has no SLWP
The IDNO is a series system generated by my program. The actual series is 100 to 478. Some of them has SLWP-Sick Leave With Pay, others has VLWP-Vacation Leave with Pay. I want to count how many leave they filed. How many SLWP or VLWP.

This is my type of report


Employee Table and Leave Table Linked

[ranganadhkodali]

Yes for that do these steps
1) on report make a group by with IDNO
2) create formula like 'VLWPCounter' and write down

if {LEAVECODE} = "VLWP" then
SUMOFLEAVE_DAYS
else
0
3) create another formula like 'SLWPCounter' and write down

if {LEAVECODE} = "VLWP" then
SUMOFLEAVE_DAYS
else
0
4) Create Summary field on SUMOFLEVE with group total (It will gives the total leaves)
5) and then place them these two formula fields in group detailed section
6) create group wise summary fields and name it like total VLWP and total SLWP
7) then after that supress the setailed section

By doing this you can get the expected result

[lantis]

It works but it has duplicate records show..

[ranganadhkodali]

Then on report options there is an check box "select distinct data for browsing"
Use that thing and as i know if you did the group by By userID ... is should not appear duplicate rows. did you suppress the detailed section?

[lantis]

im using crystal report xi. i did not see the check box "select distinct data for browsing". i've gone to the section expert under details. there is only supress blank details nothing more.

[VBFnewcomer]

ranga said to see in report options and not section expert