All,

I working on Crystal reports 2008 and working on reports optimization. It is easy to apply HINTS on Command based reports but I could not find a way to apply HINTS on View based reports.

I tried using SQL expression to apply HINTS so that while using Show sql Query under Database menu, HINTS should be applied. But it is not on the top position(after main Select).

Can any one suggest me how to apply force HINT on view based reports?

Your suggestions are really appreciated and please reply to me only.

Regards,