Stack Overflow
Stack Overflow

Questions tagged [ssrs-2008]

Microsoft SQL Server 2008 Reporting Services provides a server-based platform designed to support a wide variety of reporting needs enabling organizations to deliver relevant information where needed. Use with the [reporting-services] and/or [ssrs] tags

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

This tag is for questions specific to SSRS 2008.

6153 questions
1
vote
1 answer

What could cause a drop down list (select) to ignore its Value field?

I've got a report that has several parameters, among them CompanyID. The available values come from a dataset with the Value field set to "Value" and the Label field set to "Label". Not exactly Rocket Science. The query looks like this: select null…
jcollum
  • 43,623
  • 55
  • 191
  • 321
1
vote
0 answers

Can viewing or deploying a report from Visual Studio break its exports?

I am having some problems with SSRS reports a former employee created. The first problem comes when exporting the report results to Excel. They throw an error "We found a problem with some content. Do you want to try to recover?" and then the…
lurkedout
  • 11
  • 2
1
vote
1 answer

SSRS Table exhibiting conditional visibility without expression set

TL;DR: Is there a way to see all (visibility) expressions at work on a report? I'm quite new to SSRS. I'm working on a report which will contain 2 tables, as below: The 2 tables, simplified I have one data set, which contains one row for each…
joshzirinsky
  • 11
  • 1
1
vote
1 answer

SSRS horizontal alignment in a straight line

I'm new to SSRS and I'm unable to align the sentence horizontally in a straight line in SSRS using HTML tag. I've got a very long word and I want it to fit in a line. I tried using can grow in SSRS but it expands the text box in a vertical manner…
Prithvi P
  • 13
  • 2
1
vote
0 answers

Display specific value within a message in a specific column

I have a question on how to display a specific value within a string inside a column: Bin Message Sent X343 Message is 333-Yes No VFG33 Content Value on 155-Yes Yes JH789 Bring to Dock33 at 045-Yes Yes 1255 Message is 768-Yes No As…
lostcoder
  • 11
  • 4
1
vote
1 answer

SSRS change the color on part of an expression based on conditional logic

How do change part of the string's color in SSRS based on conditional logic. This is what the expression currently looks like: =" Total Amount Due: " & FormatCurrency(ReportItems!GrandTotal.Value) What I want to do is something like this …
YelizavetaYR
  • 1,611
  • 6
  • 21
  • 37
1
vote
1 answer

MDX StrToMember date range issues

It seems like the query can't get date range to work. I'm passing two dates as a parameters and based on that I would expect to have [Sector Name] dropdown values retrieved based on the date range(@FromJoinDateDate:@ToJoinDateDate) and both…
tym
  • 73
  • 1
  • 6
1
vote
2 answers

is the text on Chart legend can be changed?

I have a requirement to show the statistic data such as sales, visitors of previous two months on a chart, of course the legend should show the name of the two months. And I decide to design the store table as: 1) Product Jan Feb and Jan Feb can be…
user84016
1
vote
1 answer

Reporting Services RangeBar Chart X-Axis labels time portion only of a datetime value

I have a Business Intelligence project in Visual Studio 2008. I have added a report and placed a RangeBar chart in it. The dataset is as follows: dbName dbStartTime dbEndTime -------------- -----------------------…
hollystyles
  • 4,979
  • 2
  • 36
  • 38
1
vote
1 answer

SQL Server Reporting Services export to another server

Is there anyway to transfer SQL Server Reporting Services reports to another server ? Are reports stored in the Reporting Service database ?
Shahin
  • 12,543
  • 39
  • 127
  • 205
1
vote
1 answer

Loading Byte image on SSRS from database

How to load Byte data into the image box of SSRS The data is saved in the image field of the database. Could you give me expression for it? Thanks / Furqan
Furqan Sehgal
  • 4,917
  • 33
  • 108
  • 167
1
vote
0 answers

Power Bi Report Builder - Calculating change from last year

So I have 2 datasets. One is stats for year 2022, one is stats for 2021. I want to compare the numbers (totals) for each year in each category. I did this by creating a tablix using the wizard for each dataset. The last column is a measure imported…
kdeavames
  • 11
  • 2
1
vote
2 answers

Auto generate SSRS 2008 reports using SSIS 2008

I have a requirement in which the SSRS 2008 reports need to be run automatically overnight, exported to excel and then saved on a physical folder. These reports take long time to execute so they don't want the end user to spend time in the morning…
Romanshu Goel
  • 103
  • 3
  • 9
1
vote
2 answers

SSRS 2008 R2: Set selected value of drop down programmatically

I have a report that contains a drop down of users. I want the currently logged in user to be selected as a default. The drop down has a value of UserId and UserName. I have attempted the following but no…
Alistair
  • 1,939
  • 2
  • 22
  • 31
1
vote
1 answer

How to identify the report Items in SSRS

I'm new to SSRS and unbale to find out the report items used in exiting SSRS report.I would like to know how can I indentify the Report item type wether it's List or Table. Is there any property exists in ssrs to identify the Type?
KD29
  • 109
  • 1
  • 3
  • 15
1 2 3
…
99 100