Search results for query: *

Thanks "LBass", with your recommendations I was able to track down the culprit even though it took me about a day to do so. It was a custom value that was temporarily created and then removed from the database by the software provider. Even though the field was removed it still remained on...

Thanks and I will give this a try tomorrow. It makes sense and will give me a place to start.

I have used Crystal reports for over 15 years to make forms and reports. We are currently using CRX 11 on windows 7. Version 11.0.0.2495. I have a report that is more of a form. It has worked well for the past 4 years and now one of the formulas within the report has a problem where it...

After some testing I figured it out. I had to combine the the date and time fields and then use them in a formula that I put in the select criteria. datetime(date({CAS_Action.ReceivedDate}),time({CAS_Action.ReceivedTime})) {@DateTimeCombo} >...

CRXI - It has been awhile since I had to write a formula. I have been trying to get the data to pull records for the following time frame. Since this is done on a daily basis I have tried to use Today -1 to Today but have not been able to include the time frame. I have tried several time...

Thanks - I will also try this approach and see what results I come up with. These are ideas I never would have thought of without the help of others. Not only does this help solve my problem but is also a learning experience. Thanks again.

Also a good point. Unless the user is limited in their input the chance of errors is going to be present. Thanks.

Thanks Betty. It saves me time in finishing this.

Thanks, that is a good point. Something I did not think about. I assume I would use the same formula with different spelling variations? if ("WEAPON") in uppercase({CAS_ActionEntity.ActionEntityNote}) then "W" or if ("WAEPON") in uppercase({CAS_ActionEntity.ActionEntityNote}) then "W" or...

Thanks. That did work after I changed the brackets. Thanks.

Windows7: Version: CRXI / Experienced user but has been awhile since I have worked on reports. I have been trying to create a formula that would search a memo field for part of a word "weapon" and then return a value of "W". The word "WEAPON" may be entered in either uppercase or lowercase in...

CRXI - I created a formula (1) to compare a (selling date {cpmain.courtdate}) with the current date. If the selling date was before the current date a formula of (1.5 before sales) was applied. If equal to or after the selling date an (after sale poundage) was applied. Number 1 works great...

Thanks for the help. It took me a little longer to figure out as I have not worked with the tabs before. It works well. Thanks again.

That will work. I believe you are correct. It will be easier to just create a different text field. This is probably what I will end of doing. Thanks.

I have been trying to do the following in the display string: take Balance to Plaintiff - $1,000.00 and display it as: Balance to Plaintiff: $1,000.00 I want to show the first part on the far left (left justify) and the balance on the far right (right justify)of the display...

Thanks so much. It took me a few minutes to get this but once I did it worked perfectly. Thank you very much. Bill

CRXI – Technical user. Not sure if this can be done by a Crystal Formula or if it has to be done by sql statement. I have three (3) tables – cpmain \ sys_recp \ sys_trac (tables are linked) I need a total by month and based on the same date range for two of the tables: sys_recp \ sys_trac...

Thanks, that's works great. Much appreciated.

Thanks for the quick response. I created the 1st formula and will put it in the report header. The formula has a problem with the "year" part as I do not have a field named "year". whileprintingrecords; shared numbervar firstyear := distinctcount({cpmain.courtdate},{year}, "annually"); If...

Using CRXI. I have a good working knowledge of Crystal. I can get this correct in Excel but have trouble with the formula in Crystal. I grouped a date field {cpmain.courtdate} by year. I then inserted a summary in group section next to the year (count of cpmain.courtdate). This gave me the...