cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
whereismydata Regular Visitor
Regular Visitor

Export Pagianted Report via URL | Subscription PDF naming convention

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-serv... 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!!

 

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
whereismydata Regular Visitor
Regular Visitor

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

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'

 

 

1.JPG

 

 

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 

 

View solution in original post

5 REPLIES 5
bradsy Member
Member

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

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

whereismydata Regular Visitor
Regular Visitor

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

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

 

Thank you

Highlighted
whereismydata Regular Visitor
Regular Visitor

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

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'

 

 

1.JPG

 

 

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 

 

View solution in original post

jimmywhc Frequent Visitor
Frequent Visitor

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

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

whereismydata Regular Visitor
Regular Visitor

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

Hi @jimmywhc 

 

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 

 

Helpful resources

Announcements
New Topics Started Badges Coming

New Topics Started Badges Coming

We're releasing new versions of the badge that everyone's talking about. ;) Check your inbox for notifications.

MBAS 2020

Save the new date (and location)!

Our business applications community is growing—so we needed a different venue, resulting in a new date and location. See you there!

Difinity Conference

Difinity Conference

The largest Power BI, Power Platform, and Data conference in New Zealand

Top Kudoed Authors (Last 30 Days)