|
|
-
|
1. the error message:
“The type Microsoft.SharePoint.Portal.Analytics.UI.ReportViewerMessages, Microsoft.SharePoint.Portal,
Version=12.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c does not implement.”
Solutions:
To solve the problem is we must choose between those engine above or incative one of the setting in sharepoint web config or SQL Server Reporting service web config.
So , take the step like this below :
If you have both MOSS 2007 (Microsoft Office SharePoint Server) and Reporting Services ( not in SharePoint integrated mode) installed on the same IIS virtual server, then you have to make the below updates in web.config for them to work
1) In the Root web.config to comment out the below. Otherwise the reportserver will give sessionState partitionResolver Issue
–>
2) In both Reportserver and ReportManager vdir web.config, the following should be added under appSettings. Otherwise you will get ReportViewer error messages
|
-
In these two web parts, the Microsoft.Reporting.Webform is embeded. Most updated version of eProphet webparts are using verion 9.0.0.0 - this fixed the client print bug by Microsoft.
Check the web.config file to find the version of report viewer by this line(if the version is 8.0.0.0, the web parts need to be updated):
<system.web>
<httphandlers>
<add verb="*" path="Reserved.ReportViewerWebControl.axd" type="Microsoft.Reporting.WebForms.HttpHandler, Microsoft.ReportViewer.WebForms, Version=9.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" />
</httphandlers>
</system.web>
|
-
When Start the Cube Viewer from eProInfoPortal, an ERROR is thrown out:
"The 'msolap' provider is not registered on the local machine".
This is normal error if the sharepoint web server does not have the OLE DB provider for Analysis Service 2005/2008 installed.
the cube viewer needs to connect to AS service to populate the pivot grid.
The solution is simple:
just download the MSI installation from Microsoft to download the proper version of the OLE DB provider.
here is the AS2005 provider link (search AS2008 version seperatly), x86 or x64:
http://www.microsoft.com/downloads/details.aspx?familyid=d09c1d60-a13c-4479-9b91-9e8b9d835cdc&displaylang=en
|
-
when try to print a report from report viewer of eProInfoPortal, probably getting the error within a poped message like:
"Unable to load client print control" (Attached image 1)
this is known issue for Microsoft Report viewer web control.
eProInfoPortal (2.0.0.1) is using version 9.0 of report viewer control. the version 8.0 might be broken by a update from Microsoft Updates - so if it's this case, we have to update the report viewer control to 9.0.
for version 9.0, if there is still a issue, then the possible reason might be the download of the control (actually it's a ActiveX control for IE) has been disabled by client IE settings.
(see attached image 2)
or,
the RSClientPrint 2005/2008 Class has been disabled in Add-ons of IE settiings. enable them and then the report should be able to be printed(see attached image 3).
|
-
|
The document shows how to create a schedule by eProphet portal.
|
-
URL Format:
http://reportservername/reportserver?/Report Folder/Report Sub Folder/Report Name&Report Parameter Name1=Report Parameter Value1&Report Parameter Name2=Report Parameter Value2&rs:Command=Render&rc:Parameters=false&rs:Format=HTML4.0&rc:toolbar=true
Command line:
rs:Command=Render: required to render the report;
rc:Parameters=false(true): show or hide the parameters panel;
rs:Format=HTML4.0(HTML3.2,EXCEL,IMAGE,XML...): the report format for output;
rc:toolbar=true(false): show or hide the tool bar(with some buttons like paging,printing,etc)
|
-
[SYMPTOMS]
When after building relationshipbetween eprophet objects and click "save", the relationsip would not be saved and it would bring empty relationships back.
[WORKAROUND]
A bug already found in the stored procedure of ePro database. Update the proc [EPRO].[sp_eProWebAdmin_SYSupdAnalyticRelation] will solve this problem.
The proc as attachment.
|
-
eProphet 2009 has a feature for user to easily view a analysis olap data. by ePromanager, report writer can create a base view for any role which users belongs to, view the layout and save to ePro database.
When general user login to eProinfoportal, the menu will have a item called "Cube View", this will show the base view, user can layout based on selected base view and create his own view.
Current version (2.0.0.1) of this feature can only be avaliable if the windows security policy is kerbros(or there is no user security setup for cubes in eProphet).
also, since the control does not prefilter function, user can not select prefilter from the pop menu bar.
[Modified - 2010-02-11]
The cube viewer now is updated to use the user's credentials to conenct to the AS service, which means that the current login user is impersonated with the windows account and password input in eProInfoportal. So if the Administrator already setup the user in the proper role of Analysis Server, the user should be able to connect to the Cube Viewer with correct personal password.
|
-
Users must have at least the read permission on the web.config file located on root web application. e.g, if the parent site of eProInfoportal is http://servername:85 , the web.config file will locate in the folder "c:\inetpub\wwwroot\wss\virtual directuries\85". you can set domain users group read permission to the web.config only.
the reason is that the web parts of eProInfoPortal will read ePro database connection information from the web.config file.
Normally the installer will create the entry for ePro database connection in the web.config. but the installer also create a simple web page to manage the ePro database connection by http://servername:portnumber/eProinfoporta/_layouts/eProAdmn.aspx
this page can only be used by a local or domain administrator, or any user who has the write permission on web.config file as above.
|
-
Most cases of this kind of error are the security issue of assembly. Just go to "%system%\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET Files" folder and locate the application folder, setup proper permission onto it - for this case, reports and reportserver folder - give system and machine account access permission.
|
-
-
eproManager are non-clickable - like the links, expandable panel etc.
Reason:the epromanager site is not on trsusted sites list.
Solution: Add epromanager site to Trusted Sites for the loggin user from IE (Tools->Internet Options) .
|
|
|