Report using array

Navigation
0

I have the following problem: I have a table that has 3 fields:

  

id (PK) id_ (FK) dates

     

1 1 01/01/2015
   2 1 01/02/2015
   3 2 01/01/2015
   4 2 01/02/2015

Well, I have a standard report where I have to print as follows:

  

NUM (seq) Name (I look for another table) data1 data2

     

1 Joseph (FK-id-> 1) 01/01/2015 01/02/2015
   2 John (FK-id-> 2) 01/01/2015 02/01/2015

Detail is that I have to print up to 18 dates next to each other. If there are more than 18 dates for the same id game for the bottom line, otherwise skip to the next id, as above.

I'm using an array and I could only print one line below the other and repeat the name in all of them. How can I do this?

NOTE: The report is working, but printing one line below the other, I just need to show it as described above.

    
asked by anonymous 28.07.2015 / 05:47

1 answer

0

What you can do is loop through this array, group it by FK, then loop through the already clustered array, loop back the dates on each returned item, and display in the report.

    
28.07.2015 / 14:00
Consume an API Rest and Persist the data in a local bank - Titanium Send google maps address of an app in message to the mobile phone?