Print Page | Close Window

Quick question about data checking...

Printed From: Crystal Reports Book
Category: General Information
Forum Name: Announcements
Forum Discription: Please check this section for the latest announcements from Crystal Reports Forum
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=5840
Printed Date: 06 May 2024 at 1:26pm


Topic: Quick question about data checking...
Posted By: andrew
Subject: Quick question about data checking...
Date 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!


Replies:
Posted By: andrew
Date 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.

Posted By: hilfy
Date Posted: 06 Apr 2009 at 12:23pm

I can't move it, can you repost?

Thanks!
 
-Dell


-------------
Proviti, Data & Analytics Practice
http://www.protiviti.com/US-en/data-management-advanced-analytics - www.protiviti.com/US-en/data-management-advanced-analytics


Print Page | Close Window