Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Report Design
Message Icon Topic: Limit printing of group based on summary of detail Post Reply Post New Topic
Author Message
kmont
Newbie
Newbie


Joined: 15 Oct 2012
Online Status: Offline
Posts: 1
Quote kmont Replybullet Topic: Limit printing of group based on summary of detail
     Posted: 15 Oct 2012 at 6:03am

I hope this is a simple request. I'm building a payroll report that summarizes by employee the pay amount by Pay Date (entered by Parameter) and  Month and Year. The end user would like to exclude from the report any employees who have 0 in the Pay Date column but non 0 in the other two columns. I have accomplished this by building a subreport to pull in the Month and Year values, but it takes a long time to print. Is there any easier way to exclude them? I should mention that simply suppressing the values where the employee Pay Date total is 0 will not work. They need to be included in the other totals on the report (employee location, grand total) and suppressing doesn't exclude them from totaling.

 Thanks for any help you can offer. 
IP IP Logged
lockwelle
Moderator
Moderator


Joined: 21 Dec 2007
Online Status: Offline
Posts: 4374
Quote lockwelle Replybullet Posted: 15 Oct 2012 at 2:00pm
Sorry, I'm confused.
 
You correctly state that suppressing doesn't exclude them from the other totals, and that they should be in the other totals...so why can't you suppress.
 
The reason that the report runs slowly is that every time a subreport is called, CR opens a new connection the database and pulls the data back out.  So a report with 100 employees will hit the database 101 times, which can be significant if there is alot of traffic on the network, the database server, or alot of data is being queried for the subreport.
IP IP Logged
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum