H Kanwar,
Hi Kanwar,
Thanks for considering Aspose.Cells for Reporting Services.
We have checked and tested your provided report definition file. It is fine.
Please let us know your environment.
Our test environment is:
- Windows Server 2008 R2 x64, SQL Server 2008 R2 x64, Aspose.Cells.ReportingServices.DLL 2.1.0.1
- Visual Studio 2010, .NET Framework 2.0
Here is the test code for your reference.
private static string
REPORTING_SERVICE_URI = “ReportService2005.asmx”;
private static string REPORTING_EXEC_SERVICE_URI = "ReportExecution2005.asmx";
private ReportingService2005 m_ReportServices;
private ReportExecutionService m_ReportSerivcesExec;
public byte[] ExportReport(string reportname, RW.Utility.SSRS.Services.ReportExecutionService.ParameterValue[] parameters, string format)
{
string historyID = null;
string devInfo = @"False";
string encoding;
string mimeType;
string extension;
string[] streamIDs = null;
try
{
ExecutionInfo execInfo = new ExecutionInfo();
ExecutionHeader execHeader = new ExecutionHeader();
RW.Utility.SSRS.Services.ReportExecutionService.Warning[] warnings = null;
m_ReportSerivcesExec.ExecutionHeaderValue = execHeader;
execInfo = m_ReportSerivcesExec.LoadReport(reportname, historyID);
String SessionId = m_ReportSerivcesExec.ExecutionHeaderValue.ExecutionID;
if (parameters != null)
{
m_ReportSerivcesExec.SetExecutionParameters(parameters, "en-us");
}
byte[] result = m_ReportSerivcesExec.Render(format,
devInfo,
out extension,
out encoding,
out mimeType,
out warnings,
out streamIDs);
execInfo = m_ReportSerivcesExec.GetExecutionInfo();
return result;
}
catch (Exception e)
{
Console.WriteLine(e.Message);
throw e;
}
}
Hi Kanwar,
Thanks for your posting and considering Aspose.Cells for Reporting Services.
We will work on your query and get back to you asap.
Shakeel I am waiting for your answer. Meanwhile kindly answer to this question when i print a report with 0 records with SSRS’s excel extension, whatever message i give in NoRowsMessage (in RDL) it prints it perfectly fine.
But when I use Aspose to print a report with no records to XLSX format then it shows headers in report.
Hi,
Thanks for using Aspose.Cells for Reporting Services.
We still could not find your provided issues.
Please check our exported excel file. Are they in line with your requirement? (see attachments)
Please try the latest version: Aspose.Cells for Reporting Services 2008R2 (ACRS2008R2.V2.1.0.1).
Please copy Aspose.Cells.ReportingServices.dll into following folder :
${SQL Server 2008 R2 Reporting Services}\Reporting Services\ReportServer\bin.
We will keep checking it.
Issues still persists.
1) For no records always header are shown while exporting to excel using Aspose.
Can you please tell me if i can see the specific stack trace where the file is getting crashed ?? Or can you please explain me the trace of attached file ? I was usig 2.1.0.0.When I used your mentioned dll still giving error.
Hi Kanwar,
Thanks for your feedback and using Aspose.Cells for Reporting Services.
We have logged your comment in our database for investigation. We will look into it and fix this issue. Once, the issue is resolved or we have some other update for you, we will let you know asap.
Hi,
Thanks for using Aspose.Cells for Reporting Services.
We have found the issues about not showing NoRowsMessage and fixed it.
Please try the fixed version: Aspose.Cells for Reporting Services (SSRS2008) V2.1.0.8.
Please copy Aspose.Cells.ReportingServices.dll into following folder:
${SQL Server 2008 Reporting Services}\Reporting Services\ReportServer\bin.
Please let us know run result.
And other issues, we could not find, please post debug information for us .
· Update the logger value to debug in Aspose.Cells.ReportingServices.xml.
====================================================================
<level value=“debug”/>
……
==================================================================
· Run export program.
· Check Aspose.Cells.ReportingServices.log in installation folder.
Thanks Shakeel,
Hi Kanwar,
Thanks for your feedback and using Aspose.Cells for Reporting Services.
Please also provide us your RDL file which is causing this exception. We will look into your issue and help you asap.
Please find teh attached RDL.
Hi Kanwar,
Thanks for providing us RDL file and using Aspose.Cells for Reporting Services.
We have logged this issue it in our database for investigation. We will look into it and fix this issue. Once, the issue is resolved or we have some other update for you, we will let you know asap.
This issue has been logged as
- SSRS-40179 - Exception occurring on export - Additional non-parsable characters are at the end of the string.
Hi,
Thanks for using Aspose.Cells for Reporting Services.
We have tested your provided report definition file and could not find any issue.
Please try the latest version 2.1.0.9 (attached)
If you still face the issues, please post some information here.
1. Report Parameter running values .
2. MS default exported excel file.
Hi Kanwar,
Thanks for your posting and using Aspose.Cells for Reporting Services.
We actually need XLS export which is built-in and done by SSRS engine. It means, the XLS export by SSRS report engine.
Hi,
We have evaluated your issue further. We could not reproduce it, so we update some exception handling.
Please try the new version/fix : Aspose.Cells for Reporting Services (SSRS2008R2) V21.0.11 (attached).
Please let us know your run result.
Thank you.
Hi,
Please try our latest version/fix: Aspose.Cells for Reporting Services V2.1.0.16 (attached).
Please copy Aspose.Cells.ReportingServices.dll into following folder: ${SQL Server 2008 Reporting Services}\Reporting Services\ReportServer\bin.
Please let us know run result.
If you still face the issues, please post your report file here.
We will check it ASAP.
Hi,