Search results for query: *

Hello, I am using Crystal 9 and I am simply at my wits end, any help or guidance is greatly appreciated. I am trying to pull distinct values from a table as follows: record, field1, field2, field3, field4, field5, field6, field7, field8, field9 I don't care what the record is- I just need...

Hello, I am using Crystal 9 and I am simply at my wits end, any help or guidance is greatly appreciated. I am trying to pull distinct values from a table as follows: record, field1, field2, field3, field4, field5, field6, field7, field8, field9 I don't care what the record is- I just need...

it looks like I missed a scenerio... Any suggestions on how to modify the above formula(s) to handle the following scenario: 1/1-1/31 3/1 - "active" Should return 3/1 to "active" 1/1-1/31 2/1-2/28 4/1-4/30 Should return 4/1 - 4/30 The display formula appears to pull in the first date 1/1...

This worked like a charm! Thank you so much! I modified the display formula as I want to export the data for start and end date as two distinct fields, so I used the minimum start date information for one formula, and the end date for the other formula. Would it be possible to group records...

I would want to see all record lines; however, I would want a return of 3/1 to _ as the output. 1/1 to 1/31 2/1 to 2/28 3/1 to 3/31 4/1 to _ = 1/1 to _ 1/1 to 1/31 2/1 to 2/28 3/1 to 3/1 = 1/1 to 3/1 1/1 to 1/1 2/1 to 2/1 3/1 to 3/31 = 3/1 to 3/31 I've managed to cover most of the...

I need to keep the canceled status for further calculations and to show record history. I run a record selection in 4 month increments (rolling) and a record can have a cancelled status in one month, but two months later be active again. In this instace, i would want to ignore the cancel...

Greetings, Crystal 9: I am trying to develop a formula to evaluate member records based on date ranges to calculate effective dates for coverage. fields: db.member_id; db.plan_id; db.start_date; db.end_date A member id can have multiple start and end dates for each plan, but they can only...

I apologize for the confusion, thanks for the reply! I made a mistake in my example. I am dealing with items sold. They can have either "returned" status, or a "sold" status. Returned status results in a negative number, "sold" results in a positive count. Commission payments are calculated...

Thank you in advance. Crystal 9. I am trying to put together a calculation that will apply different amounts to a sum based on the range. Put another way, the first 20 items should be multiplied against x; the next 20 items should be multiplied by y; and anything beyond that should be...

I have tried that, but it ends up messing up my entire report. I just need this one sub-section to have a column, the rest of the report (all the other stuff in the detail section) must not be placed within a column. Is there a way to just to do this with one formula within an entire report...

Crystal 9... I have a total of nine variables that can populate a formula in response to a database query: The formula outputs like this: Response1 Response2 Response3 Response4 Response5 Response6 7 8 9 I need to have the output be like this: Response1 Response6 Response2...

Okay, this one is a doozie. Extra points for a work around solution: Does Crystal Report 9 (or any version) support any type of Chinese character set within the formula editor area? I am using PMingLiu font type (a Chinese character set), which can be produced in the text area of Crystal...

Simply brilliant! Thank you, thank you, thank you. May you live a long life and keep all your hair and teeth!

I need to develop a formula that will translate an English numerical date into the appropriate Spanish equivalent written out in long form. Thus, I need to turn 01/05/2005 (January 5, 2005) into "5 de enero, 2005. (enero is the Spanish word for Jan) Any suggestions on a plan of attack? Is...

Thank you for this information! Oh, and if you want to use a different color than Pale Green, you can get the color coordinates by accessing the custom color grid (by checking the "background color" box) from the drop down menu (choose "More...") Moving the cursor around will show the RBG...

I'm not sure what I was doing wrong, but this is the final formula I put together: if isnull(sum ({@IVCcount}, {@Staff})) then count ({R_MILESTONE_SUMARY.OBVERIFY_D}, {@Staff}) else Count ({R_MILESTONE_SUMARY.OBVERIFY_D}, {@Staff})-Sum ({@IVCcount}, {@Staff}) The @IVCcount formula is: if...

Thank you MJRBIM! I rechecked some of my work and figured out where I went wrong with the sum check. I just used that formula and did a sum in the group footer refrencing the formula (for some reason I previously wasn't able to choose sum from the drop down menu). Anyway, thank you all for...

Tried that, didn't work. :( I keep getting errors when I try the sum function (not to mention that Crystal reads the 1 and 0 and true/false statements and returns a value for the 0). All the variations of the sum have not worked and I usually end up with errors when I try to validate the equation.

Thank you, this seems to be improving the situation... however, I am confused by how I am to use the "CurrentFieldValue=True". I tried replacing the currentfieldvalue with my formula, but it still counts false hits.

I don't quite understand what you are suggesting. Could you clarify? Thank you.