Get rdl-file from Report Server

1. Go to report.

2. Select Properties tab.

3. On general page, click on link Edit.

4. A file download window is opened,
    Save the file.

Missing right border on table in RS-report

In some RS reports I have had problems that the right border on a table is not visible on a RS-server.

(It looks ok in development environment, VS2005,  it also is ok when the report is exported to a PDF file from the RS-server).

 

The only workaround I got to work is to add one more column to the right of this table, and merge it with the previous one, and make it very thin.

Unwanted extra pages when exporting RS report to PDF

If there is unwanted extra pages when a RS report is exported to a PDF file, the problem might be solved by making sure that the width of the body, header and footer is smaller than the width of the report itself.

Format date in Reporting Services as YYYY-MM-DD HH24:MM

=Format(Fields!LOGINDATE.Value,"yyyy-MM-dd HH:mm")

RS Date/Time parameter format vs Oracle Date format

In Reporting Services I have had big problems to compare RS parameters defined as Date/Time with columns in an Oracle Database defined as Date.

The problem is when searching with:

"oracle column" <= "date entered in Date/Time parameter".

The workaround I use is:

AND LMS_LOGINLOG.LOGINDATE      >= :param_FromDate
AND LMS_LOGINLOG.LOGINDATE -1 <= :param_ToDate

To only have Integer (and no decimals) values on Axis is RS

Select Axis Properties.
On Interval set Expression to somting like:

 

=IIF(Count(Fields!FNAME.Value,"ReportData")/CountDistinct(Fields!GroupByValue.Value,"ReportData") <5,1,"Auto")