Not sure if this happens with regular dataset but when using FlatDataSource if you have multiple Rows you are Grouping by the "Group" Total doesn't reach Past 1 sub group as Shown.
In this example we have Line Type -> Product ID -> Part Name
When you exapand Line Type and Product ID the Total Line for Line Type and Product ID do not stretch across the two other groups so you end up with a very strange "subgroup" that is basically the grand total of all the items without braking them down.
This is a bit hard to explain but I will try to show it visually the groups highlighted in Red should not be there, rather the Total Column (in green) should extend out to show the total for that group
Here is an example if it working correctly in one of your youtube videos (here the green columns extend the complete length of the row to show the totals)
Not sure if its just a setting or if its an issue with using the FlatDataSource
Hi Jose,I am not too sure, but it looks like the nature of your DataBase is a bit different from what we have in our sample. For say, I see some extra levels like 'PARTS', 2 Items groups which again got sub levels and that's why when you expand All(ProductID) it shows the collapsed summary Items group which actually a summary total of both the two child Item groups. So it would be great if you can provide me a sample or at least the dataset to reproduce the issue on our side and to investigate more on this?
Thanks,Josheela
Hi
I uploaded a sample a few days ago for a different issue it can be found here
https://filetransfer.infragistics.com/public.php?service=files&t=559ccfe7089dff00971d73a9758b4626
IF.zip is the XML with the data
PivotData_IF.zip is the project
The "DATA" that it loads. This is an XML file it loads from
C:\IF\Budget.xml
I trust you'll be able to change this in the code to load form whatever location you'd like. It was the only way I could figure out how to send you the data to replicate
To Replicate simply launch the project and place the XML file in the correct location (or modify the source to match your location of choice)
Line 133 in Form1.cs
StreamReader sr = new StreamReader(@"C:\IF\budget.xml");
Then run the project,
Dragging additional rows to the pivot should generate the "extra" grouping
Thanks!
Thank you for using Infragistics Components.
Please let me know if I can provide you any further assistance.
Hi,I had logged in an issue into our internal systems to make if PivotGrid behaving right when display FlatData.The developer had an investigation over this and confirmed that the current display of the data on the PivotGrid is expected. That's how FlatDatasouce display data and is different from the one you see in our YouTube videos where we are not using FlatData.
Please let me know if you needs anymore assistance on this issue.