Search results for query: *

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)

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

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

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

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)

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

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

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

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)

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

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

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

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)

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

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)

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)

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

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

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

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)