[Experience] SQL Server 2000 reportservice FAQ

Insufficient report Service Access Permissions:

Create a local account for the Users Group, modify the access permission of the reportserver virtual directory, allow anonymous access, and set the anonymous user to the user of the new users group.

Chinese support:

When exported to PDF, what are the Chinese characters? The reason is that the text box font should be set to a Chinese font.

A blank page is displayed in the printed result:

The size of the canvas to be restored on the layout page, preferably the same as the size of the content. If it is set to the size of the paper, a blank page will appear.

Formatted display of the time field type:

Modify the format attribute of the text box. If it is set to D, it is a long date format.

Border settings:

If borders are set for adjacent text boxes, the Border width will be different in the print result. The solution is to expand the borderstyle attribute and set the left, right, bottom, and top values respectively, set default to none.

External parameters:

Like the stored procedure, the parameter is written as @ parameter name.
Data settings:
Select *
From indicates
Where (field name = @ parameter name)
You can set the parameter name to Chinese. The parameter name may affect the page for viewing reports.