Stack Overflow
Stack Overflow

Questions tagged [ssrs-2017]

SSRS (SQL Server Reporting Services) is a server-based report generation software system from Microsoft. This version was released as part of SQL Server 2017 in October 2017.

SSRS (SQL Server Reporting Services) is a server-based report generation software system from Microsoft. This version was released as part of SQL Server 2017 in October 2017. More info in the tag.

169 questions
0
votes
1 answer

Using outer Group Totals to calculate inner Group Percentages in SSRS 2008R2

I am working on a UK Profit and Loss Report in SSRS 2008R2 and am struggling with the percentage calculations Here is an example to explain my question Detail Group1 Group2 Invoice Number Value % Sales Total …
Ian W
  • 385
  • 2
  • 10
  • 30
0
votes
1 answer

How to update SSRS textbox when database table value/string changes

In my report I have a text box , which is reading data from database table using below query: SELECT TOP 1 * FROM [dbo].[Table] ORDER BY [ID] DESC The strange thing is, for the 1st time its reading/reandering the content from the table and…
AskMe
  • 2,495
  • 8
  • 49
  • 102
0
votes
1 answer

lines break after X records in single ssrs page

I'm getting more than 200 records (for example, however, the number of records are dynamic) in a single table column in SSRS. I would like to do a line break after 25 records. ReportTable result (Just an example): Value …
AskMe
  • 2,495
  • 8
  • 49
  • 102
0
votes
2 answers

Resize tables based on number of records in SSRS

I have two table having data like below: SELECT * FROM [dbo].[TestTable_1] ID Value ---------- 1 gjha 2 dc 3 d 4 ds …
AskMe
  • 2,495
  • 8
  • 49
  • 102
0
votes
0 answers

Run stored procedure stored on one server on another

We try to run all our reports off stored procedures, however, now I am trying to report off a 3rd party server that I cannot deploy too. I am trying to find away to store the stored procedure on Server1, but execute on Server2 but the only link is…
Holmes IV
  • 1,673
  • 2
  • 23
  • 47
0
votes
2 answers

Fit multiple results returned from one dataset in single textbox

I have a data set which returns results like below: SELECT [Name] ,[Count] FROM [dbo].[TestTable1] ID Name Count ------------------------------------------ 1 International school …
AskMe
  • 2,495
  • 8
  • 49
  • 102
0
votes
1 answer

Keep the total calculated percentage on top of Stacked bar chart - SSRS

I have data like below: select * FROM [SaleOfVeheicle] ID Year Month Bike Car Bus ------------------------------------------------------------------- 1 2015 Jan …
AskMe
  • 2,495
  • 8
  • 49
  • 102
0
votes
1 answer

SSRS expression to fill back ground color based on perticuler date

I have this query which will return a date from SQL Server SELECT TOP 1 CASE WHEN (SELECT TOP 1 CONVERT(DATE, [Duedate]) AS [Duedate] FROM [dbo].[Table1] WHERE CONVERT(DATE, [Duedate]) = CONVERT(DATE,…
AskMe
  • 2,495
  • 8
  • 49
  • 102
0
votes
3 answers

sum based on background color ssrs

In my table, Out of 20 records, I'm getting 4 records "Red" based on the below expression: =Switch(DateDiff(DateInterval.Hour, Fields!SLA.Value, Now())<=72,"White",Fields!SLA.Value
AskMe
  • 2,495
  • 8
  • 49
  • 102
0
votes
2 answers

How to achieve Date format SSRS Example 12Th Jan 2019

Using expression, I'm able to get the date for mat like this in SSRS. Below is the expression : =FORMAT(Cdate(today), "dd-MM-yyyy") However, I would like to see the date as: 12Th Jan 2019 or 1St Jan 2019 or 2nd Feb 2019. How can I achieve this?
AskMe
  • 2,495
  • 8
  • 49
  • 102
0
votes
0 answers

Render SSRS report as in excel

I have a excel report like below screen: I would like to show this in the same manner in the report. When I inserted data in the database, it shows line this: The requirement is, I need to enter the data from excel to database table. Then show…
AskMe
  • 2,495
  • 8
  • 49
  • 102
0
votes
2 answers

color first five rows of a table in SSRS

Iam developing a report where I need to provide special effects on 1st few columns. How can I color code or provide 3D effect for first five rows of a table in SSRS? Also, count of values in these columns? For example: My date count …
AskMe
  • 2,495
  • 8
  • 49
  • 102
0
votes
1 answer

Custom Code for Color Gradation in SSRS header

I'm trying to make SSRS custom report header. Refereed this link: http://sqljason.com/2013/02/custom-code-for-color-gradation-in-ssrs.html How can I put below color as my report header. Note: I would like to display the text, date and sum of count…
AskMe
  • 2,495
  • 8
  • 49
  • 102
0
votes
0 answers

Update the DB table by taking user input from SSRS front end

I would like to update the DB table by taking user input from SSRS front end.And then, when I click generate report, this should get the user input values from DB table (that were previously updated in DB) and render/display in the same report body.…
AskMe
  • 2,495
  • 8
  • 49
  • 102
0
votes
1 answer

How to Pass Report Parameter as if it were a Query Parameter?

I am trying to make a report that allows a user to input an ID and then check this ID against several payee tables to see if the value already exists. The code requires an input and then displays a value of 1 if the code already exists and a 0 if…
HenderPar
  • 1
  • 1
1 2 3
…
11 12