Hi all,
I'm trying to convert a time card worksheet to cognos report so that users can print this out and manually filled in the hours. I get trouble to show name id ssn column in multiple rows. Please let me know how to achieve this.
dept name pay rate hours O/T hours
id ssn
-------------------------------------------------
1 adam sandler 20
-------------------------------------------------
100 123456789
-------------------------------------------------
--------------------------------------------------
2 bryan adams 25
--------------------------------------------------
101 222222222
-------------------------------------------------
-------------------------------------------------
3 steven lee 22
--------------------------------------------------
102 333333333
-------------------------------------------------
--------------------------------------------------
Thanks,
MB
Hi,
Please post the expected output. Will it be a page for each ID or it will be a page consisting of all the ids and ssn's. From what I understand, create a list, place a crosstab inside the list, section the list based on the ID or ssn, create a data item for hours and O/T hours as ' ,, ' and place it as columns in the crosstab that you placed inside the list, add name or id as crosstab row. Let us know if you still face any issue or need more explanation.
Good luck
New guy
Have you considered using a Repeater Table?
It will be a page consisting of all the ids and ssns. Can you explain a little more about your approach? Which items will be in the crosstab?
Quote from: New_Guy on 03 May 2017 11:52:24 AM
Hi,
Please post the expected output. Will it be a page for each ID or it will be a page consisting of all the ids and ssn's. From what I understand, create a list, place a crosstab inside the list, section the list based on the ID or ssn, create a data item for hours and O/T hours as ' ,, ' and place it as columns in the crosstab that you placed inside the list, add name or id as crosstab row. Let us know if you still face any issue or need more explanation.
Good luck
New guy
Hi,
Place dept as a column in the list.
Place a crosstab in the list as a second column.
Place the Name as the first crosstab row.
Concat ID and SSN and place it as a second row.
Create a master detail by Dept and departement between the list and the crosstab.
But before that I will try the repeater table as mentioned by CognoidJay.
Good luck
New guy
Repeater Table works perfectly.
Thank for both!
MB
Table is working better than repeater table for this.
I create a list and put dept id as the first column and then put a 1 column 3 rows table as the second column. Unlock the table cell and move EE name to the first row and ID SSN in the second row of the table.
MB