SSRS

8K

Solutions

26

Articles & Videos

4K

Contributors

SQL Server Reporting Services (SSRS) is a server-based report generation software system from Microsoft. It can prepare and deliver a variety of interactive and printed reports and is administered via a web interface or its web service. Its web services interface also supports the development of custom reporting applications. Finally, SSRS can also be integrated with SharePoint. SSRS competes with other business intelligence tools, most prominently Crystal Reports.

Related Topics

  1. Microsoft SQL Server 2008
  2. Microsoft SQL Server
  3. Microsoft SQL Server 2005
  4. DB Reporting Tools
  5. Query Syntax
  6. .NET Programming
  7. ASP.NET
  8. Microsoft SharePoint
  9. Databases
  10. Microsoft Development
Refine results

I have a stored proc..and due to the structure of this proc...the wizard in Reporting Services cannot detect this as a dataset.

Does anyone know how I might rewrite this so SSRS will read it and …

2511 views
The New “Normal” in Modern Enterprise Operations
The New “Normal” in Modern Enterprise Operations

DevOps for the modern enterprise offers many benefits — increased agility, productivity, and more, but digital transformation isn’t easy, especially if you’re not addressing the right issues. Register for the webinar to dive into the “new normal” for enterprise modern ops.

I am having an issue with deploying a report using a firebrid ODBC connection.    I have no issue creating and running the report but when i deploy to the web i get an error.  

I create the …

16 views

Hi guys,

Our organisation is deciding to move to Power BI and SSRS instead of Actuate. What should be the best approach to make both Power BI and the SSRS available to the end users within our …

322 views

Hi Experts,

I am writing an SSRS report which querys lots of tables. I am using cte to then join the tables. The return time is very slow. I am unable to post the query for various reasons. However…

642 views

Report works without error in SQL Server/SSRS v2005.
Report fails with the error below when run in SQL Server/SSRS v2012.

An error has occurred during report processing. (rsProcessingAborted)
The…

1324 views

Here is what I would like to accomplish:

I would like to build a parameter on a report that gave date options.

For example the parameter would be a dropdown list like so:

1)  Monthly  ( …

226 views

In SQL Server I call the following sproc, referenced by an SSRS report:

(CODE)

and get back a response of:

Command(s) completed successfully.

I don't get an returned rows.

Suggestions?

819 views

Experts,

 I do have sharepoint 2013 enterprise version. I would like to make kind of search engine webpart or interface where I can pull up some information from various sources like SQL , …

325 views

Looking for SQL to find list of subscriptions for SSRS reports exporting as csv formate.

515 views

This project still uses Visual Studio 2005 SQL Server Business Intelligence Development Studio and is doing some strange things.

I added a single column to an SSRS Report and get it working fine.

218 views
Free Tool: Subnet Calculator
Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Hi EE,

Where do I go to upgrade my SSIS package, can't seem to find the button? See the attached picture.

Any assistance is appreciated.

Thank you.

659 views

I have a need to select a single row of data based on a date range from field UDF_Date_Data for each ID to use as a dataset in my SSRS report. So I need the following Columns. That being said the …

726 views

I thought I understood a bit about SSRS and deployed my working report to production. I did this from an instance of Visual Studio 2005, loaded as an Administrator. First, I changed the deployment …

564 views

I asked a question not too long ago about what would cause SQL Server Agent jobs to re-appear after they had been deleted.  I was basically told by an Expert that because I deleted the jobs using …

728 views

I have the following stored proc.  It is the dataset of an SSRS report.    The stored proc doesnt run too bad..as in 30 or so seconds...but when in Report Server...it runs forever and ever and ever.

1553 views

I tried, but it appears that SSRS 2016 does not render html tables (my placeholder is set to render html).  Does anyone have a SIMPLE work around?

326 views

I've inherited a number of SSRS reports which I'm trying to clean up, pretty successfully if I say so myself.

However, even though the report Page Size is set to 8 1/2 by 11 inches (standard letter…

416 views

Hello:

I have an rdl file for SQL Reporting Services (SSRS) 2014 that I need to open and edit.  I have used SSRS for versions 2005 - 2012.

But, when I open the "Visual Studio Tools" or whatever …

137 views

Hello:

We have a SQL Reporting Services (SSRS) report for SQL 2014 in Report Manager with a simple Start Date and End Date parameter.

How do we modify this report to run automatically, without …

128 views
Free Tool: Site Down Detector
Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

I am trying to create an SSRS report using Visual Studio 2012 for an online version of CRM 2016.  I have looked at several sites and they refer me to older versions of Visual Studio, BIDS, SSDT, etc

219 views

I've inherited a bunch of underperforming SSRS reports.  I've rewritten the data sets for the report I'm currently working on, but when I attemp to preview the report it gives me a message that refers…

129 views

Hi I am just trying to figure out an issue with our software which is integrated with SSRS. The reports we connect with are on an SQL Server 2016 SSRS version. However the application is using Report …

117 views

Hi, I just want to understand all the areas I need to update to allow my application server to trust the SSRS url.

Are there tests that I can do that will show if I have trusted the SSRS url …

319 views

(CODE)

I want to result like:

(CODE)

I am able to get the Present/Absent status of a user for a single  date. But my question here is that I want to get all the users that are present/absent …

1136 views

what's the best way to  (performance wise) or other  to write this query to get all the fields that are 25 days old


select 1, 2
from table
WHERE DATEADD(DD,25,ThisDATE)>=GETDATE()

432 views
Show more content
201506-LO-Top-001

SSRS

8K

Solutions

26

Articles & Videos

4K

Contributors

SQL Server Reporting Services (SSRS) is a server-based report generation software system from Microsoft. It can prepare and deliver a variety of interactive and printed reports and is administered via a web interface or its web service. Its web services interface also supports the development of custom reporting applications. Finally, SSRS can also be integrated with SharePoint. SSRS competes with other business intelligence tools, most prominently Crystal Reports.

Related Topics

  1. Microsoft SQL Server 2008
  2. Microsoft SQL Server
  3. Microsoft SQL Server 2005
  4. DB Reporting Tools
  5. Query Syntax
  6. .NET Programming