Grouping on Oracle Function

[ihda]

I've created a view in Oracle. The view contains a function. The function is not in the list of available fields to group on. Is there a way in Crystal 8.5 to group on a function?

Thank you.

 

[Turkbear]

Hi,
Give the function an alias for the field it produces and that should show up.

More details on your function, Oracle version, etc. would be very helpful, but something like this is what I mean:

create or replace view uses_function as
select f1, f2, get_sum_of_data(d1,d2) function_column,f4,f5 from table_name;

The above view would show function_column as the field name and should show up in Crystal.
( I don't have an actual one to test, and, besides, it could depend on your actual function.)

 

[ihda]

Thank you for your response....

Oracle 9i
Crystal 8.5 Pro

The field has an alias name. Crystal does not list the alias for grouping, sorting, or using in a Crystal formula.

The only thing I can do is to print on the report.