Link to home
Create AccountLog in
Avatar of emi_sastra
emi_sastra

asked on

DIFFERENT FORMAT FOR SAME DETAIL DATASET

Hi All,

I have a CR report :

1. I want to have a different format.
2. I want to have a detail of Day Status at first row of detail section.
    Currently the first row is "Hari Kerja"
    I want to have "Day Status" before at first row.
    Day Status    "WD"   "HD" ......
    WD means WorkDay, HD means Holiday.
    The problem for adding Day Status is the data type of the dataset.

    Other way is create a new dataset for it which SlipGajiStatusHari. But I failed to do it.

How could I do it ?

Thank you.
PAYMENT-SLIP.png
Avatar of emi_sastra
emi_sastra

ASKER

The rpt file.

Thank you.
rptSlipGajiStyleMini.rpt
Avatar of Mike McCracken
I am not sure what it is you want to add.

Can you determine which value each column gets based on the number?

mlmcc
Please look at it again :

1. Hari Kerja
2. Hari Kerja Shift II
3. Lembur
4. 1.5x
...
8. 4x

Those data are feed from Detail Section 3.

Thank you.
From Dataset SlipGajiDetail.

Thank you.
Without data or at least an example it is very difficult to determine how to do what you want.

mlmcc
Let's have a scenario :

We have a dataset :

1. EmpCode
2. EmpName
3. AttendDay01
.
.
X. AttendDay31

The AttendDay01 to AttendDay31 data type is double.

At CR we have :

Hari Kerja   1.00   1.00  and so on

Lembur      1.00    1.00 and so on

All of them are from the same dataset.

Now, I want the result :

Hari Kerja   1   1  and so on (without decimals point)

Lembur      1.00    1.00 and so on

Thank you.
Just format them without the decimals.

Right click the field
Click FORMAT FIELD
Click the NUMBER TAB
Set it to 0 decimals

mlmcc
Current :

Hari Kerja   1.00   1.00  and so on
Lembur      1.00    1.00 and so on

All of them are from the same dataset.

Now, I want the result :

Hari Kerja   1   1  and so on (without decimals point)
Lembur      1.00    1.00 and so on

Not like :
Hari Kerja   1   1  and so on (without decimals point)
Lembur       1    1 and so on

Remember they all have the same dataset.

Thank you.
Remember they all have the same dataset and at the same detail section.

Thank you.
ASKER CERTIFIED SOLUTION
Avatar of Mike McCracken
Mike McCracken

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
Great.

Thank you very much for your help.