Report

(0) Share

Report

Posted on by jsshivalik

3,099

I am displaying report like below

Group	Code	Description	Opening	Receipt	Issue	Closing
						
General	G01	Paper A4		4,100.00	4,100.00	0
	G02	Printer Ribbon		60.00	60.00	0
	G03	Toner	3000	0.00	0.00	3000
Bearing	A01	bearing A-90		7,800.00	7,800.00	0
	A01	bearing a-30		8,000.00		8,000.00

I want like this now

First it should display items with closing stock > 0 and then subtotal of all items Group Wise

Then items with stock 0 and then subtotal of all items Group wise like below

General						
	G03	Toner	  3000	0.00	0.00	3000
		Sub Total	3000			3000
	G01	Paper A4		4,100.00	4,100.00	0
	G02	Printer Ribbon		60.00	60.00	0
		Sub Total	0	4,160.00	4,160.00	0
Bearing						
	A01	bearing a-30		8,000.00		8,000.00
		Sub Total	0	8000	0	8000
	A01	bearing A-90		7,800.00	7,800.00	0
		Sub Total	0	7800	7800	0

*This post is locked for comments

All responses (7)

Answers (0)

Suggested answer

Amol Salvi 18,698 on at

Like (0)

Report

RE: Report

I hope you have created report .let is know what problem you are facing as above question is requirement of report.
Suggested answer

Tina Menezes 2,582 on at

Like (0)

Report

RE: Report

Hi,

You can read my blog using the below link to display records with first with closing stock >0 followed by the group total and then the records with closing stock zero and <0 followed by the group total:

https://tinamenezesdynamicsnavblog.wordpress.com/2017/08/05/tricks-to-perform-grouping-of-records-in-reports-of-dynamics-nav/
jsshivalik 3,099 on at

Like (0)

Report

RE: Report

Hi

I dont need sorting . I want to display first those rows whose Clsoing Stock is > 0 in the Group and then display Sub Total. Then want to display rows whose closing stock is 0 and then SubTotal of items whose stock is < 0 in that Group

Thanks
Community Member on at

Like (1)

Report

RE: Report

yes agree with tina also..
Tina Menezes 2,582 on at

Like (0)

Report

RE: Report

Hi,

You need to go to the table properties and under Sorting section, add a new sorting option. Select your field under Sort by and sort it in Order Z to A to sort and display in descending order.
Suggested answer

Community Member on at

Like (0)

Report

RE: Report

Hi Jsshivalik,

you already done that please create a one row below group,code,description row ok.

Then you need descending order right so if you have a dataitem for details rows then simply goto data item --> properties--> data item table view-->under

Then your details row will display in descending order.

you already finished just a small changes:-)
Suggested answer

Nareshwar Raju Vane... 5,596 on at

Like (0)

Report

RE: Report

Hi,

You have to group in RDLC layout, in the group you can set the total (After/Before).

Regards,

Naresh.