Skip to main content

Notifications

Microsoft Dynamics GP (Archived)

SSRS report design

Posted on by Microsoft Employee

Hello,

Please I want to design a report on SSRS.

The columns are; Item number    Doc type   Transaction qty  

                            Hace1              POP                      5      

                            Hace1              SLS                     -5

But I want the qty for SLS to show in another column like this;

                         Item number    Doc type   Transaction qty   Qty Sold

                            Hace1              POP                      5      

                            Hace1              SLS                                         -5

Please how can I create such column when I have just one field containing the transaction qty.

Please I need your help.

Thank you

*This post is locked for comments

  • soma Profile Picture
    soma 24,406 on at
    RE: SSRS report design

    You are welcome.

    If my suggestion solved your problem, mark as a verified. Because this will helps to some others who having the same problem.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: SSRS report design

    @Soma

    Thank you it worked.

  • Verified answer
    soma Profile Picture
    soma 24,406 on at
    RE: SSRS report design

    Use CASE statement on your query as below to achieve the same.

    select [Item number],

    [Doc type], 

    CASE WHEN [Doc type]  = 'POP'  THEN [Transaction qty] ELSE 0.00 END  'Transaction qty',

    CASE WHEN [Doc type] = 'SLS' THEN [Transaction qty] ELSE 0.00 END 'Qty Sold' 

    from [Tabel Name]

    Hope this helps!!!

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!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

New! Quick response templatesâš¡

Save time with the new custom templates!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,056 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans