SQL Server Reporting Services Site settings

Hi OSTOJIC Danijela,

Yes it’s possible, but you’ll need a small customization. SSRS itself doesn’t directly display dynamic data (like “last updated date”) on the default start page. However, you can achieve this by creating a simple “dashboard” report that becomes the default landing page for users.

1. Create a simple SSRS report (e.g., HomePage.rdl).
2. In the report dataset, use a query like:
3. SELECT MAX(LastUpdatedDate) AS LastDataUpdate
4. FROM YourDataTable;
5. Design the report to show the date in a text box:
6. Data last updated on:  =Format(Fields!LastDataUpdate.Value, "dd-MMM-yyyy hh:mm tt")
7. Deploy this report to your SSRS site (e.g., under Home folder).
8. Set this report as the default page by saving its URL as a browser favorite or intranet shortcut for users, or by setting it as the home link in your portal navigation.

This way, when users open SSRS, they’ll immediately see the “last update date” before running any other reports.

Thanks,
Akhil.