I am creating reports using the usual viual link expert with parameters and this works fine with VB.Net even passing parameter values at runtime.

My collegues are arguing that this will work for a few records but will be very slow when large data is involved, instead they are suggesting using stored procedure on the SQL serve and returning tables.

We tried this and it works from Crystal Reports designer but the same report will fail with Query engine error if it is called through VB.Net.

Is it true that usual crystal reports will upload all tables then do the selection locally.

Secondly can anybody guide me on the issue of using stored procedures as report source data and using vb.net.