SharePoint - Business Intelligence Forum

SSRS in an Extranet environment

Tue, 14 Oct 2008 08:56:29 Z

Hello,

I have MOSS 2007 using SSRS 2005 to view reports from SQL, and I am working in an extranet enviroment. The reports work fine, until you try to view them externally from the network where i receive this error -

The request failed with HTTP status 401: Unauthorized ( The server requires authorization to fulfill the request. Access to the Web server is denied. Contact the server administrator. ).

I have read that Sharepoint Reporting services only supports access in the default zone, therefore users would not be able to view reports externally through an extranet, is this true?

If it is then is this functionality possible in the Katmai release or SSRS 2008?

Any help would be much appreciated.

Thanks.

Report Builder Credentials / Authentication over Extranet

Tue, 05 Jun 2007 21:22:27 Z

We're looking to implement a Sharepoint Portal with Reporting Services integrated.

The goal of this portal would be to allow external clients to connect to the portal, download excel reports, view reporting services reports and create their own using Report Builder.

As I read through the articles/forums/blogs about this, it seems that there is one haunting issue that may pose a problem. That seems to be how to supply credentials to the Report Server (or Sharepoint since it's integrated) so that it is aware of who is the user that is launching Report Builder.

I currently have an internal test implementation with WSS 3.0 and Reporting Services in Integrated Mode. I'm able to launch Report Builder without issues and create/save/open reports.

My concern is the issues that it sounds like we will face when we decide to replicate this and expose it as an external/production environment.

If anyone can shed some light on any of the following questions I would really appreciate it:

Internally my test implementation uses Windows Authentication. When exposing Sharepoint + Reporting Services on internet should we keep this model or is it advisable to use a Forms/SQL provider model?
When launching the Report Builder smart client application, has anyone had success with passing credentials so that only Reports and Report Models that the user should see are visible to him/her?
Some posts seem to indicate that the user will be prompted to enter their credentials when launching Report Builder over the internet. Will the user see an error message when prompted? Is that error message configurable? Upon entering those credentials, will Report Builder operate as normal?

Sorry for the long post, any help is greatly appreciated.

Sharepoint bulk file replace SSRS report update

Tue, 24 Nov 2009 15:58:59 Z

Hi,

I have a sharepoint site with integrated Sql Server Reporting services. I have several subsites (one for each deparment) each with a version of a particular report (profit and loss for example). Unfortunately, these reports have become out of sync whenever changes to the reports.

Is there a simple way of batch replacing each of the reports on all of the subsites without losing the report parameters using either batch/xcopy/script etc from a single source?

Thanks

Reporting Services AddIn for Sharepoint gets 401 Unauthorized

Tue, 24 Nov 2009 23:23:38 Z

Hi Everyone,

I've installed the Reporting Services 2008 AddIn for SharePoint 2007. When I go to Application Management - Manage Integration Settings and enter the /reportserver url, it says

"Server was unable to process request. ---> The request failed with HTTP status 401: Unauthorized."

Any ideas?

Central admin site disappears after WFE server install

Tue, 24 Nov 2009 22:56:17 Z

I am trying to install a farm with a database server, app server, wfe server using reporting services. I think the admin site gets whacked when I do the wfe install on the database server. My understanding is that you have to install a wfe on the report server (same as database server) to 'join' the server to the farm.

I am sure there are dozens of ways this could go wrong. Any ideas anyone?

Shared Schedules Broken after MOSS SP2 Upgrade - SSRS Integrated

Tue, 24 Nov 2009 16:00:59 Z

We have recently upgraded our servers to WSS & MOSS 2007 SP2

We run SSRS reports in Integrated Mode (Kerberos) and execute these reports with a Shared Schedule, 3 schedules are setup - Daily, Monthly, Weekly

Since the upgrade none of these schedules appear to be working, the Last Run of the schedule shows that it has run but yet no new Snapshots for any of the reports have been created

This works in our Dev environment, but not in our QA or Prod

Difference is.. Dev is 32bit, QA & Prod are 64bit systems

Nothing is showing in the logs, I have turned All to Information and Verbose... but yet I don't see anything in the logs pertaining to Shared Schedules

thanks,

SSAS 2005 Filter Webpart Connect to Reportview Webaprt not able to configue connection

Tue, 24 Nov 2009 13:29:44 Z

Hi,

We have bulit a cube using SSAS and we have used SSRS to generate reports using SSRS.I was able to to deploy the report on my sharepoint site.As the report generated had few parameters which was fetched from cube.So one can select these parameter in reportviewer webpart itself.But my requirement is have a separate filter for parameters.So i added a SSAS 2005 filter and connnected to the cube and got the parameter values.Wen i try to connect this filter to my reportviewer webpart,i m facing issues:

1. Initially, Encode selected value as set was checked in SSAS 2005 Filter webpart configuration,I was able to configure connection between my filter webpart and my Reportviewer.But While generating the report it gave an error saying "The filter value provided for parameter 'YEARYear' is not a valid value". Then i thought Reportviewer may not accept multiple values as parameter as SSAS filter fetches the values from Cube.

2.So i unchecked Encode selected value as set in the configuration of SSAS webpart.But this time wen i tried to configure the connection between SSAS Filter and Reportviewer, Filtered parameter has been greyed out.I m not able to connect to the Reportviewer webpart itself.

I tried out other filters like choice filter too but in vain,not able to connect the filter to my Reportviewer webpart.Filtered parameter option has been grayed out.

Is there any workaround for the same so that i can connect filter to Reportviewer webpart.Any help would be appreciated.

Thanks in advance,
Raghav

What is the best practice for a SharePoint implementation with intranet capabilities and business intelligence dashboards?

Wed, 11 Nov 2009 09:56:36 Z

Hi all,

I am developing a proof of concept and I saw several possible methods to set up an intranet, which, in advance, would like to be specific for each department throughout our organization. We would like to have a shared report center, but also non-shared departmentdashboards with BI performancepoint components.

I was thinking for an architecture like this:

Root intranet (Site collection) with different categories like country, location

- News

- weblog

With for every department an own teamsite which can connect to the root News and weblog component

- News (Inherited)

- weblog (Inherited)

- Department dashboard

- Function/jobspecific dashboards

- Documentlist (for procedures etc.)

And finally a report and document center.

Since I am quite green in the area of SharePoint I would like to know what you do think about the setup above and what the nest practices are.

Could you help me out?

Thank you!

Daniel

After Process the Cube, Report in SharePoint do not refresh

Wed, 19 Aug 2009 08:26:39 Z

Hi All,

My environment is...

A Machine - SQL Server Staging DB, SQL Server Analysis Service and SQL Server Reporting Service
B Machine - Windows SharePoint Service 3.0, SQL Server Reporting Service in integration mode.

And I have 2 report location that at A (Reporting service layout) and B SharePoint Library. Both is calling A cube for data.

everything works fine unless...

My report's data in SharePoint do not refresh even I process my cube, but at location A, the report display right data..

I have tried to use context menu -> "Manage processing Option" in sharepoint library to config the process method as "live data", but it still displaying something like cache(apparently, my "B" Report is not connecting to cube)

Do you have any idea??

Thanks in advance!

http://lamjoel.blogspot.com/

SharePoint - SSRS - windows

Tue, 24 Nov 2009 03:07:05 Z

Well, how it has been setup now

sql 2005

SSAS- cube - SSRS - reports

SharePoint 2007

Document library - page - Add a web part - Page Viewer Web part

Page Viewer Web part - Modify Shared Web Part - Link - link to the report from SSRS

one page includes up to 8 "Page Viewer Web part" , 8 reports in one page - looks like dashboard and works fine

but now I got a problem

each report should has link "details" - click on link and see new report but report must open in the same SharePoint window but it opened new window now

if I opened report on SSRS just direct link localhost/ReportServer/... and click "details" - new report will open in the same window, exactly as needed

but form SharePoint it always opened in new window

any ideas how to open new report in the same window on SharePoint ?

KPI list "Update" ,"Move up","Move Down" submenu are disabled.

Mon, 13 Apr 2009 10:15:05 Z

I could not figure out a way to sort the Value indicators in a KPI list, the submenus on the Value indicator, namely "Move UP", "Move Down" and Update appears to be disabled.

The "Update" sub menu gets enabled when you choose the KPI to get manually updated.

But the "Move Up" and "Move Down" buttons donot come into enabled state what ever the
settings we adjust.

please advice.

thanks in advance.

KPI on Custom Rules

Tue, 17 Nov 2009 17:21:45 Z

Hi,

I need to set a few KPIs based on a SharePoint List.

For example, of all the items where the Field1 is empty, calculate the percentage where Field2 is Choice1 and Field3 > 1/1/2009

This hipothetical example, just to say that I would like to set the KPI rules programatically, add custom columns to the KPI List, use those columns to filter the list of Kpi's etc.

Is this possible? Can anyone point me to some blogpost, codeplex project, or any other article that can point me on a good direction?

Thanks,
JC

SQL Server 2008 Reporting Services broke Sharepoint

Thu, 19 Nov 2009 16:07:55 Z

Hello,
I had Sharepoint 2007 running fine prior to the installation of SQL Server 2008 Reporting Services. I followed the directions to the tee. Installed Web Farm front end on the SQL Server machine, where Reporting Services was going to be running, and set it up so that it was showing on the Central Administation page. I then downloaded the Reporting Services Sharepoint Add-In and installed it. I have then gotten the following when logging into the Central Administration Page:

Server Error in '/' Application.

Runtime Error

Description:

 <configuration> <system.web> <customErrors mode="RemoteOnly"/> </system.web> </configuration>

Notes: The current error page you are seeing can be replaced by a custom error page by modifying the "defaultRedirect" attribute of the application's <customErrors> configuration tag to point to a custom error page URL.

 <configuration> <system.web> <customErrors mode="On" defaultRedirect="mycustompage.htm"/> </system.web> </configuration>

Uninstalling the Add-in the page remains the same. How do I go about fixing this?

Michael R. Mastro II

How to hide "Manage Parameters" menu from the reports in SharePoint

Tue, 10 Nov 2009 14:32:35 Z

Hello,
I have a hidden parameter called Department in my reports. I derive the value based on the the UserId that accesses the report and use it to filter the data by that Department.
I use this parameter in Subscriptions to assign the department value so I can generate department-wise reports (since subscription needs stored credentials and I cannot use the Userid to arrive at the department).

When I publish these reports to SharePoint. The users are still able to access the hidden parameter through "Manage Parameters" contextual menu. How can I hide this??

PS: I have assigned the Read permission (the default Visitors type) and it includes the Edit permission to all reports. If I change to just View items only, the reports are not even visible to the users, so it seems I need to assign Edit permission to even view the reports. Any other option available to restrict this?

Thanks

ssrs editions and version matching

Wed, 18 Nov 2009 22:41:01 Z

We recently integrated performance point monitoring server into our sharepoint 2007 enterprise farm.

We have 2 web servers and 1 application index server in the sharepoint farm, with a sql cluster. All servers running server 2008 and sql is 2008 standard.
With the installation of monitoring server we bought another seperate sql server that is running windows 2008, sql 2008, database services, reporting services, integration services and analysis services. This sql is 2008 but with sql enterprise.

So on the web servers we have ssrs and the add-in installed for 2008 and it all works fine. The ssrs on these servers are setup as scale out deployment and running enterprise ssrs.

Is it required that the ssrs running on the sharepoint web servers be enteprise edition to match the server that handles the reporting which also is sql server 2008 enterprise?

We tried it with sql 2008 standard on the web servers but never worked, but it works fine now with matched editions and versions of sql. Just want to make sure as enterprise sql can be costly.

Is there some microsoft articles to backup the matching of editions for this scenario?

SSRS Integrated Mode view report permissions

Tue, 03 Nov 2009 21:27:21 Z

I have MOSS 2007 with a SSRS 2008 instance in Integrated Mode. I have 2 Report libraries (an ExcelServices and Report Library). The only way I am able to give users permission to see SSRS reports deployed to Report Library is to give them "Contribute" which allows reports to be deleted.

However, in the ExcelServices report library, I am able to deploy SSRS reports and users can execute/view them with the simple "Read" permission. I've checked the usual suspects and cant find anything obviously different with these two libraries that would cause this discrepancy. I even created a new document library and it exhibits the same behavior...unless you give contribute permissions, users cannot see them.

How can I give permissions to the Report Library for usres to "read" only and still allow users to see/interact with reports?

TIA

mmMmmm...yummy...

How to configure public IP for record center site in central admin.

Mon, 16 Nov 2009 15:21:36 Z

Hi All,

I am trying to configure public IP address for record center site in central administration site.When i try to route the document to record center site.It gave me "Value does not fall within the expected range" error. It works fine with machine name within the server.

Could anyone come up this this type of environment ever.Please help me out.Please see the detail error below.

Value does not fall within the expected range.   at Microsoft.SharePoint.SPWeb.GetWebRelativeUrlFromUrl(String strUrl, Boolean includeQueryString, Boolean canonicalizeUrl)
   at Microsoft.SharePoint.SPWeb.GetWebRelativeUrlFromUrl(String strUrl)
   at Microsoft.SharePoint.SPWeb.GetFile(String strUrl)
   at Microsoft.SharePoint.OfficialFile.<>c__DisplayClass7.<RgofpFromListItem>b__6()
   at Microsoft.SharePoint.SPSecurity.CodeToRunElevatedWrapper(Object state)
   at Microsoft.SharePoint.SPSecurity.<>c__DisplayClass4.<RunWithElevatedPrivileges>b__2()
   at Microsoft.SharePoint.Utilities.SecurityContext.RunAsProcess(CodeToRunElevated secureCode)
   at Microsoft.SharePoint.SPSecurity.RunWithElevatedPrivileges(WaitCallback secureCode, Object param)
   at Microsoft.SharePoint.SPSecurity.RunWithElevatedPrivileges(CodeToRunElevated secureCode)
   at Microsoft.SharePoint.OfficialFile.RgofpFromListItem(SPListItem item, RecordsRepositoryProperty[]& rgofp)
   at Microsoft.SharePoint.OfficialFile.SubmitFile(SPFile file, String strRecordSeries, String& strAdditionalInfo)
   at Microsoft.SharePoint.OfficialFile.SubmitFile(SPFile file, String& strAdditionalInfo)
   at Microsoft.SharePoint.SPFile.SendToOfficialFile(String& additionalInformation)
   at Microsoft.SharePoint.ApplicationPages.SendToOfficialFile.OnLoad(EventArgs e)
   at System.Web.UI.Control.LoadRecursive()
   at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)

Thanks,

Mehmood

Sharepoint and Reporting Sevices Integrated - Install question

Tue, 17 Nov 2009 10:44:37 Z

Hello,

I want to install the reporting services integrated with sharepoint. In my farm I have the following: 1 server with MOSS + 1 server with SQL server.

Where do I install the reporting service instance?

Thanks for the help,

Best Regards,
André

Noob Q: SSRS Reporting using SharePoint Lists

Thu, 12 Nov 2009 18:29:38 Z

Hey friends, this will probably be a simple answer. I'm trying to pull a SharePoint list as a datasource in my SSRS reports. Here is the Soap Query I'm trying to immitate:

<Query>
   <SoapAction>http://schemas.microsoft.com/sharepoint/soap/GetListItems</SoapAction>
   <Method Namespace="http://schemas.microsoft.com/sharepoint/soap/" Name="GetListItems">
      <Parameters>
         <Parameter Name="listName">
            <DefaultValue>{7594E86C-5101-4FB0-AD91-B179F0ABBCC9}</DefaultValue>
         </Parameter>

etc. etc.

My question is... how do I get the value that is in DefaultValue ? I'm not seeing this hex value anywhere in the SharePoint list.

Thanks!

Installing SSRS add-in in sharepoint server 2007

Wed, 18 Mar 2009 13:58:10 Z

Hi,
I have installed SSRS addi-in in sharepoint server 2007.It installed successfully,but i am not able see the SSRS configure settings in the central administration.Can any tell why it happening like this.

Thanks...

Maruthi...

Permission Problem with Reports Library

Mon, 12 Mar 2007 08:06:01 Z

Hi,

I have a reports library with 5 reports in my sharepoint website. I want to give the access to somebody, just with the Read permission. Then i put this user in the "Sharepoint Dev Visitors" groups.

But when this user goes to the reports library, he doesn't show any report.

How can i fix this problem ?
Thanks

SQL reporting service fails on Sharepoint extranet Website

Wed, 29 Jul 2009 07:07:41 Z

Hi,
I was be able to configure the SQL reporting services 2005 to work and integrate them in intranet sharepoint site 2007 in my company.So, we decided to put them on internet facing sharepoint site using Form Authentication. However, the report service doesnt work. The error message we got is something like this :" Either Sharepoint Integrated mode is disabled or Report Server is using Trusted Account".
I dont know what's exactly going on here. I've been researching and found no solution. I would like an advice.
Thank you

SSRS2008 in SPIM mode

Fri, 30 Oct 2009 12:46:16 Z

I have MOSS 2007 EE running against SSRS/SPIM SQL Server 2008 EE SP1.

Two questions:

1. I don't see the "Manage Subscriptions" drop down for reports in the Report Library. But I do see it when I run the report and click on Actions in the upper toolbar. Everything else is working fine.

2. Also how to enable report snapshots ? I searched high and low could not find how to do this..

Thanks,
JGP

Later (a few minutes) addition: I also don't see this option in the drop down: Manage processing options.

KPI for each individual item in Sharepoint list

Mon, 16 Nov 2009 06:40:31 Z

Hi,

I have created KPI List. My reqirement is i have one list containing all project names with estimated budget.
Now i want to create KPI for this list based on budget, i.e., want to show indicator based on each individual item estimated budget.

But what i am able to do is based on No. of list items (or) based on %of list items (or) based on Sum, Maximum, Average, Minimum.
But my requirement is want to display indicator for each item in a list.

How to do this, Any ideas will be appreciated.

Thanks,
Neerubee

Thanks & Regards, Neerubee

Using Page viewer Web Part to show SSRS reporting

Tue, 17 Nov 2009 04:54:32 Z

Dear All,
I have sharepoint sever and SSRS server that dosen't integrate. I have try to use Page viewer Web Part to show SSRS reporting by enter link as http://reporturl/ReportServer?/xxx/MASTER_REP&rs:Command=Render&rc:Toolbar=True&rc:Parameters=Collapsed but there is an error as show below

Reporting Services Error

An internal error occurred on the report server. See the error log for more details. (rsInternalError) Get Online Help
- For more information about this error navigate to the report server on the local server machine, or enable remote errors
SQL Server Reporting Services

anyone can help me..

Thanks,

reporting services 2008 table column width resizing

Wed, 04 Nov 2009 13:39:01 Z

We converted a report from RS2005 to RS2008 and discovered a problem with the 2008 version. The table contains several columns with CanGrow turned on so text that is too long for the column will wrap and the row height will increase to accommodate the text.

We have a situation where the data coming back from the database is too wide for the column and should wrap, but instead of wrapping the text, the column width is being increased.

We narrowed down the circumstances where this will occur:
- the text that is too wide for the column does not have any spaces in it. Normally wrapping would occur where there is a space if possible, otherwise wrapping will occur in the middle of a word.
- the column headers have text labels that wrap

The only way we were able to resolve the problem was to remove the header row and instead add textboxes above the table to simulate the header row.

SSRS 2008 - Expand Collapse icon in reverse order

Tue, 17 Nov 2009 16:26:07 Z

Hi,

We have a cube based report which has the following layout:
1) Main Report which has groupings (and sections) on it.
2) Each of the groupings has a detail level which exposes a Sub-Report.

The Expand/Collapse functionality works fine on the button click (of the +/- icon). When the Default was set to "Hide" the icon made sense - it would show (+) in order to allow the user to expand and (-) once the section is expanded.
Based on user request, we switched the functionality for a section to show default "Expanded" and the icon still behaves the same way which is wrong (we expect the icon to now behave in the reverse way...that is to show (-) since the section is now expanded). Numerous attempts to set the defaults/ toggles etc have failed to switch the icons. (Note:- BOTH the Grouping AND the Detail levels have default Visibility set to "Show")

Even creating a new report to check this functionality produces this same erratic behavior.
In short - For a Cube based report in SSRS 2008, when the default is Expanded for a section, the toggle icon appears to work in Reverse order.
(Please reply specific to this issue above, we are aware of how to set the Visibility of a Section, Set default to Expand/Collapse by going to Properties as well as use the Toggle button - its the weird behavior of the icon that is the issue, also if there is any way to customize the icon that would be helpful too...Thanks Much!!)

Also we have tried everything on the issues:-
1) http://social.msdn.microsoft.com/forums/en-US/sqlreportingservices/thread/852012f8-fc08-4240-8885-48272590ea4f
2) http://social.msdn.microsoft.com/Forums/en-US/sqlreportingservices/thread/207be3a6-a70e-40f7-99a2-5478f67813dd
3) http://social.msdn.microsoft.com/forums/en-US/sqlreportingservices/thread/07b229fe-d24a-4bdd-ac69-e88acfa2b529
4) http://forums.asp.net/p/1079306/1596209.aspx#1596209

SSIS - For Each Loop Variable Enumerator

Fri, 13 Nov 2009 08:46:13 Z

HI

I am using a Execute SQL Task which gets me a resultset having 2 columns (Order, FileName)
Ex :   1,AuditFile
         2,SalesFile
         3,ReportFile

Once I get this resultset I want to use a foreach loop to loop through these files one by one as per order.
Means: Audit file will be read first,then SAles file and then the Report File.

How can I do this in SSIS 2008.

Thanks in advance
Moups

mou

SSRS/Sharepoint Config error

Fri, 13 Nov 2009 13:58:59 Z

Hi All,

I've been trying to set up a SQL SSRS server to integrate with Sharepoint but and experiencing problems. I have some experience in this area and have set up SSRS numerous times. I've followed an MS document to the letter yet still I am receiving the following error when I browse to http://servername/reportserver

Reporting Services Error

The report server has encountered a configuration error. See the report server log files for more information. (rsServerConfigurationError) Get Online Help

SQL Server Reporting Services

Not exactly detailed I'm sure you'll agree.

This is shown in the log file...

w3wp!library!1!11/13/2009-13:22:56:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException: The report server has encountered a configuration error. See the report server log files for more information., SharePoint content service is null. Report Server may not have joined the SharePoint farm, or Report Server service account may not have been granted access to farm.;
Info: Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException: The report server has encountered a configuration error. See the report server log files for more information.

Any starting suggestions?

ReportViewer WebPart and autoresize problem

Thu, 27 Dec 2007 18:28:22 Z

Hi all,

I'm using the Report Viewer webpart to display some reports from sql server's Reporting Services.

My problem is that :

- If I set the webparts size to fixed, I get the report but I'm limited by size to what I can do and see in the report

- If I set it to autoresize, no report is shown.

Are you aware of any issues regarding this? Any workarounds? Shouldn't the webpart adapt itself to the report?

Thank you,

lfhc

401 in reporting services web part. But only on client.

Tue, 08 Sep 2009 15:19:51 Z

As above I am now receiving 401 errors in reporting services web parts when trying to access from a client machine. When I access the same place from the Sharepoint WFE server, it works OK.

I have it in my head that it is a kerberos issue (we are using kerberos), but we have relevant SPN's listed on accounts. It has worked for months and now fallen over.

Suggestions??

KPI error: "The previously selected column no longer exists in the list"

Thu, 12 Nov 2009 22:20:26 Z

If I create a Project Tasks list and leave it with all default columns and views, I can also set up a new KPI list and indicator values with the project task list columns as expected. If I add a few custom columns to the Project Tasks list, including a calculated column, those new columns show up when creating a new indicator. But the problem comes when I start creating custom views and changing the default views. After I create a new view, modify an existing template view, or change which view is the default view, then almost all the columns no longer appear in the dropdown when creating a new indicator. Now if I modify a KPI that I created before I started customizing views, I get the error "The previously selected column no longer exists in the list. Select a new column." But the column I originally selected IS still in the list and if I cancel out of the Edit Indicator page, the KPI still calculates correctly, so it obviously knows that column still exists.

So the workaround I have is this:
1) Create a new list
2) Create a KPI list and set up every possible KPI that I want on the list
3) Then modify/create views

The problems are that 1) it's impossible to know all KPI's I might want to run on a list and 2) I can never edit the goal or warning values of the KPIs I initially set up.

Anyone have any idea why this is happening? I follow the steps exactly as described in Microsoft's article: http://office.microsoft.com/en-us/sharepointserver/HA100800271033.aspx But as soon as I modify views, then all is broken.

I'm running MOSS 2007 SP2 on Windows Server 2008 32-bit with SQL Server 2005 32-bit.

-Thanks

How to use KPI to display multi-level financial budget?

Wed, 04 Nov 2009 06:36:39 Z

Hi All,

I have a question when I am using the KPI to demonstrate financial data for my organisation. What I want to see is:

Project Managers (PA) will be able to view Project task costs: PTA,PTB,PTC.
Portfolio Managers (A) will be able to view Projects budget: PA, PB,PC,PD, which is sum-up value of each task.
Top Level Managers will see overall budgets of four portfolios : A,B,C,D, which is the sum-up value of each portfolios.

So, I have created a KPI to display financial data in Portfolio Managers' level, which is a sum value of the KPI Value indicating the acutal cost of each project, and it is working fine.
However, the question is if I can sum of the portfolio budget and pass its value to the Top level Manager, and make sure they can see the total budget of the portfolios?

It drives me nuts! Thanks for help!

BTW, I can use JQuery, but no CODE, or SharePoint Designer due to company policy...

Cheers,
NewWay

New Way to KM

SSRS Add-in will not install

Mon, 26 Oct 2009 17:39:43 Z

I'm working on upgrading my MOSS2007 install to 64-bit on both the front end and SQL 2008 back end - running all of this in Hyper-V. I keep running into error 5214 and the install rolls back when I try to install the SSRS SharePoint add-in. From the app log on the SP server...

>>Insufficient SQL database permissions for user '' in database 'SharePoint_Config' on SQL Server instance 'BRYCELAND-DATA2'. Additional error information from >>SQL Server is included below.

>>The EXECUTE permission was denied on the object 'proc_putObject', database 'SharePoint_Config', schema 'dbo'.

>>Insufficient SQL database permissions for user 'SYSTEM' in database 'SharePoint_AdminContent_16fcc28e-defa-4f9d-9d8f-d7c307ffe838' on SQL Server instance
>>'SQL SERVER NAME'. Additional error information from SQL Server is included below.

>>The EXECUTE permission was denied on the object 'proc_GetListFields', database 'SharePoint_AdminContent_16fcc28e-defa-4f9d-9d8f-d7c307ffe838', schema 'dbo'.

I have checked and double-checked permissions on both servers and I'm running pretty much everything as domain admin so I don't think this is a simple security issue.

Any ideas??

Thanks,
Bryce

Bryce

Sharepoint List with Analysis Services

Fri, 06 Nov 2009 08:31:30 Z

Hi
I want to ask that is there any way to integerate sharepoint list with analysis services.
i have few list i want to build analysis report using anlysis services but sharepoint list will be the datasource

Sharepoint & SSRS 2008 "System.IO.FileNotFoundException: Could not load file or assembly 'Microsoft.SharePoint"

Sun, 08 Nov 2009 07:16:12 Z

my environment as below:

1- SERVER A (SQL server DB 2008 sp1)
2- Server A (SSRS 2008 sp)
3- SERVER B MOSS 2007 sp1
I configured the SSRS to be sharepoint intergated mode but when i hit the Web Service URL i got the error below:

Reporting Services Error

The configuration parameter SharePointIntegrated is set to True but Share Point Object Model cannot be loaded. The error was: System.IO.FileNotFoundException: Could not load file or assembly 'Microsoft.SharePoint, Version=12.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c' or one of its dependencies. The system cannot find the file specified. File name: 'Microsoft.SharePoint, Version=12.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c' at Microsoft.ReportingServices.SharePoint.Server.SharePointServiceHelper..ctor() at Microsoft.ReportingServices.SharePoint.Server.SharePointServiceHelperFactory.get_ServiceHelper() WRN: Assembly binding logging is turned OFF. To enable assembly bind failure logging, set the registry value [HKLM\Software\Microsoft\Fusion!EnableLog] (DWORD) to 1. Note: There is some performance penalty associated with assembly bind failure logging. To turn this feature off, remove the registry value [HKLM\Software\Microsoft\Fusion!EnableLog]. . (rsSharePointObjectModelNotInstalled) Get Online Help

SQL Server Reporting Services

If i change this to Native move the message above would disappear.

hussain

Report Viewing in Sharepoint 3.0 fails

Thu, 05 Nov 2009 13:02:34 Z

Hello!

I recently installed Windows Sharepoint 3.0 on a standalone server which also serves as a SSRS 2008 server. I've deployed a few test reports to the Sharepoint site, but when I try to view the reports I receive this error message:

An error occurred during client rendering.
- The remote server returned an error: (500) Internal Server Error.

However, if I browse the contents of the report server web service, the report server will render the report correctly.

I've checked the log and found the below entries:
library!ReportServer_0-1!1100!11/05/2009-07:55:22:: Call to GetPermissionsAction(http://apps02/Reportsite/Reports/Report1.rdl).
library!ReportServer_0-1!3a0!11/05/2009-07:55:22:: Call to ListParentsAction(http://apps02/Reportsite/Reports/Report1.rdl).
library!ReportServer_0-1!1100!11/05/2009-07:55:24:: Call to GetPermissionsAction(http://apps02/Reportsite).
library!ReportServer_0-1!3a0!11/05/2009-07:55:24:: Call to GetSystemPropertiesAction().
library!ReportServer_0-1!1100!11/05/2009-07:55:24:: Call to GetPermissionsAction(http://apps02/Reportsite/Reports/Report1.rdl).

Given the fact that it works correctly using the ReportServer Web Service, and not Sharepoint. I'm assuming that Sharepoint is the culprit. After reading the last entry which states a call for retrieving permissions, I can only assume that that is where it is failing. Has anyone had this problem, and how did you solve it?

Any help would be greatly appreciated!

Cannot reuse list name for KPI Lists

Thu, 05 Nov 2009 17:35:41 Z

I am running into this issue on MOSS 2007 SP2:

1) Create a team site.
2) Create a KPI List called "testkpi".
3) Confirm that you receive the message "There are no KPIs" in the list view of the KPI list.
4) Add a KPI to confirm you can see it in the list.
5) Delete "testkpi" list.
6) Recreate "testkpi" list.

At this point, you no longer receive the "There are no KPIs" message in the list view. Instead you receive the following error:
"Key Performance Indicators (KPIs) display important measures for your organization, and show how your organization is performing with respect to your goals. This Web Part is not configured with KPI list."

Adding items to the list do not display them in the list, though they do exist. Thinking it might have been a duplication issue, we tried clearing out the first- and second-stage recycling bins between steps 5 and 6 above with the same results.

Any ideas?

Printing from SharePoint Reporting Services stretches text

Mon, 02 Nov 2009 13:28:00 Z

Using SSRS 2008. When I print the report from SharePoint (using the Reporting Services web part), the text stretches. Any ideas why? It exports to PDF, Word, and XLS just fine. It also prints just fine when I print from the report server, but we are having to move everything to SharePoint now.
Thanks,
David

KPI List Fields not displaying in a View with the Display checkbox checked

Sun, 17 May 2009 14:37:59 Z

Hi,

I am trying to display the fields of in a View of a KPI List. I am unable to change the display of Fields using Modify this View option in the View drop down menu by checking and unchecking the

Display checkbox

Is there any other setting that affects the display of Fields.(schemaXML....... ?)

Also, please let me know if there are some properties in the SharePoint Object Model that I can set to change the display of the View using Code.
Please point me to some link that discusses schemaXML and/or CAML query modification if display is modified using code......

TIA.