in the documentation for .NET you mention that you can skip rows using the following code:
&=CTF_KPI_REV_CLI.CLIENT(skip:1,noadd)
This does not seem to work in the version for reporting services:
The Value expression for the textrun ‘D01REV_9_1.Paragraphs[0].TextRuns[0]’ contains a colon or a line terminator. Colons and line terminators are not valid in expressions.
What is the correct way to write this formula in aspose.cells for reporting services?
@shakeel.faiz please find an example attached. I cannot add an example with the skip as aspose does not save files that contain errors. I have attached an output with the result of what I am expecting.
Thanks for your sample RDL and sample Excel files.
We have logged your requirement in our database for evaluation and investigation. We will look into it and help you to deal with this issue. Once, we will have some news for you, we will help you asap.
This issue has been logged as
CELLSRS-525 - Using Skip Row Smart Marker in Aspose.Cells for Reporting Services
Just to let you know that I have been running more tests, even by not using the ##group tag, but in this case it seem ASPOSE assumes I want to return the data down the columns and just repeats all the data multiple times.
Ultimately I would like to return multiple rows of data per “database line” in order to present the data in a easier format to read and have all the secondary lines grouped together (not through 7 different levels)
What I don’t seem to understand is that by using the group tag, it also hides the primary line no matter where I start the tag, when I would expect the top line to always be visible and the + to be added only for the lines that have a group tag.
Thanks for your posting and considering Aspose APIs.
Grouping seems to be working fine as I have checked your previous Excel file as shown in the following screenshot.
Please highlight your issue with some screenshots and related RDL files. Besides, it seems, your current issue is not related to Smart Marker and it is only related to grouping. Please clarify. We will then log a separate ticket based on your provided information.
I do not get this at all when I run the sample code I gave you hence my ticket, did you make any changes to the code I provided to have it output this way?
EDIT: I couldn’t believe my eyes that it worked for you since I must have spent 6 hours on this already trying to get it to work so I tried to run it again on my end but I can confirm it does not work (took a screenshot but cannot figure out hot to embed an image on the forum)
the grouping is all wrong on my end, what did you change in the code?
We are unable to open your provided RDL file. The Excel file I shared earlier with you was provided by you which I mistook as your actual output but it was your expected output which you created manually.
However, when we tried to open your RDL file i.e. grouptest_.rdl in Aspose.Cells for Reporting Services Client Tool or Microsoft Excel 2016 Add-in, it did not open up.
Please check the sample RDL files and their screenshots. As you can see, Company Sales.rdl from Aspose is opening fine but grouptest_.rdl is showing error.
i.e.
We tried to open the report definition file. But we could not use Aspose.Cells for Reporting Services Client to open the report definition file in MS-Excel.
Please share with us how did you create the report definition file?
@shakeel.faiz I used Aspose but the Addin is not very stable and I receive a lot of errors (when opening new windows or other) I sometime lose all my work and need to start over.
Sure, we will look into it and provide you an example hopefully. We have also recorded your request. Once, we will have some update for you, we will let you know asap.
@shakeel.faiz the document you attached does not have information on skip row. could you please include an example on how to use skip rows within the parameters document?