Oracle Analytics and AI

Thiagu V · 2024-12-05T08:55:24+00:00

For Example : * If a person have timecard data for monday, tuesday, wednesday, then the output should be like - MONDAY TUESDAY WEDNESDAY 11.50 16.50 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…

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
11.50	16.50	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
11.50	16.50	14.50	11.50	12.00	10.00

How to acieve this in BI Publisher RTF Template?

Thanks in Advance :)

Find more posts tagged with

Accepted answers

All comments

_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 -