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

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 :)
Answers
-
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.
0 -
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
0 -
sample xml -
sample output -
0