Report - filter few line

roshini

Hi Nav Experts!

How to use integer in report, to filter only few records, and display.

Explaing the problem:

as in my report having 4 dataitems.

I created key for area code and quantity, then it is worked fine when posting happening from one batch,if posting happening other batches then result showing as follows:

area code Quantity
001 2
002 1
003 2
001 1
003 1

I never used integer dataitem, how to use integer dataitem to get the result as follows:

area code Quantity
001 4
002 1
003 3

Hope any one can understand my problem.

Thanking

markborges

Are those dataitems linked with each other?

If so, can't you sort by "Area" code, ascending, so that you have only 1 ocurrence of each area code?

:-k

roshini

Mr.Markborges

Thanks for ur reply.

dataitems Linked with each other. but Batchno and areacode link is there.

so getting records as per batchno.

if single batch no posting then there is no problem with the report as it is showing output as

areacode quantity
001 002
002 001
003 004


if multiple batchno's is there then it is showing output as

areacode quantity
001 002
002 001
003 004

001 001
002 002

001 003
002 003
003 001

as per batchno wise.

But Result should show as follows:

Quantity should display as per areacode

areacode quantity
001 006
002 006
003 005

Can get any help

markborges

Which are your four dataitems?

Where is ARea Code located?

Where is Batchno located?

roshini

Thanks for ur quick reply


Dataitems :

Item Journal Batch
Item Journal Line
Posted Count/Picking Header
Posted Count/Picking Lines

Item Journal Line link with Journal Template Name

Posted Count/Picking Header Linked with Journal Batch Name,Document Date

Posted Count/Picking Lines Linked with Type,Batch No.

Area Code is located in Posted Count/Picking Header and Posted Count/Picking Lines.

markborges

Where is area code?

roshini

Area Code is located in Posted Count/Picking Header and Posted Count/Picking Lines.

markborges

Then maybe you should organize your dataitems differently:

Area Code
>Posted Count/Picking Header (link per Area Code)
>>Posted Count/Picking Lines (link per Type, Batch no.)
>>>Item Journal Line (find the right link, I'm not sure)

Then you do a Totalling of the Quantities for the Item Journal Lines...

This should help.

roshini

Thanks for ur quick reply....

I am printing as per Item Journal batch -->

Item Journal Batch
>Item Journal Line
>>Posted Count/Picking Header
>>>Posted Count/Picking Lines

Posted Count/Picking Header and Posted Count/Picking Lines having BatchNo. this is different, this Batchno for these 2 tables only to from which batch items were posted.

markborges

Well, you have 2 options:

1- Reorganize the dataitems so that "Area" table is the first one, then you'll have only 1 ocurrence of each Area Code.

or

2- Sumarize the information on an auxiliary table and then print from this table, but this is the HARDEST and the most EFFORTFUL. I don't advise to use this one unless you CANNOT reorganize the dataitems at all..

Maybe someone else have a different idea, but the number 1 is the most common for me.

roshini

Thanks a lot Mr. Markborges,

Thanks for ur support and quick response, I got more knowledge on reports in navision in way of approaches. as per the requirement I need to to like that only, I am still trying how to integer Temp table to get the desired result,

Hope I may get any Help!!