6/29/2023 0 Comments Using zoom for grandtotalUse the Sort Order property to define the sort order. The summary type can differ from the summary type currently used in the Cross Tab. Use the Summary Type property to specify which summary function to calculate.You can also define a field that is not currently displayed in the Cross Tab. Set the Field Name property to the name of an assigned data source's field.Select a cell you want to sort and expand the Sort By Summary Info property in the Property Grid.You can also use the Sort By Summary Info property to arrange row/column field values based on grand totals values. Set this property to None to keep the same order as records in the Cross Tab's data source. Use the Sort Order property to change the current sort order. The Cross Tab displays row and column field values in the ascending order. Use the Summary Display Type property to display results' contribution to other cell values, for example, as a percentage of grand total values. Use the Summary Type property to specify the summary function calculated against a data field. The Cross Tab summarizes values of data fields and displays the results "as is" at the intersection of the corresponding rows and columns. If you want to hide specific totals, select any cell in the row/column and disable the Row Visible/ Column Visible property. You can use the layout options to move rows and columns that display total values.
0 Comments
Leave a Reply. |