Help adding a table to Crystal Report

(0) Share

Report

Posted on by Richard West

525

I am trying to resolve an issue that is addressed in KB 942096.

However, I am having difficulity when I am trying to add a table to my Crystal report file.

Per the Kb article: "In the Available Data Sources box, select the table that you want to add to the report, click the right arrow button to add the table to the Selected Tables box, and then click OK."

The problem is that there are no tables listed under the Available Data Sources box. I then went to Create new connection - > ODBC (RDO) -> Make new connection

I have selected the Application database, entered SA for the user and trusted connection. This is what is listed under the properteies for the "selected" table that is already part of the report.

The connection is created, however I can not navigate to any of my tables. I only see DBO (with dmg_masterpassword under this entry), INFORMAITON_SCHEMA, and SYS.

Can anyone help me figure out how to get to these tables?

Thanks!

*This post is locked for comments

I have the same question (0)

All responses (3)

Answers (0)

Richard West 525 on at

Like (0)

Report

Re: Re: Help adding a table to Crystal Report

Thanks for the tip!

I can now see the tables and can add them to the report.

Was this reply helpful? Yes No
Jason Irvan 180 on at

Like (0)

Report

Re: Re: Help adding a table to Crystal Report

We had this problem in the Crystal designer before. We had to do as Kai suggested above, however we also had to deselect the Stored Procedures.

J

Was this reply helpful? Yes No
Kai Wang 265 on at

Like (0)

Report

Re: Help adding a table to Crystal Report

Right mouse click on DBO and select "Options". Make sure Tables is selected under Data Explorer. Then right mouse click on DBO and select "Refresh". See if you can see tables now.

Was this reply helpful? Yes No