Report Design Nav 2009 R2

Prasoothan

Hi,

I am new to CSIDE and C/Al. I am using Nav 2009 R2.

I would like to design a report based on the following SQL Query. Please guide.

select [Item Category Code], sum(B.[Invoiced Quantity]) as Qty, sum([Cost Posted to G_L]) as Value
from [CRONUS International Ltd_$Item] A
inner join [CRONUS International Ltd_$Value Entry] B
on A.No_ = B.[Item No_]
where B.[Posting Date] <= '04/30/2019'
group by A.[Item Category Code]
order by A.[Item Category Code]




Thanks,
Prasoothan

imclever1205

1. Create a New Report
2. Add DataItem Item Table (27) and DataItem to Value Entry Table ( 5802 ). Link Both
3. On the Data Item of the Item Table, select Properties, and in the ReqFilterFields add Item No.,Posting
Date and Item Category Code
4. On the Data Item of the Item Table,in the field DataItemTableView set your sorting on the field desired.
N.B The field should be created/exist as key in the Item Table
5. Then Click on View and Layout and start designing the Report.

This is the basic to start with the report. You will need to dig it a little bit and read some
https://docs.microsoft.com/en-us/dynamics-nav/report-design-walkthroughs

Hope it helps !

imclever1205

1. Create a New Report
2. Add DataItem Item Table (27) and DataItem to Value Entry Table ( 5802 ). Link Both
3. On the Data Item of the Item Table, select Properties, and in the ReqFilterFields add Item No.,Posting
Date and Item Category Code
4. On the Data Item of the Item Table,in the field DataItemTableView set your sorting on the field desired.
N.B The field should be created/exist as key in the Item Table
5. Then Click on View and Layout and start designing the Report.

This is the basic to start with the report. You will need to dig it a little bit and read some
https://docs.microsoft.com/en-us/dynamics-nav/report-design-walkthroughs

Hope it helps !