CR 9 Paragraph formatting

[JodyLyn]

Hi,

I am a beginner user, and I have no idea how to do this.
I have @name, but I need it to print in the details section in paragraph format (ex. name1, name2, name3, name4, etc.) Can someone point me in the right direction?

thank so much,
J

 

[synapsevampire]

A Details section does not have all rows data available to it, it has one at a time, hence your difficulty.

You need to concatenate them into a string in order to display them in thaqt fashion:

Details Formula:
whileprintingrecords;
stringvar MyNames:=Mynames+{table.name}+","

Report footer formula:
whileprintingrecords;
stringvar MyNames;
left(Mynames,len(Mynames)-1)

So the names will display AFTER the details, so just suppress the details section by right clicking it and select Suppress.

If you have groups, and want the names at the group level, you'll display at the group footer level, and add a formula in the group header to reset the Mynames variable, as in:

Group Header formula:
whileprintingrecords;
stringvar MyNames:="";

-k

 

[JodyLyn]

I have group 1 which is the quarter, then group 2, which is the department. Using what you described builds the same records over and over. Please please help!

 

[JodyLyn]

That's it! You are the best! thank you!