Lewis Brisbois Customer Care

View/Update the links in SSRS

**If you want to just VIEW - Select * from [EXPERT_PROD].[dbo].[_v_SSRS_Report_Path]

This is where you change it.

 When the load runs overnight it will update the links:

USE [Expert_PROD]

SET ANSI_NULLS ON

SET QUOTED_IDENTIFIER ON

GO

ALTER VIEW [dbo].[_v_SSRS_Report_Path]

AS

       SELECT 'Client & Matter' AS CATEGORY,'Client & Matter Directory' AS DISPLAY_NAME, 'http://ladc-expsql01/Reports/report/PROD/LBBS/Client%20Matter%20Directory' AS URL,  1 AS SORT_ORDER

       UNION

       SELECT 'Billing', 'Billings and Collections Report', 'http://ladc-expsql01/Reports/report/PROD/LBBS/Billings%20And%20Collections%20Report', 1

       UNION

       SELECT 'Billing', 'Timekeeper Billable Hours by Month', 'http://ladc-expsql01.lbbs.llp/Reports/report/TEST/Reports/AACTestReports/Completed/Timekeeper%20Hours%20by%20Month', 1

       UNION

       SELECT 'Billing', 'Timekeeper Summary', 'http://ladc-expsql01/Reports/report/TEST/Reports/AACTestReports/Completed/Timekeeper%20Summary%20Report', 1

       --ORDER BY SORT_ORDER, DISPLAY_NAME

GO

There is now a way to instantly update the links as well, without waiting for the nightly feed. 

SWDC-BI-DEVSQL, DB: [BI-DEV], Run: “exec bi.LoadSSRSReports 0;”

SWDC-BI-PRODSQL, DB: [BI-PROD], Run: “exec bi.LoadSSRSReports 0;”

That loads the links from the Expert database (the one mounted on whichever server, not the production database) and updates the link on the web pages.