We have Simple SELECT query in our command section of Crystal report 2008 to display project details. We have used the fields and designed the report.

 

However, now  we need to design report to show the Child project(s) for the given Parent Project (Parameter field) and all its resources. Can we use(write) PL/SQL block like procedure/Function inside the command section, for me to loop each child project and get its resource details?

 

Or

 

Is there any other logic which could be used inside Command section to display above conditions?

 

P.S Datasource used in Crystal reports is ORACLE SERVER

 

FYI, I may not able to write Procedure or function on db side, due to access rights restirctions

 

Thanks in advance

Regards

Sreeram