Can I call a Function in CRXI

[syncdba]

Hi,
I have created a report in CRXI & its running fine. BUT when I add a VIEW report takes long time to refresh the reports appro.10 mins otherwise reports take 45 secs. Can I change my view to a function & then call that function in my report? I'm not sure if it works. Any help?
----------------------------------------
create view crtask as
select id,accountid,
case when "sfdcOpportunity"."ISP_Complete_Account_Plan__c"='true' then 'Complete_Account_Plan : COMPLETED'
else 'Complete_Account_Plan '
end as Complete_Account_Plan,........(More 100 similar CASE lines).....
from sfdcopportunity
where closedate >= '08/01/2004' and closedate <= '07/31/2006'

 

[synapsevampire]

Why would you hardcode the dates in instead of using a parameter?

You'd be better served to create a Stored Ptrocedure if performance is the concern, then again a View might work out well providing you're properly passing the dates to the view.

Rather than stating the architecture, I suggest that you post technical information and ask for assistance in optimizing it.

Database/connectivity used?

When you have the View as the data source, what is in the Database-Show SQL Query and what's in the Report->Selection Formulas->Record?

Whatever criteria defined in the record selection should be reflected in the show sql query.

Also how long does the View take to execute (to completion) if run from a query tool?

-k