1月 17

帮助另外一个team改一个bug,主要是涉及到报表的,然后遇到几个坑,填平了记录一下.

首先这个项目报表使用的事SSRS,之前没有做过相关部署,好在资料很多.

 

报表安装配置

需要用到Reporting Services Configuration Manager

Web Service URL 选项卡下有一个 Report Server Web Service URLS, 这个复制下来,就是等会需要发布用到的地址

Database选项卡下配置report数据库

Report Manager URL 下面 就是后台管理的地址,这个等会也会用到

发布部署

在VS中,选择开发好的report project,右键属性页面  

TargetReportFolder  顾名思义,发布上去的文件夹名称

TargetServerURL    复制之前配置用到的 Web Service URL 选项卡下的路径即可

然后右键项目Deploy,即可看到发布进行中,等待完成即可.

 

数据源管理

使用Report Manager URL 下面的URL地址

在浏览器中直接打开

进入Data Sources,配置数据源

最好是记住密码,否则会需要每次输入密码.

安全性里面是报表的用户组的权限的管理,大致就OK了

 

最后记录一点配置日志的东西

日志本身的路径

C:\Program Files\Microsoft SQL Server\MSRS10_50.MSSQLSERVER\Reporting Services\LogFiles

这里可以管理日志的记录,配置文件如下

C:\Program Files\Microsoft SQL Server\MSRS10_50.MSSQLSERVER\Reporting Services\ReportServer\bin\ReportingServicesService.exe.config

修改其中的

 <add name="DefaultTraceSwitch" value="4" />

value值从0到4,默认为3,以此希望输出详细的信息

具体值对应见下表

Setting

Description

RStrace

Specifies namespaces used for errors and tracing.

DefaultTraceSwitch

Specifies the level of information that is reported to the ReportServerService trace log. Each level includes the information reported by all lower-numbered levels. Disabling tracing is not recommended. Valid values include:

0= Disables tracing

1= Exceptions and restarts

2= Exceptions, restarts, warnings

3= Exceptions, restarts, warnings, status messages (default)

4= Verbose mode

FileName

Specifies the first portion of the log file name. The value specified by Prefix completes the rest of the name. By default, the name is ReportServerService_.

FileSizeLimitMb

Specifies an upper limit on trace log size. The file is measured in megabytes. Valid values are 0 to a maximum integer. The default value is 32.

KeepFilesForDays

Specifies the number of days after which a trace log file will be deleted. Valid values are 0 to a maximum integer. The default value is 14.

Prefix

Specifies a generated value that distinguishes one log instance from another. By default, timestamp values are appended to trace log file names. This value is set to " tid, time ". Do not modify this setting.

TraceListeners

Specifies a target for outputting trace log content. You can specify multiple targets using a comma to separate each one. Valid values include:

DebugWindow (default)

File (default)

StdOut

TraceFileMode

Specifies whether trace logs contain data for a 24-hour period. You should have one unique trace log for each component on each day. This value is set to "Unique (default)". Do not modify this value.

Components

Specifies the components for which trace logs are created. The default value is all. Other valid values for this setting include the names of internal components. Do not modify this value.

Runtime

Specifies configuration settings that support backward compatibility with the previous version. Runtime settings are used to redirect requests that target the previous version of Microsoft.ReportingServices.Interfaces to the new version.

All of the configuration settings in this section are described in the .NET Framework product documentation. For more information, search for "Runtime Schema Settings" on the MSDN Web site or in the .NET Framework documentation.

 

 

 

 实际开发中,遇到过的问题

对于服务器管理员组的用户,创建及浏览报表文件没有问题,但对于一般用户在查看报表时会提示:“为用户domainname\username授予的权限不足,无法执行此操作。 (rsAccessDenied)”。(The permissions granted to user 'Domain\user' are insufficient for performing this operation. (rsAccessDenied))

 

 解决方法

Start Internet Explorer using "Run as Administrator"

Open http://localhost/reports

Go to properties tab (SSRS 2008)

Security->New Role Assignment

Add DOMAIN/USERNAME or DOMAIN/USERGROUP

Check Report builder

written by ocean \\ tags: