dbTalk Databases Forums  

Reports, very slow to open

comp.databases.ms-access comp.databases.ms-access


Discuss Reports, very slow to open in the comp.databases.ms-access forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Jake Abella
 
Posts: n/a

Default Reports, very slow to open - 03-12-2010 , 06:54 PM






I had an existing report but very slow to open. This is a payroll
program. Here's what I did.
On this report will display all the employees by branch. Then on each
employees, I made two sub reports contains their earnings on the left
side and deductions on the right side. It runs without problem but
very slow. And I found out that the two sub reports was the problem.
But I don't know to do in order for me to display the earnings and
deductions on the details of each employees.

Can some help me on this?

Reply With Quote
  #2  
Old   
Roger
 
Posts: n/a

Default Re: Reports, very slow to open - 03-12-2010 , 08:41 PM






On Mar 12, 5:54*pm, Jake Abella <jake.abe... (AT) gmail (DOT) com> wrote:
Quote:
I had an existing report but very slow to open. This is a payroll
program. Here's what I did.
On this report will display all the employees by branch. Then on each
employees, I made two sub reports contains their earnings on the left
side and deductions on the right side. It runs without problem but
very slow. And I found out that the two sub reports was the problem.
But I don't know to do in order for me to display the earnings and
deductions on the details of each employees.

Can some help me on this?
can you use groupings to define a branch group and an employee group
and use the detail section for 'earnings / deductions' ?

I assume none of queries involved with the report are slow ?

Reply With Quote
  #3  
Old   
Jake Abella
 
Posts: n/a

Default Re: Reports, very slow to open - 03-14-2010 , 01:13 AM



On Mar 13, 10:41*am, Roger <lesperan... (AT) natpro (DOT) com> wrote:
Quote:
On Mar 12, 5:54*pm, Jake *Abella <jake.abe... (AT) gmail (DOT) com> wrote:

I had an existing report but very slow to open. This is a payroll
program. Here's what I did.
On this report will display all the employees by branch. Then on each
employees, I made two sub reports contains their earnings on the left
side and deductions on the right side. It runs without problem but
very slow. And I found out that the two sub reports was the problem.
But I don't know to do in order for me to display the earnings and
deductions on the details of each employees.

Can some help me on this?

can you use groupings to define a branch group and an employee group
and use the detail section for 'earnings / deductions' ?

I assume none of queries involved with the report are slow ?
I did group my employees by branch, I open the report by selecting a
branch and the paydate first.

My earnings and deductions were on the same table, And I just don't
know to populate late these on the details report. Like I've said I
want these earnings on the left side and deductions to the rights side
group together. Do you know any ideas?

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.