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 TouchToneTommy 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: DocFKNx
  • Content: Threads
  • Order by date
  1. DocFKNx

    Paint Shop Pro 9 - Cannot Send Files (Email)

    The File...Send menu item/feature isn't working for me. When you try to mail the current open file using Send off of the File menu you get first an error message from Outlook (2003): Microsoft Office Outlook "The Operation Failed" click OK then this error: Paint Shop Pro 9 "Cannot send...
  2. DocFKNx

    Using INFORMATION_SCHEMA Views

    I'm trying to query SQL INFORMATION_SCHEMA views with Crystal but when I use Set Location the INFORMATION_SCHEMA views are not listed. Am I missing something here? Thanks! X
  3. DocFKNx

    Crystal 8.5 Stored Procedure Data Source/Datetime

    When you use a SQL stored procedure as a data source for a report, the Parameter Field for any datetime values in the parameter list of the stored procedure defaults to prompting the user for both the date AND the time. Is there any way to just get the parameter field to prompt for the DATE...
  4. DocFKNx

    ODBC Refresh in CR 8.5/9

    If while running the designer you change the ODBC data source (a stored procedure) of a report from one SQL server to another. How do you get Crystal to actually recognize the change? Right-click/Refresh doesn't do it. Verify Database doesn't do it. Set Location doesn't do it. Seems the only way...
  5. DocFKNx

    Dynamic Data Sources

    Using Crystal 8.5/9.0. I have reports that are the same but need to have different ODBC data sources at runtime depending on where they are deployed. Without saving the data source in each copy of the report how can I have just ONE report that works with any number of ODBC data sources?! I'm...
  6. DocFKNx

    Crystal Viewer Won't Print

    I've found that one of the more frustrating aspects of Crystal 8, 8.5, 9 is a clear cut understanding of what DLLs need to be distributed for runtime. I currently have an installation that now will not print from the viewer. You can hit the print button, select a page range, and hit OK but...
  7. DocFKNx

    Dynamically Populating Input Parameters

    When setting up Parameter fields you can specify a table as a source of the prompt value possibilities. This is great - at the time you create the parameter. But shouldn't this read the table each time to get an updated list of values that are current with the data set? (i.e. DATA DRIVEN). Is...
  8. DocFKNx

    Suppressing Report Items at Print Time

    Is it possible to NOT print objects in a report when it's actually sent to a print device versus appearing in the viewer? Thanks! X
  9. DocFKNx

    Grouping Reports by Quarter of ANY Calendar Year

    I recently did a report that had to be grouped quarterly (but NOT for the current calendar year). Crystal included starting at some version built-in functions for this but they only work with the CURRENT calendar year. Not all that handy. There are probably several approaches to this but this...
  10. DocFKNx

    Evaluating Null Dates

    I've seen several messages on this topic on the web - nothing I've seen has worked so far. I'm completely unable to evaluate a NULL date with SQL 2000 as the data source. I've tried several techniques including: Date( {MR_MEMBER_1.NAR_JOINDT} ) = Date(0,0,0) This evaluates to FALSE when...
  11. DocFKNx

    Conditionally Printing Objects

    Is there a way to prevent printing objects based on whether the report is running in Preview mode versus being printed? Crystal Reports 8.5 fyi. Thanks! Doc

Part and Inventory Search

Back
Top