Stack Overflow
Stack Overflow

Questions tagged [ssrs-2008-r2]

Microsoft SQL Server 2008 R2 Reporting Services provides a server-based platform designed to support a wide variety of reporting needs enabling organizations to deliver relevant information where needed.

Microsoft SQL Server 2008 R2 Reporting Services provides a complete, server-based platform designed to support a wide variety of reporting needs enabling organizations to deliver relevant information where needed across the entire enterprise.

This is a version of Reporting Services provided by SSRS

2305 questions
0
votes
1 answer

Multiple value in a parameter

I have a query that has 3 parameters Start Date, End Date and Location. The query is stored in SQL Stored Procedure, and I am calling the Stored Procedure in SSRS (EXEC dbo.ups_Calls @Start, @End, @Location) (see below code). CREATE PROC…
Arsee
  • 651
  • 2
  • 11
  • 36
0
votes
0 answers

SSRS Query Execution failed for dataset rsErrorExecutingCommand

I am sorry if this is a duplicate question. I have been searching for two days for an answer to this. I have an SSRS report that has been deployed to a SQL 2008R2 Reporting server. I have developed it using VS2015. When I hit my report server…
mbcharney
  • 355
  • 1
  • 4
  • 15
0
votes
0 answers

SSRS Reports data displaying from second page of the report

Recently we have migrated all RDLs from SSRS 2005 to SSRS 2008, all reports are working fine except one report. Only header and footer of the report are showing in the first page of the report, actual data even it is just 1 line showing in second…
Saikrishna
  • 51
  • 7
0
votes
0 answers

Embed VBA in SSRS appear in Excel

Is there anyway for me to add in a VBA code that would take effect, when the SSRS report is exported into excel. I have a report (main report) with 4 (sub reports). All reports are in portrait, except for one. I would like to know if SSRS supports…
a415
  • 359
  • 1
  • 6
  • 23
0
votes
1 answer

SSRS sub reports and main report dynamically set size for main report

I have a report with 4 sub reports. The page size of the main report is 8.5 by 11 inches, but there is one sub-report which should be 11 by 8.5. At the moment when I export this it is extremely wonky. I do have a break between each report. Is there…
a415
  • 359
  • 1
  • 6
  • 23
0
votes
1 answer

SSRS Pie chart hide 0 Value

SQL Server 2012 - SSRS Questions I currently have a Pie chart that shows the number of deliveries as a percentage on whether they are late, on time or early. What I am trying to do is use an Expression in the Chart Series Labels "Visible" property…
PJD
  • 743
  • 2
  • 12
  • 38
0
votes
1 answer

How to format to display leading zero

I am trying to display the duration in this format: 05:02:09 which is hour, minute and second. At the moment I can display it without the leading zero in this format: 5:02:09 =IIF( Fields!DataValue.Value < 0, 0, Floor(Fields!DataValue.Value /…
eMRe
  • 3,097
  • 5
  • 34
  • 51
0
votes
3 answers

DateTime to time interval in T-Sql

I am working on an SSRS report and I need to display hourly data count in a table. The hourly interval need to be displayed as 4:00pm - 5:00pm I have a log table which has DateTime available with each transaction. This table refreshes daily. I am…
viky
  • 17,275
  • 13
  • 71
  • 90
0
votes
1 answer

SSRS 2008 R2 Data Region Embedded in Another Data Region

I have two unrelated tables (Table A and Table B) that I would like to join to create a unique list of pairings of the two. So, each row in Table A will pair with each row in Table B creating a list of unique pairings between the two tables. My…
TheDirtyJenks
  • 399
  • 1
  • 3
  • 12
0
votes
1 answer

how to add new line in ssrs expression between 2 numeric values

I tried to add a new line to a textbox to make the values appears like this:- I wrote the following expression:- =FormatNumber(val(COUNTDISTINCT(Fields!YearMonth.Value)) ,Parameters!DecimalScale.Value,true,nothing,nothing) + VbCrLf +…
Bishoy Ezzat
  • 99
  • 10
0
votes
3 answers

Change a value in DB table when retrieve

Dears, I have table in Microsoft SQL server DB as follow: SysNameFlag | NotificationTime 1 | 02:55:01 1 | 07:40:00 9 | 10:55:06 Each SysNameFlag refer to specific system name. My question is how…
Sara
  • 1
  • 1
0
votes
1 answer

Configuring Report Server 2016

I configured SSRS in Native Mode and expected to be able to view report manager via my URL. But the image below was what I get, with no access to the "home" link where I could set up permission. What do I need to do to rectify this? If I click on…
UpwardD
  • 739
  • 4
  • 12
  • 36
0
votes
2 answers

Get all database names from multiple servers

We have multiple SQL Servers and most of them are standalone. I am in need of creating a stored procedure / view that would insert all database names into a table from all servers. Is there a way to do this via a stored procedure or a view? I do…
NonProgrammer
  • 1,337
  • 2
  • 23
  • 53
0
votes
1 answer

Blank Page and Alignment Issues in SSRS Report

I am trying to generate a report in SSRS BIDS 2008 and export it to PDF format in my applicaiton. I have a main report with 20+ sub reports. On Exporting to PDF I am getting multiple blank pages in between.​ I have googled up a few things like…
Parth Kalra
  • 127
  • 1
  • 1
  • 10
0
votes
1 answer

how to sum after iff condition in ssrs?

I want to sum all the values of the column, using if condition same as the column expression:- The Expression of the normal column:- iif(Fields!mcount.Value <> 0 And Fields!TaxCode.Value = 1 ,Fields!InputAmnt.Value,0) The Expression to sum, I used…
Bishoy Ezzat
  • 99
  • 10
1 2 3
…
99 100