multiple values in one row 1

[nb4884]

Hi All,

My report is grouped by project ID.
There is also a field for Category - values as S,0,1,2,3,4,5,6,7
A project can have multiple values for category for ex: S, 0, 2, 5.

If I display Category in group footer it displays only one value 0.

Pls suggest me a formula to display all the values of category separated by comma.
I want to display this in group footer.

Thanks

 

[lbass]

Assuming that category is a string, use formulas like this:

//{@reset} in the group header for project ID:
whileprintingrecords;
stringvar x;
if not inrepeatedgroupheader then
x := "";

//{@accum} to be placed in the detail section and suppressed:
whileprintingrecords;
stringvar x := x + {table.category}+",";

//{@display} to be placed in the group footer:
whileprintingrecords;
stringvar x;
if len(x)>1 then
left(x,len(x)-1)

-LB

 

[nb4884]

Thanks LB,

But the data doesnot display as unique.

I have another field in same section which is also multivalue (has about 8 values). I have set up a formula for that field to display only one record.

Now when i display the above 3 formulae, it mulitplies by 8 and displays S,0,2,5 pattern 8 times.

Please suggest how should I avoid the multiplication here.

Thanks

 

[nb4884]

Thanks LB, the formulae worked. I created a sub report and works great

 

[lbass]

You don't need a subreport. Just change the accum formula to:

//{@accum} to be placed in the detail section and suppressed:
whileprintingrecords;
stringvar x;
if not({table.category} in x) then
x := x + {table.category}+",";

-LB