Run CURL commands in SSRS report

Zolotoy 226 Reputation points
2021-01-01T14:48:43.257+00:00

Is it possible to run CURL commands in an SSRS report? Specifically, for an external image source. I know I can use something like this:
https://i5.walmartimages.com/asr/de6ae2f1-9faa-49a2-b09f-a0e5107ab1e2_1.c99ab1ce24d572916f66d6071dfe8ae4.jpeg?odnWidth=612&odnHeight=612&odnBg=ffffff
to show an image, but I need to use HTTP POST. Any idea?

Thanks

SQL Server Reporting Services
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
3,061 questions
{count} votes

2 answers

Sort by: Most helpful
  1. Jaliya Udagedara 2,836 Reputation points MVP Volunteer Moderator
    2021-01-01T19:29:22.33+00:00

    You can use a Custom Assembly.

    In Reporting Services, you can write custom code for report item values, styles, and formatting. For example, you can use custom code to format currencies based on locale, flag certain values with special formatting, or apply other business rules that are in practice for your company. One way to include this code in your reports is to create a custom code assembly using the Microsoft .NET Framework that you can reference from within your report definition files. The server calls the functions in your custom assemblies when a report is run. Custom assemblies can be used to retrieve specialized functions that you plan to use in your reports.

    More Information: Using Custom Assemblies with Reports

    0 comments No comments

  2. Joyzhao-MSFT 15,631 Reputation points
    2021-01-04T05:48:27.897+00:00

    Hi @Zolotoy

    URL access in Reporting Services is specifically designed to enable access to individual reports over a network. This type of access is best for integrating report viewing and navigation into a custom Web application. To use URL access in Web applications, you can:

    1. Address a URL to a specific report server from a Web site or portal.
    2. Use a form POST method and pass query string parameters to a report server URL using form fields.

    When a user requests data from a report server using URL access, the HTTP request uses the GET method. This is equivalent to a form submission where METHOD="GET". URL requests or form submissions that use METHOD="GET" are limited by the maximum number of characters that a server or Web browser can process.

    With POST requests (METHOD="POST" and input fields), the name/value pairs are transferred in the header and not the URL. Therefore, the name/value pairs of the query string are not part of the URL, thus enabling you to provide much longer and more complex parameter lists.

    Using direct access, a user can see the URL for the report server, and may be able to modify the query string or note the particular URL request and report server parameters for later use.

    More information,please refer to :Integrating Reporting Services Using URL Access - Web Application
    Best Regards,
    Joy


    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.

    0 comments No comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.