Inventory Valuation Report 1001

Business Central/NAV Developers Forum
1

I used report from NAV 2017 - R1001 - Inventory Valuation, to create a new report that could group by location. Because in the original report i can take the results of all Locations or filter by a specific.

My goal is to show all locations .

I added Location as Data Item, and indented Item , and dataitemlink by Code - Location Filter

Then in Code replaced :

//ValueEntry.SETFILTER(“Location Code”,GETFILTER(“Location Filter”));
ValueEntry.SETFILTER(“Location Code”,Location.Code);

//ItemLedgEntry.SETFILTER(“Location Code”,Item.GETFILTER(“Location Filter”));
ItemLedgEntry.SETFILTER(“Location Code”,Location.Code);

The original map takes about 2 minutes for all data, tis new map cant generate at all no data(20 minutes nd nothing). Except if i put some filters before generate the report, for example one location or one item.

What i am missing here?

Thanks for help

1 Like
2

It seems like the changes made in the report design have resulted in a performance issue. Here are a few suggestions that you can try to improve the performance:

  1. Remove any unnecessary data items or columns from the report layout to reduce the amount of data that needs to be processed.
  2. Check if any fields that are used in the report are not indexed. If so, add an index to those fields to speed up data retrieval.
  3. Use the SQL Server Profiler to analyze the queries generated by the report and optimize them if needed.
  4. Check the server load during the report generation. If the server is overloaded, it may take longer to generate the report.
  5. If none of the above solutions work, consider breaking the report into smaller parts, such as one report for each location, and then merge the results manually.
1 Like