I am working to generate reports in SQLNote trying to eliminate in part FileMaker.
I filter data by Dates. So far I can get the range that I need and I can see the Context Parents.
The challenge is that without the Upper Parent is not possible to establish the larger context of the report.
The Pivot table is not working because in this case we are using only 0ne Field with Sub-Items for everything except Numbers values and Dates.
It would be great to choose a Upper Context Parent "Level" so that we can be drill as deep as we need working with Filter on any Source Data.
Or maybe it can be done but I have really no clue after going around for a couple of hours.
I am trying different data structures to get what I need in order to migrate my databases into SQLNotes. I know I will have to negotiate different Pros and Cons but again this program is worth the efforts.
Thank you.
Pierre, I hope you feel better soon.
The other day I had to stop myself from working until collapsing on my laptop and take a good brake.
Comments
(yet?)