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

    Add decimal to number string

    New to JS and appreciate the help on this forum! Have numbers as stings whereby the last 2 numbers were understood as the decimal. This needs to change. Would like help on how to do this. String = 123456 Need = 1234.56 FireGeek (currently using Crystal Reports XI with Lawson 9.01)
  2. FireGeek21

    Max 2 Dates by Employee

    http://files.engineering.com/getfile.aspx?folder=5674f8a3-4ff0-465a-9292-c0793151b8dc&file=SQL_Issue_Image2.pdf
  3. FireGeek21

    Max 2 Dates by Employee

    Thank you for your assistance George. See the attached image as to what I am seeing now. Lots of Nulls. Need to get rid of those. I did add at the end a Where A.CHECK_DATE <> NULL but that put be back to where I was originally. FireGeek (currently using Crystal Reports XI with Lawson...
  4. FireGeek21

    Max 2 Dates by Employee

    I need the max 2 check dates for each employee. I was using a temp table for the most recent check date but now I need the check just before it but keep getting ALL checks before the max check. Here is my code: SELECT PAY.COMPANY as tCO, PAY.EMPLOYEE as tEE, MAX(PAY.CHECK_DATE) as tCHKDT...
  5. FireGeek21

    Return the Top 2 Records of a Group

    I need to return the top 2 historical records of a group. Group is by Employee. Each employee may have a different number of records. Need the most recent 2 by date. Thoughts??? FireGeek (currently using Crystal Reports XI with Lawson 9.01)
  6. FireGeek21

    Date ranges

    OR the record select formula should look like: {table.OrderDate} in {@disparamDateRangeFrom} to {@disparamDateRangeTo} FireGeek (currently using Crystal Reports XI with Lawson 9.01)
  7. FireGeek21

    Decimal Number

    THANK YOU BETTYJ!!! The link provided some great information for what I needed to do. I ended up moifying it and now I have a solution that is working!!! What the link didn't use that I ended up using was WhilePrintingRecords. There must be something going on with the order of processing...
  8. FireGeek21

    Decimal Number

    Skip, It's not difficult... I have a number I need to convert to a text field so I can pad with spaces at the end. This is a file specification I did not write. PROBLEM: My number is rounding and I DO NOT WANT IT TO ROUND BEFORE I CONVERT IT TO TEXT USING ToText FUNCTION AND THEN PAD WITH...
  9. FireGeek21

    Decimal Number

    OK - so, how do you pad spaces at the end of it so I get "0.8750 " ?? FireGeek (currently using Crystal Reports XI with Lawson 9.01)
  10. FireGeek21

    Decimal Number

    @Skip, I know about rounding rules. I DO NOT want it to round and it is rounding. - The actual data is 0.875 - Put field directly into the report and it shows 0.88 - My formula is showing 0.8800 *** I want to see 0.8750. I DO NOT ROUNDING. The Truncate([field], 4) is NOT working. I can't...
  11. FireGeek21

    Decimal Number

    Hi Skip, I have a FTE field that goes up to 4 decimal places. So, I have values of 1.0, .5, .75, .875, .5678. When I put this field in a report, the data with > 2 decimal places actually rounds - no formula, it rounds. If I format the field to 4 decimal places, it displays properly. So, I...
  12. FireGeek21

    Decimal Number

    As stated above, I have tried Truncate([field], 4). No success. FireGeek (currently using Crystal Reports XI with Lawson 9.01)
  13. FireGeek21

    Decimal Number

    This number field is actually part of another formula that has to display as a text. I can't use the formating option you suggest and as I previously mentioned, Truncate doesn't work. FireGeek (currently using Crystal Reports XI with Lawson 9.01)
  14. FireGeek21

    Decimal Number

    Hi, I need a formula that will force a number field not to round. It seems because of settings in File -> Options -> Fields tab -> Number -> Number tab my formula field is rounding to 2 decimal places. I need the full 4 decimal number to show. Cavaet is that this ends up displaying in a TEXT...
  15. FireGeek21

    IF Statement

    Awesome! It works. Switched out the ? for $ - typo I think. Added the == and echo and ;. Now on to the next problem, a list of 2 columns because this one is too long. :) Thanks again for everyone's help! FireGeek (currently using Crystal Reports XI with Lawson 9.01)
  16. FireGeek21

    IF Statement

    Chris, if ?row is the wrong syntax for PHP, what is the correct way of doing it? Feherke, thanks for your response. I will try the equality ( == ) and get back this evening. FireGeek FireGeek (currently using Crystal Reports XI with Lawson 9.01)
  17. FireGeek21

    IF Statement

    If I take out the IF statement that is not working, I do get a list of medications in mysql database as links to .pdf files. I am trying to add a red or blue circle .png image after each medication name based on a "level" entered in the [level] field in mysql database. Thanks for looking Chris...
  18. FireGeek21

    IF Statement

    Row is for accessing the data in a mysql database. The inside IF statement is not working. <?php if ((?row['level'])="CCMedic") { '<div><a><img src="/includes/images/red.png" alt=""></a></div>' } elseif ((?row['level'])="Medic") { '<div><a><img...
  19. FireGeek21

    IF Statement

    HI, Beginner here... I may have some syntax off a bit. Looking for some help here. I am adding a colored circle depending on the "level" in a database. The code before this connects to the database. Everything worked fine until I added the "IF" statement for the colored circles. Where...
  20. FireGeek21

    YTD Average by Week

    Running totals can't be used in a cross tab though. I need the weeks to display across. Thoughts? FireGeek (currently using Crystal Reports XI with Lawson 9.01)

Part and Inventory Search

Back
Top