I am trying to recreate our custom report for ‘Member Roster’ which is really just a customer master data listing with specific fields. It is a very simple report using only customer master data.
In the new custom reports format - Strangely (i) I need to specify a date range which makes no sense for a customer master data listing (not transaction related) and (ii) I end up with a date as the first column on the report, which is entirely unwanted and not specified in the select at all.
How can I get rid of the date range in the heading, and the date column in the detail when I am simply trying to produce a member roster (i.e. customer listing) report?
I am also getting a ‘Total’ line for each group by despite the fact that there are no numerical fields to sum in the data. There is no ‘record count’ in that total line so the line is pure noise.
The biggest issue however is that every customer record appears multiple times on the report repeating with different dates - could be update history or transaction dates etc. Unclear. But (i) I get an empty listing if I don’t specify dates and (ii) I get repeat records when I do
Appreciate any and all guidance as I try to recreate our reports in the new custom report model.
[edit] OK - I have found that if I group by Customer Name I can get and select Groups to colapseI can get to a single record (i.e. what really feels like a true group by) but this suggests that the base select, even though the only record type/table in the select is the customer master is actually selecting transaction records for the customer. What’s going on there?