Advanced Matrix
Heyya guys,
Hope you are doing great as I'm totally lost here, crying over my keyboard and over the thought that I'm trying to invent the bicycle with the stick in hand and whooping around, if you know what I mean...
So, I have a query consisted of Customers & their tickets info for particular period of time in one table. And I need to make advanced matrix for each customer showing their tickets. Easy-peasy, yeah?
What I made is a Group Header, connected to Customer Name and I put Ad Matrix there, connected to this table as well. But what I found - it shows all tickets without customer filtration.
If I remove data connection from Matrix & leave only connection from Group Header - it shows only first ticket for each Customer, but at least they're related.
If I move Ad Matrix to Group Footer - it works perfectly, but... I have issues with Visibility Expressions for Ad Matrix columns, which I want to make user manageable, and right now the expression is totally ignored by compilator.
I have a lot of thoughts arounds it. Am I doing something wrong with Ad Matrix parameters that it shows only 1 row with Matrix being in Group Header? Or is it something wrong the query and should I try making two tables: Customers & Tickets? Like Data connected to Customers table & Ad Matrix there connected to Tickets table maybe... Is it any possible way to toggle Visibility Expression with Matrix being in Footer (I have already tried to do it through code part, but I can't find suitable handler for that)?
version: FastReport.Net 2022.1.6.0
