Display Data from SQL into table format in Cimplicity Screen

Hi,

In some sites, The report may be needed to show in Cimplicity Screen instead of Excel sheet. In that case, we can use a control called Data-Grid.

It can be found under .Net control -> Windows Presentation Framework -> DataGrid.

You may already aware of stored procedures and Report Generation in Excel script.

So instead of using excel, We can directly assign the recordset as the source for Data Grid items. Thus we can achieve the below result.

As shown here, You can give direct column names and also can use alias names. So get the script from here and play around as usual.