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

The visibility of a Text Box is seen in the code view but design view

I have a Text Box in my Table in SSRS 2008. In the Design View, when I check the Visibility -> Hidden property of this Text Box from the Properties window on the right, it is set to: FALSE. The visibility of the column where the Text Box locates is…
Eray Balkanli
  • 7,752
  • 11
  • 48
  • 82
0
votes
1 answer

ssrs reports working differently on server and Local

I want users to see few reports which they have access, this is working fine when I open SSRS URL on the report server, but when I open the same URL in user local machine, the user can see all folders and reports from home button. Suggest me if…
ven
  • 15
  • 5
0
votes
2 answers

Can SSRS do excel like functions as expressions such as adding 1 cell from a column to another?

I have searched and searched but can't find the answer. I am building an SSRS report that provides a running total. I need to be able to do the equivalent of I2+J3 and have the next row be I3+J4, etc. My report uses 1 dataset. Is this possible?…
jrushing
  • 61
  • 1
  • 8
0
votes
0 answers

E-Mail delivery configuration in SSRS 2008 R2

I'm fairly new to SSRS and after a long search on the internet I would ended up here trying to get a response. Is it possible to modify the body content of the e-mail with the 2008 R2 version of SSRS. I'm actually using this exactly tags on the…
Alexandre Bastos
  • 1
  • 2
0
votes
1 answer

Painfully Slow Report coming from SSRS 2016

I am in the process of moving a batch of reports (26) from SSRS 2014 to SSRS 2016. One of them is absolutely painfully slow, but only in a browser ( both IE and Chrome ). The report depends on a query within the report (not a stored proc). I can…
Steve_Malcolm
  • 53
  • 1
  • 9
0
votes
1 answer

How to Modified X axis lables in SSRS chart or add expression to X axis lables

I making SSRS chart Line report. Default values generated from Query as it is displayed on CHART of X axis labels. How to Modified this X-axis labels ? --- Default current X Axis values: Years 2013.00 2013.25 2013.50 2013.75 …
Mr. Bhosale
  • 3,018
  • 1
  • 17
  • 34
0
votes
1 answer

Hyphenation in SSRS

I want to add hyphenation to the column headers of a tablix Consider the column value "waterbodiesinhereforme" Currently SSRS is hyphenating based on the size it can fit inside the tablix column header. Like below . waterbodiesinhereforme But my…
ndavid9
  • 13
  • 3
0
votes
2 answers

Start a new line after exactly two words of a string in SSRS-2008

I have this string that is coming from the db and the words are separated by a space. the number of words can vary from a minimum of one to a maximum of six, so what i essentially want is to start a new line immediately after the second word. For…
ArK
  • 47
  • 1
  • 1
  • 7
0
votes
1 answer

How to pass dynamic connectionstring with username and password directly in SSRS using C#?

I am using SSRS for reporting purpose in my application.In SSRS i am using Embedded DataSource for fetching data. I want to pass dynamic connection string in c# code to that datasource so based on connection string parameter it will fetch data…
Dilip Oganiya
  • 1,504
  • 12
  • 20
0
votes
1 answer

SSRS 2008 R2: How to generate a expression based Date column while exporting Excel Report?

SSRS 2008 R2: I have created a report(.rdl) using Shared datasource. I am following the tabular approach to generate the report. I need an extra column in my report which uses the excel formula to calculate the date based on two existing columns.…
RahulGo8u
  • 148
  • 2
  • 19
0
votes
2 answers

Hide Multiple Columns in SSRS Matrix

I have a Matrix report with some columns that are grouped by Month and Year in the Column Group. Now, these columns are being toggled by the Month Column as the Visibility Property is set to hide but toggled by the Month Column. But when the report…
UpwardD
  • 739
  • 4
  • 12
  • 36
0
votes
0 answers

SSRS empty value for sparkline

I created an SSRS report to show results of data received/loaded for the last 12 months. There are 3 data sources and 2 of them have data populated for the entire 12 months as expected. One of the Data Source has data populated for only the first…
jujulalu
  • 97
  • 1
  • 1
  • 9
0
votes
1 answer

SSRS 2008R2 Upgrade to 2016 Performance Issues

We recently did an SSRS upgrade and migration going from 2008R2 to 2016 Standard SP1 on a new server. The migration was done with a ReportServer DB restore, so all the 2008 RDLs were copied over. One of the reports is taking about 20 seconds longer…
Pops
  • 468
  • 2
  • 15
0
votes
1 answer

SSRS 2008 R2 - all parameters multi value AND optional

I've got a report that has 6 parameters. All parameters need to be optional and 3 have to be multi-value. One of the optional parameters is a dropdown, the rest are manually keyed in text boxes. The Where clause below works when there are…
tardytrtl
  • 3
  • 1
0
votes
0 answers

Remove headers from CSV export in SSRS/VS Designer

I'm not sure where to ask this question. I've been all over the web looking for an answer. I'm trying to export a report as pipe delimited and without headers. I've found several discussions about how to change the config file on the server. …
SteveO250k
  • 59
  • 1
  • 5
1 2 3
…
99 100