Report Runs Very Very... Slow

RasoolShaik

Hello to all navision expert,

I have a problem here... The report dat i created it runs very very slow...
the report has 3 Dataitems Item Ledger Entry and two new tables as Stock Aging Buffer and Stock Aging Prod Div Buffer where i'm inserting the data into those tables on Afterget record trigger of Item ledger entry..

can anyone help me to this issue?

Thanks
Rasool Shaik

kine

the speed depend on:
1) Usage of correct Keys
2) Navision DB or MS SQL
3) Usage FlowFields and CalcSums
4) No. of keys on the tables where you are inserting data
5) No. of concurent users using the tables you are filling
6) On Server HW
7) On Client HW
8) Other conditions

Please, be more specific...

RasoolShaik

kine wrote:

the speed depend on:
1) Usage of correct Keys
2) Navision DB or MS SQL

Navision DB

3) Usage FlowFields and CalcSums
4) No. of keys on the tables where you are inserting data
5) No. of concurent users using the tables you are filling
6) On Server HW
7) On Client HW
8) Other conditions

Please, be more specific...

mikka

Hi RasoolShaik,
check the Key you are use.
The Keys must be mastch with the Filter Fields you set. Look in the Properties (DataItemTableView) of every Dataitem. To use the false Keys is one of the most mistakes Users and Developers make!

The other points are possible, but why only at this report is the performance slow :!: :!: :!:
Or have you every time performance problems?
I think it´s not fair to say/wrote some possible thinks, and the supplicant ist much confused.
Better is it to look what is the nearest Problem.
with kind regards
mikka

ps:excuse me about my english