Blazer Pivot Grid

Hello, Anoop!
 
Thank you for reaching out to us.
 
Please find the detailed answers to your questions below:
 
1. How can I expand all the rows by default as I want to replicate Excel? 
 
If the data on the screenshot is aggregated, the desired visualization can be done with our classic view.
You can use the expandAll slice property to expand all levels by default:

report: {
    dataSource: {
      //link to the data source
    },
    slice: {
      //other slice properties
      expands: {
        expandAll: true
      },
    },  
    // other report properties
}

Here is the JSFiddle sample illustrating the described approach: https://jsfiddle.net/flexmonster/8L1r2sgq/.
 
Kindly note that you also can show the raw data in Flexmonster using our flat table view.
You can change the grid view on the Options Toolbar tab or via code as follows:

 options: {
      grid: {
        type: "flat",
      },
},

We have prepared the example as well: https://jsfiddle.net/flexmonster/a2km9w3f/.
 
2. Can I use .net entity framework to get data without using Flexmonster Data Server? 
 
You surely can! Flexmonster can accept data in JSON/CSV formats, so the most basic approach we can suggest is to generate data in one of these formats on the server.
Then, on the client side, provide the URL to the JSON/CSV file or to the server-side script, which generates JSON/CSV data. In the code, it should look as follows:

report: {
    dataSource: {
      filename: "https://cdn.flexmonster.com/data/data.csv", //link to a server-side script which generates JSON/CSV file
      //other data source properties
    },
   // other report properties
}

 
We have also noticed the Blazor framework in the ticket's title.
You can look through our Blazor integration in the documentation or check out a video tutorial for more details.
 
Hope you will find our answer helpful.
Please let us know if you have any further questions.
 
Kind regards,
Solomiia

Hello, Anoop!
 
Thank you for your question.
 
Kindly note that in the classic view, the columns and rows representing the names of fields are frozen, while the aggregated values are in the scrollable area.
Therefore, the grid automatically switches to the compact view when there is not enough space for the scrollable content.
 
We suggest the following workarounds to avoid the switch:

1. Increase the size of the HTML container.
2. Resize some columns on the frozen area to leave more space for the scrollable area.
3. Try using Flexmonster in full-screen mode so that there is more place for the columns to be drawn.
4. Place component into resizable div to have the possibility to expand it when needed: https://jsfiddle.net/flexmonster/esp9x2qk/.

 
Hope it helps.
Feel free to contact us if any other questions arise.
 
Kind regards,
Solomiia

Hello, Anoop!

Hope you are doing well.

Our team is wondering if you had a chance to look through our previous answer about avoiding the switch to the compact form. Could you please let us know if it was helpful?

Looking forward to hearing from you.

Kind regards,
Solomiia

Hello, Anoop!

Hope you are having a great week.

Just checking in to ask if the provided approaches were helpful in avoiding the automatic switch to compact view.

Looking forward to hearing your feedback.

Kind regards,
Solomiia

Hello, Anoop!
 
Thank you for getting back to us.
 
Kindly note that Flexmonster has an internal time limitation for the execution of the expandAll function or expandAllData() API call. By default, it is set to 9000 ms, but you can increase the waiting time using expandExecutionTimeout option. It should be added to your report as follows:

report: {
   options: {
     expandExecutionTimeout: 9000 //time in miliseconds
   }
}

You can find more details about this option in our docs: https://www.flexmonster.com/api/options-object/#expandexecutiontimeout.
 
Please let us know if this option works for your case.
 
Kind regards,
Solomiia

Hello, Anoop!

Thank you for your feedback.

We are glad to hear the suggested property works well for you.

Feel free to contact us in case of any other questions.

Kind regards,
Solomiia

Hello,

Thank you for contacting us.

Kindly note that accessing the database directly from the client side could lead to potential security issues.
Another possible way to handle the data from the database is to write the server-side script, which generates the JSON/CSV data. The link to the generated data should be specified in the filename property of the DataSourceObject as follows:

report: {
   dataSource: {
      type: "json", //or "csv" depending on your data
      filename: //url to the server-side script endpoint
   }
}

In case you want to display larger data amounts, one more option to visualize data from any data source is creating a custom server. The server should be responsible for fetching and processing the data from a data source. Then it should pass the data to the component. Flexmonster can handle data from any server with the custom data source API.
Please note that implementing Flexmonster custom data source API is more complex than using Flexmonster Data Server and would require developing resources. 

Please let us know if our answer helped. Looking forward to hearing from you.

Kind regards,
Nadia