Very Slow Report

siyak

Hi there good people!! Please help ](*,)

I've created a report which has the following dataitems
(
Customer
Sales Cr.Memo Header
Account Types
Customer Bank Account
)Indented in that order and i have this code under Sales Cr.memo Heder(
PostedDocDimension.SETRANGE(PostedDocDimension."Table ID",114);
PostedDocDimension.SETRANGE(PostedDocDimension."DimensionCode",'ACCTYPE');
PostedDocDimension.SETFILTER(PostedDocDimension."Document No.","Sales Cr.Memo Header"."No.");
PostedDocDimension.SETFILTER(PostedDocDimension."Line No.",'0');
IF PostedDocDimension.FIND('-') THEN;
vCust.SETFILTER("No.",AccType."Customer No.");
vCust.FIND('-');
CampaignNo := "Sales Cr.Memo Header"."Campaign No.";)

Itried to the SETCURRENTKEY(SETCURRENTKEY("Sell-to Customer No.","No."),
It is working very well,but it is very very slow

Belias

first of all, if you are in version 4.01 and above, you should use findfirst instead of find('-')...but also read the online guide about the CORRECT USE OF FINDFIRST function...

siyak

Its still very slow

Belias

i didn't ask you a very important thing...sql or native database?

iori

Use SETRANGE instead of SETFILTER.
SET DataItemTableView and DataItemLinkReference and DataItemLink ...
BTW, is there any other code in your report? I don't think it should be that slow while running so few codes...

DaveT

Hi Siyak,

Why are you not using GET instead of FIND - look to me like you are looking up the primary keys on the customer and posted document dimension tables

i.e.
if PostedDocDimension.GET(114,.","Sales Cr.Memo Header"."No.", 0, 'ACCTYPE' ) then
...

if vCust.GET(AccType."Customer No.") then
...

This may not be the only cause for the report to slow down - the links on the dataitems would need to be examined.

Hope this helps

siyak

I'm using the SQL Database.
I have these on the DataitemTableviewof Sales Cr Memo(SORTING(Sell-to Customer No.,No.) and Customer(Sorting(No.))and Customer Bank Account(SORTING(Customer No.,Code)) the DataItemLink are fine.

Belias

and how big is your database?
maybe it's "only" a complicated elaboration on a huge amount of data...

siyak

its about 2,097,152 kb.

DaveT

Hi Siyak,

Can you explain what you are trying to acheive as the design of report is very important.
For example you have a dataitem for customer and are then using a variable vCust to get customer details again :-s

Also on the dataitem link you don't seem to have (or maybe didn't post) any where clause so this would mean looping all credit notes for each customer and not just the credit notes for that customer.

siyak

On the Account Types Section body i have(Customer No. and name from Customer table and Credit Memo.No From redit memo table and Payment method,Payment type,credit Rep From Account types table) and on the Customer Bank account Body(Code,Description and Bank account no.from Customer Bank Account Table)
That is the way it looks.It works very well but its slow ](*,)