filtering the crystal report viewer

[snakeman]

hey
i'm using vb.net 2008 pro and i don't know anything about crystal reports.
i already tried working with crystal report and i created one.
but actually i dont know how to filter the report and also i don't know what the best way to connect the items in the report to my DB.
do i need to create a dataset or connect directly to the DB or what??
Because i connected my application to my DB using datasets and datatables via code (not designer).
what can i do exactly???

and also can someone help with a good website or topic in crystal report?

thx

[snakeman]

guys any help

[snakeman]

guysssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssss

[hemantpatil]

hello snakeman

for connecting a database to crystal report you just need to give the provider and the db table, views or stored procedures. you need not to create any dataset or datatable for that. and for filtering the data in the crystal report u can use Selection crieteria property of crystal report control and pass required filter.

if you are using SQL as DB then Stored Procedure will be the better option for generating reports as SP's are in precompiled format so it'll help to load reports quiclky.