i have created a crystal report in crystal report 9...i m using a number of tables in the sql server to create the report...
in vb i just want to open the report and by passing a parameter..i can display the report...i just have a lil problem..cause there is not much resources.. i am using a connection string

"Provider=SQLOLEDB.1;User ID=sa;password=;Initial Catalog=BIOSOFTBASE;Data Source = DEVELOPMENT;Use Procedure for Prepare=1;Auto Translate=True;Packet Size=4096"

in all of my vb application...what i want to do is that pass this connectionstring to the crystal report..and display the report..the reason is that the vb application would be running on client machines..can any body help me in this...thanx

p.s also the report i m using have a sub report too..i could use the recordset technique..but since the data is coming from multiple tables and for that i dont want to create a view..i m doing this way.