How to get data in repeating groups horizontally in BI Publisher RTF Template ?

Thiagu V

For Example :

• If a person have timecard data for monday, tuesday, wednesday, then the output should be like -

MONDAY	TUESDAY	WEDNESDAY
MONDAY	11.50	TUESDAY	16.50	WEDNESDAY	14.5

• If another person have timecard data for monday, tuesday, wednesday, thursday, friday and saturday, then the output should be like -

MONDAY	TUESDAY	WEDNESDAY	THURSDAY	FRIDAY	SATURDAY
MONDAY	11.50	TUESDAY	16.50	WEDNESDAY	14.50	THURSDAY	11.50	FRIDAY	12.00	SATURDAY	10.00

How to acieve this in BI Publisher RTF Template?

Thanks in Advance :)

_vero_

Hi @Thiagu V,

you can use the conditional area: you can create two different tables, in which you set that the first table appears with the first condition and the second with another condition.

Let me know.

Regards

Thiagu V

Hi @_vero_ ,

Firstly thanks for the reply.

But here in this case we cannot put conditions manually for each employee.

We should get output automatically based on the data for each employee.

Note: Above mentioned tables are just for example.

_vero_

Hi,

I don't think it's possible to create an automated thing like this on the publisher. I would make 7 tables in a conditional area, where the condition variable does a count of the days an employee is associated with, and only shows the table that has the number of columns corresponding to the days. I think it's a good workaround, tell me if I explained myself well and if I understood the problem.

Thank you

Regards

Thiagu V

sample xml -

sample output -