var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
I wrote sql query. When I run it in SQL Developer or SLQ/Plus it runns fast. When I runn it in Crystal it takes two minutes!. I even created a materialized view and added indexes. I realdy to pull my hair out and ideas?
check the option for "Use Indexes Or Server for Speed".
it is under menu "File-Report Options" in Crystal Reports.
hope it helps (and not late to reply ).
Log in with your username and password
Forgot your password?
Subscribe to dBforums Brief to receive special offers from dBforums partners and sponsors