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

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()

420 views
Courses: Start Training Online With Pros, Today
Courses: Start Training Online With Pros, Today

Brush up on the basics or master the advanced techniques required to earn essential industry certifications, with Courses. Enroll in a course and start learning today. Training topics range from Android App Dev to the Xen Virtualization Platform.

I'm new to SSRS but have a lot of experience with SQL Server and am an Access MVP.

I've inherited a number of SSRS reports form a prior developer and this particular report takes forever to run.  …

819 views

I'm new to SSRS, but not to SQL Server 2012.  I've inherited an application from a prior developer who did some of the reporting in SSRS.  One of the reports is running extremely slowly, similar to an…

513 views

I created an SSRS report that executes fine in Microsoft Visual Studio. I deployed it to the report server. However when I try to execute from the report server I get the following:

An error has …

423 views

We are using SQL 2016 along with SSRS 2016 and the new KPI features. Is there a way to have more than 4 colors for the KPIs? We are using Green, Red, Blue and Grey but would like to add more to the …

214 views

Hi there,

Our company changes fiscal years in Feb each year.  
It works like this:
Fiscal Month = Calendar -1
Fiscal Year = Calendar +1

So, Feb, 2017 = Period 1, 2018.

I need to display …

838 views

Hi Experts,

currently I have a report that has a parm dropdown.  Within the dropdown there is a list of the past 6 months:
01-01-2017
12-01-2016
11-01-2016
10-01-2016
09-01-2016
08-01-2016

219 views

Hi all,
I have a sub report in which I am passing a multi-select parameter on the main report. The Sub report parameter is also a multi-select.  The problem I am having is that when the sub report's …

416 views

Hi Experts,

I have a parm that is displaying in the drop down like:


I want it to display like:
1-1-2017
etc...

I need to take out the time.  I have tried text/date time.

This comes …

1231 views

Hi Experts,

I have this code from SSMS and it comes from Temp Tables:
(CODE)

And so on it has 7 different Categories.

Data is like:


In SSRS I need it to look like:


And the Bar …

1932 views
Live: Real-Time Solutions, Start Here
Live: Real-Time Solutions, Start Here

Receive instant 1:1 support from technology experts, using our real-time conversation and whiteboard interface. Your first 5 minutes are always free.

SQL Server v2012 - we have a bunch of SSRS subscription Agent jobs in place on a server that I removed the schedules for a couple days ago, using this method:

SELECT ss.*
--DELETE ss
FROM …

431 views

Hi,

I can't get rid of the blue border on the signature images i'm producing in my report, Border is set to None, Sizing is set to Fit, example is attached...any ideas ??

Thanks

Steve

831 views

I am just providing a snippit but here is what I am trying to do.

I have a dropdown list that has a list of values to chose from.  This is a dropdown on report server.   I need to add a value for …

324 views

I am using Report Builder 3.0 in order to connect to SSRS report server http://mosaic.catex.com/reportserver.
Is there a way to use Power BI to connect to SSRS report server instead in order to …

223 views

Hello,
I'm working on an SSRS report which I'm extracting sales data for different item classes. I have the body of the report complete. I need to create a parameter drop down to either report on …

232 views

I need some help with Date Calcs please. I need SQL syntax for the following to use in a SELECT statement:

First day of Current Month for Last Year - example if today is 1/19/17  then I need 1/1/16…

335 views

Hi,
I have developed an ssis package to run 3 reports from reporting service that are data driven subscriptions.
When I run the ssis job it executes all the 3 reports at once, what I need is to run …

2044 views

I deployed one SSRS report on Report server .  While running  this report on client machine , first time it asks to install "SQL server reporting service R2". While installing this software it asks …

233 views

We have two server one Running SSRS with several reports created and the other an IIS Server that hosts a few websites.

I need to publish my SSRS Reports to the IIS Server for external access. …

340 views
DevOps Toolchain Recommendations
DevOps Toolchain Recommendations

Read this Gartner Research Note and discover how your IT organization can automate and optimize DevOps processes using a toolchain architecture.

I use parameters a lot and in the past I always had a query that went with the parameter.  I have a new report where the user needs to manually enter multiple id numbers in the parameter.   I can't …

430 views

I have a report in SSRS, and have 8 columns that I want to dynamically name the first day of the week (Sunday being 1st day), so one column would be current week, and then each week the previous week …

336 views

I am moving data from a source to an identical target table for archiving. What is the best way to get the row count for the source table and for the archive table?

425 views

I am very new to SSRS, and also very new to the project I am supposed to support. So new I thought pressing the F5 button in Visual Studio would open up a web-page of the hundred or so reports. …

447 views

I made a huge mistake and tried to copy an existing RDL and must have clicked the OK button as it was trying to set up a new connection...

Then I tried to see the management form for the page and …

231 views

I have a tablix where I have some complicated calculations for my detail field. What I need to do is to make a sum of values that the detail field is returning inside the tablix.

What would be the …

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

TOP EXPERTS

view all

RELATED TOPICS view all topics

  1. MS SQL Server 2008
    (49,070)
  2. MS SQL Server
    (157,551)
  3. MS SQL Server 2005
    (71,561)
  4. DB Reporting Tools
    (8,002)
  5. Query Syntax
    (47,604)
  6. .NET Programming
    (131,922)
  7. ASP.NET
    (123,346)
  8. MS SharePoint
    (37,064)
  9. Databases
    (53,696)
  10. MS Development-Other
    (47,949)