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

    Opendocument.asp parameter syntax

    Hi, can someone give me an example using the parameter option to apply a record selection criteria to the query. I think it is something like &RSELECT='{fieldname}=value' Cheers, Geoff
  2. FoxG

    Linking Reports to Current CE User

    Hi, Does anyone know how to access the other user details that apply to a CE User ID/Name (ie. as defined in the CE user setup). What I could do with is a command/function that could access the CMS database to return the corresponding Fullname and/or Email details for either the current...
  3. FoxG

    Link reports to Current CE User details

    Hi, Does anyone know how to access the other user details that apply to a CE User ID/Name (ie. as defined in the CE user setup). What I could do with is a command/function that could access the CMS database to return the corresponding Fullname and/or Email details for either the current...
  4. FoxG

    How do I access a Business View from CR10

    I have created a business view using the CE10 Business View Manager. Why am I unable to see the business view from CR10 when I attempt to select a data source from within the Crystal Enterprise CRM repository? Any help appreciated. Thanks, Geoff
  5. FoxG

    Changing db connection when using commands in CR9

    Hi, I have a report using an oledb connection to an Oracle database. The report uses a command to determine the fields required from a specific table. I want to re-connect the report to the database via an ODBC connection that I have set up. When I try to set the source location it does not...
  6. FoxG

    Missing SQL Tables in Data Explorer

    Hi, I am using CR8.5 and all I can see are tables up to the letter J. I sure this must be already covered but the search option is not working at the moment. The database has over 12000 tables !! Is there a limit on the number of tables that can be access in the list via data explorer...
  7. FoxG

    CrViewer via IE 5.5

    I obtained this from a page on the web. This Html script works fine for the report specified. What would you need to change to make it work for a different report? (Eg. generated via an ODBC link to a SQL server database? Any info would be appreciated, Geoff <html>...
  8. FoxG

    The ODBC link to everything (designed by Microsoft)

    Hi, download the file from Microsoft using ftp ftp://ftp.microsoft.com/softlib/mslfiles/WX1350.EXE The ODBC Desktop Database Drivers 3.5 are designed for use on Microsoft Windows 95 or later, or Windows NT 3.51 or later. Geoff
  9. FoxG

    Default button to set parameters?

    When setting up the parameter - choose the date data type, then press the button to set the default. I have seen this in several threads. Why do I not have this feature ?? I have CR7. Any suggestions. Thanks, Geoff
  10. FoxG

    Constantly refreshing reports !

    Hi, Is anyone else aware of a quirk when using currentdate in the record selection formula. Every time I read a new page it prompts to refresh the report. I seem to have found a solution! Don't use currentdate in the record selection !! Add a formula BeforeReadingRecords; currentdate...
  11. FoxG

    Constantly refreshing reports !

    Hi, Is anyone else aware of a quirk when using currentdate in the record selection formula. Every time I read a new page it prompts to refresh the report. I seem to have found a solution! Don't use currentdate in the record selection !! Add a formula BeforeReadingRecords; currentdate...
  12. FoxG

    Keep Together Question (non beginner!)

    Hi, Is there any way to suppress the blank page that comes when using the keep together option for the first group to be processed if it contains more a page full of records? I am familiar with the principle of keep together, however there does not appear to be straight forward solution to...
  13. FoxG

    Auto Close from Mailmerge Document

    Does anyone know how I can exit a Mailmerge document and the main document automatcally when I close the merge document? Thanks Geoff

Part and Inventory Search

Back
Top