Analytical Functions?!?

[jbarbato]

Hi There! I am using Crystal Reports XI with Oracle 10g DB - OLE DB Provider

I am using analytical functions in my sql, and I am getting errors. The code is kinda boggy, so before I post it, I want to know if it is ok for me to use analytical functions?!? I am using First_Value & Last_Value. Here is a sample:

last_value(schedule_attained) over (
partition by project_number,summary_type,summary_value1,summary_value2,location,
deliverable_type,expense_type,perspective,discipline_group_id,
discipline_id
order by finish_date rows between unbounded preceding and unbounded following)
as last_sch_attained

If someone tells me that analytical functions are allowed, I will post the rest of my code.

Thanks,
Jayme

 

[IanWaterman]

Never used functions, you could try using a view or stored procedure that incorporates your function to return a data set. Crystal can then report off the View or SP.

With a SP that must return your complete data set, whilst views can be treated like a table and joined to other tables and/or views.

Ian