show long result in multiple rows

[marzbuzz]

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            
            

[New_Guy]

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

[AnalyticsWithJay]

Have you considered using a Repeater Table?

[marzbuzz]

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?

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

[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

[marzbuzz]

Repeater Table works perfectly.

Thank for both!

MB

[marzbuzz]

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