Benchmark Report Excel Format Issue

NateHadro — Tue, 06 Apr 2010 13:56:44 GMT

I am creating a custom Benchmark Report with the below code. The issue I am having is when I request the format of type "Excel" to be returned. A window starts to popup and then goes away without returning any report. PDF works just fine, but I need it in Excel format.

ESRI.ArcGIS.Client.BAO.Tasks.BenchmarkReportParameters benchmarkReportParams =
                new ESRI.ArcGIS.Client.BAO.Tasks.BenchmarkReportParameters();

            //Attempt to load Area_ID as Store Name
            //benchmarkReportParams.TALayersFields.Add("Area_ID");

            benchmarkReportParams.BenchmarkOptions = ESRI.ArcGIS.Client.BAO.Tasks.BenchmarkOptions.useNone;
            benchmarkReportParams.FieldSortType = ESRI.ArcGIS.Client.BAO.Tasks.BenchmarkSortOptions.sortNone;
            benchmarkReportParams.OutputTypes.GetReport = true;

            benchmarkReportParams.StandardReportOptions = new ESRI.ArcGIS.Client.BAO.Tasks.ReportOptions();
            benchmarkReportParams.StandardReportOptions.Format = "Excel";
            benchmarkReportParams.StandardReportOptions.Header.Subtitle = reportSubtitleTextBox.Text;
            // See http://resources.esri.com/help/9.3/BusinessAnalyst/Docs/OnlineAPIs/summarization.htm
            // for summarizations variables and downloadable files.
            benchmarkReportParams.Summarizations.Add("TOTPOP00");
            benchmarkReportParams.Summarizations.Add("TOTPOP_CY");
            benchmarkReportParams.Summarizations.Add("TOTPOP_FY");

ESRI.ArcGIS.Client.BAO.Tasks.BenchmarkReportTask benchMarkReportTask =
                new ESRI.ArcGIS.Client.BAO.Tasks.BenchmarkReportTask();

            // Wire up async event handlers
            benchMarkReportTask.Failed +=
                new EventHandler<ESRI.ArcGIS.Client.Tasks.TaskFailedEventArgs>(task_Failed);
            benchMarkReportTask.ExecuteCompleted +=
                new EventHandler<ESRI.ArcGIS.Client.BAO.Tasks.BenchmarkReportEventArgs>(benchMarkReportTask_ExecuteCompleted);

            benchMarkReportTask.Token = BAOAPIAuth.Current.Token;
            benchMarkReportTask.ExecuteAsync(benchmarkReportParams);

Benchmark Report Excel Format Issue

DominiqueBroux — Tue, 06 Apr 2010 17:31:13 GMT

A workaround might be to uncheck the option 'Confirm Open After Download' for the xls files.

The steps are depending on OS but should be something like this:
1) Open a folder (any folder),
2) Tools > Folder Options > File Type tab,
3) Scroll down to the XLS extension,
4) Click "Advanced",
5) Uncheck the "Confirm Open After Download" box,

Benchmark Report Excel Format Issue

NateHadro — Wed, 07 Apr 2010 12:17:35 GMT

I don't think the Vista, or Windows 7 (Which I am using) have this option. I looked in the control panel as well and didn't see any options for this. Thanks for the idea though.

Benchmark Report Excel Format Issue

NateHadro — Wed, 07 Apr 2010 16:15:59 GMT

I was able to fix this issue by not opening the Excel document in a new window. With a PDF I was opening the report in a new window, but with Excel that was not working. After changing it to open in the current window, it prompts me to open or save the document.

topic Benchmark Report Excel Format Issue in ArcGIS API for Silverlight Questions

Benchmark Report Excel Format Issue

Benchmark Report Excel Format Issue

Benchmark Report Excel Format Issue

Benchmark Report Excel Format Issue