DataFeed from SSRS reports collection management

Gonzalez, Gonzalo M. (contracted) 20 Reputation points
2023-09-13T16:04:08.3833333+00:00

Dears,

In a SSRS report, I'm exporting a Data Feed that results into [REPORT_NAME].atomsvc file (XML format).

The issue I'm having is with the content of that file:

<?xml version="1.0" encoding="utf-8" standalone="yes"?><service xmlns:atom="http://www.w3.org/2005/Atom" xmlns:app="http://www.w3.org/2007/app" xmlns="http://www.w3.org/2007/app"><workspace>atom:titleRelatorio Florestal</atom:title><collection href="http://pmieuirlsrs10/ReportServer?%2FLeaf2Go%2FReports%2FBrazil%20Reports%2FRelatorio%20Florestal&Market=AR&Safra=4018&Filial=12&Gerencia=13&Supervisor=102&Instrutor=2009&rs%3AParameterLanguage=&rs%3ACommand=Render&rs%3AFormat=ATOM&rc%3AItemPath=table1">atom:titletable1</atom:title></collection></workspace></service>

In "collection href=..." element is adding HOST_NAME "pmieuirlsrs10" instead of DNS .

How can I manage this?

From where I can change it? in order to not change one by one each SSRS report.

Thanks in advance!

Best regards,

Gonzalo.

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,065 questions
0 comments No comments
{count} votes

Accepted answer
  1. Anonymous
    2023-09-14T06:00:14.68+00:00

    Hi @Gonzalez, Gonzalo M. (contracted)

    When the Atom rendering extension creates an Atom service document, a unique identifier is created for the data feed, a URL that identifies the report, the Atom rendering format, and the name of the report item.

    https://learn.microsoft.com/en-us/sql/reporting-services/report-builder/generating-data-feeds-from-reports-report-builder-and-ssrs?view=sql-server-ver16#work-with-data-feeds

    This may be related to the report server URL you configured. You can check this document: https://learn.microsoft.com/en-us/sql/reporting-services/install-windows/configure-a-url-ssrs-configuration-manager?view=sql-server-ver16.

    Best regards,

    Aniya

    1 person found this answer helpful.

0 additional answers

Sort by: Most helpful

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.