web

You’re offline. This is a read only version of the page.

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,751

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

I have the same question (0)

All responses Img

All responses (4)

Answers Img

Answers (1)

Community Member on at

Like (0)

Report

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.

Was this reply helpful? Yes No
javedakhtar 1,751 on at

Like (0)

Report

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.

Was this reply helpful? Yes No

javedakhtar

1,751 on at

Like (0)

Report

Report

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

Was this reply helpful? Yes No

Verified answer

keoma 32,729 on at

Like (0)

Report

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.

Was this reply helpful? Yes No

Helpful resources

Quick Links

Leaderboard > 🔒一 Microsoft Dynamics NAV (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans