SSRS

8K

Solutions

26

Articles & Videos

5K

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

Hi Expert,

I want to inventory all of my SQL Server Instances along with Server Name, DB_Name, DB_Owner, Create_Date, Version, Edition, Recovery_model as much i can retrieve.

Please Help!

416 views
How Do You Stack Up Against Your Peers?
How Do You Stack Up Against Your Peers?

With today’s modern enterprise so dependent on digital infrastructures, the impact of major incidents has increased dramatically. Grab the report now to gain insight into how your organization ranks against your peers and learn best-in-class strategies to resolve incidents.

Hi Experts,

I have a report that until recently used one SQL database to populate.  Business requirements are forcing me to split the database up.  When I deploy the report it fails and I get the …

1226 views

Hi Expert,

In the following report i want to see total section based count like this Total EBS Core count xyz
Expression i used =sum(cint(trim(Fields!processorecount.value)))


is_ebs      …

1017 views

I added the Parent line to one of my reports that only had a detail line, and along with  =Int((RowNumber(Nothing))/65520) was able to break report into multiple sheets if user imported  huge reports …

814 views

I have a schedule report. Each row represents a time in 30 minute increments. Each column is a person. Each cell has information on what the person is scheduled to do at that time. It is highlighted …

615 views

I'm building a Windows application with a form to run an SSRS report.  I added the form, added the Report Viewer, docked it to the Parent Container, chose the rdlc file, clicked on rebind the data …

119 views

Hi Expert,

This is my following query but there are 3 condition ebs, non-ebs and open

select
case when i.is_ebs = 1 then 'EBS'
        when i.is_ebs <> 1 then 'Non-EBS'
        when …

1436 views

Hi EE,

All of the sudden multiple reports on our SSRS instance have begun timing out I have checked the underlying database no, or index/stats issues and IO performance (read/write) is between …

11123 views

Hi Expert,

I want to get the result only if the condition is true in the Oracle_License Column. This is for Reporting purposes.

Select
    o.hostname
,      o.lsbdistdescription as OS_Version
,      …

937 views

I have an application that helps inspectors complete inspections.  the backend of the application is sql and we also have a few ssrs reports that run off the database.  My Boss wants me to figure out …

430 views
Why You Need a DevOps Toolchain
Why You Need a DevOps Toolchain

IT needs to deliver services with more agility and velocity. IT must roll out application features and innovations faster to keep up with customer demands, which is where a DevOps toolchain steps in. View the infographic to see why you need a DevOps toolchain.

I use SSMS often and have used SSRS as well.

What does SSIS do? What are the biggest features of SSIS?

345 views

I've come across a strange issue which I haven't seen before and cannot figure out what is going on.
The stored procedure will be used in an SSRS Report and contains a fair number of temporary …

2464 views

I need to modify a report by simply adding a page break between each instance of a group. I add the page break but it is ignored. This is a fairly basic report with nested groups. Is there another …

1440 views

We are currently running SQL2016 SSRS on a SQL 2012 R2.  We just updated the SSRS 2016 to SP1 CU2 as we applied the same update to our 2016 SQL Servers.  After we applied the updates we are now …

247 views

I was looking for a powershell that would download all of my report objects.

I have something that will get the RDL files in a folder structure which is great.

I need something to get it all …

781 views

I have a dataset in an SSRS report that has commas in it.  

for example....

john, smith


I am doing a select all ...so I need to put pass this data to my stored proc to run the report as a …

1042 views

Hi Experts,
Is there a image page/length limit size. I have an image that goes over 13 pages long. However it stops short at 13 pages. It should be around 15 pages long.  The reason I have such a …

725 views

I am creating a report with a table that is grouped company. Each company is on a separate page and the grouping is by company.  I need to print the company name in the header of the page.  Currently …

261 views

Hi,
We use SSRS in SQL2012 and we have several demands from the users to embedded the report with the formula, the formula given by users is looks complexs and I wonder if we can do this  with ssrs ?

225 views
How our DevOps Teams Maximize Uptime
How our DevOps Teams Maximize Uptime

Our Dev teams are like yours. They’re continually cranking out code for new features/bugs fixes, testing, deploying, responding to production monitoring events and more. It’s complex. So, we thought you’d like to see what’s working for us. Read the use case whitepaper.

Here is my situation

I have an report that includes support person email among other items.  (There are 6 unique emails)

Here is some sample data

Recordid   customerid  orderdate        …

232 views

I have a network folder that has 10,000 images that are small bmp files.    They are stored with the naming convention of   6300.bmp where the 6300 will change to 6301, 6302 and so on for each part …

233 views

Bug. When exporting to Excel the SSRS report, the data exported is the first retrieved in the page.
What it means is if you run the report with certain criteria (C1), you see the result set and you …

236 views

Hello experts -

We are in the process of localizing our SSRS reports and have run into an issue that I don't think is solvable at the user level. When you have a report with a multi-select …

842 views

I am creating a searchable SSRS report where staff can search the data sest on client ids. Staff should be able to insert client id (one at a time) into client id search parameter and then get all the…

848 views

Where can I setup a parameter format?  

For example:
I have a float parameter labeled "amount", when I preview the report, VS allows me to enter in 15.4455663.  I need the format to be 15.45.

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

SSRS

8K

Solutions

26

Articles & Videos

5K

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