Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » BIRT » Data Sets and SQL Views
Data Sets and SQL Views [message #826923] Thu, 22 March 2012 16:56 Go to next message
Dave Waters is currently offline Dave Waters
Messages: 2
Registered: March 2012
Junior Member
I already have a sql database that has numerous views already created, and I can use the views providing I code the sql query direct.
Is there away through the data sets that would allow me to see and use the views?
At present I only see the database tables.

Many Thanks
Re: Data Sets and SQL Views [message #827028 is a reply to message #826923] Thu, 22 March 2012 19:57 Go to previous messageGo to next message
Jason Weathersby is currently offline Jason Weathersby
Messages: 9167
Registered: July 2009
Senior Member

In the data set editor there is a setting to show tables, views, stored
procedures or all or all. It is in the drop down list box labeled Type.
It is below the Available Items tree view.

Jason

On 3/22/2012 12:56 PM, Dave Waters wrote:
> I already have a sql database that has numerous views already created,
> and I can use the views providing I code the sql query direct.
> Is there away through the data sets that would allow me to see and use
> the views?
> At present I only see the database tables.
>
> Many Thanks
Re: Data Sets and SQL Views [message #827517 is a reply to message #827028] Fri, 23 March 2012 12:40 Go to previous messageGo to next message
Dave Waters is currently offline Dave Waters
Messages: 2
Registered: March 2012
Junior Member
That's very interesting - I think there may be a bug.
When I select 'ALL' types I just get tables ?
I have to select 'Views' to see views, one would have thought the 'All' option would have selected all types.
aah well.
Thanks Very Much for your help.
Re: Data Sets and SQL Views [message #827755 is a reply to message #827517] Fri, 23 March 2012 18:57 Go to previous message
Jason Weathersby is currently offline Jason Weathersby
Messages: 9167
Registered: July 2009
Senior Member

Can you log a bugzilla entry for this?

Jason

On 3/23/2012 8:40 AM, Dave Waters wrote:
> That's very interesting - I think there may be a bug.
> When I select 'ALL' types I just get tables ?
> I have to select 'Views' to see views, one would have thought the 'All'
> option would have selected all types.
> aah well.
> Thanks Very Much for your help.
Previous Topic:Simple chart with no aggregation?
Next Topic:Is it possible to check if parameter allows null at rendering time?
Goto Forum:
  


Current Time: Sat Oct 25 18:20:25 GMT 2014

Powered by FUDForum. Page generated in 0.03827 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.0.2.
Copyright ©2001-2010 FUDforum Bulletin Board Software