Print Page | Close Window

Help Crystal Report on HP service manager

Printed From: Crystal Reports Book
Category: Crystal Reports for Visual Studio 2005 and Newer
Forum Name: Writing Code
Forum Discription: .NET programming API, report integration
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=17780
Printed Date: 03 May 2025 at 2:28pm


Topic: Help Crystal Report on HP service manager
Posted By: NEO_X
Subject: Help Crystal Report on HP service manager
Date Posted: 16 Oct 2012 at 7:02pm
Hi all
I have problem with report on my system, I can't code formula to count number of Incident.
This is my Formula:

   if left (totext({ACTIVITYM1.DESCRIPTION}),35) = "Incident Status Change to Completed" then 1 else 0

but some records more than 1 desciption="Incident Status Change to Completed" -> count fail

plz help me resolve
thanks all


-------------
NEOLEO


Replies:
Posted By: NEO_X
Date Posted: 16 Oct 2012 at 10:27pm
everyone
plz help me!!!!!

-------------
NEOLEO

Posted By: hilfy
Date Posted: 17 Oct 2012 at 6:38am
Neo_X,
 
Most of the folks who answer questions here are in the US. ALL of us are volunteers who answer questions when we have time.  Like any other all-volunteer forum, you cannot expect immediate answers.
 
Here's what I would try.  Change your formula to something like this (use the correct field name....)
 
if left (totext({ACTIVITYM1.DESCRIPTION}),35) = "Incident Status Change to Completed" then {ACTIVITYM1.INCIDENT_ID}
 
Then, instead of doing a sum, do a distinct count on the Incident_ID to get the number you're looking for.
 
-Dell


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

Posted By: NEO_X
Date Posted: 22 Oct 2012 at 12:46am
Thank for help Hilfy
but your solution still error, because if that formula false -> else "". then "distinctcount" error
now i have idea, is create subreport but i don't know how to add "record selection" to rationalize
plz help me
thanks


-------------
NEOLEO

Posted By: hilfy
Date Posted: 22 Oct 2012 at 3:24am
If you don't put an Else on the if statement, the else is null, which should not be counted.
 
-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