Search results for query: *

Crystal 8.5 or 11 ( I have both installed on my system) I want to know if a formula can be written to detect when the number of days between a field contaning an Intake Date and a field containing an Outcome Date is less than 4 days, but not include Sundays in that count. For example: If an...

OK - got back to report and changed it to use the Running Totals with evaluation formula - worked perfectly. Thank you. Harriet

Got called away for an urgent matter - hope to get back to this report tomorrow. I will try above suggestions. Thanks so much for your quick responses. Harriet

Crystal 8.5 My report shows people who have adopted more than one animal in a particular time period. Before suppressing certain sections, it looks like: Group: Person ID 1111 Animal ID AAAAA Animal ID BBBBB Sub Total: 2 Group: Person ID 2222 Animal ID CCCCC...

I wasn't insulted!!!! And I totally agree re performance issues. I should have told you that the estimated max. potentital amount of records being dealt with for this partictular report will likely never be more than 1000 and there will be only one person running the report. The export is...

There is no definite limit to the funds in the string. When I test using my above setup, I am indeed getting the results I desire - only those lines containing the fund I select are appearing. Harriet

My intent is to allow a user to enter the name of the fund they wish to see included on the report. I think InStr will do it. My select formula is InStr({Gf.Gf_Fund},"@Fund") > 0 The parameter @fund collects the Fund Name to be extracted from the string. I still want to play with your...

Crystal 8.5. I have fields that are strings like: CAPITAL CAMPAIGN; WILDLIFE CAMPAIGN FERAL CAMPAIGN; CAPITAL CAMPAIGN In other words, a list separated by semi colons. Is there a formula I can use to find strings that contain certain text, regardless of where it is in the string...

Brilliant! Thank you so much. Report now looks great. Harriet

Crystal ver. 8.5 I have a report in which I have one field formatted to "suppress if duplicated". My only problem with this report is that when there is a suppressed duplicate, it leaves a blank line where the duplicated value would have shown. Is there anyway to eliminate that blank line...

The database is created by a software called "Chameleon", where we enter all of our animal information. (We are a Humane Society/Shelter). I cannot do any processing within the database. Chameleon uses runtime of Crystal to distribute reports. I write the reports which are then picked up via an...

Sorry, I did mean connectivity = ODBC. All of the data I require is in one database,linking two tables. Because one set of criteria is based on the date an animal arrived (i.e. all intakes for a calendar year) (main report), and the other the day an animal left (i.e. all outcomes for a...

Crystal 8.5 ODBC Database Both Main and Subreport are Cross Tabs. My main report counts animal ID's based on one set of critera. The subreports counts animal ID's based on a different set of criteria. The rows and columns are the same for both cross tabs, with the rows being months of the year...

I just want to say a big thank you to both the person who posted this question and the expert who answered it. I had no idea I could do this and it is a wonderful thing! I actually just used the formula to conditionally suppress a field in a cross tab report and it worked like a charm! Thanks...

Thanks again for all the suggestions. I finally decided to rewrite the report using formula structures I better understood and avoided using variables. It works fine and is no longer a problem on the Adagio systems. Just for interest, I have contacted the Adagio tech folks for their take on...

Thanks for all the suggestions, tried them but no change. I did copy the error message correctly, except I see there is a ? where the message actually shows a thick vertical line. I did not write this formula, and I am not yet up to speed on variables, so I don't quite understand the purpose of...

Crystal 8.5 I have a report that works on all but 3 systems. Those 3 systems have one thing in common: they all have Adagio software installed. The error message is: Error in formula <Variance Value>. 'numberVar Var =?' A variable name is expected here. The formula it is referring to is...

Aha, so I use 00,00,00 as midnight (not 24, 00, 00). Your suggested formula did the trick, Thanks! Harriet

Crystal 8.5 I need to divide a report into 3 military time segments: 08:00:01 to 16:00:00 (8 am to 4 pm shift) 16:00:01 to 24:00:00 (4 pm to midnight shift) 24:00:01 to 08:00:00 (midnight to 8 am shift) Crystal does not allow me to enter anything past hour 23. Can I do this split on...

Crystal 8.5 I have a report that uses a formula called "Variance Value". numberVar Var := if {animal.animal_type} in "CAT" and {animal.sex} in "F" then {@Variance #} * 62.38 else if {animal.animal_type} in "DOG" and {animal.sex} in "F" then {@Variance #} * 90.74 else if {animal.animal_type}...