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.

Refine results

I need to install and create reports in report builder 3.0 on report manager (not sharepoint), where are the best documents for this?  The end user needs to be able to create their own reports via rep…

19 views
Top 6 Sources for Identifying Threat Actor TTPs

Understanding your enemy is essential. These six sources will help you identify the most popular threat actor tactics, techniques, and procedures (TTPs).

In report manager I cannot export the report to excel or pdf, any suggestions?

110 views

Hi,

Is there a way to let user build their own report on line? What I want to achieve is to make sure user can only use the pre-defined report template and dataset. They basically can just enter pa…

39 views

I had this question after viewing SSRS reports -- "The subscription encrypted content was removed." (https://www.experts-exchange.com/questions/28979684/SSRS-reports-The-subscription-encrypted-content…

1020 views

I am working on a CRM 2011 system with two application servers (TESTCRM and DEVCRM) and a shared SQL Server (DEVCRMDB)

I am getting an error when running any report on DEVCRM  The report cannot be …

928 views

I have an ssrs report server that i would like to allow users from a trusted domain to use.  I don't know how to accomplish this.
these users on the trusted domain are obviously not in my active dire…

124 views

I created a windows form with SSRS Report Viewer.  I would like to add a listbox that would allow the users to select each report and then will display the report.

I had gotten the below code but k…

28 views

Heyas,

My organization is about to undergo a major network upgrade this will affect both inbound and outbound traffic within the network. My query is what should I check from an SQL Server perspect…

531 views

We have two unique EMRs, both of which use SQL for data storage--we are looking at providing dashboard reporting for other end users.  Right now, we do a combination of Crystal Reports that farm out v…

427 views

Hello,

What is wrong with this?


BEGIN TRANSACTION
UPDATE tn
  SET tn.[NC_HIST_POST_1] = SubQuery.[2015]
  FROM PS_NC_BUDG_STG_UPL tn  JOIN (
 SELECT *
  FROM (
 SELECT ACCOUNT
 ,…

322 views
How to improve team productivity

Quip adds documents, spreadsheets, and tasklists to your Slack experience
- Elevate ideas to Quip docs
- Share Quip docs in Slack
- Get notified of changes to your docs
- Available on iOS/Android/Desktop/Web
- Online/Offline

Hi I have used SSRS report wizard to create SSRS tablix report but when I see the output its showing some blank space between the rows. Basically the length of the row is too big. How do I change it ?…

616 views

I need to read a Tablea, then add those records (10  varchar)  into a existing SSRS report parameter (@Temp) before I process that parameter in the Stored Procedure. The parameter will already have ch…

1129 views

I built a simple Matrix in SSRS. I'm just trying to add a Grand Total to the right of December. In the month header It should say Total
and for each year it should have the total for each month from…

219 views

Hi,

I am new to Report Builder. I am trying to build a report that is like a summary report for each property. I get to a point that user can enter parameters to a sp. My questions are:

1. I kno…

931 views

Heyas,

This issue just started occurring on 1 of my SSRS Servers I applied the following fix:

http://tech.lanesnotes.com/2014/02/sql-server-reporting-services-service.html

I would like to kno…

421 views

I have a query below which run fine except when I include the join to the sysjobs table, I just can't figure out why the query get error, anyone has ideas where and how to start troubleshooting ? Here…

324 views

We have a current SQL query which summarizes the hours worked by a particular branches staff.  Rather then running this report every month I would like to create a new report which automatically calcu…

528 views

We have a large migration from SSRS v2005 to v2012.  We are not just doing a backup/restore of ReportServer.  We are handling it at the level of the data.  Meaning, we script all report definition fro…

6383 views

I have read through many explanations and cannot find one that helps me with this.  Hopefully others will find the solution useful also.

I have a field with lastname, firstname.  I need to split th…

629 views
What Should I Do With This Threat Intelligence?

Are you wondering if you actually need threat intelligence? The answer is yes. We explain the basics for creating useful threat intelligence.

Hello experts -

I am trying to use a multi value parameter to filter two different fields in a tablix. However, SSRS does not allow me to specify OR when adding filters. For example, the user sele…

322 views

I have a problem When i insert data into a field of same length, when i select the results in grid view they are not align correctly but when i select results to text they are a well aligned.

what …

4156 views

I already have RAID, etc like https://msdn.microsoft.com/en-us/library/cc296756(v=bts.10).aspx talks about and am thinking about FAILOVER CLUSTERING like https://support.microsoft.com/en-us/kb/822400 …

149 views

I have a SSRS report on which I need total rows. It is grouped on two fields. After the parent(first) group, I need to put the totals. The parent group is Gender and the child group is Job Title. I am…

529 views

I have a basic report with one table and a parameter against customer name.  So when the user runs the report they get prompted to select the customer names they wish to run the report against.

How…

125 views

Can someone recommend a book I could get or read online to learn more about expressions, formulas, and all things Visual Studios 2008 with regards to report writing? I see several books out there for …

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

TOP EXPERTS

view all

RELATED TOPICS view all topics

  1. MS SQL Server 2008
    (48,770)
  2. MS SQL Server
    (156,713)
  3. MS SQL Server 2005
    (71,488)
  4. DB Reporting Tools
    (8,006)
  5. Query Syntax
    (47,304)
  6. .NET Programming
    (131,569)
  7. ASP.NET
    (123,037)
  8. MS SharePoint
    (36,958)
  9. Databases
    (53,501)
  10. MS Development-Other
    (47,927)