Hi Tim,
You can do this with a Running Total. In the Report Header create a formula that defines and initializes a variable like:
WhilePrintingRecords; StringVar Results := "";
In the Detail section, create a formula that adds the Result_Name to the variable:
WhilePrintingRecords; StringVar Results; Results := Results & {table.Result_Name} & ", ";
In the Report Footer, add one last formula to display the string:
WhilePrintingRecords; StringVar Results; Left (Results, Length (Results) - 2);
I used the Left function to remove the last ", " from the string.
Good luck,
Brian
Hi Tim,
Here's what you need to do:
1. Insert a Crosstab. Use the 'Result Name' column as the Row of the Crosstab and the Sample Number field as the 'Summarized Field'.
Set the summary function to 'Count'.
2. Place the crosstab on the Report Footer.
3. Go to the Crosstab Expert > Customize Crosstab > Get rid of the Gridlines if you don't need them.
-Abhilash
Add comment