Search results for query: *

Thanks Geates... I removed the error resume and stumbled my way through it...I ended up with 3 sub functions.

Bear with me if I'm not making any sence I'm really new at this. I have never really had to do something so involved. This was my first attempt ... I really want a checker to find the latest file in that folder based on date it has to be latest date so the latest date could be today or...

I have several scripts that do somewhat that but not quite I have the read all but I think I need some kind of IF statement that says look for these words... 1. logged on user profile because file will be in the user profile C:\Users\USERNAME\AppData\Local\LOGFOLDERHASMANYFILES 2. In this folder...

I have Crystal version 10. I am trying to summarize to get a percentage but I am unable because each formula that I have created ends up doing the same thing. Once I do get the value I want in the group footer and then try to add it it says that I can not summarize field. I currently have 4...

Yes

I have version 10. I can add a command with the SLQ statements.

Thanks for your reply, I did start doing that initially and it works. However because there are more orders than there are employees I want the preview to show the employee's name first so then I can drill to the detail and see the first visit for that WO. My main objective is to show Employee...

Hi - I have a crystal report where I am trying to count in a Work Order grouped by Employee. I am able to count and get a percent per order but now I want my main group to be by employee visits per work order. The problem is that when I group it by employee it breaks my calculation because I...

If all you are looking for is to convert your DATE/TIME to DATE in order to make it a parameter you can do it as follows: In FORMULA FIELDS create a date formula date(DateTimeField) Then you can create your parameter out of this new field and it will only promt you for the date and not the...

Thanks for the tip looks like UFL does the same conversion as TZ.

I am using this formula in Crystal 10 under SQL Expression fields. So it is being ran in Crystal against the DB.

I don't have version 8.5, I have version 10 but will it allow you to do an INSERT, PICTURE, and then once the picture is there right click on the picture and select MOVE, BACK. Version 10 allows this. hope this helps! *:-)

Hi, I would like to know if there is a way to use this expression only after the records have been extracted from the database in crystal...I have this SQL Expression formula and want to only calculate it once it is in Crystal not while reading the records. *************FORMULA***************...

I have a report that gives me e.g. 230 records. Of those records there are a total of 200 distinct records if I do a distinct count of them. Within these records I have a date/time value for some of these records most have one date/time stamp but some have a date/time that are different from...

I have a crystal report grouped by address and showing the distinct count date. I'm looking to validate that date and only have it show me any specific addresses and dates where the dates are 7 days appart from each other. Any address that has dates less than that I don't care about. For...

Hi does anybody know if there is a formula that can be created to only display the value of a field that ends in a particular character for example: If I have a list of numbers. 51234 22366 39385 69875 51864 59857 To only display all the fields that contain information that ends with 5 for...