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
LVL 1
emi_sastraAsked:
Who is Participating?
 
mlmccConnect With a Mentor Commented:
Try this formula in the custom number of decimals

If ({SlipGajiDetail.ValKeterangan} = "Hari Kerja") then
    0
Else
    2

Open in new window


mlmcc
0
 
emi_sastraAuthor Commented:
The rpt file.

Thank you.
rptSlipGajiStyleMini.rpt
0
 
mlmccCommented:
I am not sure what it is you want to add.

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

mlmcc
0
Cloud Class® Course: Python 3 Fundamentals

This course will teach participants about installing and configuring Python, syntax, importing, statements, types, strings, booleans, files, lists, tuples, comprehensions, functions, and classes.

 
emi_sastraAuthor Commented:
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.
0
 
emi_sastraAuthor Commented:
From Dataset SlipGajiDetail.

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

mlmcc
0
 
emi_sastraAuthor Commented:
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.
0
 
mlmccCommented:
Just format them without the decimals.

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

mlmcc
0
 
emi_sastraAuthor Commented:
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.
0
 
emi_sastraAuthor Commented:
Remember they all have the same dataset and at the same detail section.

Thank you.
0
 
emi_sastraAuthor Commented:
Great.

Thank you very much for your help.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.