Search results for query: *

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

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

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

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

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

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

Crystal 11 I have been looking for a way to view only those records that have 2 or more of the same docket number. I tried using the following from reviewing some of the posts on this with no sucess. If there is 3 of the same docket number then I need to see all three records. I put the...

Using Crystal Reports 11. Using the following fields: {cpmain.recedate} {cpmain.totjdgpaid} I want to total the count of records by year for those records that have a zero balance and for those greater than zero. This would involve only the cpmain.totjdpaid field. I can get a count of...

I need help in having the report automatically select the information based only on each Wednesday for the current week (Monday - Friday). Currently I have a Date parameter that is used to select each Wednesday. It would be easier than selecting a date each time the report is ran. In the...

CRXI - I have a text field. I only want to display when the value is = or greater than the following: 08CV158506 or 08TX005798. I can get it to work for one, but not both. This works - if {cpmain.docketnbr} >= "08CV158506" then false else true This does not - if {cpmain.docketnbr} >=...

CRXI - Is it possible to have 1 value within a group return records based on a different date range. The data that is returned then adds the fees and subtracts what has been paid and shows a balance for all of the records returned (I already have this forumula done and working). Sum...

CRXI - DATE FIELD {cpmain.disbursdt} in group header. Report uses a Detail-Summary parameter value. When selected I can get the group to display all of the records along with the dates. Example: 12-01-08 details here 12-05-08 details here What I want to do is when the user selects...

CRXI - I have been trying to create a formula to do the following. I want the formula to look at a number in a field and then times it by 365, then divide it by the current date. There is a number associated with each day of the year. ie: 01-01-2008 = 1, 01-02-2008 = 2 and so on. I just do...

I need a little help with my formuala's. CRXI The field being evaluated is non-numeric. My goal is to calulate a numeric amount from that field. If amount is up to $5,000.00 then $25.00 If amount is between 5,001.00 to $25,000.00 then "$105.00" If amount is between 25,001.00 to $50,000.00 then...

CRXI - I have created a text box with background text. In with the background text are a few date values. In one (1) of the values I have been trying to have it display text if the field is left empty. This will remind them to put the date in the field. The field is a date field. I have...

I have a formula that I use on a report. I want to be able to view the data on the screen but suppress it when the report is printed. I have tried several things under suppress and have read through all of the forums but have not seen anything like this. Any help would be greatly appreciated...

I'm tyring to write a formula to calulate a percentage. I have had some sucess but it is not correct. I 1st haved added the following in a formula called poundage (see below). I then took and created a new formula called "1.5" - In this forumla is "1.5 * @Poundage" This results in the correct...

We enter currency amounts in a table based on a code (sys_trac.actioncode). I can get all of the code and amounts in a report as follows: actioncode trackamt SFPP $50.00 SFX $1,170.00 SFM $1.50 SFAD $40.00 SFOA $9.00 What I have been trying (without...

Using CRXI - I want to try and set up a conditional expression to suppress a field if a parameter field is filled in. If the parameter field is empty I want to show the field. Reason: Normal fields lengths are about 30 characters, most of the reports (70%) we are able to use the regular...