Badly formatted report looks like CSV rendered it not ACTXT

Aspose.Cells Product Family
,
21

@boaz.goldstein,

As requested earlier, please try this scenario using latest version and share the feedback. Testing with the latest version is highly recommended as up-gradation are always done to resolve different type of issues in our newer versions. If you still face issue, please share your RDL and template files for our testing here.

22

Hi Ahsan
Can you please provide download link to the DLL itself?
The link you sent is for downloading the MSI which is not prefered.
Latest file i got from you last year and installed was:
ACRS2012.V17.8.5.zip
Inside only:
Aspose.Cells.ReportingServices.dll

Thanks
Boaz

23

@boaz.goldstein,

You may please try to download the Aspose.Cells.ReportingServices_Dllsv18.2.ZIP file which contains DLLs for Aspose.Cells.ReportingServices v18.2 and provide your feedback.

24

Thanks Ahsan
I noticed that DLLs inside the Zip you sent - are all Aspose cells version 18.2.0.0
image.png (15.8 KB)
You mentioned version 18.2.5.
Can you please resend the link?

Thanks
Boaz

25

@boaz.goldstein,

It is better you download and install the fix using MSI Installer of Aspose.Cells for Reporting Services (the link for v18.2.5 is already provided in one of our previous posts).

Anyways, you may try using the Dlls version of the latest fix/version (Aspose.Cells for Reporting Services v18.2.6) here if it works for your needs.

26

@boaz.goldstein,

Moreover, was the report definition file created by Aspose.Cells for ReportingServices Client?

27

Hello Amjad and Ahsan @ Aspose support
Aspose.Cells 18.2.5 was deployed in our production Reporting services 2012 farm (3 servers working in scale-out config).
As I anticipated - the problem still occurs with the newer version.
What i would like to check is whether caching problem can explain this issue…?
Our reports are executed using a custom delivery extension, which gets the execution parameters of a single report using a data-driven subscription in SSRS. Format input variable, at some cases may be actxt or accsv as expected by aspose dll and extension definition in rsreportservice.config file.

Any other way we can explain this?
How can we understand where is this issue coming from?

Thanks
Boaz

28

@boaz.goldstein,

Please mention the details about custom delivery extension. We are checking your scenario and will get back to you with more information in this regard.

29

Hi
Regarding custom delivery extension -
Developed obviously in .NET and inherits ssrs dlls.
This is a delivery extension so we can “call” via a data-driven subscription where you can use database values to populate execution and delivery variables.
For the delivery variables, depending on the format we use the registered aspose extensions we use - ACTXT, ACCSV.
delivery extension is managing report execution internally using database records for persistency and UI interface.
delivery extension dll is registered in rsreportservice.config file with global variables.
you also need to register the extension in the .net policy file.

What additional information can help you here?

Thanks
Boaz

30

@boaz.goldstein,

Thank you for sharing the details. We will get back to you with our feedback soon.

31

Hi Aspose Support,
Any new details you can provide? this issue still persists.
Thanks
Boaz

32

@boaz.goldstein,

I am getting the details and will update you soon.

33

@boaz.goldstein,

Well, we built test environment which includes delivery extension but we could not reproduce the issue. Now we plan build to new debug version which can get more information from your end for investigation. Is it ok that we provide you debug version and you test it on your environment to get more information to trace the issue?

34

Hi Amjad
Sure - it sounds like the best option.
Let me know where i can download it from.
Thx
Boaz

35

@boaz.goldstein,

We are working on it and will let you know soon.

36

@boaz.goldstein,

We are developing the debug version and will provide you in the next week.

37

@boaz.goldstein,

Please try the latest fix (debug version): Aspose.Cells for RS v18.2.8

In order to get the debug information, please update logger level to debug in Aspose.Cells.ReportingServices.xml:
i.e.,

============================================
<logger>
		<level value="debug"/>      
	</logger>
=============================================
38

Hello Support
We have deployed the debug version in our production reporting-servers today and have started collecting debug logs.
How do you want to progress from here?

Thanks
Boaz

39

@boaz.goldstein,

Please share the debug logs with us, we will check it soon.

40

Hi Support,
Here are the logs from after a little over 24 hours of activity with the debug version.
These logs are from 3 production servers.

Aspose.Cells.ReportingServices_18.2_logs.zip (708.5 KB)

Thanks
Boaz