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 Chris Miller 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. help2003

    Removing group from sorting or to get latest date only

    lbass, Ignore my previous post. My report is working fine now. I used sql query with subquery. Thanks
  2. help2003

    Removing group from sorting or to get latest date only

    Thanks for replies. synapsevampire, I told that if I use group(which I am using right now)I cann't get to sort by my @diff. lbass, I tried your suggession also before. my query with sub query is working in sql Plus, when I use the same query in Crystal 8.5 , I am getting ODBC oracle driver...
  3. help2003

    Removing group from sorting or to get latest date only

    Hi I am doing a report with a latest date and other info. table1 Uniqueid and Table2 latest date one Id can have multiple transactions, but I need only latest date. I can do this by group and suppress other dates, but report out put sort by ID, I need sort by aging which is (latest date -...

Part and Inventory Search

Back
Top