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

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

I am not sure what it is you want to add.

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

mlmcc

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

mlmcc

ASKER

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.

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.

ASKER

From Dataset SlipGajiDetail.

Thank you.

Thank you.

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

mlmcc

mlmcc

ASKER

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.

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

Right click the field

Click FORMAT FIELD

Click the NUMBER TAB

Set it to 0 decimals

mlmcc

ASKER

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.

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.

ASKER

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

Thank you.

Thank you.

ASKER CERTIFIED SOLUTION

membership

Create an account to see this answer

Signing up is free. No credit card required.

ASKER

Great.

Thank you very much for your help.

Thank you very much for your help.

ASKER

Thank you.

rptSlipGajiStyleMini.rpt