11-28-2014 02:45 AM
Hi,
I have a custom report which have 1 grouping and that grouping has the "Show Summary" so it shows each group sub-total.
Which is fine.
But, how can I remove the last "grand total" footer line at the bottom of the report ?
I want to remove it because for the kind of data I display, it does'nt make sense.
Thanks
Solved! Go to Solution.
12-01-2014 06:17 AM
Michel,
Unfortunately, you can't remove the final summary line. You could potentially blank it out, however... to do this you would have to adjust the Footer in Field Formatting for every field in the report definition. Try choosing "Custom Formula". Set the "Default Custom Footer Formula" to 0 (or perhaps leave it blank), and then set the "Group 1 Custom Footer Formula" to the formula you would like to use for your first grouping's summary.
Try it out with one field first, and then apply to others if you like the results.
-Jameson
12-01-2014 06:17 AM
Michel,
Unfortunately, you can't remove the final summary line. You could potentially blank it out, however... to do this you would have to adjust the Footer in Field Formatting for every field in the report definition. Try choosing "Custom Formula". Set the "Default Custom Footer Formula" to 0 (or perhaps leave it blank), and then set the "Group 1 Custom Footer Formula" to the formula you would like to use for your first grouping's summary.
Try it out with one field first, and then apply to others if you like the results.
-Jameson
12-01-2014 06:42 AM
Thank you Jameson!
It works.
It is not the ideal solution but it's good enough for my client.
Thanks!
Michel
Discover and save your favorite ideas. Come back to expert answers, step-by-step guides, recent topics, and more.
New here? Get started with these tips. How to use Community New member guide