September 27, 2012 at 3:11 pm
Try this...then circle back to fill the nulls (linked datasources)
SELECT DISTINCT Cat.Name AS Reportname, dst.Name AS DataSetName, Dsc.Name AS DataSourceName, Cat.Path
FROM DataSets AS dst RIGHT OUTER JOIN
Catalog AS Cat ON dst.ItemID = Cat.ItemID LEFT OUTER JOIN
DataSource AS Dsc ON Cat.ItemID = Dsc.ItemID
WHERE (Cat.Type = 2)
ORDER BY Reportname
February 28, 2013 at 9:08 am
Thanks for sharing your RDL's for the Report Server management report and great job. It was very helpful and helped resolve most of my issues promptly.
Regards.
April 17, 2013 at 11:21 pm
Top job Michael
Ramesh Konda
May 8, 2013 at 4:19 pm
Thank you for the reports.
I downloaded the zip file, extracted the rdl files and imported them into a reporting project.
I like the design and choice of color for the reports.
They provided excellent information about the reports.
I currently have them on my desktop machine.
Does the fact that these report, being released to the public, mean we are allowed to use them on a production server?
I don't use anything in production that is not licensed.
Thanks
Gary
May 9, 2013 at 6:09 am
Go right ahead, Gary -- your thank you is enough!
I'd also look back over the comments. MaricopaJoe has made some significant additions to his version of these reports and posted his code changes in the comments -- Sadly I haven't incorporated them into the base set in the download.
June 7, 2013 at 10:00 pm
I noticed today that some data sources where being missed using the schemas listed in the data sources.
If you are using Sharepoint 2010 with SSRS then you will want to update the queries that contain:
http://schemas.microsoft.com/sqlserver/reporting/2005/01/reportdefinition or
http://schemas.microsoft.com/sqlserver/reporting/2008/01/reportdefinition
http://schemas.microsoft.com/sqlserver/reporting/2010/01/reportdefinition
The new schema worked on both 2008 and 2012 reports. I am not sure if this is a Sharepoint Issue, but if you are seeing missing connections, then you will want to update the query accordingly.
These reports will NOT reflect Sharepoint Permissions, and those are not stored in the ReportServer.
May 17, 2014 at 9:42 am
We migrated to fresh hardware and fresh Reporting Services databases for SQL Server 2012. When I copied the Reporting Services reports to the new SQL Server 2012 instance, I noticed that we are periodically missing data on the ReportStatistics page. For example, the following summaries on the page are missing data:
- Online Usage - Last 180 Days
- Online Number of Users - Last 180 Days
- Top 10 Online Users -Last 180 Days
Has anyone else noticed missing data with SQL Server 2012? Just thought I would check before I go through the code. Up until this point, the pages worked great.
Thanks,
J.
May 17, 2014 at 11:52 am
Did you check the schema references in the report, so that it points to http://schemas.microsoft.com/sqlserver/reporting/2010/01/reportdefinition
In the ExecutionLogview3, does it indicate that you are using more than one server (scale out)?
May 17, 2014 at 1:11 pm
Please start a new thread instead of posting to one that is a year old.
Best,
Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru on googles mail service
March 6, 2017 at 9:33 pm
Hi Michael, I want to thank you for sharing your excellent work. 7 years and it is still extremely helpful.
Thanks!!!!!🙂🙂🙂
July 1, 2018 at 5:14 pm
Eight years on and still relevant - thanks for sharing this, is of great help and saved me heaps of time.
October 4, 2018 at 11:47 pm
Thanks these reports are great. I added them to my reportserver no problem. Cheers!
May 14, 2019 at 3:59 pm
Anyone have a download link for this? The recent website changes appear to have removed the article attachments 🙁
Viewing 13 posts - 106 through 117 (of 117 total)
You must be logged in to reply to this topic. Login to reply