Reporting Services and an old sharepoint install

Hello,
I'm trying to install Reporting Service on a windows 2003 SP1 server
where a sharepoint had been uninstalled.
The install program still detect my old sharepoint installation.
i have checked the 2 documents from the support to remove manually
sharepoint, but the problem still occurs.
Please help. :'(
--
Ceci est une signature automatique de MesNews.
Site : http://mesnews.no-ip.comReporting services should still install. Is there a problem installing RS
other then the warning?
--
| Subject: Reporting Services and an old sharepoint install
| From: "Julien Dumetier" <julien.dumetier@.gmail.com>
| Message-ID: <mn.e39f7d54264629de.0@.gmail.com>
| Organization: DL Consultant
| X-Newsreader: MesNews/1.03.00.00
| Date: Thu, 28 Apr 2005 15:27:10 +0200
| MIME-Version: 1.0
| Content-Type: text/plain; charset="iso-8859-15"; format=flowed
| Content-Transfer-Encoding: 8bit
| Newsgroups: microsoft.public.sqlserver.reportingsvcs
| NNTP-Posting-Host: 81.255.66.8
| Lines: 1
| Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP08.phx.gbl!tk2msftngp13.phx.gbl
| Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sqlserver.reportingsvcs:42174
| X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
|
| Hello,
|
| I'm trying to install Reporting Service on a windows 2003 SP1 server
| where a sharepoint had been uninstalled.
| The install program still detect my old sharepoint installation.
|
| i have checked the 2 documents from the support to remove manually
| sharepoint, but the problem still occurs.
|
| Please help. :'(
|
| --
| Ceci est une signature automatique de MesNews.
| Site : http://mesnews.no-ip.com
|
||||> Reporting services should still install. Is there a problem installing RS
> other then the warning?
> --
The problem is at runtime, when i log in using the admin profile, if i
click on the button "New Folder" in the page
http://myserver/Reports/Pages/Folder.aspx, the page doesn't seem to
submit.
I've checked the report server log (using the verbose mode), and i
only have INFO level messages.
I can surf to "site parameters" or "Properties", but when i press an Ok
button nothing seems to occurs.
Tell me if you need more precisions.
--
Ceci est une signature automatique de MesNews.
Site : http://mesnews.no-ip.com|||Check out this web link. It might help you resolve your issues.
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rsinstall/h
tm/gs_installingrs_v1_9fdy.asp
--
| Subject: RE: Reporting Services and an old sharepoint install
| From: "Julien Dumetier" <julien.dumetier@.gmail.com>
| References: <mn.e39f7d54264629de.0@.gmail.com>
<Uv8OizATFHA.3052@.TK2MSFTNGXA01.phx.gbl>
| Message-ID: <mn.ebb87d54847889f0.0@.gmail.com>
| Organization: DL Consultant
| X-Newsreader: MesNews/1.03.00.00
| Date: Fri, 29 Apr 2005 15:52:35 +0200
| MIME-Version: 1.0
| Content-Type: text/plain; charset="iso-8859-15"; format=flowed
| Content-Transfer-Encoding: 8bit
| Newsgroups: microsoft.public.sqlserver.reportingsvcs
| NNTP-Posting-Host: 81.255.66.8
| Lines: 1
| Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP10.phx.gbl
| Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sqlserver.reportingsvcs:42301
| X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
|
| > Reporting services should still install. Is there a problem installing
RS
| > other then the warning?
| > --
|
| The problem is at runtime, when i log in using the admin profile, if i
| click on the button "New Folder" in the page
| http://myserver/Reports/Pages/Folder.aspx, the page doesn't seem to
| submit.
| I've checked the report server log (using the verbose mode), and i
| only have INFO level messages.
| I can surf to "site parameters" or "Properties", but when i press an Ok
| button nothing seems to occurs.
|
| Tell me if you need more precisions.
|
| --
| Ceci est une signature automatique de MesNews.
| Site : http://mesnews.no-ip.com
|
||||Brad Syputa - MS vient de nous annoncer :
> Check out this web link. It might help you resolve your issues.
> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rsinstall/h
> tm/gs_installingrs_v1_9fdy.asp
> --
Unfortunatly, i don't have sharepoint installed on the server, it has
been uninstalled before the Reporting Service Install.
I don't have a SharePoint Web.config file, the only .config file i
have is web.config which is located at c:\Inetpub\wwwroot\wpresources
The config file looks like :
<configuration>
<system.web>
<customErrors mode="On" />
<httpHandlers>
<add verb="*" path="*.asax"
type="System.Web.HttpForbiddenHandler, System.Web, Version=1.0.5000.0,
Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" />
<add verb="*" path="*.ascx"
type="System.Web.HttpForbiddenHandler, System.Web, Version=1.0.5000.0,
Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" />
<add verb="*" path="*.asmx"
type="System.Web.HttpForbiddenHandler, System.Web, Version=1.0.5000.0,
Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" />
<add verb="*" path="*.aspx"
type="System.Web.HttpForbiddenHandler, System.Web, Version=1.0.5000.0,
Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" />
<add verb="*" path="*.ashx"
type="System.Web.HttpForbiddenHandler, System.Web, Version=1.0.5000.0,
Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" />
</httpHandlers>
</system.web>
</configuration>
If i might add :
<HttpModules>
<add name="Session"
type="System.Web.SessionState.SessionStateModule"/>
and
<pages enableSessionState="true" enableViewState="true"
enableViewStateMac="true" validateRequest="false" />
Where should i write them ?
Second solution :
How the install program detect my old sharepoint install ? Maybe if we
could make the installation of Reporting Service (RS ) unable to detect
the old sharepoint install, i could try another uninstall-install of
RS.

reporting services add-in for WSS

I am having issues installing the reporting services addin for sharepoint.
While the installer claims the install was successful, I do not see the
features in Sharepoint Central Administration.
A look at the install log shows that the install failed. I am logged in as
administrator, this account is also the primary and secondary site
collection administrator on sharepoint.
User: administrator
Installing Report Server feature.
Calling copyappbincontents command.
copyappbincontents command completed successfully.
Adding Report Server feature to farm.
Report Server feature was already installed.
Activating Report Server feature to root level site collections.
Activating feature in web app 'Replica'
Activating feature to root site collection: http://localhost:81
Feature already activated in site collection http://localhost:81
Activateing Report Server feature in all admin site collections.
Activating feature in web app ''
Activating feature to root site collection: http://localhost:43565
******* User does not have permission to add feature to site collection:
http://localhost:43565
Updating DocIcon.xml file
DocIcon.xml file updated.
Beginning install of cab files.
Calling HCInstal for lcid '1033'
Outcome code is: 32
...
Cab files installed successfully.Figured this out. I had installed WSS when the computer was not attached to
a domain using the local administrator account. And, now the computer is
attached to the domain. Even though I was logged in as the domain admin and
had changed the site collection owners to this domain admin account the
install of Reporting Services add-in kept on failing. So, I logged in using
the local computer admin account and did the install and that worked.
"shikarishambu" <shikarishambu70@.hotmail.com> wrote in message
news:uTooRi1FIHA.536@.TK2MSFTNGP06.phx.gbl...
>I am having issues installing the reporting services addin for sharepoint.
>While the installer claims the install was successful, I do not see the
>features in Sharepoint Central Administration.
> A look at the install log shows that the install failed. I am logged in as
> administrator, this account is also the primary and secondary site
> collection administrator on sharepoint.
> User: administrator
> Installing Report Server feature.
> Calling copyappbincontents command.
> copyappbincontents command completed successfully.
> Adding Report Server feature to farm.
> Report Server feature was already installed.
> Activating Report Server feature to root level site collections.
> Activating feature in web app 'Replica'
> Activating feature to root site collection: http://localhost:81
> Feature already activated in site collection http://localhost:81
> Activateing Report Server feature in all admin site collections.
> Activating feature in web app ''
> Activating feature to root site collection: http://localhost:43565
> ******* User does not have permission to add feature to site collection:
> http://localhost:43565
> Updating DocIcon.xml file
> DocIcon.xml file updated.
> Beginning install of cab files.
> Calling HCInstal for lcid '1033'
> Outcome code is: 32
> ...
> Cab files installed successfully.
>

Reporting Services Add-in for SharePoint

Hi!
I has added this pack for MOSS2007 server but can't add Reporting Services
web-part in any site.
In the Site Collection Features don't available Report Server Integration
Feature in the list.
Anybody have information for resolving this issue?
Thanks!
Andrey.You need to install the Reporting Services Add-in for SharePoint. This can
be found here:
http://www.microsoft.com/downloads/details.aspx?FamilyID=1e53f882-0c16-4847-
b331-132274ae8c84&DisplayLang=en
Once you install that the Integration Features will show up in Central
Admin.
--
Chris Alton, Microsoft Corp.
SQL Server Developer Support Engineer
This posting is provided "AS IS" with no warranties, and confers no rights.
--
> Thread-Topic: Reporting Services Add-in for SharePoint
> thread-index: AcgM9WLa5NLs773ISuSFOI0+e6883w==> X-WBNR-Posting-Host: 207.46.193.207
> From: =?Utf-8?B?QW5kcmV5IFZhc3lsZW5rbw==?=<AndreyVasylenko@.discussions.microsoft.com>
> Subject: Reporting Services Add-in for SharePoint
> Date: Fri, 12 Oct 2007 10:29:04 -0700
> Hi!
> I has added this pack for MOSS2007 server but can't add Reporting
Services
> web-part in any site.
> In the Site Collection Features don't available Report Server Integration
> Feature in the list.
> Anybody have information for resolving this issue?
> Thanks!
> Andrey.
>|||Hi , Chris!
That add-in has installed already. In Central Admin page I can modify
Integration faetures. But on the sites I can't create reports using Report
Model and Report Builder.
WBR, Andrey.
"Chris Alton [MSFT]" wrote:
> You need to install the Reporting Services Add-in for SharePoint. This can
> be found here:
> http://www.microsoft.com/downloads/details.aspx?FamilyID=1e53f882-0c16-4847-
> b331-132274ae8c84&DisplayLang=en
> Once you install that the Integration Features will show up in Central
> Admin.
> --
> Chris Alton, Microsoft Corp.
> SQL Server Developer Support Engineer
> This posting is provided "AS IS" with no warranties, and confers no rights.
> --
> > Thread-Topic: Reporting Services Add-in for SharePoint
> > thread-index: AcgM9WLa5NLs773ISuSFOI0+e6883w==> > X-WBNR-Posting-Host: 207.46.193.207
> > From: =?Utf-8?B?QW5kcmV5IFZhc3lsZW5rbw==?=> <AndreyVasylenko@.discussions.microsoft.com>
> > Subject: Reporting Services Add-in for SharePoint
> > Date: Fri, 12 Oct 2007 10:29:04 -0700
> >
> > Hi!
> > I has added this pack for MOSS2007 server but can't add Reporting
> Services
> > web-part in any site.
> > In the Site Collection Features don't available Report Server Integration
> > Feature in the list.
> > Anybody have information for resolving this issue?
> >
> > Thanks!
> > Andrey.
> >
>|||Have you added the Reporting Services document types to the document
library? If so are you getting an error when you try and add a new web part
of that type?
If you have NOT added the document types to the library yet you'll need to
do that. Follow the instructions here to do that:
http://msdn2.microsoft.com/en-us/library/bb326289.aspx
If you are getting an error then you'll need to configure kerberos
authentication correctly as that is most likely the issue.
Information on Security for SharePoint / SRS can be found here:
http://msdn2.microsoft.com/en-us/library/bb283324.aspx
--
Chris Alton, Microsoft Corp.
SQL Server Developer Support Engineer
This posting is provided "AS IS" with no warranties, and confers no rights.
--
> Thread-Topic: Reporting Services Add-in for SharePoint
> thread-index: AcgPE/euns22EAknRFev2m4IIhd8hg==> X-WBNR-Posting-Host: 207.46.19.168
> From: =?Utf-8?B?QW5kcmV5IFZhc3lsZW5rbw==?=<AndreyVasylenko@.discussions.microsoft.com>
> References: <09F5E9F6-48FA-4609-875D-9910C0251A9D@.microsoft.com>
<Ua5D1lPDIHA.5712@.TK2MSFTNGHUB02.phx.gbl>
> Subject: RE: Reporting Services Add-in for SharePoint
> Date: Mon, 15 Oct 2007 03:13:01 -0700
> Hi , Chris!
> That add-in has installed already. In Central Admin page I can modify
> Integration faetures. But on the sites I can't create reports using
Report
> Model and Report Builder.
> WBR, Andrey.
> "Chris Alton [MSFT]" wrote:
> > You need to install the Reporting Services Add-in for SharePoint. This
can
> > be found here:
> >
> >
http://www.microsoft.com/downloads/details.aspx?FamilyID=1e53f882-0c16-4847-
> > b331-132274ae8c84&DisplayLang=en
> >
> > Once you install that the Integration Features will show up in Central
> > Admin.
> > --
> > Chris Alton, Microsoft Corp.
> > SQL Server Developer Support Engineer
> > This posting is provided "AS IS" with no warranties, and confers no
rights.
> > --
> > > Thread-Topic: Reporting Services Add-in for SharePoint
> > > thread-index: AcgM9WLa5NLs773ISuSFOI0+e6883w==> > > X-WBNR-Posting-Host: 207.46.193.207
> > > From: =?Utf-8?B?QW5kcmV5IFZhc3lsZW5rbw==?=> > <AndreyVasylenko@.discussions.microsoft.com>
> > > Subject: Reporting Services Add-in for SharePoint
> > > Date: Fri, 12 Oct 2007 10:29:04 -0700
> > >
> > > Hi!
> > > I has added this pack for MOSS2007 server but can't add Reporting
> > Services
> > > web-part in any site.
> > > In the Site Collection Features don't available Report Server
Integration
> > > Feature in the list.
> > > Anybody have information for resolving this issue?
> > >
> > > Thanks!
> > > Andrey.
> > >
> >
> >
>|||Thanks, Chris!
I had reolved this issue and now find information about creating reports in
Builder.
Please, let me know If you have examples of this reports.
WBR, Andrey Vasylenko.
"Chris Alton [MSFT]" wrote:
> Have you added the Reporting Services document types to the document
> library? If so are you getting an error when you try and add a new web part
> of that type?
> If you have NOT added the document types to the library yet you'll need to
> do that. Follow the instructions here to do that:
> http://msdn2.microsoft.com/en-us/library/bb326289.aspx
> If you are getting an error then you'll need to configure kerberos
> authentication correctly as that is most likely the issue.
> Information on Security for SharePoint / SRS can be found here:
> http://msdn2.microsoft.com/en-us/library/bb283324.aspx
> --
> Chris Alton, Microsoft Corp.
> SQL Server Developer Support Engineer
> This posting is provided "AS IS" with no warranties, and confers no rights.
> --
> > Thread-Topic: Reporting Services Add-in for SharePoint
> > thread-index: AcgPE/euns22EAknRFev2m4IIhd8hg==> > X-WBNR-Posting-Host: 207.46.19.168
> > From: =?Utf-8?B?QW5kcmV5IFZhc3lsZW5rbw==?=> <AndreyVasylenko@.discussions.microsoft.com>
> > References: <09F5E9F6-48FA-4609-875D-9910C0251A9D@.microsoft.com>
> <Ua5D1lPDIHA.5712@.TK2MSFTNGHUB02.phx.gbl>
> > Subject: RE: Reporting Services Add-in for SharePoint
> > Date: Mon, 15 Oct 2007 03:13:01 -0700
> >
> > Hi , Chris!
> > That add-in has installed already. In Central Admin page I can modify
> > Integration faetures. But on the sites I can't create reports using
> Report
> > Model and Report Builder.
> >
> > WBR, Andrey.
> >
> > "Chris Alton [MSFT]" wrote:
> >
> > > You need to install the Reporting Services Add-in for SharePoint. This
> can
> > > be found here:
> > >
> > >
> http://www.microsoft.com/downloads/details.aspx?FamilyID=1e53f882-0c16-4847-
> > > b331-132274ae8c84&DisplayLang=en
> > >
> > > Once you install that the Integration Features will show up in Central
> > > Admin.
> > > --
> > > Chris Alton, Microsoft Corp.
> > > SQL Server Developer Support Engineer
> > > This posting is provided "AS IS" with no warranties, and confers no
> rights.
> > > --
> > > > Thread-Topic: Reporting Services Add-in for SharePoint
> > > > thread-index: AcgM9WLa5NLs773ISuSFOI0+e6883w==> > > > X-WBNR-Posting-Host: 207.46.193.207
> > > > From: =?Utf-8?B?QW5kcmV5IFZhc3lsZW5rbw==?=> > > <AndreyVasylenko@.discussions.microsoft.com>
> > > > Subject: Reporting Services Add-in for SharePoint
> > > > Date: Fri, 12 Oct 2007 10:29:04 -0700
> > > >
> > > > Hi!
> > > > I has added this pack for MOSS2007 server but can't add Reporting
> > > Services
> > > > web-part in any site.
> > > > In the Site Collection Features don't available Report Server
> Integration
> > > > Feature in the list.
> > > > Anybody have information for resolving this issue?
> > > >
> > > > Thanks!
> > > > Andrey.
> > > >
> > >
> > >
> >
>|||Check this link here:
http://msdn2.microsoft.com/en-us/library/ms155933.aspx
It generalizes what Report Builder does and has links at the bottom on how
to generate report models and so forth.
At the bottom you'll see a "Note:" section.
The short of it is hit F1 once Report Builder loads up and there should be
some information on how to use it to build reports.
--
Chris Alton, Microsoft Corp.
SQL Server Developer Support Engineer
This posting is provided "AS IS" with no warranties, and confers no rights.
--
> Thread-Topic: Reporting Services Add-in for SharePoint
> thread-index: AcgQqsVZxwi6kwH5RtOJSnWFZIMZbg==> X-WBNR-Posting-Host: 207.46.19.197
> From: =?Utf-8?B?QW5kcmV5IFZhc3lsZW5rbw==?=<AndreyVasylenko@.discussions.microsoft.com>
> Thanks, Chris!
> I had reolved this issue and now find information about creating reports
in
> Builder.
> Please, let me know If you have examples of this reports.
> WBR, Andrey Vasylenko.
> "Chris Alton [MSFT]" wrote:
> > Have you added the Reporting Services document types to the document
> > library? If so are you getting an error when you try and add a new web
part
> > of that type?
> >
> > If you have NOT added the document types to the library yet you'll need
to
> > do that. Follow the instructions here to do that:
> >
> > http://msdn2.microsoft.com/en-us/library/bb326289.aspx
> >
> > If you are getting an error then you'll need to configure kerberos
> > authentication correctly as that is most likely the issue.
> >
> > Information on Security for SharePoint / SRS can be found here:
> >
> > http://msdn2.microsoft.com/en-us/library/bb283324.aspx
> >
> > --
> > Chris Alton, Microsoft Corp.
> > SQL Server Developer Support Engineer
> > This posting is provided "AS IS" with no warranties, and confers no
rights.
> > --|||Hi, Chris!
Thanks for information!
I has created report in SQL Server BID Studio then uploaded it in MOSS 2007
library under System account. Now I can view report trough Report Viewer
fine!
Unfortunately under any other account (even with admin permissions in
MOOS2007 and SQL 2005) in Report Viever I got error:
--
An error has occurred during report processing.
Cannot create a connection to data source 'DataSource1'.
Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.
--
At SQL server I got next error
--
Failure Audit:
Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'. [CLIENT: 192.168.33.38]
--
Did you know resolving this issue?
Now 1-st server SQL 2005 SP2 with all DBs (including RS Add-in created) and
2-nd with MOSS2007 and Reporting Services Add-in.
Thanks!
WBR, Andrey Vasylenko.
"Chris Alton [MSFT]" wrote:
> Check this link here:
> http://msdn2.microsoft.com/en-us/library/ms155933.aspx
> It generalizes what Report Builder does and has links at the bottom on how
> to generate report models and so forth.
> At the bottom you'll see a "Note:" section.
> The short of it is hit F1 once Report Builder loads up and there should be
> some information on how to use it to build reports.
> --
> Chris Alton, Microsoft Corp.
> SQL Server Developer Support Engineer
> This posting is provided "AS IS" with no warranties, and confers no rights.
> --
> > Thread-Topic: Reporting Services Add-in for SharePoint
> > thread-index: AcgQqsVZxwi6kwH5RtOJSnWFZIMZbg==> > X-WBNR-Posting-Host: 207.46.19.197
> > From: =?Utf-8?B?QW5kcmV5IFZhc3lsZW5rbw==?=> <AndreyVasylenko@.discussions.microsoft.com>
> >
> > Thanks, Chris!
> > I had reolved this issue and now find information about creating reports
> in
> > Builder.
> > Please, let me know If you have examples of this reports.
> >
> > WBR, Andrey Vasylenko.
> >
> > "Chris Alton [MSFT]" wrote:
> >
> > > Have you added the Reporting Services document types to the document
> > > library? If so are you getting an error when you try and add a new web
> part
> > > of that type?
> > >
> > > If you have NOT added the document types to the library yet you'll need
> to
> > > do that. Follow the instructions here to do that:
> > >
> > > http://msdn2.microsoft.com/en-us/library/bb326289.aspx
> > >
> > > If you are getting an error then you'll need to configure kerberos
> > > authentication correctly as that is most likely the issue.
> > >
> > > Information on Security for SharePoint / SRS can be found here:
> > >
> > > http://msdn2.microsoft.com/en-us/library/bb283324.aspx
> > >
> > > --
> > > Chris Alton, Microsoft Corp.
> > > SQL Server Developer Support Engineer
> > > This posting is provided "AS IS" with no warranties, and confers no
> rights.
> > > --
>|||That most likely means you have anonymous access turned on for one of your
IIS web sites somewhere. Reporting Services and SharePoint integration
requires Windows Integrated or Forms Authentication for the integration to
function properly.
Also, you have "Windows Integrated Security" turned on for your Report Data
Source which is getting the credentials from IIS (which is the anonymous
account) and that is why you are seeing the NT Authority user come up. If
you want you can change your data source to use "Credentials Stored
Securely in the Report Server" and specify some windows creds or SQL Auth
to pass to the data source instead of trying to pass the credentials.
--
Chris Alton, Microsoft Corp.
SQL Server Developer Support Engineer
This posting is provided "AS IS" with no warranties, and confers no rights.
--
> Thread-Topic: Reporting Services Add-in for SharePoint
> thread-index: AcgReRr0cB6fW03jTR+VczmGe+LfEQ==> X-WBNR-Posting-Host: 207.46.19.197
> From: =?Utf-8?B?QW5kcmV5IFZhc3lsZW5rbw==?=<AndreyVasylenko@.discussions.microsoft.com>
> References: <09F5E9F6-48FA-4609-875D-9910C0251A9D@.microsoft.com>
<Ua5D1lPDIHA.5712@.TK2MSFTNGHUB02.phx.gbl>
<F745C498-D926-44F7-B253-5096012D5D8C@.microsoft.com>
<1UYT0hyDIHA.5712@.TK2MSFTNGHUB02.phx.gbl>
<A9D4F711-EB48-4022-922D-00255577E855@.microsoft.com>
<zHfxAKMEIHA.4200@.TK2MSFTNGHUB02.phx.gbl>
> Subject: RE: Reporting Services Add-in for SharePoint
> Date: Thu, 18 Oct 2007 04:22:02 -0700
> Hi, Chris!
> Thanks for information!
> I has created report in SQL Server BID Studio then uploaded it in MOSS
2007
> library under System account. Now I can view report trough Report Viewer
> fine!
> Unfortunately under any other account (even with admin permissions in
> MOOS2007 and SQL 2005) in Report Viever I got error:
> --
> An error has occurred during report processing.
> Cannot create a connection to data source 'DataSource1'.
> Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.
> --
> At SQL server I got next error
> --
> Failure Audit:
> Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'. [CLIENT:
192.168.33.38]
> --
> Did you know resolving this issue?
> Now 1-st server SQL 2005 SP2 with all DBs (including RS Add-in created)
and
> 2-nd with MOSS2007 and Reporting Services Add-in.
> Thanks!
> WBR, Andrey Vasylenko.
>
>
> "Chris Alton [MSFT]" wrote:
> > Check this link here:
> > http://msdn2.microsoft.com/en-us/library/ms155933.aspx
> >
> > It generalizes what Report Builder does and has links at the bottom on
how
> > to generate report models and so forth.
> >
> > At the bottom you'll see a "Note:" section.
> >
> > The short of it is hit F1 once Report Builder loads up and there should
be
> > some information on how to use it to build reports.
> > --
> > Chris Alton, Microsoft Corp.
> > SQL Server Developer Support Engineer
> > This posting is provided "AS IS" with no warranties, and confers no
rights.
> > --
> > > Thread-Topic: Reporting Services Add-in for SharePoint
> > > thread-index: AcgQqsVZxwi6kwH5RtOJSnWFZIMZbg==> > > X-WBNR-Posting-Host: 207.46.19.197
> > > From: =?Utf-8?B?QW5kcmV5IFZhc3lsZW5rbw==?=> > <AndreyVasylenko@.discussions.microsoft.com>
> > >
> > > Thanks, Chris!
> > > I had reolved this issue and now find information about creating
reports
> > in
> > > Builder.
> > > Please, let me know If you have examples of this reports.
> > >
> > > WBR, Andrey Vasylenko.
> > >
> > > "Chris Alton [MSFT]" wrote:
> > >
> > > > Have you added the Reporting Services document types to the
document
> > > > library? If so are you getting an error when you try and add a new
web
> > part
> > > > of that type?
> > > >
> > > > If you have NOT added the document types to the library yet you'll
need
> > to
> > > > do that. Follow the instructions here to do that:
> > > >
> > > > http://msdn2.microsoft.com/en-us/library/bb326289.aspx
> > > >
> > > > If you are getting an error then you'll need to configure kerberos
> > > > authentication correctly as that is most likely the issue.
> > > >
> > > > Information on Security for SharePoint / SRS can be found here:
> > > >
> > > > http://msdn2.microsoft.com/en-us/library/bb283324.aspx
> > > >
> > > > --
> > > > Chris Alton, Microsoft Corp.
> > > > SQL Server Developer Support Engineer
> > > > This posting is provided "AS IS" with no warranties, and confers no
> > rights.
> > > > --
> >
> >
>

Reporting Services Add In

I am attempting to set up SharePoint and Reporting Services to run in
Integrated mode. I have successfully in stalled MOSS 2007 and Reporting
Services. I've installed SP2 for SQL Server and configured Reporting Services
to run in Integrated mode.
For some reason I cannot get the Reportnig Services add on for Sharepoint to
install. It gets to the very end of the installation and then performs a
rollback. I'm logged on as an Administrator. My user is also a farm
administrator. All the prereq's are installed.
The ONLY error I find in Even Viewer is the generic 11708 "failed to
install" error.
Has anyone else encountered this? If so, how did you resolve the issue?
Thanks!Check the log file at:
C:\Documents and Settings\[username]]\Local Settings\Temp\RS_SP_0.log
"A. Robinson" <ARobinson@.discussions.microsoft.com> wrote in message
news:2F9CDC1A-35C4-47D6-A81B-40594AA9A9F6@.microsoft.com...
>I am attempting to set up SharePoint and Reporting Services to run in
> Integrated mode. I have successfully in stalled MOSS 2007 and Reporting
> Services. I've installed SP2 for SQL Server and configured Reporting
> Services
> to run in Integrated mode.
> For some reason I cannot get the Reportnig Services add on for Sharepoint
> to
> install. It gets to the very end of the installation and then performs a
> rollback. I'm logged on as an Administrator. My user is also a farm
> administrator. All the prereq's are installed.
> The ONLY error I find in Even Viewer is the generic 11708 "failed to
> install" error.
> Has anyone else encountered this? If so, how did you resolve the issue?
> Thanks!
>

Reporting Services 2005 in SharePoint Integrated mode with formsauthentication problem

Well, I have reporting services 2005 installed and configured in
sharepoint integrated mode, so I am deploying reports in sharepoint
libraries. After that I configured sharepoint to use forms
authentication with builtin AspNetSqlMembership provider, but this
action caused reports to not execute. I searched and found hotfix 3186
for this issue and applied it, but nothing has changed!
Error I have been experiencing is following:
An unexpected error occurred while connecting to the report server.
Verify that the report server is available and configured for
SharePoint integrated mode. --> The request failed with the error
message:
<html><head><title>Object moved</title></head><body>
<h2>Object moved to <a href="http://links.10026.com/?link=/_layouts/login.aspx?ReturnUrl=
%2f_vti_bin
%2fReportServer%2fReportService2006.asmx">here</a>.</h2>
</body></html>
anyone can help? maybe i have not configured something correctly...
Irakli
It would be better of you post that question in .reportrtingsvcs or
sharepoint user group.
"Irakli" <Irakli.Rostiashvili@.gmail.com> wrote in message
news:5e330a25-f9bb-4657-9e26-e00a0ab96f6f@.m34g2000hsf.googlegroups.com...
> Well, I have reporting services 2005 installed and configured in
> sharepoint integrated mode, so I am deploying reports in sharepoint
> libraries. After that I configured sharepoint to use forms
> authentication with builtin AspNetSqlMembership provider, but this
> action caused reports to not execute. I searched and found hotfix 3186
> for this issue and applied it, but nothing has changed!
> Error I have been experiencing is following:
> An unexpected error occurred while connecting to the report server.
> Verify that the report server is available and configured for
> SharePoint integrated mode. --> The request failed with the error
> message:
> --
> <html><head><title>Object moved</title></head><body>
> <h2>Object moved to <a href="http://links.10026.com/?link=/_layouts/login.aspx?ReturnUrl=
> %2f_vti_bin
> %2fReportServer%2fReportService2006.asmx">here</a>.</h2>
> </body></html>
> anyone can help? maybe i have not configured something correctly...

Reporting Services 2005 in SharePoint Integrated mode with forms

Well, I have reporting services 2005 installed and configured in
sharepoint integrated mode, so I am deploying reports in sharepoint
libraries. After that I configured sharepoint to use forms
authentication with builtin AspNetSqlMembership provider, but this
action caused reports to not execute. I searched and found hotfix 3186
for this issue and applied it, but nothing has changed!
Error I have been experiencing is following:
An unexpected error occurred while connecting to the report server.
Verify that the report server is available and configured for
SharePoint integrated mode. --> The request failed with the error
message:
--
<html><head><title>Object moved</title></head><body>
<h2>Object moved to <a href="http://links.10026.com/?link=/_layouts/login.aspx?ReturnUrl= %2f_vti_bin
%2fReportServer%2fReportService2006.asmx">here</a>.</h2>
</body></html>
anyone can help? maybe i have not configured something correctly...Irakli
It would be better of you post that question in .reportrtingsvcs or
sharepoint user group.
"Irakli" <Irakli.Rostiashvili@.gmail.com> wrote in message
news:5e330a25-f9bb-4657-9e26-e00a0ab96f6f@.m34g2000hsf.googlegroups.com...
> Well, I have reporting services 2005 installed and configured in
> sharepoint integrated mode, so I am deploying reports in sharepoint
> libraries. After that I configured sharepoint to use forms
> authentication with builtin AspNetSqlMembership provider, but this
> action caused reports to not execute. I searched and found hotfix 3186
> for this issue and applied it, but nothing has changed!
> Error I have been experiencing is following:
> An unexpected error occurred while connecting to the report server.
> Verify that the report server is available and configured for
> SharePoint integrated mode. --> The request failed with the error
> message:
> --
> <html><head><title>Object moved</title></head><body>
> <h2>Object moved to <a href="http://links.10026.com/?link=/_layouts/login.aspx?ReturnUrl=> %2f_vti_bin
> %2fReportServer%2fReportService2006.asmx">here</a>.</h2>
> </body></html>
> anyone can help? maybe i have not configured something correctly...

Reporting Services 2005 and Windows Sharepoint Services

Hi,

I have a small dilemma; is it possible to install WSS on the same server as SQL Server 2005?

We building a portal using SQL Server / RS 2005 and the idea is to use WSS as the base. The problem is that WSS uses .NET 1.0 and SQL 2005 uses .NET 2.0. And they doesn't seem to work together.

Is there a workaround, I have searched the net and there are people saying they are running this configuration but havn't been able to find out how to accomplish it.

Anyone who has done this?There is a section in the SQL 2005 online docs about getting this to work. Basically, you need to create a seperate app pool run run RS as well as exclude the /reports and /reportserver paths in the SharePoint admin.
In the RTM build of SQL 2005, this configuration will work "out of the box".

Reporting Services 2000 and Sharepoint - Help Please

I am so lost....
Ok, I need to install reporting services so we can use build reports
with sharepoint. Our server model looks like.
Server 1 - Sharepoint
Server 2 - Sharepoint Database
Where do I need to install reporting services.. on server 1 or server
2?. Then, I am going to install Reporting Services Service Pack 2,
whch has web parts for sharepoint, so I am assuming that I need to
install RS on Server 1.
The documentation from MS is..well.. not so easy to follow. Anyone
done this before?
Thanks,
-SJHi,
you didn't say which version of sharepoint you use..
I have setyp and used RS 2000/2005 with all version of sharepoint and it's
almost the same configuration.
Have you checked out this link?
Configuring Reporting Services for SharePoint 3.0 Integration
http://technet.microsoft.com/en-us/library/bb326356(SQL.90).aspx
You will find the answers there i think.
Please let me know!
/Daniel Bugday
"SJ" <sjourdan@.gmail.com> wrote in message
news:1181235193.094940.183890@.h2g2000hsg.googlegroups.com...
>I am so lost....
> Ok, I need to install reporting services so we can use build reports
> with sharepoint. Our server model looks like.
> Server 1 - Sharepoint
> Server 2 - Sharepoint Database
> Where do I need to install reporting services.. on server 1 or server
> 2?. Then, I am going to install Reporting Services Service Pack 2,
> whch has web parts for sharepoint, so I am assuming that I need to
> install RS on Server 1.
> The documentation from MS is..well.. not so easy to follow. Anyone
> done this before?
> Thanks,
> -SJ
>|||On Jun 7, 12:09 pm, "Daniel Bugday" <itkons...@.gmail.com> wrote:
> Hi,
> you didn't say which version of sharepoint you use..
> I have setyp and used RS 2000/2005 with all version of sharepoint and it's
> almost the same configuration.
> Have you checked out this link?
> Configuring Reporting Services for SharePoint 3.0 Integrationhttp://technet.microsoft.com/en-us/library/bb326356(SQL.90).aspx
> You will find the answers there i think.
> Please let me know!
> /Daniel Bugday
> "SJ" <sjour...@.gmail.com> wrote in message
> news:1181235193.094940.183890@.h2g2000hsg.googlegroups.com...
>
> >I am so lost....
> > Ok, I need to install reporting services so we can use build reports
> > with sharepoint. Our server model looks like.
> > Server 1 - Sharepoint
> > Server 2 - Sharepoint Database
> > Where do I need to install reporting services.. on server 1 or server
> > 2?. Then, I am going to install Reporting Services Service Pack 2,
> > whch has web parts for sharepoint, so I am assuming that I need to
> > install RS on Server 1.
> > The documentation from MS is..well.. not so easy to follow. Anyone
> > done this before?
> > Thanks,
> > -SJ- Hide quoted text -
> - Show quoted text -
Thank you very much for your reply!

Reporting Services & Sharepoint

Greetings all,
Can anyone point me to information regarding the integration of RS reports
into SP? I am wondering what the recommended practice has been so far, is
anyone even doing this? The product site for RS mentions SP, but I am
unable to find any good examples of this.
Anyone working with these two services in an enterprise environment? How
are you finding RS for analytical reporting?
thanks,
JDI believe that RS SP2 will have SharePoint integration. Some mention of it
is here -
http://weblogs.asp.net/Mat_Stephen/archive/2004/12/20/327323.aspx
SBC
"Joe Dirt" <veganopolis@.spam_is_for_jerks_gmail.com> wrote in message
news:pan.2004.10.21.10.53.10.847905@.spam_is_for_jerks_gmail.com...
> Greetings all,
> Can anyone point me to information regarding the integration of RS reports
> into SP? I am wondering what the recommended practice has been so far, is
> anyone even doing this? The product site for RS mentions SP, but I am
> unable to find any good examples of this.
> Anyone working with these two services in an enterprise environment? How
> are you finding RS for analytical reporting?
> thanks,
> JD
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.818 / Virus Database: 556 - Release Date: 12/17/2004|||You may also try googling "Reporting Services Web Parts" for this. Bryant
Likes and I have both done some work on this, but Bryant's components are
available for download, and I think he's added features .
--
Jay Nathan
http://www.jaynathan.com/blog
"c1sbc" <c1sbc@.comcast.net> wrote in message
news:uWAgsEq5EHA.2012@.TK2MSFTNGP15.phx.gbl...
> I believe that RS SP2 will have SharePoint integration. Some mention of it
> is here -
> http://weblogs.asp.net/Mat_Stephen/archive/2004/12/20/327323.aspx
> SBC
>
> "Joe Dirt" <veganopolis@.spam_is_for_jerks_gmail.com> wrote in message
> news:pan.2004.10.21.10.53.10.847905@.spam_is_for_jerks_gmail.com...
> > Greetings all,
> >
> > Can anyone point me to information regarding the integration of RS
reports
> > into SP? I am wondering what the recommended practice has been so far,
is
> > anyone even doing this? The product site for RS mentions SP, but I am
> > unable to find any good examples of this.
> >
> > Anyone working with these two services in an enterprise environment? How
> > are you finding RS for analytical reporting?
> >
> > thanks,
> > JD
>
> --
> Outgoing mail is certified Virus Free.
> Checked by AVG anti-virus system (http://www.grisoft.com).
> Version: 6.0.818 / Virus Database: 556 - Release Date: 12/17/2004
>

Reporting on Sharepoint Lists?

I was wondering if it would be possible to generate reports directly from
Windows Sharepoint Services (WSS) Lists or from the output of a Webservice?
tnx
-= Maximizing Creativity and Productivity =-Dear Maarten
Yes, you can generate a report from data of WSS - although it is a bit of a
guesswork. WSS saves all user data in one table only (called UserData). You
will have to filter the right data from this table. In order to know what to
filter, you will have to identify the tp_ListId (uniqueidentifier) of the
WSS-List on which you want to base your report. In order to find this
tp_ListId you have to search first in the Sites table for the tp_ID of the
site. With this ID you can look up the tp_ID of the subweb in the Webs table.
And finally, with the ID of the subweb you can look up the ID of the WSS list
in the Lists table.
The next step will be to identify the fields for the identified list. There
is only one way: make a print screen from the WSS-list and scroll the list
date in the UserData table in order to find the fields that store the WSS
list data.
Furthermore, I have found it easiest to define different views on the
UserData table and to work with this views in Reporting Services (not
directly with the UserData table). In the view, you can rename the fields of
the UserData table with aliases that are the names of the columns of the WSS
list.
A last hint: you can display reports in WSS. Just define a WSS page with a
webpart aerea and give this webpart the reportserver link of the report you
want to show. It works fine.
Good luck - Judith Schuetz (www.osn.ch)
"Maarten Visser" wrote:
> I was wondering if it would be possible to generate reports directly from
> Windows Sharepoint Services (WSS) Lists or from the output of a Webservice?
> tnx
> -= Maximizing Creativity and Productivity =-|||Judith.
Thanks for the information, I understand your solution.
But, like you are saying.. ' It is a bit of a guesswork'.
I have to build a solution for a customer, where end users have to build
reports and the manipulation of data has to be as easy as possible. Because
of this, i was thinking to use WSS as a front-end for data input and
Reporting Services for generating reports on this data.
I'm afraid the given solution would not work in this case, because the user
needs to be able to add columns (in WSS) and the report should than easily be
adapted by the user to show this column. (It would be best if the report
automatically showed the extra column).
Could the ADO.Net extensibility of Reporting Services do something here..
Would it be possible to build a webservice that gets the information from
Sharepoint and let Reporting Services build reports based on the data (rows)
that this webservice provides?
Tnx.
Maarten
I'm afraid the given solution would not work in this case, because the user
needs to be able to add columns and the report should than easely be adapted
by the user to show this column. (It would be best if the report
automatecally showed the extra column).
"j schuetz" wrote:
> Dear Maarten
> Yes, you can generate a report from data of WSS - although it is a bit of a
> guesswork. WSS saves all user data in one table only (called UserData). You
> will have to filter the right data from this table. In order to know what to
> filter, you will have to identify the tp_ListId (uniqueidentifier) of the
> WSS-List on which you want to base your report. In order to find this
> tp_ListId you have to search first in the Sites table for the tp_ID of the
> site. With this ID you can look up the tp_ID of the subweb in the Webs table.
> And finally, with the ID of the subweb you can look up the ID of the WSS list
> in the Lists table.
> The next step will be to identify the fields for the identified list. There
> is only one way: make a print screen from the WSS-list and scroll the list
> date in the UserData table in order to find the fields that store the WSS
> list data.
> Furthermore, I have found it easiest to define different views on the
> UserData table and to work with this views in Reporting Services (not
> directly with the UserData table). In the view, you can rename the fields of
> the UserData table with aliases that are the names of the columns of the WSS
> list.
> A last hint: you can display reports in WSS. Just define a WSS page with a
> webpart aerea and give this webpart the reportserver link of the report you
> want to show. It works fine.
> Good luck - Judith Schuetz (www.osn.ch)
>
> "Maarten Visser" wrote:
> >
> > I was wondering if it would be possible to generate reports directly from
> > Windows Sharepoint Services (WSS) Lists or from the output of a Webservice?
> >
> > tnx
> >
> > -= Maximizing Creativity and Productivity =-|||Sorry - I can't help you with this one.
"Maarten Visser" wrote:
> Judith.
> Thanks for the information, I understand your solution.
> But, like you are saying.. ' It is a bit of a guesswork'.
> I have to build a solution for a customer, where end users have to build
> reports and the manipulation of data has to be as easy as possible. Because
> of this, i was thinking to use WSS as a front-end for data input and
> Reporting Services for generating reports on this data.
> I'm afraid the given solution would not work in this case, because the user
> needs to be able to add columns (in WSS) and the report should than easily be
> adapted by the user to show this column. (It would be best if the report
> automatically showed the extra column).
> Could the ADO.Net extensibility of Reporting Services do something here..
> Would it be possible to build a webservice that gets the information from
> Sharepoint and let Reporting Services build reports based on the data (rows)
> that this webservice provides?
> Tnx.
> Maarten
>
> I'm afraid the given solution would not work in this case, because the user
> needs to be able to add columns and the report should than easely be adapted
> by the user to show this column. (It would be best if the report
> automatecally showed the extra column).
>
> "j schuetz" wrote:
> > Dear Maarten
> >
> > Yes, you can generate a report from data of WSS - although it is a bit of a
> > guesswork. WSS saves all user data in one table only (called UserData). You
> > will have to filter the right data from this table. In order to know what to
> > filter, you will have to identify the tp_ListId (uniqueidentifier) of the
> > WSS-List on which you want to base your report. In order to find this
> > tp_ListId you have to search first in the Sites table for the tp_ID of the
> > site. With this ID you can look up the tp_ID of the subweb in the Webs table.
> > And finally, with the ID of the subweb you can look up the ID of the WSS list
> > in the Lists table.
> >
> > The next step will be to identify the fields for the identified list. There
> > is only one way: make a print screen from the WSS-list and scroll the list
> > date in the UserData table in order to find the fields that store the WSS
> > list data.
> >
> > Furthermore, I have found it easiest to define different views on the
> > UserData table and to work with this views in Reporting Services (not
> > directly with the UserData table). In the view, you can rename the fields of
> > the UserData table with aliases that are the names of the columns of the WSS
> > list.
> >
> > A last hint: you can display reports in WSS. Just define a WSS page with a
> > webpart aerea and give this webpart the reportserver link of the report you
> > want to show. It works fine.
> >
> > Good luck - Judith Schuetz (www.osn.ch)
> >
> >
> > "Maarten Visser" wrote:
> >
> > >
> > > I was wondering if it would be possible to generate reports directly from
> > > Windows Sharepoint Services (WSS) Lists or from the output of a Webservice?
> > >
> > > tnx
> > >
> > > -= Maximizing Creativity and Productivity =-|||This is a fragment from a sp I wrote for a customer that ought to get you
started...
declare @.tbl table(DisplayName varchar(100), ColName varchar(100), List
varchar(20), ShowFld varchar(100))
select top 1 @.flds=cast(tp_Fields as varchar(8000))
from dbo.Lists
where <-- some selection clause -->
select @.flds = '<root>'+@.flds+'</root>' -- surround field list with top
level node, otherwise DOM throws error
exec sp_xml_preparedocument @.hnd output, @.flds
insert into @.tbl
select *
from openxml(@.hnd, N'/root/Field') with (DisplayName varchar(100), ColName
varchar(100), List varchar(20), ShowField varchar(100))
where DisplayName is not null
exec sp_xml_removedocument @.hnd
select @.cmd='select "ID"=ud.tp_ID, Created=ud.tp_Created,
Modified=ud.tp_Modified, Author=u1.tp_Title'
declare crs cursor for select DisplayName, ColName, List, ShowFld from @.tbl
open crs
fetch next from crs into @.name, @.colname, @.list, @.showfld
select @.joinum=2, @.join=''
while @.@.fetch_status = 0
begin
if @.list is not NULL -- if this is a userlist field, join in the list and
return the value (not the list id)
begin
select @.alias = 'u'+cast(@.joinum as varchar(3))
select @.join=@.join+' join dbo.'+@.list+' '+@.alias+' on
(ud.'+@.colname+'='+@.alias+'.tp_ID and ud.tp_Siteid='+@.alias+'.tp_SiteID)'
select @.cmd=@.cmd+', '''+@.name+'''='+@.alias+'.tp_'+@.showfld
select @.joinum=@.joinum+1
end
else
begin
if left(@.colname, 5) = 'ntext' select @.colname = 'cast('+@.colname+' as
varchar('+cast(@.txtlen as varchar(4))+'))'
select @.cmd=@.cmd+', '''+@.name+'''='+@.colname
end
fetch next from crs into @.name, @.colname, @.list, @.showfld
end
close crs
deallocate crs
select @.cmd=@.cmd+' from dbo.UserData ud join dbo.UserInfo u1 on
(ud.tp_Author=u1.tp_ID and ud.tp_Siteid=u1.tp_SiteID) '+@.join
select @.cmd=@.cmd+' order by ud.tp_ID'
Cheers
Mitch
"j schuetz" wrote:
> Sorry - I can't help you with this one.
> "Maarten Visser" wrote:
> > Judith.
> >
> > Thanks for the information, I understand your solution.
> > But, like you are saying.. ' It is a bit of a guesswork'.
> >
> > I have to build a solution for a customer, where end users have to build
> > reports and the manipulation of data has to be as easy as possible. Because
> > of this, i was thinking to use WSS as a front-end for data input and
> > Reporting Services for generating reports on this data.
> >
> > I'm afraid the given solution would not work in this case, because the user
> > needs to be able to add columns (in WSS) and the report should than easily be
> > adapted by the user to show this column. (It would be best if the report
> > automatically showed the extra column).
> >
> > Could the ADO.Net extensibility of Reporting Services do something here..
> > Would it be possible to build a webservice that gets the information from
> > Sharepoint and let Reporting Services build reports based on the data (rows)
> > that this webservice provides?
> >
> > Tnx.
> > Maarten
> >
> >
> > I'm afraid the given solution would not work in this case, because the user
> > needs to be able to add columns and the report should than easely be adapted
> > by the user to show this column. (It would be best if the report
> > automatecally showed the extra column).
> >
> >
> >
> > "j schuetz" wrote:
> >
> > > Dear Maarten
> > >
> > > Yes, you can generate a report from data of WSS - although it is a bit of a
> > > guesswork. WSS saves all user data in one table only (called UserData). You
> > > will have to filter the right data from this table. In order to know what to
> > > filter, you will have to identify the tp_ListId (uniqueidentifier) of the
> > > WSS-List on which you want to base your report. In order to find this
> > > tp_ListId you have to search first in the Sites table for the tp_ID of the
> > > site. With this ID you can look up the tp_ID of the subweb in the Webs table.
> > > And finally, with the ID of the subweb you can look up the ID of the WSS list
> > > in the Lists table.
> > >
> > > The next step will be to identify the fields for the identified list. There
> > > is only one way: make a print screen from the WSS-list and scroll the list
> > > date in the UserData table in order to find the fields that store the WSS
> > > list data.
> > >
> > > Furthermore, I have found it easiest to define different views on the
> > > UserData table and to work with this views in Reporting Services (not
> > > directly with the UserData table). In the view, you can rename the fields of
> > > the UserData table with aliases that are the names of the columns of the WSS
> > > list.
> > >
> > > A last hint: you can display reports in WSS. Just define a WSS page with a
> > > webpart aerea and give this webpart the reportserver link of the report you
> > > want to show. It works fine.
> > >
> > > Good luck - Judith Schuetz (www.osn.ch)
> > >
> > >
> > > "Maarten Visser" wrote:
> > >
> > > >
> > > > I was wondering if it would be possible to generate reports directly from
> > > > Windows Sharepoint Services (WSS) Lists or from the output of a Webservice?
> > > >
> > > > tnx
> > > >
> > > > -= Maximizing Creativity and Productivity =-|||I was negligent in noting that;
This posting is provided "AS IS" with no warranties, and confers no rights.
Now that the lawyers are happy - have fun... :-)
"Mitch vH [MSFT]" wrote:
> This is a fragment from a sp I wrote for a customer that ought to get you
> started...
> declare @.tbl table(DisplayName varchar(100), ColName varchar(100), List
> varchar(20), ShowFld varchar(100))
> select top 1 @.flds=cast(tp_Fields as varchar(8000))
> from dbo.Lists
> where <-- some selection clause -->
> select @.flds = '<root>'+@.flds+'</root>' -- surround field list with top
> level node, otherwise DOM throws error
> exec sp_xml_preparedocument @.hnd output, @.flds
> insert into @.tbl
> select *
> from openxml(@.hnd, N'/root/Field') with (DisplayName varchar(100), ColName
> varchar(100), List varchar(20), ShowField varchar(100))
> where DisplayName is not null
> exec sp_xml_removedocument @.hnd
> select @.cmd='select "ID"=ud.tp_ID, Created=ud.tp_Created,
> Modified=ud.tp_Modified, Author=u1.tp_Title'
> declare crs cursor for select DisplayName, ColName, List, ShowFld from @.tbl
> open crs
> fetch next from crs into @.name, @.colname, @.list, @.showfld
> select @.joinum=2, @.join=''
> while @.@.fetch_status = 0
> begin
> if @.list is not NULL -- if this is a userlist field, join in the list and
> return the value (not the list id)
> begin
> select @.alias = 'u'+cast(@.joinum as varchar(3))
> select @.join=@.join+' join dbo.'+@.list+' '+@.alias+' on
> (ud.'+@.colname+'='+@.alias+'.tp_ID and ud.tp_Siteid='+@.alias+'.tp_SiteID)'
> select @.cmd=@.cmd+', '''+@.name+'''='+@.alias+'.tp_'+@.showfld
> select @.joinum=@.joinum+1
> end
> else
> begin
> if left(@.colname, 5) = 'ntext' select @.colname = 'cast('+@.colname+' as
> varchar('+cast(@.txtlen as varchar(4))+'))'
> select @.cmd=@.cmd+', '''+@.name+'''='+@.colname
> end
> fetch next from crs into @.name, @.colname, @.list, @.showfld
> end
> close crs
> deallocate crs
> select @.cmd=@.cmd+' from dbo.UserData ud join dbo.UserInfo u1 on
> (ud.tp_Author=u1.tp_ID and ud.tp_Siteid=u1.tp_SiteID) '+@.join
> select @.cmd=@.cmd+' order by ud.tp_ID'
> Cheers
> Mitch
> "j schuetz" wrote:
> > Sorry - I can't help you with this one.
> >
> > "Maarten Visser" wrote:
> >
> > > Judith.
> > >
> > > Thanks for the information, I understand your solution.
> > > But, like you are saying.. ' It is a bit of a guesswork'.
> > >
> > > I have to build a solution for a customer, where end users have to build
> > > reports and the manipulation of data has to be as easy as possible. Because
> > > of this, i was thinking to use WSS as a front-end for data input and
> > > Reporting Services for generating reports on this data.
> > >
> > > I'm afraid the given solution would not work in this case, because the user
> > > needs to be able to add columns (in WSS) and the report should than easily be
> > > adapted by the user to show this column. (It would be best if the report
> > > automatically showed the extra column).
> > >
> > > Could the ADO.Net extensibility of Reporting Services do something here..
> > > Would it be possible to build a webservice that gets the information from
> > > Sharepoint and let Reporting Services build reports based on the data (rows)
> > > that this webservice provides?
> > >
> > > Tnx.
> > > Maarten
> > >
> > >
> > > I'm afraid the given solution would not work in this case, because the user
> > > needs to be able to add columns and the report should than easely be adapted
> > > by the user to show this column. (It would be best if the report
> > > automatecally showed the extra column).
> > >
> > >
> > >
> > > "j schuetz" wrote:
> > >
> > > > Dear Maarten
> > > >
> > > > Yes, you can generate a report from data of WSS - although it is a bit of a
> > > > guesswork. WSS saves all user data in one table only (called UserData). You
> > > > will have to filter the right data from this table. In order to know what to
> > > > filter, you will have to identify the tp_ListId (uniqueidentifier) of the
> > > > WSS-List on which you want to base your report. In order to find this
> > > > tp_ListId you have to search first in the Sites table for the tp_ID of the
> > > > site. With this ID you can look up the tp_ID of the subweb in the Webs table.
> > > > And finally, with the ID of the subweb you can look up the ID of the WSS list
> > > > in the Lists table.
> > > >
> > > > The next step will be to identify the fields for the identified list. There
> > > > is only one way: make a print screen from the WSS-list and scroll the list
> > > > date in the UserData table in order to find the fields that store the WSS
> > > > list data.
> > > >
> > > > Furthermore, I have found it easiest to define different views on the
> > > > UserData table and to work with this views in Reporting Services (not
> > > > directly with the UserData table). In the view, you can rename the fields of
> > > > the UserData table with aliases that are the names of the columns of the WSS
> > > > list.
> > > >
> > > > A last hint: you can display reports in WSS. Just define a WSS page with a
> > > > webpart aerea and give this webpart the reportserver link of the report you
> > > > want to show. It works fine.
> > > >
> > > > Good luck - Judith Schuetz (www.osn.ch)
> > > >
> > > >
> > > > "Maarten Visser" wrote:
> > > >
> > > > >
> > > > > I was wondering if it would be possible to generate reports directly from
> > > > > Windows Sharepoint Services (WSS) Lists or from the output of a Webservice?
> > > > >
> > > > > tnx
> > > > >
> > > > > -= Maximizing Creativity and Productivity =-|||I'm reviewing this... sounds promising:
http://www.teuntostring.net/blog/2006/03/update-reporting-over-sharepoint-lists.html
"Maarten Visser" wrote:
> Judith.
> Thanks for the information, I understand your solution.
> But, like you are saying.. ' It is a bit of a guesswork'.
> I have to build a solution for a customer, where end users have to build
> reports and the manipulation of data has to be as easy as possible. Because
> of this, i was thinking to use WSS as a front-end for data input and
> Reporting Services for generating reports on this data.
> I'm afraid the given solution would not work in this case, because the user
> needs to be able to add columns (in WSS) and the report should than easily be
> adapted by the user to show this column. (It would be best if the report
> automatically showed the extra column).
> Could the ADO.Net extensibility of Reporting Services do something here..
> Would it be possible to build a webservice that gets the information from
> Sharepoint and let Reporting Services build reports based on the data (rows)
> that this webservice provides?
> Tnx.
> Maarten
>
> I'm afraid the given solution would not work in this case, because the user
> needs to be able to add columns and the report should than easely be adapted
> by the user to show this column. (It would be best if the report
> automatecally showed the extra column).
>
> "j schuetz" wrote:
> > Dear Maarten
> >
> > Yes, you can generate a report from data of WSS - although it is a bit of a
> > guesswork. WSS saves all user data in one table only (called UserData). You
> > will have to filter the right data from this table. In order to know what to
> > filter, you will have to identify the tp_ListId (uniqueidentifier) of the
> > WSS-List on which you want to base your report. In order to find this
> > tp_ListId you have to search first in the Sites table for the tp_ID of the
> > site. With this ID you can look up the tp_ID of the subweb in the Webs table.
> > And finally, with the ID of the subweb you can look up the ID of the WSS list
> > in the Lists table.
> >
> > The next step will be to identify the fields for the identified list. There
> > is only one way: make a print screen from the WSS-list and scroll the list
> > date in the UserData table in order to find the fields that store the WSS
> > list data.
> >
> > Furthermore, I have found it easiest to define different views on the
> > UserData table and to work with this views in Reporting Services (not
> > directly with the UserData table). In the view, you can rename the fields of
> > the UserData table with aliases that are the names of the columns of the WSS
> > list.
> >
> > A last hint: you can display reports in WSS. Just define a WSS page with a
> > webpart aerea and give this webpart the reportserver link of the report you
> > want to show. It works fine.
> >
> > Good luck - Judith Schuetz (www.osn.ch)
> >
> >
> > "Maarten Visser" wrote:
> >
> > >
> > > I was wondering if it would be possible to generate reports directly from
> > > Windows Sharepoint Services (WSS) Lists or from the output of a Webservice?
> > >
> > > tnx
> > >
> > > -= Maximizing Creativity and Productivity =-|||Do you know if this will be valid for the new version of WSS(v3)?
"Mitch vH [MSFT]" wrote:
> This is a fragment from a sp I wrote for a customer that ought to get you
> started...
> declare @.tbl table(DisplayName varchar(100), ColName varchar(100), List
> varchar(20), ShowFld varchar(100))
> select top 1 @.flds=cast(tp_Fields as varchar(8000))
> from dbo.Lists
> where <-- some selection clause -->
> select @.flds = '<root>'+@.flds+'</root>' -- surround field list with top
> level node, otherwise DOM throws error
> exec sp_xml_preparedocument @.hnd output, @.flds
> insert into @.tbl
> select *
> from openxml(@.hnd, N'/root/Field') with (DisplayName varchar(100), ColName
> varchar(100), List varchar(20), ShowField varchar(100))
> where DisplayName is not null
> exec sp_xml_removedocument @.hnd
> select @.cmd='select "ID"=ud.tp_ID, Created=ud.tp_Created,
> Modified=ud.tp_Modified, Author=u1.tp_Title'
> declare crs cursor for select DisplayName, ColName, List, ShowFld from @.tbl
> open crs
> fetch next from crs into @.name, @.colname, @.list, @.showfld
> select @.joinum=2, @.join=''
> while @.@.fetch_status = 0
> begin
> if @.list is not NULL -- if this is a userlist field, join in the list and
> return the value (not the list id)
> begin
> select @.alias = 'u'+cast(@.joinum as varchar(3))
> select @.join=@.join+' join dbo.'+@.list+' '+@.alias+' on
> (ud.'+@.colname+'='+@.alias+'.tp_ID and ud.tp_Siteid='+@.alias+'.tp_SiteID)'
> select @.cmd=@.cmd+', '''+@.name+'''='+@.alias+'.tp_'+@.showfld
> select @.joinum=@.joinum+1
> end
> else
> begin
> if left(@.colname, 5) = 'ntext' select @.colname = 'cast('+@.colname+' as
> varchar('+cast(@.txtlen as varchar(4))+'))'
> select @.cmd=@.cmd+', '''+@.name+'''='+@.colname
> end
> fetch next from crs into @.name, @.colname, @.list, @.showfld
> end
> close crs
> deallocate crs
> select @.cmd=@.cmd+' from dbo.UserData ud join dbo.UserInfo u1 on
> (ud.tp_Author=u1.tp_ID and ud.tp_Siteid=u1.tp_SiteID) '+@.join
> select @.cmd=@.cmd+' order by ud.tp_ID'
> Cheers
> Mitch
> "j schuetz" wrote:
> > Sorry - I can't help you with this one.
> >
> > "Maarten Visser" wrote:
> >
> > > Judith.
> > >
> > > Thanks for the information, I understand your solution.
> > > But, like you are saying.. ' It is a bit of a guesswork'.
> > >
> > > I have to build a solution for a customer, where end users have to build
> > > reports and the manipulation of data has to be as easy as possible. Because
> > > of this, i was thinking to use WSS as a front-end for data input and
> > > Reporting Services for generating reports on this data.
> > >
> > > I'm afraid the given solution would not work in this case, because the user
> > > needs to be able to add columns (in WSS) and the report should than easily be
> > > adapted by the user to show this column. (It would be best if the report
> > > automatically showed the extra column).
> > >
> > > Could the ADO.Net extensibility of Reporting Services do something here..
> > > Would it be possible to build a webservice that gets the information from
> > > Sharepoint and let Reporting Services build reports based on the data (rows)
> > > that this webservice provides?
> > >
> > > Tnx.
> > > Maarten
> > >
> > >
> > > I'm afraid the given solution would not work in this case, because the user
> > > needs to be able to add columns and the report should than easely be adapted
> > > by the user to show this column. (It would be best if the report
> > > automatecally showed the extra column).
> > >
> > >
> > >
> > > "j schuetz" wrote:
> > >
> > > > Dear Maarten
> > > >
> > > > Yes, you can generate a report from data of WSS - although it is a bit of a
> > > > guesswork. WSS saves all user data in one table only (called UserData). You
> > > > will have to filter the right data from this table. In order to know what to
> > > > filter, you will have to identify the tp_ListId (uniqueidentifier) of the
> > > > WSS-List on which you want to base your report. In order to find this
> > > > tp_ListId you have to search first in the Sites table for the tp_ID of the
> > > > site. With this ID you can look up the tp_ID of the subweb in the Webs table.
> > > > And finally, with the ID of the subweb you can look up the ID of the WSS list
> > > > in the Lists table.
> > > >
> > > > The next step will be to identify the fields for the identified list. There
> > > > is only one way: make a print screen from the WSS-list and scroll the list
> > > > date in the UserData table in order to find the fields that store the WSS
> > > > list data.
> > > >
> > > > Furthermore, I have found it easiest to define different views on the
> > > > UserData table and to work with this views in Reporting Services (not
> > > > directly with the UserData table). In the view, you can rename the fields of
> > > > the UserData table with aliases that are the names of the columns of the WSS
> > > > list.
> > > >
> > > > A last hint: you can display reports in WSS. Just define a WSS page with a
> > > > webpart aerea and give this webpart the reportserver link of the report you
> > > > want to show. It works fine.
> > > >
> > > > Good luck - Judith Schuetz (www.osn.ch)
> > > >
> > > >
> > > > "Maarten Visser" wrote:
> > > >
> > > > >
> > > > > I was wondering if it would be possible to generate reports directly from
> > > > > Windows Sharepoint Services (WSS) Lists or from the output of a Webservice?
> > > > >
> > > > > tnx
> > > > >
> > > > > -= Maximizing Creativity and Productivity =-|||Hi,
In case you are interested, we have developped a Reporting Services Data
Extension for SharePoint. An evaluation version is available on our web site
at http://www.enesyssoftware.com/Default.aspx?tabid=56.
If you would like to develop it from scratch, the article from Teun Duynstee
is surely the way to go.
--
Frederic Latour
Enesys
http://www.enesyssoftware.com
"Bob C." wrote:
> I'm reviewing this... sounds promising:
> http://www.teuntostring.net/blog/2006/03/update-reporting-over-sharepoint-lists.html
> "Maarten Visser" wrote:
> > Judith.
> >
> > Thanks for the information, I understand your solution.
> > But, like you are saying.. ' It is a bit of a guesswork'.
> >
> > I have to build a solution for a customer, where end users have to build
> > reports and the manipulation of data has to be as easy as possible. Because
> > of this, i was thinking to use WSS as a front-end for data input and
> > Reporting Services for generating reports on this data.
> >
> > I'm afraid the given solution would not work in this case, because the user
> > needs to be able to add columns (in WSS) and the report should than easily be
> > adapted by the user to show this column. (It would be best if the report
> > automatically showed the extra column).
> >
> > Could the ADO.Net extensibility of Reporting Services do something here..
> > Would it be possible to build a webservice that gets the information from
> > Sharepoint and let Reporting Services build reports based on the data (rows)
> > that this webservice provides?
> >
> > Tnx.
> > Maarten
> >
> >
> > I'm afraid the given solution would not work in this case, because the user
> > needs to be able to add columns and the report should than easely be adapted
> > by the user to show this column. (It would be best if the report
> > automatecally showed the extra column).
> >
> >
> >
> > "j schuetz" wrote:
> >
> > > Dear Maarten
> > >
> > > Yes, you can generate a report from data of WSS - although it is a bit of a
> > > guesswork. WSS saves all user data in one table only (called UserData). You
> > > will have to filter the right data from this table. In order to know what to
> > > filter, you will have to identify the tp_ListId (uniqueidentifier) of the
> > > WSS-List on which you want to base your report. In order to find this
> > > tp_ListId you have to search first in the Sites table for the tp_ID of the
> > > site. With this ID you can look up the tp_ID of the subweb in the Webs table.
> > > And finally, with the ID of the subweb you can look up the ID of the WSS list
> > > in the Lists table.
> > >
> > > The next step will be to identify the fields for the identified list. There
> > > is only one way: make a print screen from the WSS-list and scroll the list
> > > date in the UserData table in order to find the fields that store the WSS
> > > list data.
> > >
> > > Furthermore, I have found it easiest to define different views on the
> > > UserData table and to work with this views in Reporting Services (not
> > > directly with the UserData table). In the view, you can rename the fields of
> > > the UserData table with aliases that are the names of the columns of the WSS
> > > list.
> > >
> > > A last hint: you can display reports in WSS. Just define a WSS page with a
> > > webpart aerea and give this webpart the reportserver link of the report you
> > > want to show. It works fine.
> > >
> > > Good luck - Judith Schuetz (www.osn.ch)
> > >
> > >
> > > "Maarten Visser" wrote:
> > >
> > > >
> > > > I was wondering if it would be possible to generate reports directly from
> > > > Windows Sharepoint Services (WSS) Lists or from the output of a Webservice?
> > > >
> > > > tnx
> > > >
> > > > -= Maximizing Creativity and Productivity =-

Reporting on SharePoint list data?

Hi,
Can anyone direct me to a step by step tutorial on how to create a Reporting
Service's XML Dataset that queries a SharePoint list? I have found bits and
pieces in the SQL Books on line but I have not been able to put it all
together.
Thanks
Jeff.Hello again,
I was able to setup a dataset that queries a SharePoint list so I don't need
help on that any more :-).
The new problem: The report run fine in my development environment but when
I deploy my report and I try to run the report from the RS server I get an
"Query execution failed for data set 'DataSet1'" error. Since the
SharePoint server is running on a different machine I suspect that RS is
running the web service call under the identity of the ASP.NET thread which
does not have rights on the SharePoint server. I tried modifying the thread
pool that IIS is running RS but after I did that Report Manager would not
run any more :-(
What is the correct procedure to get RS to run under a domain account?
Thanks
Jeff.
"Jeff Richardson" <BobcatRidge@.newsgroups.nospam> wrote in message
news:uTVyJEaiGHA.2208@.TK2MSFTNGP05.phx.gbl...
> Hi,
> Can anyone direct me to a step by step tutorial on how to create a
> Reporting Service's XML Dataset that queries a SharePoint list? I have
> found bits and pieces in the SQL Books on line but I have not been able to
> put it all together.
> Thanks
> Jeff.
>|||Hello Jeff,
Thank you for posting in the MSDN newsgroup.
As for the reporting service accessing SPS list data issue, I think your
thought on the security permission is reasonable. At development time in VS
IDE, it use the logon user as the security context to access any remote
datasource (if require authentcated) user. However, after you deployed it
to reportServer, if you haven't explicitly set any credential for the
datasource(used in the report), it'll still use the authenticated user(if
you choose integrated windows credential) or the report server's service
account(if you do not specify any credentials).
Anyway, changing the report server's service identity is certainly not
recommended. I suggest you consider choose a certain credential supply mode
for your SPS datasource. We can configure credentials for report datasource
through two means:
1. In the DataSource's "Credentials" properties at design-time in VS IDE.
2. Use the report manager to configure credentials info for datasource
after deploying to report server.
Here is the BOL reference about how to specify credentials for datasource
connection:
#Specifying Credential and Connection Information
http://msdn2.microsoft.com/en-us/library/ms160330.aspx
Hope this helps.
Regards,
Steven Cheng
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
Get Secure! www.microsoft.com/security
(This posting is provided "AS IS", with no warranties, and confers no
rights.)|||Hi Jeff,
Have got any further progress on this issue or does my last reply helps you
a little? If there is anything else we can help, please feel free to post
here.
Regards,
Steven Cheng
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
Get Secure! www.microsoft.com/security
(This posting is provided "AS IS", with no warranties, and confers no
rights.)