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...
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...
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...
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...
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...
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
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.