Monday, March 26, 2012

making reports with xml data source

Can i make a report from non sql-server data source ?
To be specific:
I have an xml data source, and i built the dataset from the xml,by VIsual
Studio -DotNet [by Code],
can i bound reporting services 2000 to this dataset as datasource?
if NO, can we do it in sql server Reporting Services 2005?
thanks in advanced
Oren.On Sun, 10 Apr 2005 00:11:05 -0700, Oren Said <Oren
Said@.discussions.microsoft.com> wrote:
>Can i make a report from non sql-server data source ?
>To be specific:
>I have an xml data source, and i built the dataset from the xml,by VIsual
>Studio -DotNet [by Code],
>can i bound reporting services 2000 to this dataset as datasource?
>if NO, can we do it in sql server Reporting Services 2005?
>thanks in advanced
>Oren.
See, "Using an External Dataset with Reporting Services" in BOL for RS
2000.
Andrew Watt
MVP - InfoPath|||The new controls (available with beta 2 of Widbey) should allow this. Unitl
the controls are out and being used I'm not guaranteeing that but it is my
understanding that they will allow this (both a web and winform control
will be available).
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Oren Said" <Oren Said@.discussions.microsoft.com> wrote in message
news:B8E667B7-78EA-4A2F-92FC-9B230ABCCE6A@.microsoft.com...
> Can i make a report from non sql-server data source ?
> To be specific:
> I have an xml data source, and i built the dataset from the xml,by VIsual
> Studio -DotNet [by Code],
> can i bound reporting services 2000 to this dataset as datasource?
> if NO, can we do it in sql server Reporting Services 2005?
> thanks in advanced
> Oren.|||Here are some options for today:
Customize your own XML datasource for SQL Server 2000, and cosume the
webservice from SQL and acces those objects from the report (SQLRS)
Customize you own BOL for use XML as datasources, (make sure your BOL
support more than 10k records)
Wait for SQL 2005, certainly MS will have something available (its the
promess)
Thanks
Jerry
--
Call a WebService from SQL Server 2000
http://www.rdlcomponents.com/EXSP/default.aspx
WebService Data Processing Extension
http://www.rdlcomponents.com/DTE/Default.aspx
"Bruce L-C [MVP]" wrote:
> The new controls (available with beta 2 of Widbey) should allow this. Unitl
> the controls are out and being used I'm not guaranteeing that but it is my
> understanding that they will allow this (both a web and winform control
> will be available).
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Oren Said" <Oren Said@.discussions.microsoft.com> wrote in message
> news:B8E667B7-78EA-4A2F-92FC-9B230ABCCE6A@.microsoft.com...
> >
> > Can i make a report from non sql-server data source ?
> >
> > To be specific:
> >
> > I have an xml data source, and i built the dataset from the xml,by VIsual
> > Studio -DotNet [by Code],
> > can i bound reporting services 2000 to this dataset as datasource?
> >
> > if NO, can we do it in sql server Reporting Services 2005?
> >
> > thanks in advanced
> >
> > Oren.
>
>sql

No comments:

Post a Comment