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 IamaSherpa 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. JMG1019

    passing date parameter in to sql script

    pkra and kskid, I have the same error when I try to pass a date to my command window. Here is the code which would receive the date.... AND ACCESS_LOG.ACCESS_TIME >= TO_DATE ('{?Start Date}', 'DD-MM-YYYY HH24:MI:SS') AND ACCESS_LOG.ACCESS_TIME <= TO_DATE ('{?End Date}', 'DD-MM-YYYY...
  2. JMG1019

    Formatting formula

    Hi, I use Crystal Reports 11. We pull data from individuals records and compare those values to a set group of compliant values. If the individual is not compliant we need the name to be highlighted (in our case crred and crbolditalic). The problem I am running into is that there are several...
  3. JMG1019

    SQL brings back data quickly, parameters stall out process

    I hadn't tried using the parameter selection in the 'Add Command' window. That worked much better than utilizing the selection criteria in Crystal. Thank you for your help.
  4. JMG1019

    SQL brings back data quickly, parameters stall out process

    I add my SQL (which queries our Oracle database) through the use of the 'Add Command'. All rows are returned to Crystal and the parameters do the filtering. Other flexible parameter reports generally don't take longer to run, they actually run faster. When the query is added to Crystal and...
  5. JMG1019

    SQL brings back data quickly, parameters stall out process

    I am using a SQL statment to retrieve data for my report. If the Crystal report is run with just the SQL statement it takes less than 10 minutes to run. When I add parameters to the Crystal Report (I'm using XI), the report takes approximately 45 minutes to run. Any suggestions on why...

Part and Inventory Search

Back
Top