Formula on Totals

shakeel.faiz · December 7, 2012, 10:30am

Hi,

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

I have added your comments against the issue id: SSRS-40074.

Hopefully, we will provide you some update or ETA soon for this issue.

gaparna · December 14, 2012, 10:56am

Hi ,

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

shakeel.faiz · December 17, 2012, 10:12am

gaparna:

Hi ,

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.

gaparna · January 2, 2013, 10:11am

Hi,

Happy New Year !

We just wanted to follow up to see if we have any updates on the formula before and after hide columns. Please let us know.

Thanks,

Aparna

shakeel.faiz · January 2, 2013, 10:34am

Hi,

Thanks for your kind wishes and using Aspose.Cells for Reporting Services.

We also wish you happy new year 2013.

Our developers are on Holidays at present, so you will get some update on next week.

We have also added your comments in our database. Once, we will have some update for you, we will let you know asap.

Thanks for your patience.

gaparna · January 8, 2013, 6:23pm

Hi,

Sorry, to bother on and on. We would like to know if there is any update on this issue. We are going live in another week and as this is a critical functionality, we thought we will check again.

Please let us know if there any updates.

Thanks,

Aparna

shakeel.faiz · January 9, 2013, 7:20am

Hi,

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

Sure, once there is some update for you, we will share it with you asap.

We have also logged your comments against this issue id: SSRS-40074.

Hopefully, your issue will be fixed soon.

gaparna · January 9, 2013, 10:58pm

Thank you ! As an interim solution , if we could make the &=&= SUMIF(...) can be shown as values on the VS and not as formula until we get a fix for the hide before and after the formula column would help. Although we would definitely need the hide and formula to work as that's a critical funcationlaity for us.

We appreciate all the help.

Thanks,

Aparna

shakeel.faiz · January 10, 2013, 1:41am

Hi,

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

We have discussed your issue with the developments team. We will soon provide you a fix or interim solution.

We will get back to you asap.

amjad.sahi · January 10, 2013, 3:38am

Hi,

We have found the issues and fixed them accordingly.

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

Please let us know your run result.

By the way, we are developing new feature about showing image and text in a cell, so we might delay in replying your issues/queries.

Thank you.

shakeel.faiz · January 11, 2013, 12:40am

gaparna:
Thank you ! As an interim solution , if we could make the &=&= SUMIF(...) can be shown as values on the VS and not as formula until we get a fix for the hide before and after the formula column would help. Although we would definitely need the hide and formula to work as that's a critical funcationlaity for us.

We appreciate all the help.

Thanks,

Aparna

Hi,

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

We have fixed sum question at table footer.

Please download and try the fixed version: Aspose.Cells for Reporting Services v1.9.0.12 (MSI).

Please let us know your run results.

gaparna · January 11, 2013, 10:27am

Hi,

Does the SUMIF only work on the footer and not on the dataset. We didn't test it on the footer but we tested it on the table , summing across column values and not across the row values like &=&=SUMIF($B$5:$CD$5,"Week Of",B{r}:CD{r}) and it didn't work . It still displays the text and not the values on the VS.

update : We tested it on the footer as well and it doesn't work.

Please let us know if the usage is acceptable by the tool.

Thanks,

Aparna

shakeel.faiz · January 11, 2013, 10:52am

Hi,

Thanks for your posting and using Aspose.Cells.

Could you please retest this issue? Because I have recently updated the link from 11 to 12.

So you might be using older Aspose.Cells for Reporting Services v1.9.0.11 (MSI).

Please use the latest one now: Aspose.Cells for Reporting Services v1.9.0.12 (MSI) and let us know your feedback again.

Thanks for your cooperation.

gaparna · January 11, 2013, 3:25pm

Hi,

I'm afraid it is still not working. The formula displays differently , partly in SSRS langauage on the VS/UI /Web , but works in Excel. SUMIF($B$5:$CD$5,"Week Of",Inspections.NAME:Inspections.WEEK60) instead of SUMIF($B$5:$CD$5,"Week Of",B{r}:CD{r}).

Thanks,

Aparna

shakeel.faiz · January 13, 2013, 2:22pm

Hi,

Thanks for your posting and testing your issue with the latest: Aspose.Cells for Reporting Services v1.9.0.12 (MSI).

We have logged your comments/feedback in our database against the issue id: SSRS-40074.

Please spare us sometime, we will soon get back to you.

shakeel.faiz · January 14, 2013, 3:40am

Hi,

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

We cannot find the SUMIF function in your report define file, so the report define file could show the SUMIF formula on the VS/UI /Web.

We have checked your provided report define file.

If you want SUMIF function at the table footer, we advise you to try setting =SUM(K9:K9) directly.

gaparna · January 14, 2013, 7:08am

Hi,

Thank you for looking into the issue. We are attaching a snapshot of where the SUMIF is located at. There are 2 instances where the traditional SUM would not work.

In the example given here , we are trying to sum the values from left to right on the same data row and not the footer. We need this only because, when we hide the columns through Modify Attribute, the addition of column values through C{r}+D{r}+E[r}+....., does not calculate correctly because , after the hide , the columns are shifted left and it would lose some of the values that it would have summed up if not hidden. For example, if the column B is hidden, now C is shifted to B , and hence the value of C is lost as the value of D is now shifted to the column C.

The other scenario which we had described earlier in the thread was for the footer. We are able to use SUM(N9:N9) for a group footer successfuly. We have a second footer which is a sum of all the groups and if we use the same formula, it would only sum the last group and not all of the groups. So , we had used a SUMIF to find a string TOTAL and get the corresponding SUM totals to get the Grand Total.

If there are better and working ways, we would definitely use that. It was just a work aorund. Please let us know if there are other ways to accomplish it.

Thanks,

Aparna

shakeel.faiz · January 14, 2013, 8:10am

Hi,

Thanks for your feedback and providing us further information.

We have logged your comments in our database for investigation. We will look into your issue and get back to you asap.

Once, the fix is available or we will have some update for you, we will share it with you asap.

gaparna · January 14, 2013, 10:04pm

Hi,

Thank you for looking into it. We purchased Aspose for the usage of formula's and it's becoming very critical we deliver the product soon. We would appreciate if we could get this working as early as possible atleast the interim solution of SUMIF. But we would need the original issue being solved where we would have a scenario of hide column between 2 formula's and hence the circular reference error. We truly appreciate your timely help.

Thanks,

Aparna

shakeel.faiz · January 14, 2013, 11:56pm

gaparna:

Hi,

Thank you for looking into it. We purchased Aspose for the usage of formula's and it's becoming very critical we deliver the product soon. We would appreciate if we could get this working as early as possible atleast the interim solution of SUMIF. But we would need the original issue being solved where we would have a scenario of hide column between 2 formula's and hence the circular reference error. We truly appreciate your timely help.

Thanks,

Aparna

Hi,

Thanks for your comments and feedback. We appreciate that you have purchased Aspose.Cells for Reporting Services.

We have also logged your comments in our database. We will look into your rest of issue and help you asap.