You are welcome.
We managed to link the tables according to the relation into another table . Now don’t know how would place the data into smart markers. We added a 3rd table Casualty and linked all three tables as suggested into one attached in this thread (repint.csv)
repint.zip (4.7 KB)
The final table has a column RecType and would differentiate the individual table (Accs, Vehs and Casualties) by a letter A, V or C
We got stuck as noticed that Group feature on Smart Markers only supports group for 1 field, or perhaps we don’t know how to use it’s syntax correct.
Can you please show an example with smart markers on a template how would we display an accident details, than vehicle details per accident, then casualties per vehicle.
Either with the single table attached here , or with the 2 separate tables (if using those just display accident details, than vehicle details per accident; as we can follow than from your example and implement the Casualties table also)
We also have Aspose.Words and is not necessarily to be in spreadsheet format (as we’ll convert to PDF) and if you think the task is simpler to achieve with ReportingEngine we can use that if you can give a basic template example to achieve it.
Thanks in advance
@Remus87
Could you share an excepted file?
The simplest method now seems to be to merge three tables according to your expected results by yourself, and then simply import one table instead of smartmarker
Sure.
Attached you’ll find:
- the feed files needed (in their simplest form sufficient to showcase the required functionality as they have more than 50 columns each but we make abstractions of rest) → repaccs1.csv, repvehs1.csv, repcas1.csv
- the Expected output → ExpectedResult.xlsx
- Documentation needed to understand the task (with just few self explanatory diagrams)
Input-Expected-Documentation.zip (726.5 KB)
Thanks for the sample files and details.
We need to evaluate your requirements/issue in details. We have opened the following new ticket(s) in our internal issue tracking system and will deliver their fixes according to the terms mentioned in Free Support Policies.
Issue ID(s): CELLSNET-54674
@Remus87
There are multiple levels of nesting here, and we need to redesign the smartmarker to support this level of nesting.
Currently, it is recommended that you organize the data and set it directly to each cell according to your own needs.
Do you mean processing the data into a hierarchical structure?
If so, we did that. And we have 2 hierarchical structures to choose from: Dataset and/or JSON.
1 - We’ve loaded each csv file into a datatable, add the datatables into a dataset , initialize the required nested links via datarelations, set the relations as nested (datarelation.Nested = true)
2 - We serialized the dataset object into a JSON string
Still didn’t figure it out how to reference the markers to fit the data in.
So it is not supported on this level of nested (level 0 - level 1 - level 2) to work with the designer template and place the markers via spreadsheet editor ?
We know how to achieve that programmatically (in code) and fill in the data to generate the final report.
The scope on this use case is to be able to modify the template post development via editor and not modify the code for simpler maintainability.
@Remus87
Thank you for your feedback and detailed information. Smart Markers currently cannot support such complex requirements. We are redesigning smart markers to meet complex hierarchical nesting requirements. Once there are updates, we will notify you promptly.
Thanks for the prompt reply.
We are pleased to inform you that your issue (logged earlier as “CELLSNET-54674”) has been resolved. The fix will be included in our upcoming release (Aspose.Cells v23.12) that we plan to release in the next week. You will be notified when the new version is published.
Thank you!
Managed to do the required with Aspose Words (the reporting engine feature), but will be good to have the Cells alternative also.
@Remus87
You are welcome. Thank you for your feedback. Once the version is released, we will notify you immediately.
@Remus87
Please check
CELLSNET54674.zip (9.6 KB)
Codes.zip (1.5 KB)
As you want to concat some markers, so we have to set them to other columns, then get expected result by formulas.
And there is still an issue that we can not hidden the row if there is no Casualty.
Thank you for the demo and detailed explanation.
Will have a go with it possibly next week.
@Remus87
The demo code depends on the next version.
We will release a new version in the next week.
We will provide a sample project with template file after releasing.
Thank you for your patience.
The issues you have found earlier (filed as CELLSNET-54674) have been fixed in this update. This message was posted using Bugs notification tool by johnson.shi
@Remus87
Please check the attched
CELLSNET54674.zip (9.0 KB) which contains template file and sample codes.
And we defined some named ranges for distinguishing which level the smart marker belongs to.
Thanks for the update!