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

    New records this month per group CR 8.5 SQL Db

    LB............You ROCK!! I've never used minimum / maximum in formulas and queries before. Thank you very much! Ris...
  2. risman

    New records this month per group CR 8.5 SQL Db

    I'm trying to display a patient's exam if in the past month, it is the first one ever. I have witten a report that gathers our whole Db. It is grouped by Patient ID, sorted by Date of Service, (descending), and I have a running total of the exams that restarts with each Patient ID group. Then...
  3. risman

    8.5 Connectivity View Disappears in Data Link Properties

    Hello, I have been having trouble with CR 8.5 OLE Db to an SQL cluster, so I just reinstalled Crystal. It worked fine yesterday. Today, I started a new report using the Standard Report Expert. After making a connection in the usual manner: The Data Explorer / More Data Sources / OLE Db / OLE...
  4. risman

    8.5 Blank Report Cannot Save

    The reinstallation worked. Thank you! Risman
  5. risman

    8.5 Blank Report Cannot Save

    Hello, A problem with no data being returned has started occuring with Crystal 8.5 OLE Db connecting to an SQL cluster. I develop new reports on my PC, (Win XP). I also edit existing reports which I copy off of our report server to my PC. The reports run fine in our application for endusers...
  6. risman

    Daily Schedule in 10 minute increments

    Hello, I am using an SQL Db with CR 8.5. I have what is probably a very elementary question, but I just can't figure it out: I am trying to design a report that shows scheduled exam times and open times that can filled for various departments for the current date and the following day. I...
  7. risman

    DateTime Param for a String field

    Hello, Ok, I don't know if anyone will see this, but here is the solution: The table I was hitting had strings for the data type. It's returns were formatted like this: Jan 1, 2006 But the application would not take a date or a string parameter in that form. (From what I could tell). So my...
  8. risman

    QUEREY A STRING FIELD WITH A DATE TYPE PARAMETER

    Hi Ken, Ok, I don't know if you'll see this, but here is the solution: The table I was hitting had strings for the data type. It's returns were formatted like this: Jan 1, 2006 But the application would not take a date or a string parameter in that form. (From what I could tell). So my...
  9. risman

    QUEREY A STRING FIELD WITH A DATE TYPE PARAMETER

    Thanks Synapsevampire, My issue isn't solved, but I think I'm heading right. A couple of thoughts..... 1) If I want the end user to be able to pick the FromDate & ToDate, (as DateTimes and not DateTime Strings), wouldn't I want to convert the DateTime Parameters to DateTime String Parameters...
  10. risman

    QUEREY A STRING FIELD WITH A DATE TYPE PARAMETER

    I am using CR 8.5, SQL Server, OLE Db driver. I have a Db field ({Corrected_Date}) that is a String. The format disregards leading zeros except for minutes and seconds.: 1/1/2006 2:09:07AM 10/2/2005 2:43:00PM etc.... I am searching for records corrected between two Dates, or DateTimes, (2...
  11. risman

    DateTime Param for a String field

    Hello, Upon fixing the report as stated above, and closing the selection expert, I got the message: "A String is Required Here". I clicked "ok", and was then able to run the report without being forced back into the select expert or anything. The report ran great. I rechecked the Select...
  12. risman

    DateTime Param for a String field

    And use it in the selection querie like this: DTStoDate({table.yourstringdate}) >= {?FromDate} and DTStoDate({table.yourstringdate}) <= {?ToDate} and {MEDICAL_REPORT_OBJECT.WKT_ID} =10 ???????? Then would the parameters {?FromDate} and {?ToDate} be set as Date fields?
  13. risman

    DateTime Param for a String field

    Hello, I have access to the server, but I have never created a new view before. I browsed this field using one of the dropdowns in the selection expert. It came back with this format: "YYYY/MM/DD hh:mm:ss.xx" Example 1: Parameters {?FromDate} and {?ToDate} are set as DateTime...
  14. risman

    Date Parameters for String fields

    Hello, I am using CR 8.5, SQL Server, OLE Db driver. I have a DateTime/String problem that I'm probably over thinking, but......I have a Db field ({Corrected_Date}) that is a String. The format disregards leading zeros except for minutes and seconds.: 1/1/2006 2:09:07AM 10/2/2005 2:43:00PM...
  15. risman

    DateTime Param for a String field

    Hello, I am using CR 8.5, SQL Server, OLE Db driver. I have a DateTime/String problem that I'm probably over thinking, but......I have a Db field ({Corrected_Date}) that is a String. The format disregards leading zeros except for minutes and seconds.: 1/1/2006 2:09:07AM 10/2/2005 2:43:00PM...
  16. risman

    Age formula with weeks and days

    Don't I have to use &quot;Remainder&quot; somehow after the first part calculates the years, then again after months and then again after weeks? Thanks-
  17. risman

    Age formula with weeks and days

    Hello, I am using age formulas in a report which work very well. How can I add on to the formulas below to specify years, monthes, weeks, and days old? Ex.: Little Bobby is 7 years, 8 months, 3 weeks, 2 days old today! Thanks! Risman If Month({table.dob}) <= Month(CurrentDate) and...
  18. risman

    dllregistryserver entry port error

    Thanks for replying you guys! After gathering all sorts of documents I could find from Crystal and related sites, (Tek-Tips too of course), I uninstalled Crystal, reinstalled Crystal, reapplied the Service Pack for 8.5, the monthly Hot fix, database drivers and dlls. Rebooted. Viola! I am not...
  19. risman

    dllregistryserver entry port error

    After searching around a bit more, I found what I think is the answer to the &quot;entry port not found&quot; problem. The Faq tab under Crystal Decisions: Crystal reports 3 Integrate Faq 768-3537. Problem is, I'm still getting Database errors and SQL Server Errors with my report. Maybe I...
  20. risman

    dllregistryserver entry port error

    Hello, I using CR 8.5 with Windows XP, IE 6 connecting OLEDB to an SQL Server. I was receiving Database Errors and SQL Server errors when trying to run a report with a Stored procedure. I downloaded the Service Pack 1, the monthly Hot Fix, and the Database Exporting Hot fix from Crystal's Web...

Part and Inventory Search

Back
Top