topic Re: Export Pagianted Report via URL | Subscription PDF naming convention in Report Server

Export Pagianted Report via URL | Subscription PDF naming convention

whereismydata — Wed, 04 Sep 2019 13:23:41 GMT

Hi :)

we use an on-prem power bi reporting server for hosting our reports. I've created some paginated reports with subcriptions, eg. export every month to windows file share. Only issue I have is the naming of the pdf file. Every month the pdf should be named like "report_month_year.pdf" I did not find any sufficient solution - all I found was to ad '@timestamp' to create a timestamp. But this is not working for me since I export the report not in the same month as the data shown in the report.

During my research I stumbled upon export a report via URL. Since I use MS Flow quite a lot I was wondering if I could build a flow which downloads the pdf and then also renames it (I know, I also could export the pdf via subscription and then rename it with flow)

And here is my problem:

https://docs.microsoft.com/en-us/sql/reporting-services/url-access-parameter-reference?view=sql-server-2017 says the syntax for exporting is:

https://myrshost/ReportServer?/myreport&rs:Format=PDF

with the example:

https://servername/ReportServer_THESQLINSTANCE/Pages/ReportViewer.aspx?%2freportfolder%2freport+name+with+spaces&rs:Format=pptx

I access our reporting server by this domain:

http://ourserver/Reports/browse/

When I try this nothing happens, I just get redirected to the favorites pane:

http://ourserver/Reports/Pages/ReportViewer.aspx?%2freport%2fPaginated%20Reports&rs:Format=PDF

So I guess I have two questions:

1) is there a solution where I can handle naming in the subscription menu (or in the sql job)

2) what's wrong with my link?

Hope someone can help me. Thank you very much!!

Re: Export Pagianted Report via URL | Subscription PDF naming convention

bradsy — Wed, 04 Sep 2019 23:43:46 GMT

The http://server/reports directory is for the hosted front end. If you want to use the API to access the reports, then use the reportserver folder, http://server/reportserver

Re: Export Pagianted Report via URL | Subscription PDF naming convention

whereismydata — Thu, 05 Sep 2019 07:26:45 GMT

ah, ok. I'll give it a try.

Thank you

Re: Export Pagianted Report via URL | Subscription PDF naming convention

whereismydata — Thu, 05 Sep 2019 09:49:43 GMT

Hi,

I did find the error; I got confused with the folder in the syntax.

Paginated Reports are uploaded into the the 'folder' 'Paginated Reports'

and looking at the destination I thought I have to use the folder 'report' as well.

http://server/reports/browse/report/Paginated%20Reports

but instead I just have to use the filename; apparently this folder is not a real folder

http://server/ReportServer/Pages/ReportViewer.aspx?%2fPaginated+Reports&rs:Format=PDF

Re: Export Pagianted Report via URL | Subscription PDF naming convention

Anonymous — Wed, 08 Jan 2020 07:38:40 GMT

Hi,

I had the same problem and would like to download the paginated report by url. And it did not work, do you have the solution for that? Thanks.

Regards,

Jimmy

Re: Export Pagianted Report via URL | Subscription PDF naming convention

whereismydata — Wed, 15 Jan 2020 21:45:55 GMT

Hi Anonymous

I posted my solution above, but in short:

just attach the filename of the report to the url of your report server.

http://server/ReportServer/Pages/ReportViewer.aspx?%2fPaginated+Reports&rs:Format=PDF