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

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

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

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

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

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

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

Crystal 8.5 I use the following formula for a row in a cross tab report: WeekdayName(DayOfWeek({activity.new_date})) The report is run with start and end date parameters, with the intent to see which days of the week have the most actvities. This formula sits within a group that divides the...

Crystal 8.5. Sorry, this is a very basic question, but I have never been able to figure out how to change the default destination drive used when exporting. Right now, it defaults to c:\temp, and I would like it to default to c:\, no particular folder. Can that be done? Thanks, Harriet

Crystal 8.5 Data (text) for one field is received as follows jones,jim;smith,mary;potter,harry What I need is to have each name appear separately. Would it be possible to write a formula that would perhaps test for the first, then second, then third, etc, semi colon and parse out just the...

Using Crystal 8.5 I am trying to construct a formula that will show me a numeric value that represents the number of months between a specific month and current month. For example: If the month in the date field called {date_seen} is Sept. and the current month is November, the number I...

Using Crystal 8.5 When exporting from Crystal to Excel 7, an extra row appears between each row. I have tried aligning all the fields and fitting the section,and ensuring that "can grow" is not checked, but I still get the extra rows. I'm looking for any other ideas re what to look for that...

I currently run Crystal 8.5, only because one of my applications that uses Crystal for its reports (Raiser's Edge) will not work with anything above 8.5. My other database application can and should be using at least ver.9, if not ver. 11. Can I run two different versions of Crystal on the...

I would like to insert bulleted text into a crystal report. Can anyone tell me the best way to achieve this? Thanks, Harriet

Crystal 8.5. I have a report that must be transported to the end user as a tab delimited file, one tab between each field, no quotes around the text. 1) When I choose to save the report as either tab delimited text or tab delimited values, there are double quotes added around each text field...

Last week, you solved the problem for me when I had to subtract the total count of two groupnames from another groupname, by using the set of formulas at the end of this note. Is it possible to use something similar for a sum of $ amount field group total on the same report? What I want to...

Using Crystal 8.5 I have a report that groups on a "status" field, and I show a total count for each status. Example: Status # ------ ------- Active 10 Held 3 Terminated 2 Instead of a grand total that adds the above numbers, I...

I had to reinstall Crystal 8.5 Professional. I chose to have the help files installed, but they do not appear to be there. Nothing happens when I press F1 or choose from the Help drop down menu. I tried reinstalling just the Help portion, but still no Help files. Anyone have any idea what...

I am looking for the formula to use with Crystal to turn the first letter of a persons name into upper case (leading caps). Can anyone help. Thanks, Harriet Farmer Ottawa Humane Society