fields in a table 1

[cm1234]

I am running CR 9.0 and have a issue in getting fields
in a tabel to display in a different way
The string is made in MS sql and i need it to
not loke like this because he has three qaulifications
nametable Qualifytable
1 Mike A1
2 Mike B2
3 Mike C3
But to be visual in CR as the following
nametable Qualifytable
1 Mike A1 B2 C3

Hope thet some one can help.

best regards
cm1234

 

[satinsilhouette]

You could try grouping and then overlay each one so that is flows they way you want it to look. Or, since we don't have much to go on here, you could bring the table in twice more to pick up that field the 3 times that you need to.

Thanks so much!
satinsilhouette

 

[TheBlondOne]

If you search on the BO website for "Dynamic Array" this will help you.

You will need to group on nametable and insert the qualifytable into the details section.

You can then build an array to populate with information from the details section which will be displayed in the group footer.

The only other thing you might have to do is to move the field nametable from the group header into the group footer.

-Steve


"if at first you don't succeed, sky diving is not for you"!!! )

 

[lbass]

First insert a group on the name field. Then you could either:

1- Place a crosstab in the group footer where you use the name as the row and the qualifications field as the column field, using maximum of the qualifications field as the summary field. Then suppress the column labels, go to the customize style tab and suppress the column and row totals, and then also go to format grid->and uncheck "show grid lines". Or,

2-Create three formulas:

//{@reset} to be placed in the name group header:
whileprintingrecords;
stringvar qual;
if not inrepeatedgroupheader then
qual := "";

//{@accum} to be placed in the detail section:
whileprintingrecords;
stringvar qual := qual + {table.qualification} + " ";

//{@display} to be placed in the groupfooter:
whileprintingrecords;
stringvar qual;

Suppress the details section and drag the groupname into the group footer.

-LB

 

[cm1234]

Hej IBASS

This did just do the trick,
thank you very much for your help its
very commendable.

best regards
cm1234