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 :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / SSRS report design
Microsoft Dynamics GP (Archived)

SSRS report design

(0) ShareShare
ReportReport
Posted on by Community Member

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

  • Verified answer
    soma Profile Picture
    soma 24,416 on at

    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!!!

  • Community Member Profile Picture
    Community Member on at

    @Soma

    Thank you it worked.

  • soma Profile Picture
    soma 24,416 on at

    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.

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