Add more Rows

[Jesus Alejandro Castillo Lizarraga]

Good day.-

I been working with you library for a few months, but one question comes to my head and is, can i add more rows o separate the rows, here is a sample of my code.-

this.dataSource = {

                    data: this.data,

                    expandAll: true,

                    /*can we separate this row from 1 to 3??*/

                    rows: [{ name: 'nRuta', caption: 'NoRuta' } , { name: 'ruta', caption: 'Ruta' }, { name: 'empleado', caption: 'Vendedor' }],

                    columns: [{ name: 'id_linea', caption: 'Id', showSubTotals: false  } , { name: 'Linea', caption: 'Linea', showSubTotals: false } /* */],

                    formatSettings: [{ name: 'venta_total'}],

                    values: [{ name: 'venta_total' }],

                    filters: [],

                    conditionalFormatSettings: [

                      {

                        value1: 30,

                        value2: 50,

                        conditions: 'Between',

                        style: {

                          backgroundColor: '#80cbc4',

                          color: 'black',

                          fontFamily: 'Tahoma',

                          fontSize: '12px'

                        }

                      }

                      ,

                      {

                        value1: 20,

                        value2: 25,

                        conditions: 'Between',

                        style: {

                          backgroundColor: '#f48fb1',

                          color: 'black',

                          fontFamily: 'Tahoma',

                          fontSize: '12px'

                        }

                      }

                    ]

                  };

[Sivamathi Natarajan]

Hi Jesus Alejandro Castillo Lizarraga, 

 

Thanks for contacting Syncfusion support. 

We suspect that your requirement is “Classics layout”. It looks like below UI. Could you please confirm is this your requirement? 

 

 

If yes, currently the pivot table follows Excel-like layout. But we have logged the requirement as a feature task in our database which will be available in any of our upcoming release. You can track the task in the following link. 

 

https://www.syncfusion.com/feedback/5859/classic-layout-support-for-pivotgrid 

 

Please let us know if you have concern. 

 

Regards, 

Sivamathi. 

[Jesus Alejandro Castillo Lizarraga]

Yes, something like that, but i was trying to something like this:

on my web and the excel:

because rigth now the report give me something like this 2 images

on web:

it's ok, but the info it repeats 3 times in both reports and for the user is a little confusing 

export to excel:

But i'm glad about your answer and i been follow the request, thanks!!!

[Sivamathi Natarajan]

Hi Jesus, 

 

Yes, this is also the classics layout. And we have already provided you its feature task. It is applicable for both component rendering and exporting. Kindly track this for updates. 

 

Regards, 

Sivamathi.