I'm having a simular issue, i'm retrieving data from several datatables/view bound to an applikation developed in C#. 5 of the tables only contains one row but two of them can contain multiple rows. I have been trying to solve this by adding several detail selections. Most of them are just holdig data that will result in one page is written. And in the other two details i have put a subreport with the following structure
Detail (loop the rows from the datatable and adding them to a shared variable, formula) page footer (displays the data from the variable) by showing the variable pd from a formula.
I have written the following code to collect the data: shared stringvar pd; If pd = "" then pd := {msvm_ObjectProperties.propertyDescription} Else pd := pd + ", " + {msvm_ObjectProperties.propertyDescription}
I get the correct data in the first of three report pages. But it seems to keep looping when it should not.
Hiss, Balkong, Seniorboende 55+ the desiered layout from page1 row1, row2, row3 this data is collected from the three rows.
Hiss, Balkong, Seniorboende 55+, Hiss, Balkong, Seniorboende 55+ the desiered layout from page2
Hiss, Balkong, Seniorboende 55+, Hiss, Balkong, Seniorboende 55+, Hiss, Balkong, Seniorboende 55+ the desiered layout from page3
Anyone got a solution?
|