Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. kabtjb

    Comparing a value in a column against another value in the same column

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

    Comparing a value in a column against another value in the same column

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

    Crystal 8.5 - Formula - 2 ranges pulling from the same table

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

    Crystal Reports 8.5

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

    Crystal Reports 8.5

    In a report I have a column that has duplicate records and I need to be able to flag the first occurance of each dupicate record. Please help.
  6. kabtjb

    Parameters (Range and Decrete Values) Crystal 8.5

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

    Parameters (Range and Decrete Values) Crystal 8.5

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

    Parameters (Range and Decrete Values) Crystal 8.5

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

Part and Inventory Search

Back
Top