Recent content by GCL2007

Thanks - My mistake - the field actually read Process Eng. -PL1 I didn't notice the - at first. Your formula properly reported everything to the left of the - It was a data issue.. My apologies and thanks again

Actually I am stil having an issue. I have a record where it is Process Eng. PL1 and it is pulling up in the formula as Process Eng . Would like for it to come up blank because of no - . Can you help? Thanks!!!!

Thanks again Pete. At first review, looks great.. Now I get to present this to my users... Thanks!!!!

Thanks Pete - Fantastic job as always.. The only thing I noticed in ym brief check is that if the building code is missing (no -) it is printing the whole string. If there is no - , I'd like it to leave the field blank... Thank you!!!

Hello, I have a request to extract building code from a string. The problem is they want everything to the left of the last - in the string. For example, the field could be Bu1-Bu2-Supervisor Shipping or it could just be Bu1-Welder or it can be completely blank. I guess I want to extract...

Yes - my data wasn't as clean as I hoped... Perfect!! Thank you Again!

Thanks Pete.. I'm getting A subscript must be between 1 and the size of the array . Any thoughts?

I have a field that is typically populated in the format 12345-67-890 or something similar to that. There are two - characters, however the number of characters can vary. If I wanted to just get everything after that 2nd - . In the above I would want to report 890, what would be the best way...

Thanks - I ended up creating a command table and used the SomeField < AnotherField + 1 approach. I'm happy to see you agreed with what I did... Seems to work fine.. Thanks!

Hi - Wondering if anyone has ideas. I'm trying to create a report that reports Transaction records that I want to group into Fiscal Periods. I have a Periods table with Start and End Dates for the Period. I am just trying to report transactions by Period (for example, March 29 to April 25)...

Thank you Pete - I think that will work for me.. Thanks!!!!!

Hello, I am trying to create a report for check writing. The request was to format the amount value like this: ************$123.44 with the leading *s and a $ immediately preceding the field value(which is 123.44) I would like the total field to be a fixed size, so if the value was larger, I...

I have a SQL Server 2008R2 database that we use as a date warehouse. It is large, data file is 42 GB, but the Trans log file is 80 GB and growing. It is a Simple database with Maintenance Plan backups every night. Much of the data gets loaded in from our ERP system. I don't understand seeing...

Hi - I'm using Crystal 2016. We have Oracle database and my users have input a folder location stored in a BLOB field (\\server\folder\folder1) in one of the tables of my database.. I had a hard time getting it to display but finally did using a SQL Expression formula...

AS always, Thanks LB!!!