What can we help you with?
Search
Sorry, you do not have permission to carry out this action.
Avolve Software - Powered by Kayako Help Desk Software
What can we help you with?
Search
knowledgebase : Installation > Report Server
Deploying Custom Reports onto a New SSRS Server
If moving any custom reports onto a new SSRS server, the attached instructions and settings must be applied to the custom reports in order for them to work.
Installing SQL Server Reporting Services (SSRS)

To install SQL Server 2008 Reporting Services

  1. Insert the Microsoft SQL Server 2008 product DVD into the DVD Drive, and run Setup.exe to open the SQL Server Installation Center.

  2. In the SQL Server Installation Center window, click Installation from the left-hand menu, then choose between the  New SQL Server stand-alone installation or add features to an existing installation radio buttons. See Figure 1. 

  3. Now step through the initial setup steps.  Once you get to the Installation Type screen choose Add features to an existing instance of SQL Server 2008, then select your instance and click Next. See Figure 2. 

  4. In the Features Selection window, locate Reporting Services (it is below Instance Features) and check the box next to Reporting Services, then click Next. See Figure 3.

  5. Click Next on the Disk Space Requirements window.

  6. In the Server Configuration window, select an Account Name for Sql Server Reporting Services. Once you've choosen your 'Account Name' click the "Next" button. See Figure 4. 

  7. In the Reporting Services Configuration window, choose Install, but do not configure the report server and click Next.  See Figure 5. 

  8. Click the Next buttons until you get to the Ready to Install window, and then click the Install button. Once the installation setup process is complete and successfully installed, click Next, then from the Complete window, click Close.

 

Optionally, double check SQL Server Reporting Services is installed as a service on your computer by locating it within the Computer Managment - Services section. See Figure 6.

Reporting Metrics Queries for ProjectDox SQL Database

Description

Reporting metrics queries for ProjectDox SQL Database

Solution

Average Project Size

 

selectAVG(MB)from (

SELECT p.Name AS Project,

(SUM(f.Filesize)/ 1024)AS MB

FROM Projects p

JOIN Files f

ON p.ProjectID = f.ProjectID

GROUPBY p.Name) x

 

 

 

Average File Size

 

selectAVG(filesize)from Files

 

 

 

Total Number of Document Pages & Plan Pages by Year Uploaded

 

 

selectisnull(sum(PageCount),0)as [2014 Total Document Pages]

from Files

whereyear(UploadDate)BETWEEN 2014 AND 2014

and(SheetSize ='8.5x11.0'or SheetSize ='8.5x11')

 

selectisnull(sum(PageCount),0)as [2014 Total Plan Pages]

from Files

whereyear(UploadDate)BETWEEN 2014 AND 2014

and SheetSize <>'8.5x11.0'and SheetSize <>'8.5x11'

 

 

 

 

Number of Files Uploaded Per Project  (OPTIONAL: Time Period)

 

 

SELECT p.Name AS Project,COUNT(l.LogReportID)AS'# Files Uploaded'

FROM LogReports l

JOIN Files f

ON l.EntityID = f.FileID

JOIN Projects p

ON f.ProjectID = p.ProjectID

AND l.EventType ='FileUpload'

--OPTIONAL: Uncomment the YEAR and MONTH if you want results for a specific time period

--ANDYEAR(l.UsageDate)= 2014

--ANDMONTH(l.UsageDate)= 5

GROUPBY p.Name

ORDERBY p.Name

 

 

 

Number of Files Downloaded Per Project (OPTIONAL: Time Period)

 

 

SELECT p.Name AS Project,COUNT(l.LogReportID)AS'# Files Downloaded'

FROM LogReports l

JOIN Files f

ON l.EntityID = f.FileID

JOIN Projects p

ON f.ProjectID = p.ProjectID

AND l.EventType ='FileDownload'

--OPTIONAL: Uncomment the YEAR and MONTH if you want results for a specific time period

--ANDYEAR(l.UsageDate)= 2014

--ANDMONTH(l.UsageDate)= 5

GROUPBY p.Name

ORDERBY p.Name

 

 

 

Total Size of Files Uploaded Per Project

 

 

SELECT p.Name AS Project,(SUM(f.Filesize))AS Megabytes

FROM Projects p

JOIN Files f

ON p.ProjectID = f.ProjectID

GROUPBY p.Name

ORDERBY p.Name

 

 

 

Total Size of Files Uploaded Per User

 

 

SELECT u.FirstName AS'FirstName', u.LastName AS'LastName',u.Email AS'Email',(SUM(f.Filesize)/ 1024)AS Megabytes

FROM Users u

JOIN Files f

ON u.UserID = f.AuthorID

GROUPBY u.LastName, u.FirstName, u.Email

ORDERBY u.LastName

 

 

Revised 02-18-2015

 

 

Setting SSRS report measurements

When modifying the SSRS reports, make sure, before checking them in, that they export correctly in PDF. Some of the reports are not easily printed on 8.5x11 sheet of paper, make sure they all export into one page width in PDF. This means, no extra blank page and no grids that get cut off and put on extra pages.

Here how to prevent that:

  1. Click on Report > Report Properties > Layout tab (Page Setup tab in SSDT-BI)
  2. Make a note of the values for Page width, Left margin, Right margin
  3. Close and go back to the design surface
  4. In the Properties window, select Body
  5. Click the + symbol to expand the Size node
  6. Make a note of the value for Width

To render in PDF correctly Body Width + Left margin + Right margin must be less than or equal to Page width. When you see blank pages being rendered it is almost always because the body width plus margins is greater than the page width.

Remember: (Body Width + Left margin + Right margin) <= (Page width)

To get the body width, click on the white part of the body of the report and in the properties screen on the right you’ll see the measurements. To get the report width, click on anywhere outside, not on the report, and in the properties screen on the right you’ll see the measurements.

 

Contributed by: Chris Wright

Contributed on: 2/27/17