web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Microsoft Dynamics GP (Archived)

Report Writer Calculated Field

(0) ShareShare
ReportReport
Posted on by 12

Dear All,

I am using note field on SOP document number to store the shipping information.  I added calculated field to get this data but my problem is its formatting differently from line no. 2.  How to pad this line so that it will be printed properly on output.  Please see the screen shots.

4401.Capture1.JPG

2843.Capture2.JPG

2843.Capture3.JPG

*This post is locked for comments

  • Harold Worby Profile Picture
    1,331 on at

    Youll need a fixpoint font like Courier to get the colums to line up

  • Suggested answer
    babubaskaran@outlook.com Profile Picture
    12 on at

    Thanks for your reply Worby but unfortunately changing the font wont fix this issue.  The notes field information can be printed using calculated field upto 80 character in a row and then go to the next row but the data on note field doesn't recognize the format or the way typed and print here and there.  I ended up moving data back forth on 2nd row to match the heading of each column and somehow managed to print properly.

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

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the August Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans