I have a table setup to group. If I group By InvoiceID, it work fine, it groups by Invoice. If I try to group by CustomerID I get either 1 or 0 groups returned. I know it's not the data because for every InvoiceID, there is a CustomerID, which you can see from my sample. What am I doing incorrectly??
1 Answer, 1 is accepted
Hello Michael,
I inspected the attached report definition and I think it should be working as expected as the table is in the group header and its DataSource is bound to its parent "group" data.
I replaced the SqlDataSource with CSV data with a similar schema to make the report runnable. I removed the Filtering and the Report Parameters. The report was rendered as expected in this case when it was grouped by CustomerID.
I have attached the modified report. You may take a look at it and try to find out whether the filtering or the data was causing the problem. If the issue persists, you may send us sample data we may use to replicate it and investigate further.
Regards,
Todor
Progress Telerik
Rank 1
Iron
Iron
Todor,
Thank you for looking at this. I am also unsure why the grouping was not working, because it should have. I literally just finished replacing the table with grouping with a Crosstab table and removed the grouping. I kept the filtering as-is and it is working as I need it to. The layout is not as clean, but it gets me the result I need.
Thank you,
Mike