Skip to main content

Notifications

Announcements

No record found.

Finance | Project Operations, Human Resources, ...
Answered

Report Writer Hide a Calculated Field

Posted on by 750

Hello,

  I have created two calculated fields in report writer that pull information on the SOP Packing Slip in to create a barcode using the 39 font this works perfect however I do not need one of the bar codes to display all the time. I need to only show when another field that is a string contains the letter R. Is this possible?

  Thanks 

Categories:
  • fireinc Profile Picture
    fireinc 750 on at
    RE: Report Writer Hide a Calculated Field

    Thanks this worked exactly as I had hoped.

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

    David,

    I've reported countless spam posts in recent times... spammers get more and more creative, as they don't post any garbage anymore, they try to make the answer look some kind of legit, but always have some embedded links included that points to not-so-legit web sites..

    I don't think there is much the site admins can do against that plague... the system should have some user creation validation, but it's hard to track of the hundreds of accounts that likely get created every day.

  • David Musgrave MVP GPUG All Star Legend Moderator Profile Picture
    David Musgrave MVP ... 13,928 Most Valuable Professional on at
    RE: Report Writer Hide a Calculated Field

     Harry132 Don't just copy someone else's (mine) reply and hide a website link by making the font the same color as the background.

    Highlighting your spam post, shows the website.

    I have requested your account be blocked.

  • Verified answer
    David Musgrave MVP GPUG All Star Legend Moderator Profile Picture
    David Musgrave MVP ... 13,928 Most Valuable Professional on at
    RE: Report Writer Hide a Calculated Field

    Hi

    Just create a calculated field that looks at the field that contains an R and either returns the data you want to see or an empty string.  You can use use the hide when empty option to stop date and numeric fields showing with zero or empty values.

    You can use the RW_Pos report writer function I added to v7.0 of GP to check if there is an R in the string. It is a wrapper for the Dexterity pos() function.

    {-----------------------------------------------------------------------
    RW_Pos

    Returns a numeric value indicating the starting position of a string within a string.

    16Jan02 DMUSGRAVE PR29033: Added RW function to wrap Dex functions
    -----------------------------------------------------------------------}

    function returns integer OUT_pos;
    in string IN_target; { The string you want to search in }
    in string IN_search; { The string you want to search for }
    in integer IN_start; { The position at which the search will start in the target string }

    OUT_pos = pos(IN_target, IN_search, IN_start);

    Regards

    David

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,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,214 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans