Skip to main content

Notifications

Announcements

No record found.

Finance | Project Operations, Human Resources, ...
Suggested answer

struck with Report Writer Calculated Field limit

Posted on by 190

I need to put a paragraph which will include customer name, address etc at the report footer.

the paragraph looks something like this:

some text in front...... + customer name + some text in middle + address 1 + address 2 + address 3 + some text at the end.

I use VBA to read customer name, address 1,2,3 etc and join them together with the "some text in front" "some text in middle" and "some text at the end" .

problem now is I need to span the entire final text paragraph nicely across the report / page width.

If I use RW Calculated field, there is a limit of 80 characters !!! and each line will appear rather short, not occupy the full page width and look odd...

beside calculated field, any other work around?

I read somewhere about using label instead, but can't figure out how.

or any other suggestion?

thanks.

Categories:
  • David Musgrave MVP GPUG All Star Legend Moderator Profile Picture
    David Musgrave MVP ... 13,917 Most Valuable Professional on at
    RE: struck with Report Writer Calculated Field limit

    Hi Lo

    If you cannot work with 80 character lines and a bigger font, then another tool might be your only option.

    Regards

    David

  • HFLo Profile Picture
    HFLo 190 on at
    RE: struck with Report Writer Calculated Field limit

    Hi, David:

    thanks for confirming the 80 char limit   (:

    will have to go for crystal then... too bad.

  • Suggested answer
    David Musgrave MVP GPUG All Star Legend Moderator Profile Picture
    David Musgrave MVP ... 13,917 Most Valuable Professional on at
    RE: struck with Report Writer Calculated Field limit

    Hi Lo

    You will not be able to get around the 80 character limit for string calculated fields.

    The best you can do is break up your longer data into lines of 80 characters using RW Functions or a custom GP Power Tools RW Function.

    https://winthropdc.wordpress.com/2008/09/01/using-the-built-in-report-writer-functions/

    https://winthropdc.wordpress.com/2011/01/13/working-with-text-fields-in-report-writer/

    https://winthropdc.wordpress.com/2011/09/08/how-to-display-more-than-80-characters-of-an-extender-long-string-field-in-reports-using-the-support-debugging-tool/

    Regards

    David

  • HFLo Profile Picture
    HFLo 190 on at
    RE: struck with Report Writer Calculated Field limit

    Hi

    Thanks for feedback. I have read that article (and few others on related issue), but problem here is (I guess) the limit of 80 char for calculated field, which will not occupy the full width. Using bigger font will not help as we need to maintain uniform font for the whole report.

    Thanks again and hope to hear more.

  • Suggested answer
    Beat Bucher  GP Geek  GPUG All Star Profile Picture
    Beat Bucher GP Gee... 28,021 Super User 2024 Season 1 on at
    RE: struck with Report Writer Calculated Field limit

    Hi,

    Have a look at this forum thread.. this might help you get to the point you're looking for. Though it wasn't for the same field, but the principle remains the same by creating a calculated field

    community.dynamics.com/.../how-can-i-increase-lengths-of-items-on-report-writer

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,253 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,188 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans