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 wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by DocFKNx

  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

    YES you can query INFORMATION_SCHEMA.views from any user database. Only under master are they listed in enterprise manager. This is the curious part. You can query them but WHERE are they?!?! Thanks! X
  3. DocFKNx

    Using INFORMATION_SCHEMA Views

    Not sure if I understand. I created a new report and was trying to set the Database Location to point to the views. If you look under the master database you can see them listed but under any other user database they are not listed. They aren't listed in Enterprise Manager either but you can...
  4. 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
  5. DocFKNx

    Crystal 8.5 Stored Procedure Data Source/Datetime

    Yes that's how I had it before but then you lose the super-neato-fancy calendar date selector and have to rely on users getting the date format right. I think the answer is no - at least not in 8.5 or 9.0 - maybe 10! ; ) Thanks! T
  6. 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...
  7. DocFKNx

    Crystal Viewer Won't Print

    No I haven't found a fix to this yet. I've tried pretty much everything including reinstalling the entire runtime distribution. It's baffling. X
  8. DocFKNx

    Displaying BLOB fields in Crystal solved!!!!

    I was never having problems SEEING BLOBs in a report. The problem I'm having is the selection box/canvas size wireframe around the BLOBs is easily 5 times the actual size of the graphic. If you try to resize this so you can put other objects around it in the report the image is automatically...
  9. 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...
  10. DocFKNx

    Dynamic Data Sources

    Also note that the reports use stored procedures in SQL as the ultimate data source (navigated to via ODBC connections). Not sure if this is pertinent. The stored procedure name is the same from ODBC source to ODBC source. Thanks!
  11. 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...
  12. DocFKNx

    Crystal Viewer Won't Print

    Nope purely stock viewer configuration. X
  13. DocFKNx

    Crystal Viewer Won't Print

    That DLL list is the product of my researching the runtime.hlp files (Crystal 8.5), runtime.chm files (Crystal 9) and email tech support from Crystal itself. I was hoping someone here might have a 'working' list at this point ; ). X
  14. 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...
  15. DocFKNx

    Evaluating Null Dates

    I was poking around in Report Options and found my "Convert NULL field to Default" was unchecked. I checked it and that formula started working for me like it did for you. Still need to find out what that really does but for not it seems to be a solution to my dilema which is GREAT...

Part and Inventory Search

Back
Top