Issues with Aspose.cell.reportingservices exported file using "ACXLSX" format rendering option

Aspose.Cells Product Family
2

Hi,

Thank you for considering Aspose.

We think that the number format code you are using may not be the standard code. Please share your RDL file. We will check it soon. Aspose.Cells for Reporting Services 2005 supports following standard codes.

Number g ,N , D0 ,F ,e
Date g ,D ,d
Time g ,T ,t
Percentage P,P0
Currency C

Thank You & Best Regards,

3

Hi -

Please find the attached rdl file. Still i'm waiting for an answer for my issue #1 which is why i'm getting the error while opening the workbook which i exported.

I will get the same error until i open and save the exported workbook in excel 2007.(refer the attached workbook)

Thanks

BK

4

Hi,

Thank you for sharing your RDL and exported xlsx file.

There is a custom code "N0" used in your RDL file which is causing this issue. We are working on it to support that custom code and we will provide you with a fix soon.

Thank You & Best Regards,

5

Where do you see customcode=NO in my RDL, I am unable to find that line in it.

Thanks

BK

6

Hi,

Thank you for considering Aspose.

Well, it is not “NO”, it is ‘N0’ (‘0’ is digit). You can search for the “format” tag in your RDL file to see the custom format code used. We are working to support this custom format code and we will provide you a fix soon.

Thank You & Best Regards,

7

Hi

Please try the attached latest fix of Aspose.Cells for Reporting Services and perform the following steps,

Step 1:

Please copy Aspose.Cells.ReportingServices.dll to ${SSRS}\ReportServer\bin\ path.

Step 2:

Please update render extension at server:

To do this, open C:\Program Files\Microsoft SQL Server\MSSQL.x\Reporting Services\ReportServer\rsreportserver.config and find the following lines …… element:

" and update

"

Thank You & Best Regards,

8

I followed based on your steps.

Step1: Replaced the existing files (Aspose.Cells.ReportingServices.dll) with the one you provided in bin folder(D:\Content\ReportServices\MSSQL.1\Reporting Services\ReportServer\bin)

Step 2: I have those extensions already in my config file, so no change required.(attached the config file as *.txt file)

When i run my application, I'm getting the error below

An attempt has been made to use a rendering extension that is not registered for this report server. ---> An attempt has been made to use a rendering extension that is not registered for this report server. ---> An attempt has been made to use a rendering extension that is not registered for this report server.

I tried to register the new dll you provided aswell, but not able to successfully register, i'm getting an error as dll already loaded even after stopping the sqlserverreportingservices.

What am i missing? are its still an issue please let me know.

Thanks

BK

9

Hi

We have checked your file. Please update your extension.

Your rsreportserver.txt:

XslxRenderer,Aspose.Cells.ReportingServices" />

New Extension:

XlsxRenderer,Aspose.Cells.ReportingServices" />

Thank You & Best Regards,

10

The issues you have found earlier (filed as 8431) have been fixed in this update.

This message was posted using Notification2Forum from Downloads module by Amjad Sahi.
11

HI -

I purchased a licence copy of Aspose.cells.reporting services.Purchase order # 3500304537.

i tried to set the licence file by folowing the steps mentioned here

http://www.aspose.com/documentation/ssrs-rendering-extensions/aspose.cells-for-reporting-services/licensing.html

I have my licence file copied to folder" C:\Program Files\Aspose\Aspose.Cells.ReportingServices\License "

and edited the C:\Program Files\Aspose\Aspose.Cells.ReportingServices\Aspose.Cells.ReportingServices.xml file to have the path of my licence but still not able to get rid of the evaluation watermark.(attached the xml file).

Question:

why do i see "Aspose.Cells.ReportingServices.Client.dll" instead of "Aspose.Cells.ReportingServices.dll" under the folder C:\Program Files\Aspose\Aspose.Cells.ReportingServices\Bin? but i able to see the Aspose.Cells.ReportingServices.dll under D:\Content\ReportServices\MSSQL.1\Reporting Services\ReportServer\bin.

I even tried copying the licence file and Aspose.Cells.ReportingServices.xml to my D:\Content\ReportServices\MSSQL.1\Reporting Services\ReportServer\bin. folder. no change.

Please help.

BK

12

Hi,

Please try the following steps:

If the problem still persists, do let us know.

Thank you.

13

Hi -

Thanks for your reply. But i still have the problem, i'm not sure what is wrong.

I will be working in US EST time.

BK

14

Hi,

Could you post your license file to us via mail. To post the license file please follow the instructions @: https://forum.aspose.com/t/how-to-send-license-file-to-support-team/225542

We will check your issue soon.

Also, please confirm us here in this thread when you have posted your license file.

Thank you.

15

Hi -

I have posted the licence file by emailing you, please respond asap.

Regards

BK

16

Hi,

Yes, we have received your license file, we will check your issue and get back to you soon.

Thank you.

17

Hi,

We have tested your license file, it works fine.

Well, we need further details from you in figuring out your issue. Please give us your server environment, OS, SQL Server version, 32-bit/64bit and other details etc. Moreover, kindly provide us the Aspose.Cells.ReportingServices.log and install.log files here, we want to check them too.

It is to be noted here, if you are using SQLServer 2008/2005 with 64bit machine, this licensing issue might occur as the component can throw an exception for license file existence. If this is the case with you, we are already working on this issue and will figure out this issue in 1-2 days.

Thank you.

18

I have emailed you the server details with intall.log to troubleshoot further on licence file issue.

Regards

BK

19

Hi,

Thank you for considering Aspose.

We checked your install log file. Installation is normal.

Please try the attached latest version. If the question still exists, please check follow information.

· Please check the PATH value of the registry key.

‘HKEY_LOCAL_MACHINE\SOFTWARE\Aspose\Aspose.Cells.ReportingServices’ key.

· Check the ‘Path’ value is installation path.

· Check the Aspose.Cells.ReportingServices.xml file.

The Aspose.Cells.ReportingServices.xml file must be in ${installation}

· Configure Aspose.Cells.ReportingServices.xml as:

Please copy the license file to C:\Program Files\Aspose\Aspose.Cells.ReportingServices\License\Aspose.Cells.Reporting.Services.lic

OR Configure Aspose.Cells.ReportingServices.xml as:

Please copy license file to ${Reporting Services}\ReportServer\bin\ ， ${Reporting Services}\ReportServer\

Or

${Installpath}\License.

The license file name is Aspose.Cells.Reporting.Services.lic.

If the issue still exists, please post Aspose.Cells.ReportingServices.log here.

Thank You & Best Regards,

20

my registry path is C:\Program Files\Bin\SSRS2005\Aspose.Cells.ReportingServices.dll. which is wrong. let me know what it should be.

it almost a week from my purchase, still unable to resolve this issue.. is there any better support i can have?

BK.

21

Hi,

Thank you for considering Aspose.

Well, the registry path is basically your installation path of Aspose.Cells for Reporting Services. For a standard installation (with default path) the registry path is as following,

C:\Program Files\Aspose\Aspose.Cells.ReportingServices\

Please check it and let us know if it works fine.

Thank You & Best Regards,