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
2 answers

Where ssrs field contains any of selected parameters

The table has a field that may contain any combination of the four letters"DICS." For example any of these: "I", "DC", "DIS", "CS", or "DICS." I put "WHERE DISCScores IN (@DISCScores)" in the Dataset and set the Parameter properties to include…
David Megnin
  • 79
  • 1
  • 1
  • 10
0
votes
1 answer

Drill down SSRS: hide columns based on drill down in ssrs

Before drill down summary report: After drill down : I have tried this and not able to hide project Name column,it should show only when I drill down the human resource fields.
author4
  • 125
  • 2
  • 12
0
votes
1 answer

Get space related information from multiple servers

I need to create an SSRS report that would display space related information for all of our servers and associated databases. Is there a way to create a stored procedure that would loop through all servers and write space information to a temp…
NonProgrammer
  • 1,337
  • 2
  • 23
  • 53
0
votes
1 answer

Hide textbox on export

I have one textbox in SSRS report which I need to hide on export. I added expression for Hidden property to =IIF(Globals!RenderFormat.Name <> "RPL", True, False). but it always hiding textbox in ReportViewer as well as any type of export…
par
  • 1,061
  • 1
  • 11
  • 29
0
votes
2 answers

Deployed SSRS Report displays blank

I have successfully deployed my first SSRS Report using BIDS, please see image below I can see the deployed SSRS in the web browser But when I click the report name to view/access the report it displays blank and no error! why is that? I'm new to…
Francis Saul
  • 728
  • 2
  • 16
  • 37
0
votes
1 answer

SSRS Report with embedded XML datasource very slow

I've a problem with a very simple report that takes 10 minutes to load, even with just a few rows of test data. The preview in the report designer only takes at most a few seconds. The report uses an embedded XML data source. There is a single data…
kapex
  • 28,903
  • 6
  • 107
  • 121
0
votes
0 answers

SSRS Migration errors rs.exe -i ssrs_migration.rss

We are trying to migrate from a 2010 Sharepoint Integrated SSRS instance to a 2014 standalone SSRS. I can connect with the accounts used to both servers. When the RSS process begins, I see the connection occur from Process Monitor, and we see data…
RowdyVinson
  • 150
  • 2
  • 7
0
votes
1 answer

SSRS: Grant access to users from a group to reports deployed (rsAccessDenied)

I have deployed some reports. I have a user (among others) which is included in a group. I would like to grant access permission to all the users from this group to be able to execute report (to see the reports deployed). So from Reporting Services…
Willy
  • 9,848
  • 22
  • 141
  • 284
0
votes
2 answers

SSRS Issues with 32bit and 64bit ODBC drivers

The ultimate goal is for users to be able to run a report that looks pretty and grabs current information from our database. We'd like to use SQL Report Builder since we're already using it for other reports. The database is Cisco UCCX and we're…
esafresa
  • 480
  • 7
  • 19
0
votes
1 answer

SSRS Custom format with 2 decimal places for Y axis labels

I have a rdl report which has a chart. I would like to set one or zero decimal places depending on a report parameter so I perform the following: Right Click on the axis chart Report Item -> Properties -> Number -> Custom and I provide below…
Willy
  • 9,848
  • 22
  • 141
  • 284
0
votes
2 answers

SSRS 64bit to mandatory 32bit ODBC (Cisco UCCX)

We're using 64bit SSRS on our reporting server (2008 R2). We have an ODBC connection with the 32bit IBM Informix driver connecting to Cisco UCCX. When I try to add a New Data Source in SSRS to this connection I get the below error. "ERROR [IM014]…
esafresa
  • 480
  • 7
  • 19
0
votes
5 answers

SSRS - missing data in the table in my report even though no missing data in sql server

I have a stored procedure returning data like: Id Name fromTable 1 Alison Table1 2 Gary Table2 3 Jack Table1 4 John Table3 by the code: Select Id, Name, fromTable='Table1' from Table1 union Select Id, Name, fromTable='Table2'…
Eray Balkanli
  • 7,752
  • 11
  • 48
  • 82
0
votes
1 answer

SSRS Parameter expression to select hours range dynamically

I am currently working on an SSRS report and I have to deliver this report two times a day. (At 12 PM and 12 AM). The report has the following parameters. Date: (Picks Today's Date) Beg Hour: (Defaults to 8 i.e. 8AM) End Hour: (Defaults to 18 i.e.…
Kashyap MNVL
  • 603
  • 4
  • 13
0
votes
0 answers

SSRS report while exporting it is giving misterious boarders

My [SSRS] report exports to PDF just fine, but when it exports to excel, I end up with these strange and mysterious grids. When I checked with the other server it appears to export correctly. There, the extension is .xls, but xlsx. in the strange…
pavan kumar
  • 1
0
votes
1 answer

pass date parameters from one SSRS report to another

How can I pass these two date parameters to another report, so that users wont have to fill these boxes again?
Salta
  • 25
  • 6
1 2 3
…
99 100