Thanks for getting back to me, but no, this column is not part of a group. I need to be able to take a med rec no from January and compare that med rec no to the med rec no's in the months prior to January. I don't care if the med rec no shows up twice in January or after January I only want...
Hello!
I am working with Crystal 8.5 and in one of my reports I'm trying to compare a value in a specific column against the other values in the same column. If the value is unique then I want to shade that row otherwise I want to do nothing. Example: I am looking at a column called Med_Rec...
Everything in this formula works except the last two statments in the fromula. It is the part that involves the vst_v.dx_cd table. I am trying to enter two different ranges using the same table. When I enter the first range and run it then the first range works, but when I add and run the...
If I use the formula below then only the previous record and the active record are bing compared. I need the active record to be compared against the entire column and continue this process until the last record in the column.
numbervar CntCurr;
If previous({table.MedRec}) = {table.MedRec}...
That was it!! Thank you so much!! The word 'in' wasn't in the drop down menu options, but when I typed it in the actual formula it worked!! Thanks again!!
Here is an example of what my record selection formula looks like:
{Table1.Field} in ["A", "B", "C"] and
{Table1.Field} in DateTime (2002, 10, 01, 00, 00, 00) to DateTime (2003, 09, 30, 23, 59, 59) and
{Table2.Filed} = {?Parameter}
I have created a parameter in Crystal 8.5 that is able to run a range value or a dicrete value seperately, but I need the parameter to allow the user to have the option of running both a range value and dicrete value at the same time. When I try to run the parameter using both a range value and...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.