Announcements
 Crystal Reports Forum : General Information : Announcements
Message Icon Topic: Quick question about data checking... Post Reply Post New Topic
Author Message
andrew
Newbie
Newbie
Avatar

Joined: 11 Nov 2008
Location: United Kingdom
Online Status: Offline
Posts: 35
Quote andrew Replybullet Topic: Quick question about data checking...
    Posted: 20 Mar 2009 at 9:23am
Hi All,

I'm not sure if this is actually possible within the scope of crystal reports but i'll ask anyway...

I'm writing a report that shows our engineer call outs and revenue earned....

so:

Engineer A - Job 1 - $100

Engineer B - Job 2 - $200

Which runs fine... but, sometimes they double up on jobs and thus it needs to show in the report, otherwise the financial figures are wrong.

So:

Job 3 = $100

Currently comes up as:

Engineer A - Job 3 - $100

Engineer B - Job 3 - $100

Revenue = $200


Desired:

Engineer A - Job 3 - $50

Engineer b - Job 3 - $50

Revenue - $100


------------
Is this possible to achieve within Crystal reports without any database alterations (as in having a formula run within while report is printing)?

Many thanks in advance!
IP IP Logged
andrew
Newbie
Newbie
Avatar

Joined: 11 Nov 2008
Location: United Kingdom
Online Status: Offline
Posts: 35
Quote andrew Replybullet Posted: 06 Apr 2009 at 6:49am
I hate to post bump but....
 
Does anyone know if the above issue is even possible? i've been looking all over the net since I last posted this - and I still cant find out a way to sort this via crystal reports.
 
Also i've just noticed i've posted this originally to the wrong forum! (announcements instead of data connectivity), would one of the moderators mind moving this to the right area? Failing that I dont mind reposting and deleting this thread.


Edited by andrew - 06 Apr 2009 at 7:38am
IP IP Logged
hilfy
Admin Group
Admin Group
Avatar

Joined: 20 Nov 2006
Online Status: Offline
Posts: 3702
Quote hilfy Replybullet Posted: 06 Apr 2009 at 12:23pm

I can't move it, can you repost?

Thanks!
 
-Dell
IP IP Logged
Post Reply Post New Topic
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



This page was generated in 0.047 seconds.