News and Announcements icon

Dynamics 365 CommunityForums Microsoft Dynamics GP (Archived) SSRS report design

Microsoft Dynamics GP (Archived)

SSRS report design

(0) Share

Report

Report

Posted on by Community Member 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

All responses Img

All responses (3)

Answers Img

Answers (1)

soma 24,406 on at

Like (0)

Report

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 Microsoft Employee on at

Like (0)

Report

RE: SSRS report design

@Soma

Thank you it worked.
Verified answer

soma 24,406 on at

Like (0)

Report

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

Helpful resources

Quick Links

Leaderboard

#1

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

#2

Martin Dráb 230,445 Most Valuable Professional

#3

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans