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.
We wanted to find out if there are any updates on the formula, it's really a critical functionality for us , for the report to be able to function with formula having hide columns before and after the formula column. We are going live very soon and we wanted to know the status of this issue. Please let us know and we truly appreciate for all the support you have extended so far .
We wanted to find out if there are any updates on the formula, it's really a critical functionality for us , for the report to be able to function with formula having hide columns before and after the formula column. We are going live very soon and we wanted to know the status of this issue. Please let us know and we truly appreciate for all the support you have extended so far .
Thanks,
Aparna
Hi,
Thanks for your posting and using Aspose.Cells for Reporting Services.
We are afraid, we do not have any update for you at this moment. Please spare us some more time. It seems your issue is difficult to be fixed, so it is going to take even longer (few weeks).
Anyway, I have now added your comments against the issue id: SSRS-40074 to escalate your issue.
Once, we will have some update for you, we will let you know asap.