>Hi
> I'm using crystal report 7. My reports would be generated on the basis of parameters passed. I tried with its sql designer and report designer but unable to find any useful tip/document. also i want to know the best way to achieve this. i'm using vb6 and sql 7.0

If you are talking about specifying the Where clause to filter your data to be printed, use the .SelectionFormula property.