Okay - I think I figured out what was wrong. The calculated days should be a SUM and I believe it's only pulling the last field in the report in.
That being said. I fixed my formula so that I am now calculating correctly.
datevalue({EMPLOYEE_1.New_Rehire_date})-sum({@Calc_Days})
WooHoo...
The {EMPLOYEE_1.New.Rehire_Date} is a date field.
I validated my formula in Excel for example:
Rehire Date 7/19/2011 - Days previously Worked of 320
should give me a returned date of 9/2/2010
instead I am getting a date of 02/19/2011 which isn't even close
I am trying to calculate a date in Crystal. What need to do is calculate number of days previously worked and minus from their rehire date calculate a combined length of service date.
My calculation is working properly but I can't get the date to calculate correctly.
Here is my formula...
I am new to SQL and I'm having a hard time with getting the right results from my subquery.
I am reporting off of three tables, Vendors, Invoices and Line Items and I am trying to get the results for each invoice that has more than one line item in the InoviceLines Table.
Here is my code so...
Hi Everyone,
Is there a way to limit the types of characters in a user input box (not a text box).
I have a text box that I use for capturing social security numbers and have a key press event set up so that they can only enter numbers. However, if they enter less than 9 characters or skip...
Try opening the file in PDF and they copying the text directly from the pdf file (you should have a flashing cursor and should be able to highlight and copy your text). Then just paste it into your word document.
This also works if you need to put it into excel and then use your text to...
Hi Everyone,
I've just started working with arrays and I can't seem to get it to work properly. The first item saves just find but my array keeps overwritting itself. Any suggestions?
-----------------------
'Declare Arrays A_{Array Name}
Private A_EE_NBR(0) As Integer
Private...
Yes it did! Thank you so much! Is there a really good reference book out there that you can recommend? I've looked at a couple of them but I'm not sure which one to get.
Thanks again and have a great day!
Jewel
Hi Everyone,
I have a program that I need to convert a dollar amount to Euros. I've done the background calculations computing from dollars to euros. I can get the proper amounts to show up in my listbox items but I'm having a hard time figuring out how to swap the decimals and the commas...
So it's not a ratio of one to one i.e.; one border text box assigned to one memotype dbaseField? Are the multiple border text boxes being used as dividing lines that need to grow?
Okay if I understand correctly, You have database field we will call dbaseField and a text box that you use to as a left border to that dbaseField.
In design mode, drag your dbasefield into your blank text box, the field will then show up as {dbaseField Name} in your text box.
Go into your...
Is it a textbox, a label or both? Is your line spacing set to multiple? Do you have your can grow selected with 0 (for unlimited). Or is is that you want the last line of text to be underlined and that needs to vary depending on length?
Is this being pulled from a database or do you allow a...
Hi Everyone,
I am new to VB and need help with a project. I have a user-interface that has a list box with employee's names added to it (Debbie, John, Jim, etc) which are defined as strings. On my form, there is a select single name button and select multiple name button. There is also...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.