datasource not showing all tables

I have a datasource that I created that shows about 1/3 of the tables in my Oaracle 10g database. Can anyone suggest what might be causing only 1/3 of the tables in my database to show when I go to create a dataset. Although the table does not show, I can still use the table(s) that aren't showing in the datasource navigator.

Find more posts tagged with

Comments

mwilliams

Hi johnsonDMG,

Where are you viewing the data? In the dataSet editor preview data section, the designer preview tab, or in another way?

johnsonDMG

hi mike....

I'm in the process of creating a pl/sql query; so I'm in the data explorer, right click Data Sets, then choose New Data Set... create the new dataset via my JDBC data source, select SQL query... then next.

I then see my database "Available items"... I see some of the tables like 1/3 of them if the view of my schema items. I can still type in the table i want to query (but is not being displayed to the left of the sql query editor). I'm just wondering why i don't see all my tables in my Oracle 10g database. I can see them in Crystal Reports when I'm referencing my a datasource.

mwilliams

johnsonDMG,

What version of BIRT are you using?

johnsonDMG

version 3.4.1

mwilliams

johnsonDMG,

In your designer, go to Window: Preferences: Report Design: Data Set Editor: JDBC Data Set. There you can set the max number of schemas and tables that you can see in the dataSet editor. This should do it.

johnsonDMG

Perfect.... thanx

mwilliams

No problem!