.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Register
 
Win Surprise Gifts!!!
Congratulations!!!


Top 5 Contributors of the Month
Easy Web
Imran Ghani
Post New Web Links

PerformancePoint Dashboard using Excel Services - How to export or print?

Posted By:      Posted Date: September 08, 2010    Points: 0   Category :SharePoint
 
I have a PPS dashboard in 2010 that has an Excel services report with a nice graph and grid.  I do not see an "export to Excel" toolbar or a print function.  In the old 2007 Sharepoint, the Excel services report had a menu which allowed the user to export to excel (copy / paste) or OPEN in Excel.  (actually open the pivot table) How do I expose that menu bar in 2010?  Thanks.


View Complete Post


More Related Resource Links

Repeat header rows on all pages when you export to excel sheet and print it

  
Hello , I need to export report into excel sheet. And when people try to print it . The header rows only appear on First page of the print . Other subsequent pages d onot have header rows. I saw another thread saying SQL server 2008 R2 will solve the issue. Can you tell me that is fixed and how to i go about configuring it on SQL server 2008 R2.   Thanks Madhavi

Exporting a PerformancePoint Excel Services Report to Excel

  

Have an Excel services PivotTable in a PPS 2010 dashboard.  When the user selects the "Export to Excel" option they receive this error.

I do not see any options in the webpart to show the old toolbar that used to show up in the Excel Services views.  (It had an option to open the pivottable in Excel or export a "snapshot" to Excel)

How do users export Excel Services reports to Excel?

Error

The selected view does not support an export to the selected format.

 

Troubleshoot issues with Microsoft SharePoint Foundation.

Correlation ID: c189d209-c218-4606-aad4-2f280d5c6977

Date and Time: 9/20/2010 10:26:17 AM


Export Reporting Services Report from PerformancePoint Bug?

  

I believe I've found a bug in the PerformancePoint web part--has anyone else run into this?  Here's the scenario:

 

1. An SSRS report against SSAS, from a Reporting Services Integrated mode (2008R2) instance, having two parameters (the # of parameters doesn't matter, and the same behavior below was observed when an older SSRS2005 Report Manger mode instance was used for reports as well)

2. A new Report object is created in PerformancePoint Dashboard Designer, and the report links are added

3. The Report is added to a PerformancePoint dashboard using Dashboard Designer

4. The Report is has paramters that match the report, and the filters are connected to the report

5. After the report is published, it behaves as expected--renders fine and the filters work fine

6. When the report is exported to Excel using the command on the PerformancePoint web part's drop-down menu, the report ALWAYS renders with the data that would be correct if *no* parameters were passed in by the PerformancePoint filters.  So, for example, the report always displays numbers for "ALL", even after the filter is changed to "North America".

#1 - #5 are all as expected.  #6 is unexpected, and appears to be a bug.  Step #6 in SharePoint 2007 with PerformancePoint worked fine--it only a

PerformancePoint And Excel Services config

  

I am having a prolem with Performance Point Services I have created and configured the Secure Store Service Application, generated the Keys Configured the Unattened in Performance Point Services Application and configured the Excel services as per http://blogs.msdn.com/b/performancepoint/archive/2009/11/24/deploying-performancepoint-2010-soup-to-nuts.aspx 

and I am getting this error in the error log

PerformancePoint Services could not connect to the specified data source. Verify that either the current user or Unattended Service Account has read permissions to the data source, depending on your security configuration. Also verify that all required connection information is provided and correct.

System.Net.WebException: The request failed with HTTP status 401: Unauthorized.

at System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage message, WebResponse response, Stream responseStream, Boolean asyncCall)

at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String methodName, Object[] parameters)

at Microsoft.PerformancePoint.Scorecards.DataSourceProviders.ListService.GetListCollection()

at Microsoft.PerformancePoint.Scoreca

PerformancePoint And Excel Services config

  

I am having a prolem with Performance Point Services I have created and configured the Secure Store Service Application, generated the Keys Configured the Unattened in Performance Point Services Application and configured the Excel services as per http://blogs.msdn.com/b/performancepoint/archive/2009/11/24/deploying-performancepoint-2010-soup-to-nuts.aspx 

and I am getting this error in the error log

PerformancePoint Services could not connect to the specified data source. Verify that either the current user or Unattended Service Account has read permissions to the data source, depending on your security configuration. Also verify that all required connection information is provided and correct.

System.Net.WebException: The request failed with HTTP status 401: Unauthorized.

at System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage message, WebResponse response, Stream responseStream, Boolean asyncCall)

at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String methodName, Object[] parameters)

at Microsoft.PerformancePoint.Scorecards.DataSourceProviders.ListService.GetListCollection()

at Microsoft.PerformancePoint.Scoreca

PerformancePoint Services - Dashboard Designer won't launch from PerformancePoint Content library

  

There are a couple of ways to launch Dashboard Designer for PerformancePoint Services. One of them is to go to a BI Center site, than to the PerformancePoint Content library and click New Item on the Items tab of the ribbon. If you then select one of the items listed, eg a PerformancePoint KPI, Dashboard Designer should launch.

Now in my case, it doesn't. I get a popup titled 'Dashboard Designer Redirect' telling me 'Loading Dashboard Designer...', but when the popup disappears after a few seconds, nothing happens. In the SharePoint logs, I can find a few errors, listed below. What intrigues me here is that the problem seems to be caused by a resource file ppsma.Client.en-US.en-US.resx that cannot be found. Note the double en-US.enUS in there. I do see the resource file in the listed location, but it has en-US in it's filename only once.

This is not a serious problem as I do have other options to launch Dashboard Designer, like going to the Data Connections library, then select New Document - PerformancePoint Data Source, which will launch DD. Or go to the BI Center main page and select the 'Start using PerformancePoint Services' link and start DD from there, which also works. But I am just curious whether there is something wrong with my installation, or this is a bug I should report on MS Connect.

The errors in the log:


Export Visio Database Table Names to Excel

  
If you use the Enterprise Architect edition of Microsoft Visio for data modeling regularly, then there is a good chance that at some point you've wanted to export just the table names into Excel. You might want to do this to map logical ERD entities to physical data model tables, track project status by entity, or track overlap between database versions.

Export SharePoint List to Excel Spreadsheet Programmatically using C#

  
In SharePoint applications, Custom Lists are used to store business data and Document Libraries to store the documents. But for data manupulation and analysis, Microsoft Excel provides very rich features as compared to SharePoint Lists. That's why people still loves to work on Microsoft Excel Sheets.

PrintPocketCE Print Pocket Excel, Pocket Word and email files

  
Version 3.560 (May 15, 2009):
bullet

Important bug fix: a slight difference in how some devices create fonts was causing a few devices to have significantly longer print times for large print jobs.
bullet

Adjusted PocketJet printer paper feed commands
bullet

Other minor fixes and enhancements.

Version 3.559 (Mar 5, 2009):
bullet

Added support for Martel MCP78xx printers

Version 3.558 (Aug 20, 2008):
bullet

Added support for Martel MCP78xx printers

Version 3.557 (June 27, 2008):
bullet

Fixed error in Canon printer support
bullet

Fixed COM0 port selection

Version 3.556 (June 15, 2008):
bullet

Added support for Brother MW-260
bullet

Added support for Sato MB400

Version 3.555 (Aug 8, 2007):
bullet

Added support for Pentax RuggedJet 3 and RuggedJet 4 printers
bullet

Changed Epson TM-P60 support to maximum page width of 1200 dots

Version 3.551 (Aug 1, 2006):
bullet

Added Peripheral Nomad printer support

Version 3.550 (Mar 23, 2006):
bullet

Added Panasonic JT-H200PR printer support
bullet

Added Pocket Spectrum printer support
bullet

Fixed problem with WM5.0 "inverted image" problem

Export Gridview data to Excel sheet

  

Hi ,

     I have a requirement where i need to export the gridview data to excel.My code export the data in excel that was fine.

But the enchancement needed now , I was exporting the 3 gridview in same excel sheet under the workbook.

Now i need to export the 3 grid view in 3 different sheet in the same workbook.


so can please tell or share the updated code in my below code ...

public void writeovrsummary()
    {

Response.Write("<BR>");

        Response.Write("Overall Summary");
        //Response.Write("<BR>");
        //Response.Write("Report as of " + DateTime.Now.ToString("hh:mm ss tt"));

        StringWriter sw = new StringWriter();
        HtmlTextWriter hw = new HtmlTextWriter(sw);

        SqlCommand com = MyConnection.CreateCommand();
        com.CommandText = "useroverall_Report";
        SqlParameter[] par = new SqlParameter[1];
        par[0] = new

Export Dataset to excel sheet in a required format?

  

Hi,

I know how to export a grid view to excel.

But here i have a Dataset which consists of data like below and also it need to display in a required format like below.

pno psubno pstate pdetailid pdetails

 12    1          CA         1           cbsdjcbdjc     

12     1          CA          2        cndcnjdcjcj

12     2           VA         4          xcndwkfcgygry

13     1            AL        1           ncdcnjdcndj

My excel sheet  should like this.

pid       pstate     

 12/1      CA             &nb

Reporting services in 2008 r2 how to get a report in a print button click event in my c#.net page

  

how to  get a report in my c#.net page button lick event also steps to call a report from asp.net to reporting services

 

Thanks in advance


Excel Services: Develop A Calculation Engine For Your Apps

  

The Excel Services architecture lets users design their own algorithms and share workbooks on a server.

Vishwas Lele and Pyush Kumar

MSDN Magazine August 2007


Excel: Integrate Far-Flung Data into Your Spreadsheets with the Help of Web Services

  

Excel 2003 lets you dynamically integrate the data provided by different Web services. It also lets you take advantage of the latest capabilities in Office 2003 to customize list views, graphs, and charts, and to catalog bulk items online or offline. Find out how you can makle the most of the data returned from your Web services with the Office 2003 Web Services Toolkit API.

Alok Mehta

MSDN Magazine February 2005


export to excel issue

  

Hello ,

I have a browser enabled form which i published to sharepoint ..now i want to export the contents of the form to excel..i have 1 repeating table and two repeating sections ..whenever i go to export to excel and then choose just one repeating table or a repeating section or any option other than export all form data i get an error ...first the progress bar just freezes and then when i end the task through task m anager i get a msg that microsoft excel could not start.make sure excel is installed correctly and then try again....

Can somebody tell me how to debug this..i have tried the export of a form containg repeating table and sections and it works good ..so that means there is some problem with my form..so now can somebody give me an idea as to what can the problem be and how can i debug it.

Thanks


ASP.NET Excel Export Issue

  

Hi,

I am trying to export data from SP to a .xlsx sheet. Total no of rows is more  than 15000 with total of 13 columns.The data is generated with the help of SQL Server SP. Till this point it is working fine. However while exporting to excel I do not get any data , the excel  has blank content.

If I have records less than 12000 it generated the excel report with  relevant data. However as row increases the report is blank.

Also the excel is generated through the code but when I deploy to server and try to generate it generates a blank excel. 

 Please advice what needs to be done. I have tried multiple options but none works.


Export altered gridview to Excel

  

Hello... stuck on this one!!  In a gridview RowDataBound named gvwResult I am altering one of the cells with a value retrieved from the query.

I have added:

if (hdnExchangeTo.Value.ToString() != "1")
        {
            for (int i =0; i < gvwResult.Rows.Count; i++)
            {
                gvwResult.Rows[i].Cells[7].Text = ExchangeCurrency(gvwResult.Rows[i].Cells[7].Text.ToString());
            }
        }

to the common code to export to Excel:

        Response.Clear();
        Response.Buffer = true;
        Response.AddHeader("content-disposition","attachment;filename=Export.xls");
        Response.Charset = "";
        Response.ContentType = "application/vnd.ms-excel";
        System.IO.StringWriter sw = new Syste

Categories: 
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend