nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Data set table selection doesn't show all database tables

bappoo

Hi All,

I have noticed that when I create a data set the tables listed in the "Available Items" box does not show all the tables in my database.

At first I thought this might be a permissions thing, i.e. the database user does not have permissions to see all the tables, but I made sure I was using a dbo account. Also, if I add a filter then I can see the tables that were previously not displayed.

So far I am thinking that this is a limitation on the number of tables that can be displayed in the list. Can anyone confirm this and / or let me know how I can overcome this? Is there a parameter setting for example, that allows the list to display more items?

Many thanks

Paul

Find more posts tagged with

Comments

mwilliams

Hi Paul,

Yes, this is a setting in the designer that limits the amount of schemas/tables that are shown. You can still use them, they just aren't listed. To increase this number, go to Window -> Preferences -> Report Design -> Data Set Editor -> JDBC Data Set. You should see the settings there.

Hope this helps.

bappoo

Thanks Michael, will check this out. 
Warm regards 
Paul 
 
<blockquote class='ipsBlockquote' data-author="mwilliams">Hi Paul, 
 
Yes, this is a setting in the designer that limits the amount of schemas/tables that are shown. You can still use them, they just aren't listed. To increase this number, go to Window -> Preferences -> Report Design -> Data Set Editor -> JDBC Data Set. You should see the settings there. 
 
Hope this helps.</blockquote>