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
Articles & Videos
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.
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…
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.
SSRS Expression I have is…
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.
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) …
Is there a way to disable the home link so tab users don't see it at all in ssrs 2008 r2
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…
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…
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
4) Last quarter
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…
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…
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.
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…
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…
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 …
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…
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…
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…
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…
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:
If I define a variable in the OS like:
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 …
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…
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…
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…
I'm running the below database in older physical box:
and planning to migrate it to different box using offline backup method (cold backup). Hence I need to shrink the SQL serv…
Written by Valentino Vranken.
A while ago I wrote an article called Chart Optimization Tips (http://www.experts-exchan
In this short article I will be talking about two functions in the SQL Server Reporting Services (SSRS) function stack. Those functions are IIF() and Switch(). And I'll be showing you how easy it …
Ahmedabad Jivrajpark, Gujarat, India
6,000 points this week
Harrisburg, PA, United States
2,000 points this week
Phoenix, United States
1,800 points this week
1,800 points this week
1,336 points this week