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.
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.
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
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.
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.
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.
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.
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 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.
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.
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.