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
7
votes
1 answer

Show or Hide SSRS column based on specific parameter value

I am having trouble showing/hiding a column based on parameter value chosen. How my report is set up: Parameter: ImportStatus --ImportStatus parameter has three values you can choose from: M, V, E If I choose ImportStatus value = 'M', then I want…
NonProgrammer
  • 1,337
  • 2
  • 23
  • 53
7
votes
2 answers

The query contains the XXXXXName parameter, which is not declared. SSRS2008/MDX query

Parser: The query contains the XXXXXName parameter, which is not declared. (msmgdsrv) I have no idea why I keep getting this error. It occurs when I change the MDX in the query designer and trying OKing out of the query designer. The strange thing…
adolf garlic
  • 3,034
  • 7
  • 39
  • 54
7
votes
2 answers

How to display yesterdays date in SSRS expression

In one of the column name, I need to display yesterday's date like - September 4,2014 I used DateAdd("d",-1,Today()) function to display,but it is displaying like - 9/4/2014 12:00:00 AM. How can i get the above format like - monthname,dd,YYYY ?
SqlLearner
  • 763
  • 8
  • 23
  • 37
7
votes
1 answer

Truncate textbox content with ellipsis in SSRS

By default, when the contents of a textbox in SSRS overflows the width of the textbox, the textbox will grow vertically to accommodate its content. This feature can be turned off, by setting the "CanGrow" property of the textbox to "False". However,…
Dan
  • 10,480
  • 23
  • 49
7
votes
2 answers

SSRS Dynamically change the cell background and font color

I need to change the Table Cell Background color to Yellow and Font color to Bold / Red for values which are less than 80. Cell Expression is =Fields!Mark.Value How to change the Cell Background Color / Fill the Color to Yellow ?
goofyui
  • 3,362
  • 20
  • 72
  • 128
7
votes
4 answers

SSRS 2008:How to hide a table row (Conditionally) based on category field

I am new to Sql Server Reporting Services. I have created my following report. I want to remove/hide rows of Brand Total whenever it does not exist in Brand list. Like in following picture i want to remove/hide "Ethnic Total" whereas "Ethnic" Brand…
almond eyes
  • 283
  • 2
  • 4
  • 9
7
votes
1 answer

Passing a dataset to subreport in SSRS

I have a subreport that uses the same data as my main report. Right now, it populates its dataset by re-querying the database. Is there a way to pass the data set to the subreport instead of creating the dataset again for the sub report,because…
Sally El-Sayed
  • 161
  • 1
  • 5
  • 11
7
votes
1 answer

ssrs - repeat tablix at top of every page

I have a report made up of 2 tablix. The first tablix just has some basic information in it, and is linked to a dataset. The second tablix is linked to a different dataset and is made up of a lot of rows and spans multiple pages. All I am looking to…
Luke K.
  • 177
  • 3
  • 5
  • 16
7
votes
2 answers

SSRS Repeating group headers?

I have this data DateRecived JObNumber REcCnt 20130626 1234 1 20130627 1238 11 20130628 1240 2 20130629 1242 23 I applied the group by on…
user2553512
7
votes
1 answer

Is there any possibility to Deploy Single Report in SSRS

I'm having problem with SSRS Report Deployment. I've 2 Hundreds of Reports in my SSRS Report Solution. When, I deploy the Report it deploy all reports which is very time consuming. Now, what I'm looking for is, I want to re-deploy only the Report…
N Subedi
  • 2,858
  • 2
  • 22
  • 36
7
votes
5 answers

SSRS: Relative URL Hyperlink

In SSRS 2008 I would like to create a relative path URL. Long story short I have a subscription that outputs a few thousand static HTML pages to a folder that is used as content for a website. In the past I have created full URLs to other pages on…
Registered User
  • 8,357
  • 8
  • 49
  • 65
7
votes
3 answers

SSRS reports is showing as listed directory

How can I get SSRS reports to show a web page view? When I go to the SSRS reports page, it's not showing the web page view. It shows a list of data sources, data sets and report folders. After going inside the reports folder, I can invoke the…
user2043913
  • 71
  • 1
  • 1
  • 4
7
votes
4 answers

SSRS Datepicker control is not showing in Chrome and safari

I am using SSRS for reports in asp.net application. SSRS Datepicker control is not showing in Chrome and safari. It is just displaying the textbox.
Geeth
  • 5,282
  • 21
  • 82
  • 133
7
votes
5 answers

How do I allow a drop-down list parameter in SSRS to have a default value of "-- All -- "?

I have a drop-down list that gets populated based on a stored-procedure - that parts works fine. It gets populated dynamically, based on whatever the "Survey ID" is But I don't want it to say