thread Any way to reduce/limit text in description field on a transaction report? in Online Store

Any way to reduce/limit text in description field on a transaction report?

ArtSpace-HF — Wed, 12 Mar 2025 15:52:19 GMT

On a transaction report, the description field can get quite extensive because it's tied to the online description we have for related online events/programs (lots of details mentioned).

Is there anyway to limit/reduce/alter the amount of text that will show on a report for this field?

At the moment, when looking at a report, the description column can just get so big because of the text it's tied to, and accounting folks would love if there's a way to limit this, so the the reports are much cleaner and easier to read.

Thank you!

Re: Any way to reduce/limit text in description field on a transaction report?

Donnie-M — Wed, 12 Mar 2025 15:58:51 GMT

@ArtSpace-HF Are you pulling the report from your online dashboard?

Re: Any way to reduce/limit text in description field on a transaction report?

ArtSpace-HF — Wed, 12 Mar 2025 16:24:46 GMT

Yes, running a transactions CSV report.

Re: Any way to reduce/limit text in description field on a transaction report?

Donnie-M — Wed, 12 Mar 2025 18:21:44 GMT

@ArtSpace-HF You can do a quick trick to fix it so to speak. Copy this and paste it in a new column in the 2nd cell down: "=LEFT(AE2,30)" This will truncate the description to 30 characters and you can put description above it in the header. The "AE" is the column of the description (at least on my report) Then you can right click on the big description column and "hide" and get it out of there. This is a low tech solution, and you could always record a macro.

Re: Any way to reduce/limit text in description field on a transaction report?

ArtSpace-HF — Wed, 12 Mar 2025 22:14:15 GMT

Got it, thanks very much!

Re: Any way to reduce/limit text in description field on a transaction report?

Summer2024 — Wed, 19 Mar 2025 12:57:21 GMT

Thanks for providing the best answer here @Donnie-M ! 😃