SQL Server Reporting Service (SSRS) Fourth article summary of SSRS usage

1. How to make the header appear on each page (translate)

　　A. Turn on Advanced mode:

Click the arrow to the right of column goups in the group bar to select Advanced mode;

　　　　

　　B. finding the first static group

In the row Groups area ( Note that it is not Column Groups), click the static group, and the corresponding textbox in the Tablix will be highlighted , click each of the static groups until the leftmost column header is highlighted, which is usually the first static group;

　　C. Setting properties

In the Properties window, set RepeatOnNewPage to True while confirming that the KeepWithGroup property is set to After.

2. Commonly used expressions:

A. Show page number: =globals! Pagenumber.tostring () + "/" +globals! Totalpages.tostring ()

B. Formatted time format: =format (CDate (fields! StartDate.Value), "Yyyy/mm/dd")

3. A picture to understand Table/list/matrix difference:

4. Summary:

A. about how the content is centered: The current solution is manual adjustment, one time to look at once, then adjust to see again, until appropriate.

B. Blank page: The main reason is that the actual data content width + distance from the left line of the page + distance from the right line of the page is greater than the actual width of the page, resulting in overflow;

C. How to locate the report Data window: Ctrl+alt+d.

SQL Server Reporting Service (SSRS) Fourth article summary of SSRS usage