Re: RE : [Axapta-Knowledge-Village] Slow Performance of Report

Mon, 03 Jan 2005 07:17:57 -0800

Well Steve i thanks a lot for your advice well the problem is that View Only supports a downward hierarchy with each only at one level.
 just like
----- I level
     -------II level
             ---------III level
                     --------------- IV level
 
And so i have to draw some relations on to database which is like below
----- I level
        --------II level
        ---------III level
       --------- IV level
 
I hope that you must have understood my problem than that is not possible in View.
And if you have some workaround then please share the same.
 
Any way happy new year 2005
 
Can contact me at [EMAIL PROTECTED]
Waiting for your mail.
com> wrote:
Check that you have the right index when accessing your tables.  If you can, create a view that will regroup all the info you need instead of accessing them individually from the fetch, something it's faster with a view.

Steeve...


-----Message d'origine-----
De : compashi [mailto:[EMAIL PROTECTED]
Envoyé : 28 décembre 2004 09:46
À : Axapta-Knowledge-Village@yahoogroups.com
Objet : [Axapta-Knowledge-Village] Slow Performance of Report



Hi Everbody,

Well friends i have designed a report on SubLedger transaction. For
that i have to take field from many tables viz.
VendTrans,AssetTrans,BankAccountTrans,CustTrans,Ledgertable and not
mention Ledgerttrans also. now i have inserted my desire dataset on a
temp table which i have created.
But mine problem is that when report is executed it takes a lot of
time.
I have all populated all the data on to the fetch method.

Please tell me if there is any optimization techinque in terms of
Coding or the deployment which can speed my report execution and
whether this temp table strategy is the right one to be followed when
data is to be extracted from many tables and many relation have to be
implemented.
Ultimately report is to deployed in 3-tier architecture.

any suggestion is welcomed .

Have a nice day to all Axapta Community members and advance wishes
for New Year .






Sharing the knowledge on Axapta.
Yahoo! Groups Links









Sharing the knowledge on Axapta.

__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com

Sharing the knowledge on Axapta.


Yahoo! Groups Links

Reply via email to