Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics NAV (Archived) / Report
Microsoft Dynamics NAV (Archived)

Report

(0) ShareShare
ReportReport
Posted on by jsshivalik 3,027

Hi

  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

  • Suggested answer
    Amol Salvi Profile Picture
    Amol Salvi 18,694 on at
    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 Profile Picture
    Tina Menezes 2,576 on at
    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 Profile Picture
    jsshivalik 3,027 on at
    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 Profile Picture
    Community Member Microsoft Employee on at
    RE: Report

    yes agree with tina also..

  • Tina Menezes Profile Picture
    Tina Menezes 2,576 on at
    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.

    Descending-order1.png

  • Suggested answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    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

    3704.Capture.PNG

    Then your details row will display in descending order.

    you already finished just a small changes:-)

  • Suggested answer
    Nareshwar Raju Vaneshwar Profile Picture
    Nareshwar Raju Vane... 5,596 on at
    RE: Report

    Hi,

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

    Regards,

    Naresh.

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans