I have a field limittypesequence and need data from 2 and 4, I was able to figure out the calculation below for 2 separate variables but when I put it in a table I cannot get the results broken down for the same parameter id.
=If IsNull(<Fractionvalue1>)
And <Limittypesequence>=4 Then...
I have to create a crystal report that will need to filter by 4 different selections: Factory, Source Order#, Style and Color. There can be nulls in any of the selections which will need to be skipped, and they want to be able to choose multiple selections on any of the selections.
I tried...
I need to sort on a string field and have it list the fields that are separated by comma's
I have style numbers in a large string field - 0559, 0592.0560,057888, 0364, 0258
I want it to list in a column:
0258
0364
0559
0560
057888
0592
I have a string data field with numbers separated by comma's.
Example of data:
0470,08161,08845,28845,0458,08058,41319,41329,41330,44154,44450,44454,R00600,M0458,M00600,M02600,F00458,85264,83454,83444
I want to have these numbers listed in a column and sorted
expected output
0458
0470
08058...
I've been researching how to sort a query by a date within a history field.
Beginning of field -
On 03/21/06 10:08:00 AM SM made the following changes:The Value For Misc 11 was changed from to BTThe Value For Misc 13 was changed from to RETOn
04/18/06 10:08:07 AM SM made the following...
I need to breakdown fields by task type and then list the start and end dates for that task. I'm using Crystal 9 with NGC's eSPS software. We have calendars setup with tasks and I need to breakdown each task with it's start and end dates.
Task Types (TACalendar.name) - Approved Cost, Bid Pkg...
I need to parse a field to show all the groups of data in this large field. For example- all the email addresses.
<ROW><EVENT type="C">Task Is Late</EVENT><ACTION type="C">Send
Email</ACTION><PARAMS type="C"><parameters><NUMPARAMETERS>1</NUMPARAMETERS><Caption1>Days...
I have a table where I need to sort by level 1, then level 2 and 3.
Level 1 - Employee related (Parentid = 0) (Typeid = 39)
Level 2 - New Hire (Parentid = 39) Typeid = 45,46,47)
Level 3 - Bayonne, NJ (Parentid = 45) (Typeid = 48)
Level 3 - Fayetteville, NC (Parentid = 45)...
I have a crystal report where I needed to calculate the difference between when a help desk call was opened and then when it was responded to. I have been many days working on this, because I had to incorporate the Business Days and Business Hour formula's. Having done all that I have come up...
I have a report where I need multiple parameters and multiple formula's. My selection criteria is: {TASKS.HOURS} > 0 OR {TASKSACT.HOURS} > 0 and
{TASKS.RESPONS} = {?Tech } and
{TASKS.COMPLETED} >= {?FromDate} AND {TASKS.COMPLETED} <= {?ToDate} OR
({TASKSACT.COMPLETED}) >= ({?FromDate}) and...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.