Some views in MSSQL not showing in Data Sets

I have several views in MS SQL 2008 that do not show as available to include in a dataset in Data Explorer. They are fairly complex so I would prefer to use them instead of doing joins in BIRT and having to maintain two sets.

I am using BIRT 2.6.1 and MS SQL Enterprise 2008 R2. There is only one instance of MS SQL running, and adding a table to the DB shows up in Designer.

All tables display, and some views display. I have stopped and restarted the DB, closed and restarted BIRT Designer, and rebooted.

Help would be appreciated. I'm probably doing (or not) something obvious but I can't come up with a solution.

Dave

Find more posts tagged with

Comments

mwilliams

Hi Dave,

Are you talking about in the dataSet editor when you're building your query, you don't see some of the tables, etc. that should be there? If so, there is a setting in your preferences that limits the tables and schemes you can see. You can change this to allow the others to show up. They are always available, but just don't show based on this limit. If this isn't what you mean, please let me know.

Dave O

<blockquote class='ipsBlockquote' data-author="'mwilliams'" data-cid="71970" data-time="1294339415" data-date="06 January 2011 - 11:43 AM">
Hi Dave, 
 
Are you talking about in the dataSet editor when you're building your query, you don't see some of the tables, etc. that should be there? If so, there is a setting in your preferences that limits the tables and schemes you can see. You can change this to allow the others to show up. They are always available, but just don't show based on this limit. If this isn't what you mean, please let me know. </blockquote>
 
 
Thanks for the response Michael. 
 
The only setting visable in Preferences is the row limit per page. It was set to 500, so I changed it to 1000 - no joy. All of the tables show up in the Edit DataSet dialog, and three views that were made before I restored the DB to my environment from a contract programmer. I can create new tables and they show up in the DataSet editor, but new views don't. I just tried again and came up with the same results. I tried backing up and restoring the DB, no joy there either. Still missing the views. I created a view with a minimum structure as a test, and it did not show up in BIRT. 
 
Dave 
 
sorry for the blank post

mwilliams

Dave,

Hmmm, so you're not at the table/scheme limit if you can see newly created tables. If you create a new dataSource and dataSet after the new view is created, do you see the new views then? Or just the original ones?

Dave O

Resolved.

I don't know how I was only seeing the Preferences show the number of rows to return, but with the focus on the report design I get the complete preferences menu you were referring to. The number of rows of tables was limited to 100. Increasing that showed the additional views.

Thank you for the help. Probably not the last I'll need!

Dave

mwilliams

Dave,

Not a problem. Always glad to help!