Free Support Forum - aspose.com

Formula on Totals

Hi ,

We wanted the formula for the columns and it works on the excel , but although it displays the value on the report as , ((fields!week1,value+fields!week1,value)), and for sub totals where we have the sum as sum(c3:c3) displays the whole text rather than the value on the report. For the Totals for the group , we have a formula &=&=(SUMIF(C3:C{-1},"Total",O3:O{-2}) ). These formula convert into values on the excel but on the report seems to display the text. Is there a way to make it work in both the places.

Thanks in advance.

Thanks,

Aparna

Hi,

Thanks for your posting and using Aspose.Cells for Reporting Services.

Please provide us your sample source RDL file and the output rendered reports to look into this issue.

Please also download and try the latest version:
Aspose.Cells
for Reporting Services v1.8.0.71 (SSRS2008R2)

and let us know your run results.

We have also logged this issue in our database for investigation at our end.

Once, there is some update for you, we will let you know asap.

This issue has been logged as SSRS-40074.

Thank you for the quick reply. We will download the new version and try it again.

Meanwhile, attaching the rdl and excel files along with some screenshots on the error(hide fucntion) and issues(totals display) we see. Columns I and J have come over , as per the logic in dyn hide those need to be hidden.

Thanks,

Aparna

Hi,

Thanks for providing us all the necessary files i.e

1 - RDL reports
2 - Xlsx renderings
3 - Screenshots.

We have logged your files and feedback in our database. It will help us resolve this issue.

Once, this issue is resolved or we have some other update for you, we will let you know asap.

Please also let us know your run results with the latest version given in the above post.

Thank You !

We did install .71 version and it has helped with the individual totals where C{r}+D{r}+e{r} formula is applied. The other subtotals and total values where we have used the SUM fucntion has not been corrected yet.

But when we try to open the report on the designer it fails. The new download only had the services.dll and not the client dll and hence we are not sure if that had any effect. Attached is the screenshot of the error.

The error is at

Public Sub GetAsposeClientTools()
If AsposeClientTools Is Nothing Then
Set AsposeClientTools = CreateObject("Aspose.Cells.ReportingServices.Client.AsposeClient")
End If
End Sub

Thanks,

Aparna

gaparna:

Thank You !

We did install .71 version and it has helped with the individual totals where C{r}+D{r}+e{r} formula is applied. The other subtotals and total values where we have used the SUM fucntion has not been corrected yet.

Hi,

Thanks for your feedback.

We have logged your comments against the issue id: SSRS-40074

gaparna:

But when we try to open the report on the designer it fails. The new download only had the services.dll and not the client dll and hence we are not sure if that had any effect. Attached is the screenshot of the error.

The error is at

Public Sub GetAsposeClientTools()
If AsposeClientTools Is Nothing Then
Set AsposeClientTools = CreateObject("Aspose.Cells.ReportingServices.Client.AsposeClient")
End If
End Sub

Thanks,

Aparna

We have logged this issue in our database with the issue id: SSRS-40075.We will look into it and help you asap.

Thanks for looking into it. Looking forward for the fix.

Thanks,

Aparna

Hi,

Thanks for using Aspose.

Please download and try the latest MSI installer: Aspose.Cells for Reporting Services V1.8.0.72 (MSI).

Please let us know your run results.

If you still face the issues, please post your report file here.

We will check it ASAP.

Hi,

We have the 8.0.78 version now. We are able to open up the report and everything. The formula's are being displayed as formula's on the VS yet and not as values. It does work on the exported excel. Is there something we have missed to acheive that ? Please let us know.

Thanks ,

Aparna

gaparna:

Hi,

We have the 8.0.78 version now. We are able to open up the report and everything. The formula's are being displayed as formula's on the VS yet and not as values. It does work on the exported excel. Is there something we have missed to acheive that ? Please let us know.

Thanks ,

Aparna

Hi,

Thanks for your input and using Aspose.Cells for Reporting Services

Please spare us some time, we will look into your issue and get back to you soon.

Hi,

Thanks for your posting and using Aspose.Cells for Reporting Services.

We have found the issues relating to circular reference error.

Attachment: Report40078-4.rdl

Hiding column caused the excel formula point to wrong column index.

Now we have fixed the bug and supported sample formula index update.

Please try the fixed version: Aspose.Cells for Reporting Services V1.8.0.79 (MSI).

Please let us know your run results.

Hi,

The formula's for the dataset is working with the values being displayed in VS. Earlier the formula was being displayed in VS. However, the formula is still being displayed as the same for the group by 's like the total's in the footer row. Would there be a possible fix for this ? Please let us know. Thanks in advance.

Thanks,

Aparna

Hi,


Could you attach your sample RDL file and screen shots taken in VS.NET to highlight / show the issue(s) (you may encircle the problematic areas in red) regarding Group by formulas for the fields, we will further look into your issue soon.

Thank you.

Please find the attached snapshot from VS, showing the formula being displayed on the GUI.

Thanks,

Aparna

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


This message was posted using Notification2Forum from Downloads module by aspose.notifier.

Thank you for the update. We are testing out all the featurs on your new version. We noticed, the issue discussed above for the total's for all the groups is not working. The subtotals for the groups using SUM(N3:N3) does work. But the totals for all the groups as the last footer is still not working. We used sumif function to make it work on the excel, but the formula ( &=&=(SUMIF(C3:C{-1},"Total",N3:N{-2}) ) ) is still being displayed in the VS.

Thanks,

Aparna

Hi,


We will look into your issue soon.

We have logged your comments with your RDL file that you provided us in your previous reply against your issue “SSRS-40074”. I have reopened your issue again.

Once we have any update on it, we will let you know here.

Thank you.

Hi,

We had a circular reference earlier, that you had fixed for us earlier. However, looks like if the formula's exist before the hidden columns, it does work. But if we have one after the hidden columns, the formula's go crazy again. Attaching the rdl and excel for your reference. Apart from the circular reference error, we also have the total's formual being displayed as the formula on VS and not value , because the formula's are excel based which is logged as SSRS-40074.

Also, attached is the screenshot of the data on excel and VS. On the excel, the formula in Feb availability (row totals) has 5 cells, but one of the cells is hidden druing runtime. Instead of using only the visible 4 cells, it uses a cell forward that is visible which is the Jan totals and hence the formula's are all mixed.

Thanks,

Aparna

Hi,

Thanks for your posting and providing us the necessary files with screenshots showing the problems.

Please spare us some more time to look into these issues.

Once, the fix is available or we have some other update for you, we will let you know asap.

Hi,

Please let us know, if you have any updates on the circular reference error.

Thanks,

Aparna