ReportServer Forum

privettoli

Member

Registered: 2015-01-13

How to get list of all reports via URL

Hi,

My problem is that I don't know right URL to get list of reports, I want to show user all available reports on ReportServer.
Can I get them by page (by 10 items for example)?

And some questions about httpauthexecute config:
1) What is right executeuserid? Where can I get it for my user?
2) Can I configure my settings to allow exporting any id or key via URL, without specifying them in httpauthexecute.cf?

Thanks in advance.

Last edited by privettoli (2015-01-13 12:23:54)

Arno Mittelbach

datenwerke

Registered: 2012-02-14

Re: How to get list of all reports via URL

There are many ways to get a list of all possible reports. Scripting is one of them. For an introduction check out the Script Guide at http://reportserver.datenwerke.net/en/shop/.
A second approach would be to go directly to the data layer and have a look at the table RS_REPORT. This contains all report nodes within the report manager.

Arno

privettoli

Member

Registered: 2015-01-13

Re: How to get list of all reports via URL

For now I don't have 120 euro for such kind of documentation, because we will not use ReportServer before I will be able to do all that we need from it, where can I get free info about scripting?

privettoli

Member

Registered: 2015-01-13

Re: How to get list of all reports via URL

And my second question: how to configure my ReportServer that I will get all reports with no need to specify their ids or keys in .cf?

Arno Mittelbach

datenwerke

Registered: 2012-02-14

Re: How to get list of all reports via URL

I don't quite understand the second question. As for the first ... There ain't no such thing as a free lunch.

privettoli

Member

Registered: 2015-01-13

Re: How to get list of all reports via URL

For now, as I understood, I have to clarify all ids and keys of reports, that I want to access via httpauthexport.
Or I can just leave ids and keys empty and I will be able to get access to all of them?

And one more question: I downloaded the project sources to add list functionality, but when I open it in Intellij Idea, I don't know how to compile this project, where to start from, etc. Can you help me in few phrases or is there some useful post in blog or something?

Arno Mittelbach

datenwerke

Registered: 2012-02-14

Re: How to get list of all reports via URL

For running scripts and, e.g., getting a list of all reports there is no need to add anything to the ReportServer code base. As for httpauthexport, this feature is really not meant for what you have in mind.
For making large number of reports available externally it is much easier to have automatically log in a user and then simply use ReportServer's permission system.

A first idea of how to hook into ReportServer's authentication mechanism can be found at http://blog.datenwerke.net/2013/08/Repo … ation.html. Further
information is available in the ReportServer manuals.

privettoli

Member

Registered: 2015-01-13

Re: How to get list of all reports via URL

But can you give me more information about how to write this script or where to put it? How to use it?