Step 1: click on the column header and choose Textbox Properties. Step 2: Choose Interactive Sort from the Textbox properties dialog and the checkbox for Enable interactive sort on this Textbox Choose Player ID field from the Sort by drop down. And we are done. Let us perform the same for PlayerNamefield.Now run the report As can be seen that the sorting has been enabled on two columns and the report is presented in descending of Player ID. Paging in SSRS report This section will give us the way of generating custom paging in our report. We will also learn the use of Global variable in doing so. Step 1: In the report design screen, right click and from the context menu, choose Add Page Footer Once the Page Footer is added, we can then add controls to it. Step 2: Let us add four textboxes from the Report Item toolbox onto the designer as shown under Step 3: Choose the 2nd textbox and click on the Expression Step 4: From the expression window that opens, let us write the expression =Globals!PageNumber Similarly for the 4th Textbox, let us the expression as =Globals!TotalPages.
Step 1: click on the column header and choose Textbox Properties. Step 2: Choose Interactive Sort from the Textbox properties dialog and the checkbox for Enable interactive sort on this Textbox Choose Player ID field from the Sort by drop down. And we are done. Let us perform the same for PlayerNamefield.Now run the report As can be seen that the sorting has been enabled on two columns and the report is presented in descending of Player ID. Paging in SSRS report This section will give us the way of generating custom paging in our report. We will also learn the use of Global variable in doing so. Step 1: In the report design screen, right click and from the context menu, choose Add Page Footer Once the Page Footer is added, we can then add controls to it. Step 2: Let us add four textboxes from the Report Item toolbox onto the designer as shown under Step 3: Choose the 2nd textbox and click on the Expression Step 4: From the expression window that opens, let us write the expression =Globals!PageNumber Similarly for the 4th Textbox, let us the expression as =Globals!TotalPages.
1.%20SSRS.docx