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

Community site session details

Session Id :
Microsoft Dynamics GP (Archived)

Unable to get the same alignment in SSRS as in GP memo field

(0) ShareShare
ReportReport
Posted on by 1,921

Hi Everyone,

In one of the PO Entry memo field, I enter text that looks like this:

Item 1              $10.00

Item 12365       $12.00

Item3652          $14.00

In the textbox, everything is perfectly aligned.  However, when I print my SSRS Report, the information is not aligned properly.  It looks like this:

Item 1            $10.00

Item12365             $12.00

Item3652           $14.00

 

In order to get this unperfect result, I had to add a formula in the SSRS field which I found on another forum:

=(replace(replace(First(Fields!TXTFIELD.Value),Chr(13),vbCrLf),chr(9),space(2)))

 

If I didn't put this formula, things would appear like this:

 Item1     $10.00         Item12365    $12.00         Item3652     $14.00

 

Has anyone ever faced this problem and found a way to solve it?  I'm wondering if the same thing happens with Crystal Reports.

Thanks

 Francis

*This post is locked for comments

I have the same question (0)
  • Francis Larocque Profile Picture
    1,921 on at
    Re: Re: Re: Re: Unable to get the same alignment in SSRS as in GP memo field

    Of course, it is an issue with SSRS since Crystal  Reports displays the data correctly.  On the other end, objects are so old in GP, they dating back to Windows 95 era.  Text boxes don't even recognize tabs, but consider them as a series aof spaces, right click isn't enabled for cutting and pasting from one field to another, there is a clear button which you need to press before keying in new information, and so on.  It's two generations late. 

  • Mike Smith Profile Picture
    6,840 on at
    Re: Re: Re: Unable to get the same alignment in SSRS as in GP memo field

    I've found this to be more of an issue with SRS than the underlying datasource itself.

    This is the only work around that I have found at this point though.

  • Francis Larocque Profile Picture
    1,921 on at
    Re: Re: Unable to get the same alignment in SSRS as in GP memo field

    Thanks very much for the answer, Mike.  I find it quite unbelievable that Crystal Reports does a better job with an MS system than an MS report generator.  These guys should wake up and make sure that their own products work properly toghether...

  • Mike Smith Profile Picture
    6,840 on at
    Re: Unable to get the same alignment in SSRS as in GP memo field

    I've had this same issue with SRS.  The way I've worked around it is to use a table and add the data fields to the appropriate cells.  Crystal Reports does not have this behavior when everything is aligned 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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Andrés Arias – Community Spotlight

We are honored to recognize Andrés Arias as our Community Spotlight honoree for…

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans