Creating Crystal Rpt from sql tables and accessing in vb6

[yousufkhan]

--------------------------------------------------------------------------------

i have sql database i wanted create a report in crystal report 7 how should i access the sql tables in report i dont want use odbc datasource if i use odbc i ll have to always create some odbc connection at client site what is the other way for this so that when i call this report from vb 6 it should not say cannot open sql server

[mabbas110]

You first design it by sql server and then by code just pass the other information of sql server from code. But i would recommend you to use DSN , by this way if sql server db name changes , cr would update itsellf.

[yousufkhan]

I ll design it in sql server using odbc but how to pass other informatin from vb
coz it will ask for odbc connection otherwise it will give error cant open sql server.

[mabbas110]

U can pass other information from crystal report control. search for it u will find many code.