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!

Register Log in
  • Congratulations strongm 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: *

  • Users: spcc07
  • Content: Threads
  • Order by date
  1. spcc07

    Group by week then sum for three columns

    I am using Crystal XI, Oracle database. What I am trying to do: Week Range APP DEC DEP 12/27/2009 - 01/02/2010 12 1 2 01/03/2010 - 01/09/2010 10 2 1 01/10/2010 - 01/16/2010 5 1 1 The numbers under APP, DEC and DEP represent dates that...
  2. spcc07

    Suppression of records by priority

    I am using Crystal XI, Oracle database. I have a list of AT codes that should take priority when a person has more than one record (i.e. they have more than one AT code). AT CODE PRIORITY FTB takes priority over XBB, XTF, XCC. MBB takes priority over MTF. MTF takes priority over MCC and WRS...
  3. spcc07

    Null returning 0

    I am using Crystal XI. Oracle database. I am using a formula that LBASS posted in what is now a closed thread, it returns 0 instead of Null. How would I get it to return NULL? Copied From Previous Post: Open and save a new formula {@null} without entering anything. Then change your formula...
  4. spcc07

    Using Variables to list on one line

    Crystal 8.5 SQL Server I have one person who may have many scholarships: Person_ID Scholarship Amount 1111 Scholar1 1000 1111 Scholar2 1500 2222 Scholar1 1000 2222...
  5. spcc07

    SQL Create MIN Source from one to many field

    Cr 8.5 SQL This table is set up as a one to many. I need a SQL statement to get the First Source based on Minimum Source Date. Person_ID Source Source Date
  6. spcc07

    Edit Selection Formula - Running Totals

    Version 8.5 SQL database I have a report with 3 sets of three running totals with Admits >= 3 OR Deposits >= 1 in (Reports - Edit Selection Formula - Group) The results look like this: Applied Admit Deposits 2005 2006 2007 2005...

Part and Inventory Search

Back
Top