Sorry, CR doesn't 'create' rows of data, it just reports on the data that is there.
The simplest solution is to preprocess your xml to include the extra rows in either the same table or a table that you can link to OR you can add to the xml to include the additional data that you want for each item so that you can parse that into another array and display the 2 array values at the same time so that it 'looks' right...
either way the place to 'add' this data is in your middle tier or in data retrieval process.
Personally, I go with 'super' rows in my data retrieval so that everything I want to display on that row is in the row. If I need multiples rows of data, I would have multiple rows in my data, then display the 'common' stuff as group headers and the 'extra' stuff like this in details. Shared variables/Running Totals keep the counts/averages correct, just a bit more work.
I haven't needed multiple arrays as I am suggesting as, well personnally, I don't think that arrays in CR are all that useful, they never seem to be able to do what I want/need them to, but I can see how they could work in this case
HTH
Edited by lockwelle - 11 Jul 2012 at 3:35am
IP Logged
