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

    I am merely trying to define an ODB

    Well, it could be a few things. First, do you have the website security set to use the anonymous NT account? If so, then do you have the SQL Server database user account entered in the ODBC login? Most likely if the first thing that happens when clicking on the link is a login screen, then the...
  2. darwinh

    Date Difference in mm/dd/yyyy hh:mm Formet

    Yes, There is a DateDiff function. If you are using Crystal Reports 7 or greater the function will be found as a download on the SeagateSoftware Web Site. www.seagatesoftware.com It will be a UFL file. You can use the function to calculate the date difference ot two datetime fields. Let me know...
  3. darwinh

    suppressing data in groups

    If you are reporting on basiscally the same fields and need the same type of grouping. Then just make multiple groups/subgroups sections. If you have a STATUS field that distinguishes the updated full record set from the history set. You can conditional suppress the grouping based on the...
  4. darwinh

    How to Connect to SQL Server via ODBC over Internet?

    To connect to a SQL Server data source using ODBC over the Internet. You need to setup the system DSN on the SQL Server / Web Server if they are the same machine. The client requesting the web does not need to know about the DSN source. Microsoft has a reference article to help. Using ADO...

Part and Inventory Search

Back
Top