News and Announcements icon

Dynamics 365 CommunityForums Microsoft Dynamics NAV (Archived) want to create report ...

Microsoft Dynamics NAV (Archived)

want to create report in nav 2016

(0) Share

Report

Report

Posted on by javedakhtar

1,745

Hi All,

i want to create stock on item ledger entry but the client want in this format.

	LOCATION A	LOCATION B	LOCATION C	TOTAL
ITEM NO 1
LOT1	10	11	12	33
LOT2	13	14	15	42
TOTAL ITEM NO 1				75
ITEM NO 2
LOT1	16	17	18	51
LOT2	19	20	21	60
TOTAL ITEM NO 2				111

i tried using matrix taken row group

item no (parent grp)

--lotno(child group)

in columns

-location

in data

-quantity(its in lotno header).

but the quantity is taking the first record but i want to sum my quantity based on item and lot no . kindly help.

*This post is locked for comments

All responses Img

All responses (4)

Answers Img

Answers (1)

Verified answer

keoma 32,675 on at

Like (0)

Report

RE: want to create report in nav 2016

i tried the following:

created a new report with dataitem "item ledger entry" and the needed fields.

then added a tablix using tablix wizard with fields and groups.

totals/subtotals

layout

result

rendering result:

maybe that helps.

javedakhtar

1,745 on at

Like (0)

Report

Report

RE: want to create report in nav 2016

ITEM CAT A				ITEM CAT A
ITEM NO1				ITEM NO2
LOCATION A	LOT1	1		LOCATION A	LOT11	1
LOCATION A	LOT2	2		LOCATION A	LOT21	2
LOCATION B	LOT 3	3		LOCATION B	LOT 31	3
LOCATION C	LOT 4	4		LOCATION C	LOT 41	4
TOTAL	ITEM NO1	10		TOTAL	ITEM NO2	10

javedakhtar 1,745 on at

Like (0)

Report

RE: want to create report in nav 2016

Sir ,

My customer wants to save some page space that why asking to print report in one page min two item side by side.

ITEM CAT A ITEM CAT A

ITEM NO1 ITEM NO2

LOCATION A LOT1 1 LOCATION A LOT11 1

LOCATION A LOT2 2 LOCATION A LOT21 2

LOCATION B LOT 3 3 LOCATION B LOT 31 3

LOCATION C LOT 4 4 LOCATION C LOT 41 4

TOTAL ITEM NO1 10 TOTAL ITEM NO2 10

is it possible in rdlc if yes then how should i approach it.
Community Member Microsoft Employee on at

Like (0)

Report

RE: want to create report in nav 2016

Hi Javed,

Try to add column Outside the group.

I have created one Matrix report with Row group - Item No (parent Group) and Lot No (Child Group) and column group as Loc Code.

added rows outside the group and columns outside the group and getting correct results as totals.

You need to consider "Remaining Qty " field to get Available stock details.

Helpful resources

Quick Links

Leaderboard

#1

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

#2

Martin Dráb 230,198 Most Valuable Professional

#3

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans