Share via

Sql Server 2014 Express

Hrishikesh Lele 1 Reputation point
2021-02-24T10:20:28.18+00:00

Hello,

I am onsite for commissioning a machine. I am using SSRS to generate a customised report. Server intalled is SQL SERVER 2014 EXPRESS. I have designed the reports in Visual Studio 2017 (SSDT).

I am viewing certain events information in the reports. After configuring the data for the reports (data sources, datasets etc.), the "Preview" to tab helps me generate a report with all the latest and updated data.

However, when I view the reports on a web browser, I don't see the updated data at all. Where I am expecting data, there I see no data.

I have tried the following uptil now-

  1. Changed the default browsers
  2. Cleared the reports cache (.data) files
  3. Create new project and reports in the same s/w (VS2107 (SSDT))
  4. Added a Clear Session parameter in the report rendering URL.
  5. Refreshed the reports manually from the web browser.

I am stuck here on this at a very critical time. Requesting the experts help as this issue has taken everyone by surprise.

Thanks,

Hrishikesh

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.

SQL Server | Other
SQL Server | Other

Additional SQL Server features and topics not covered by specific categories


1 answer

Sort by: Most helpful
  1. Lukas Yu -MSFT 5,826 Reputation points
    2021-02-25T02:14:19.993+00:00

    Hi,

    The first thing to check is, that you need SQL Server Express with Advanced Services edition for SSRS to work. Express edition alone is not support with SSRS.
    See the note in : SQL Server Reporting Services

    Regards,
    Lukas

    Was this answer helpful?


Your answer

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