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 Mike Lewis 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. rksandman

    MicroStrategy VS BO

    We are looking at MicroStrategy for our Enterprise Reporting Solution, and I'm wondering if any of you have experience with MicroStrategy and could share your Pros and Cons of the product and how its Report Services compares to the Crystal Report designer for creating document type reports...
  2. rksandman

    Slow refresh against oracle tables

    To respond to Annette there is nothing else going on in the report. I set it up to test the speed bucause I am having this problem with most of my reports that run off this Oracle db. here is my email address rksanders@attbi.com I will be looking into doing what Synaps has suggested using...
  3. rksandman

    Slow refresh against oracle tables

    I looked at Jims idea, when adding the +0 to the query it then removes it from the SQL being pushed to the server, Ill have to take a look at the ODBC tracing tool that you mention. I have run this same query using ole db and tns native connection and Im seeing the same problem which leads me to...
  4. rksandman

    Slow refresh against oracle tables

    Hello Synaps, thanks for the quick reply, I changed the like statement, as you suggested but the problem still exist. I have already taken the sql and run it through SQL Navigator and the process time is just over 5 seconds. Any other ideas?? if I run the following it return all 500 records and...
  5. rksandman

    Slow refresh against oracle tables

    Hi Please Help, I am using CR ver 9 on a win2k platform oracle client 8i, the data source is oracle 8i, the ODBC Drivers tried are Cr Oracle, MS Oracle, Oracle and Oracle Wire.. I run the following qry and it takes at least 10 min to return 106 records. If I remove the date portion of the qry...
  6. rksandman

    Hiding page header with detail section

    This will only work for the first page, but if you insert a detail section and move it to the top of the detial sections then in the suppression formula box write a formula; recordnumber>1
  7. rksandman

    ASP problem CRAXDRT ERROR 2147192184 Server ha not yet been opened

    Hello, I am reporting against an oracle database using 8.5 and am trying to run the report using ASPs but Im getting the "CRAXDRT ERROR 2147192184 Server has not yet been opened" msg. Im not real strong in Oracle but it appears that the asp is not making the connection to the...

Part and Inventory Search

Back
Top