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

    Using "OR" to select data

    Try reversing the order of these clauses: ((IsNull({AP_VEND_PMT_ACT.AP_PMT_TYPE_CD}) and ({AP_PMT_DTL_VIEW.AP_TRAN_TYPE_CD}) = "M")) OR (({AP_VEND_PMT_ACT.AP_PMT_TYPE_CD} = "D") and ({AP_PMT_DTL_VIEW.AP_TRAN_TYPE_CD} = "I")) ISNULL must be the first check that you do. Bob Suruncle
  2. BobSuruncle

    How Do I Add Column to Middle of Table

    If you're using SQL Server Management Studio, then go to Tools | Options | Designers and turn off the checkbox for "Prevent saving changes that require table re-creation" Bob Suruncle Bob Suruncle
  3. BobSuruncle

    Crystal formula for barcode display shows extra characters in date format?

    In the ToText function, make sure that you use upper case M for the month. Lower case m is for minutes. HTH Bob Suruncle Bob Suruncle
  4. BobSuruncle

    Formatting an embedded field in Crystal 2016 Support Pack 5

    I am using 2016 SP6 Should be the same behaviour. Double-click the text object to put it in edit mode. Then click the field to highlight it. Then right-click and choose formatting. Depending on the field type the dialog will be slightly different. HTH Bob Suruncle Bob Suruncle
  5. BobSuruncle

    Return value from table based on max date

    I think that you ought to be able to do this fairly simply. Create your report as usual, connecting to you Sybase db. Create a new SQL Expression. Give it a Name - MyMaxDate (SELECT Max(V.Visit_Date) FROM HEALTH_AND_SAFETY_VISIT V) In your record Selection Formula, add it to the existing...
  6. BobSuruncle

    Need formula to convert part of text records to numbers for numerical sorting

    Hi, Variables are placeholders, and can make a formula more efficient and easier to read. Variables can be named with whatever name you want. The only rules are that they must start with a letter, and may not be the same name as a built-in function. Your variable name can't be "sum", or "len"...
  7. BobSuruncle

    Need formula to convert part of text records to numbers for numerical sorting

    Yes, that seems correct. I'm unsure why you'd get a database error like this. Bob Suruncle
  8. BobSuruncle

    Need formula to convert part of text records to numbers for numerical sorting

    I don't know what would be causing this database error. I'm testing on Microsoft SQL Server using the codes that you had provided. Anyone else have any ideas? Bob Suruncle
  9. BobSuruncle

    Need formula to convert part of text records to numbers for numerical sorting

    Please modify your group so that the report is grouped on this formula. You can modify the Group so that it displays the original field as the Group Name. Bob Suruncle
  10. BobSuruncle

    Need formula to convert part of text records to numbers for numerical sorting

    The following should account for all of the values that you sent. Local StringVar p := {AR_InvoiceHistoryDetail.ItemCode} ; Local NumberVar i ; Local NumberVar L := Len(p) ; Local StringVar txt := '' ; Local StringVar nm := '' ; Local StringVar txt2 := '' ; Local NumberVar x := 0 ; Local...
  11. BobSuruncle

    Need formula to convert part of text records to numbers for numerical sorting

    Hi, It looks like you have some data that is different that what you had first described. Specifically, there are likely ItemCodes that begin with numbers. The formula that I gave you will choke on these. I also noticed that one of the examples that you gave has text, then numbers, and then...
  12. BobSuruncle

    SAP Business Objects Enterprise 14.0.11

    APOS Systems has a product called Storage Center that lets you back up your BI system, and then selectively restore content whenever you need to. Includes reports, schedules, security, universes, connections, etc., etc., etc. Bob Suruncle
  13. BobSuruncle

    Need formula to convert part of text records to numbers for numerical sorting

    You didn't mention that you'd be grouping on this, just sorting by it. I think that if you group on it, and the order comes out correctly, you're 90% of the way there. Next step would be to use Change Group and on the "Options" tab, select "Use a Formula as a Group Name" In the X2 button, just...
  14. BobSuruncle

    Cross-tab calculated Member

    There are around 20 properties, but the number of properties may change on each run. We're returning the differences between current values and previous values for these objects. For a given run of the report, 2 or 3 properties may have changed, but it's possible that 15 or 20 properties could...
  15. BobSuruncle

    Need formula to convert part of text records to numbers for numerical sorting

    OK, there may be a prettier and more efficient way of doing this, but the following should work: Local StringVar p := {'ESL_Svc_Codes_'.Item Code} ; Local NumberVar i ; Local NumberVar L := Len(p) ; Local StringVar txt := '' ; Local StringVar nm := '' ; For i := 1 to L do ( if NumericText...
  16. BobSuruncle

    Need formula to convert part of text records to numbers for numerical sorting

    Sorry, further testing on my system shows that this will only work if the Numbers are the initial part of the string. Do all of your item codes begin with the same characters, "/ES" ? (or at least do the numbers always start at location 4) If so, then you could change the formula a little and...
  17. BobSuruncle

    Need formula to convert part of text records to numbers for numerical sorting

    You could create a formula using the Val() function and then sort on that formula. e.g @MySort Val({'ESL_Svc_Codes_'.Item Code}) Bob Suruncle
  18. BobSuruncle

    Cross-tab calculated Member

    Hi all, I'm using Crystal Reports 2016. I have a report that shows the properties of objects. The data coming into the report has both the Current value of the properties and the Previous value. e.g. PropertyName, PropertyValue, HistoryType ObjectColour, Green, Current ObjectColour, Red...
  19. BobSuruncle

    Removing HTML from text field

    Rather than removing the text you could just format the field to interpret the HTML text. Right-click on the field and choose "Format Field". On the "Paragraph" tab of the Format Editor, select HTML from the "Text Interpretation" drop-down. Bob Suruncle
  20. BobSuruncle

    help calculating the time difference between two records based on a 3rd field value

    So you have a COMP/WAPPR pair? What other pairings do you have that you need to calculate time differences for? Does COMP *ALWAYS* come before WAPPR? Would there ever be a WONUM without one or the other of these statuses? Would there ever be a repeat of one of these statuses for a given WONUM...

Part and Inventory Search

Back
Top