Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: fcullari
  • Content: Threads
  • Order by date
  1. fcullari

    2 table variables for same set of table fields based on one datafield

    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...
  2. fcullari

    Adding Bar Code to BO 6.54 Report

    I have a report that requires a sample # to also show as a barcode. I have the barcode font that I need but do not know how to add it to the report?
  3. fcullari

    4 selection fields which may have Null data

    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...
  4. fcullari

    Sorting on a string field

    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
  5. fcullari

    Need to be able to list strings in a Column on report

    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...
  6. fcullari

    Need to be able to select Date and changes in History Field

    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...
  7. fcullari

    Multiple formula fields

    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...
  8. fcullari

    Parsing data from One Large Field

    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...
  9. fcullari

    Hierarchal sort on Table

    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)...
  10. fcullari

    Crystal 9 Sum on Formula Field Type = Number

    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...
  11. fcullari

    Multiple Parms not working

    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...

Part and Inventory Search

Back
Top