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!

Register Log in
  • Congratulations derfloh 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: *

  1. fcullari

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

    I put a portion of the table below I need to get data from limittypesequence 2 value1, fractionvalue1, value2, fractionvalue2 and if limittypesequence = 4 value1 and fractionvalue1. If I open the condition to limittypesequence 2 and 4 I get duplicate tests and the columns do not line up. I'm...
  2. fcullari

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

    There are separate data values for limitsequence 2 value 1 or fractionvalue1(Lower Spec Value) and another set for limitsequesnce 4 value 1 or fractionvalue (midpoint), your suggestions would only show 1 value.
  3. 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...
  4. 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?
  5. fcullari

    4 selection fields which may have Null data

    How do I put in a blank when I do not require the parameter, but want the rest of the conditions to run in the report? After coding like stated above, how do I allow blank as an option?
  6. 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...
  7. fcullari

    Sorting on a string field

    Thanks synapevampire, If you do come across your article with alternatives to bubble sorting, Please send it to me. I appreciate the example you sent me and I will try and use it
  8. 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
  9. fcullari

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

    Can someone help me on this one?
  10. fcullari

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

    It's a simple formula {datFieldUser.Field_Value}
  11. 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...
  12. fcullari

    First of the Month formula

    I have a data field that has a string of numbers, I want to have each number list separately, and be able to sort by those numbers. Example of data field: 0470,08161,08845,28845,0458,08058,41319,41329,41330,44154,44450,44454,R00600,M0458,M00600,M02600,F00458,85264,83454,83444 I want to see my...
  13. fcullari

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

    Thanks, I'm almost there now. But instead of a coded date I need to use a formula date @Transdate or a Parameter Date ?Date. What do I need to change to make that work.
  14. 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...
  15. fcullari

    Multiple formula fields

    I created all the formula's for the start and end dates, now how do I get the Calendar_name fields for break along the top with the dates. I just need Calendar_name fields for the Product Development tasks, and I need them to show from the top. Style Season Bid Pkg Approved Cost...
  16. fcullari

    Multiple formula fields

    I will try this longer version. Thanks for your help.
  17. fcullari

    Multiple formula fields

    Cross tab within the report does not solve my problem. They want a tabular report with all the tasks broken down and the start & end times under the tasks. I've never done this kind of report with Crystal before.
  18. fcullari

    Multiple formula fields

    I created a formula field for all the Calendar Names - Example: IF ISNULL ({TACalendar_1.Name})THEN 0 ELSE IF {TACalendar_1.Name} = 'FINAL COST APPVL TO FINANCE' THEN 1 ELSE 0 Because I need to breakdown the Calendar Names and then put the Start and End dates per that task. The Calendar_ID...
  19. fcullari

    Multiple formula fields

    There is a StartDate and EndDate fields. [Calendar ID] [Style] [Season] [Calendar Name] [Approved [Bid Pkg [Dev Cost] Sent] Spec] [Start [End [Start [End [Start [End Date] Date} Date] Date]...
  20. 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...

Part and Inventory Search

Back
Top