question

DonFisher-8776 avatar image
0 Votes"
DonFisher-8776 asked Isabellaz-1451 edited

Reporting Services Portal

Let me start by saying that I am a report writer and not a SP Admin or SQL Server Admin or anything like that, so some of what I ask or say may seem like sheer ignorance. Please forgive.

We are currently moving all of our SSRS reports from a SP integrated installation to a Native installation. We have hundreds of reports and the number is growing all the time. In SP mode, the list that is created can be filtered and sorted, I can create my own views and tailor what I see to suit my needs for managing my many reports.

In Native Mode, there is nothing like that. It is just one giant list. Is that really the best that we can do? I have been offered my own folder, but that seems like a very rudimentary way to solve this problem and I will still not be able to create any kind of view or custom list.

How do others solve this problem? Is there a way to populate a SP list based on this portal? I find it hard to believe that I am the only one who thinks this is a terrible oversight by MS. There has to be some other way to efficiently manage a huge list reports.

sql-server-reporting-services
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

Isabellaz-1451 avatar image
0 Votes"
Isabellaz-1451 answered Isabellaz-1451 edited

Hi @DonFisher-8776 ,

Report manager in native mode can also sort and filter reports , below image is my native report manager screenshot, you can see the search box in the top right corner, use it you can filter the reports by the name or description , you can also show the reports at list mode ,then you will see the modified date of the report ,you can sorting the reports by the modified date , modified user , name ,type, description and size.


130972-screenshot.png



Best Regards,
Isabella


If the answer is helpful, please click "Accept Answer" and upvote it.

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.


screenshot.png (75.5 KiB)
· 2
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Thanks IsabellaZhangMSFT-7746 but that isn't what I am looking for. I would like to be able to create views so that I do not have to search and sort every time I need to manage my reports. It seems to be a very simple thing that is rather conspicuously missing. The entire reporting ecosystem is very complex and robust and to have a repository with no way to have durable sorting and filtering is silly.

Maybe in the next iteration......

0 Votes 0 ·

yeah,SSRS in native mode currently doesn‘t have that feature.

0 Votes 0 ·