Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

connect to database and add tables to a new report?

Status
Not open for further replies.

Fursten

Programmer
Dec 27, 2000
403
PT
Hi,

I´m using Visual Basic 6.0 and Crystal Reports8.0
Eveytime I open an existing report using RDC i never need to setLogOninfo and things like that. so, why everyone, including Crystal Decisions, say that we need to do that?

What I think is that, everytime we save a rpt with logoninfo inside, I don´t need to logon by code, right?

Well, the problem however isn´t that. the problem cames when i´m trying to make a clean report. I would like to know how can I add tables to the new report?

By theory, i should:

1) connect to the database:Logoninfo i think

2) Add tables based on that connection

My question is: How can we do that?

the add table method is complety strange. i really dont´like that. I just want to do things like when working with Crystal Reports: select the method to connect...open the connection and chosse the tables..just that. Crystal Decisions had put a lot of strange methods to logon (worst..in diferent objects: Application; table; database; report)...argh!! I honestly think that the object model is not well done about this object. It´s very confusing just to make a simple thing.

I don´t want to use ADO to do that, too. Using the new methods to version 8 like AddOLEDBSource works fine, but I don´t want to use ADO to put tables on my reports!

Just want to use OLEDB or ODBC to connect and then get some tables.

Any help is appreciate.

Thank you
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top