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 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: *

  1. walterk123

    Calender - Can't view completed activities...

    How about a calendar report that will allow a user to see both pending and completed items. My users want a calendar based report that lays out all the pending and completed in a day by day grid. I did not see how to choose Completed in the options of a report.
  2. walterk123

    Conditional format smallDateTime field in report CR6.0 MSSQL7.0

    Is there a way to get this day back, since I just wasted it on a futile task?? Apparently, my application was not looking at my report directory used by all the users, but instead, using my development box. So all the changes I was making on the production report directory would never appear in...
  3. walterk123

    Conditional format smallDateTime field in report CR6.0 MSSQL7.0

    Not quite - it was date(1900,1,1). I ma not sure if CR is that picky about 01 vs. 1. I just tried to enter the formulas: date({SOShipHeader.ShipDateAct})= date(1900,01,01) and/or date({SOShipHeader.ShipDateAct})= date(1900,01,01,00,00,00) with no luck. I thought maybe it needed hh:mm:ss too...
  4. walterk123

    Conditional format smallDateTime field in report CR6.0 MSSQL7.0

    I have a report that is showing all open orders in our system. For each customer, it tells us when the order was planned to ship, and when it actually shipped. [planshipdate, actshipdate] (If it shipped, it should be closed and not appear. If it does, that is an issue for our folks to address.)...
  5. walterk123

    UNION issue within Crystal Reports

    I am also having a UNION issue with CR 6 and a report. I get the same error message as 1st post (nevets72). I removed the text after the UNION statement and the report ran. However, when I put that portion back - it stopped. My original SQL stmt produced summary values that did not match another...

Part and Inventory Search

Back
Top