I am trying to build an array per group built from multiple records.
I have multiple records of fields containing lets say "courses taken".
Each course itself maybe a multiple record. I mean to say someone can have "history" twice, "geography" 3 times etc .
I have tried concatenating a string, but gave up on that approach. ie.
concatenatedfield:=concatenatedfield+Table.course

So back to arrays: Each student is a group and I need to take his courses and summarize the fields onto a single line in the group footer. I am getting student 1, but student 2 contains student 1's answers and on it goes building forever to student 3. It is probably not the array that is broken, but rather the "fin" statement I use to hold the every growing string variable.
But, when I try shared stringvar fin, and clear it in the group header I get an array error.
vw is Tablename
.Student is name (yes I have real records with nothing in this field)
.Module is course (yes I have real records with nothing in this field)
build the array (note whilereadingrecords does not work correctly I get too many courses per student that are not really there's)
Lastly, I do not know the number of courses per student coming in, but I do know that 10 is and will always be the largest number they can have.
==========================
formula called out into detail section
==========================
WhilePrintingRecords;
stringvar array arrModule;
numbervar i;

if  {vw.Module}<>"" and {vw.Student}<>""
 then
(if not({vw.Module} in arrModule) then
(
    i := i + 1;
    redim preserve arrModule;
  
      arrModule := {vw.Module};
   
));
arrModule;
==========================
formula called out in groupfooter
==========================
WhilePrintingRecords;
stringvar array arrModule;
stringvar fin;

numbervar j;
 numbervar k;
for j := 1 to ubound(arrModule) do
fin := fin + arrModule[j] + ", ";

if len(fin)> 0 then
left(fin,len(fin)-2);
=======================

Is "fin" building to infinity?
To check what is in the array, how can I print it out as is ?
in a for loop?
when I use redim arrModule[1] in a group header I get an error as this.
"A subscript must be between 1 and the size of the array"

I have seen google notes about that you cannot clear out a string variable as a shared variable when using it inside of an array????


Edited by mrtj - 29 May 2013 at 4:43am

I fixed it


shared numbervar i;

if  {vw....
));
//arrModule;
i;
I changed this from not a shared variable. Then in group header set i to 0
also removed the arrModule statement that was here since I didnt need it to print in the detail part.
new footer formula
===========
WhilePrintingRecords;
stringvar array arrModule;
stringvar fin;
shared numbervar i;

numbervar j;
 numbervar k;
fin:="";             //I added this here which did help, because fin was growing even after I fixed "i"
for j := 1 to ubound(arrModule) do
fin := fin + arrModule[j] + ", ";
redim arrModule[ubound(arrModule)];

//if len(fin)> 0 then
if i >1 then left(fin,len(fin)-2);  //this fixes the fact that students with no courses were getting commas printing out .
the redim statement I added here , which index is set to be the current value of i on the current student, so when next student comes in the i could be say as high as lets say 3 courses (i=3), then I was getting 3 commas in the next non-course attending student but the left stmt above took out two of the commas leaving 1 pringing, so the if stmt took care of that saying i has to be gtr than zero.
=========
separate clear formula called out in header
===============
shared numbervar i;
 i:=0;
============
So now i is reset to zero in header, and fin is set to blanks before the for loop waddles thru the array. it works.
Now my next task is to fix the fact that the header

the reason i cannot do your string thing is I am getting 2 geographies
2 histories 3 maths etc

My final task is to sort the array alphabetically so it prints out
geogrpahy history math
and not math geography history


Edited by mrtj - 29 May 2013 at 12:18pm

I let the report dictate when a new page is inserted, I do not want to tell it to insert a new page after a footer or before a header, because the folks want it on least amount of pages as possible. So with that said when detail lines do not fit on one page, when room runs out and a page is inserted apparently the group header formulas run again, and these formulas are set to set the indexes of the array back to 1, and so I lose all the courses built up on the previous page and a student instead of having 8 courses only has his "2nd page" of detail rows accumulated.

that worked. thanks.