Showing posts with label sql-server. Show all posts
Showing posts with label sql-server. Show all posts

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

Wednesday, March 7, 2012

Maintenance Plans on MSDE

Hi NG,
I've defined a job and a maintenance plan on my SQL-Server. The target
system is using MSDE. I could see that the job was created, but with the
Enterprise Manager I cannot see that there is a folder 'Database Maintenance
Plans' under folder 'Management'.
Does anybody know if Maintenance plans are generally possible under MSDE, or
is there something missing on my target system where MSDE is installed.
Thanks for support, rene
hi Rene,
Re Fo wrote:
> Hi NG,
> I've defined a job and a maintenance plan on my SQL-Server. The target
> system is using MSDE. I could see that the job was created, but with
> the Enterprise Manager I cannot see that there is a folder 'Database
> Maintenance Plans' under folder 'Management'.
> Does anybody know if Maintenance plans are generally possible under
> MSDE, or is there something missing on my target system where MSDE is
> installed.
> Thanks for support, rene
Maintenance Plans are supported, but you do not have a graphical tool to
manage them, and have to rely on xp_sqlmaint system extended stored
procedure
(http://msdn.microsoft.com/library/de...-us/tsqlref/ts
_xp_aa-sz_0mb8.asp)
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.9.1 - DbaMgr ver 0.55.1
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply