Search results for query: *

I'm using Crystal9 with Oracle Server. I'm having trouble extracting substrings from a string that is a result of a variable formula. I have two numbers that are being used and converted to text, the timekey (x) and the number recorded with that key (n). I'm using this approach because I need...

Hi - I have CR9 with Oracle. Trying to do a month version of the following formula example that calculates the number of days between the order date and ship date, excluding Saturdays and Sundays: Local DateTimeVar d1 := {Orders.Order Date}; Local DateTimeVar d2 := {Orders.Ship Date}; DateDiff...

Greetings - using CR9 with Oracle8 Server. the last 2 or 3 detail items in a subreport at the bottom of the page seem to want to repeat at the top of the next page. I've tried combos of "keep object together" and "keep group together" to no avail. "keep group together" is not a good option as...

Using Crystal 9 with Oracle. I am using variables to capture names that are associated with a gift record. The string result can have multiple values or the same value repeated. What I need is for the value to show once in the string result. In the group header I have the reset formula, the...

Using CR vers 9.2.2.693 I have the following formula: WhilePrintingRecords; StringVar last3actscom; last3actscom := last3actscom+"|"+ {V_ACTIONS_MM.ACTCOMM} The problem is that the field {V_ACTIONS_MM.ACTCOMM} can be very many characters long which would make the string variable over the...

How do I capture a value in the main report so that I can compare it to values in a subreport? For instance, one name type (lets call it NT1) has a Full Name value of Mr. and Mrs. John Smith. This is the value that is in the main report page header. I then have next on my subreport: Name Type...

I'm using Crystal Reports 9.2 with an Oracle database. I need help to display unique values for a first name field of diffent name types. (For expample, Preferred Name, recognition Name, Spouse name, etc.) I'm creating a subreport that lists first names only but I don't want the names to repeat...

Is there a way to combine an x,y chart with a pivot table, to drill down? I know that the x,y chart (scatter) is not an option to use with pivot tables. What I need is to be able to click on a coordinate in the x,y chart and see the individuals who have that x,y value. For instance x,y value...

I have a question about multiple group behavior. I have two groups, Boards and Jobs. I need to show all active jobs and all boards for each individual. The outcome for someone who has 2 boards and 3 jobs is: Board1 Job1 Job2 Job3 Board2 Job1 Job2 Job3 I need to have no more...

I need to show all group titles on a report in specified order regardless of whether there are records or not. Each group is showing a running total (count) of that category and I need to show a zero for a category with no records. Without resorting to a rigid format, is there a way this can...