Access data for reports directly from SQL or via COM+???
Posted on 2006-06-22
Hi please can someone tell me which way is best -
I have an program written in VB which has uses dll's in a COM+ application to access data stored in SQL. I am also using functions in the dll's to get data used in Crystal reports. The problem with this is every time i need a new report i need to add a new function to the dll to get the new data then recompile and redistribute the COM proxy application (v. painfull).
Instead should i get the crystal reports to access the data directly from SQL, if so what are the possible pitfuls?
Many thanks in advance,