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

Hello Experts Exchange
I have a SQL Server Reporting Services report that has a dataset with several columns, I want these columns going down as rows on the left hand side in a table, and my data fro…

143 views
How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

I have an employer id value (12-3456789) totally 9 digit. I have this field as a varchar(10) in my DB.
I wrote my stored proc to pull this info for my report.

(CODE)


SSRS Expression I have is…

28 views

I have multiselect dropdown where users can select 1st item and 3rd item or just first item alone.
If that happens, I want my tablix to be hidden which is supposed to be shown for item 2.



I ha…

1015 views

Can someone help me understand what am I doing wrong in this VB6 function?

I have a Custom code in my SSRS report which will be invoked from my report. All it does it takes input (MilestoneTypeId) …

1921 views

Is there a way to disable the home link so tab users don't see it at all in ssrs 2008 r2

125 views

Hi Experts,

I have a report.

I noticed when I open a report.rdl file in VS2013 I see the main part of the report.  When I do a deploy of that .rdl file and copy the link into a browser a Selecti…

351 views

I have been creating reports in SSRS.  I have created a report, using the wizard, to set the grouping (one field) and the rest are in the detail section.  Works great.  Here's my question:  the groupi…

313 views

Hello,

I am developing a SSRS Report in which i have date parameters based on different selections. It has the date range like
1) Last week
2)Last month
3) YTD
4) Last quarter
5)Custom date

2533 views

I have a report that I would only like to show data based on criteria. I use an expression to highlight fields and would like to limit the report sections to that same data from the expression only. H…

713 views

Hello Everyone,

I have a strange issue, i have developed a report which  has multiple parameters in it. When i am running it in visual studio its working fine but when i deployed it on web server a…

2016 views
IT Security CISA, CISSP & CISM Certification

Master the advanced techniques required to protect network resources from external threats with the IT Cyber Security bundle. Built around industry best-practice guidelines, the IT Cyber Security bundle consists of three in-depth courses.

Hello,

I need some advice on setting up security/permissions to users in SSRS.
Here is the requirement
1.      Build one standard report using Report Builder. Publish this report in SSRS.
2.      Provid…

128 views

In the tablix of the report , I set the filter to the following

I created 3 parameters
@begindate,@enddate, and @Stagenumber.


I get difficulty when adding the @stagenumber  parameter, which I…

1726 views

I am having issues getting a SSRS report site up and running and making it accessible form the internet. I can access the Report Manager URL from inside my network. I can also access the Web Service U…

1129 views

I am creating a report where the SP returns a fixed set amount of columns although the column names are dynamic. Is there a way to have the report pick up on this and use the dynamic names, each time …

331 views

I am trying to add multiple values for highlighting the cell. Trying to use "IN" and i don't think the syntax for the expression is correct...

Trying to add both values that are bold: (it works wit…

414 views

I have a request on a report to highlight a value in one field based on a value from another field, is that possible in SSRS?

They would like the have the "ACFD Level Of Service" value of "Cancelle…

412 views

I am trying to run a query that will provide me with all the stored procs being used by report server and what report they are used in.

I would then like to some how compile this list of stored pro…

839 views

scan a windows directory and use the folder structure to create if they do not exists the folder names on a report server...along with placing any rdl files in place.  Essentially the windows structur…

728 views

I need to show text after a field in SSRS. I am able to do an "If, Then" to replace a value, but would like to show text after the standard value. This is the expression I currently have:

=IIF(Fie…

219 views
Find Ransomware Secrets With All-Source Analysis

Ransomware has become a major concern for organizations; its prevalence has grown due to past successes achieved by threat actors. While each ransomware variant is different, we’ve seen some common tactics and trends used among the authors of the malware.

If I define a variable in the OS like:

SET MyTest="Hello"

Is it possible and if so, how, to get that MyTest variable value into an RDL of SSRS? It's on SQL Server 2014.

It is possible to do …

429 views

Hello,

I'm trying to add Reporting Services application in SharePoint 2013. I've installed Reporting Services (Integrated Mode) (SQL Server 2012 SP1). The Reporting Services Add-in for SharePoint w…

257 views

Hi All,

I'm currently running SQL Server 2012 Standard SP1 on my Windows Server 2008 R2 and have login as SA user, somehow I cannot start the SQL Agent from SSMS and cannot edit the SQL maintenance…

838 views

Guys,
I'm interested to know that how sql server in reporting services 2014 perform the download of the report, for example if I have 300k rows of data from my report and I chose excel 2003 to be sav…

241 views

Hi All,

I'm running the below database in older physical box:

(CODE)

and planning to migrate it to different box using offline backup method (cold backup). Hence I need to shrink the SQL serv…

1425 views

I am trying to create a Stacked Bar Graph in SSRS - i have the below data

Month      Q1              Q2               Q3               Q4
May            50.00%      20.00%      30.00%      0.00%
June            38.46%      30.77%      15.38%      15.38%

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

TOP EXPERTS

view all

RELATED TOPICS view all topics

  1. MS SQL Server 2008
    (48,410)
  2. MS SQL Server
    (156,026)
  3. MS SQL Server 2005
    (71,385)
  4. DB Reporting Tools
    (7,991)
  5. Query Syntax
    (47,085)
  6. .NET Programming
    (131,255)
  7. ASP.NET
    (122,812)
  8. MS SharePoint
    (36,807)
  9. Databases
    (53,327)
  10. MS Development-Other
    (47,908)