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

Nested tables in SQL Server Reporting Services without using Subreports

I'd like to achieve somthing similar to the nested products and orders tables shown in this XtraReports example using SQL Server Reporting Services. Also I'd prefer to do it without using Subreports.
Akmal
  • 35
  • 5
1
vote
1 answer

SSRS: Displaying User specific data on a report

on SQL Server Reporting Services, I have the below requirnment for a report Users are authenticated for Reporting using Active Directory (windows domain accounts) We have an custom authentication DB and the data that should appear on the report are…
Eranga Dissanayaka
  • 1,930
  • 3
  • 24
  • 27
1
vote
1 answer

Displaying Popup alert for SSRS Parameter validations

I am working on a SSRS report which has From & To date as input parameters and it has to be validated such that From date can't be more than To date. I was successful in creating a custom VB code which takes care of validation but the problem is…
Praveen
  • 11
  • 1
  • 5
1
vote
1 answer

Is there a way to pass in an array to rs.exe

I am trying to make a command line util to let me register updates to my TFS SSRS reports. I am using rs.exe. It has the -v option where you can pass in a parameter. Is there a way to pass in an array (or some kind of collection). I would like to…
Vaccano
  • 78,325
  • 149
  • 468
  • 850
1
vote
0 answers

ssrs How to Make very simple timeline using 3 date fields from same record using names as labels

I would like to show a project timeline in SSRS for a single project record containing a few milestone dates Given the following data set: (Single record) ProjectID (Text) , StartDate (Date), ApprovalDate(Date) , FinshDate (Date) I would…
Sean
  • 55
  • 4
1
vote
1 answer

How can I set a report parameter based on the print medium type?

I need to toggle some presentation in my SSRS Report based on the print medium the report will be generated on. I have to do this for a bunch of reports (SalesInvoice, SalesConfirm, SalesQuotation). The problem is I can't find an access point where…
Kempeth
  • 1,856
  • 2
  • 22
  • 37
1
vote
0 answers

SSRS Color code based on comparison between two columns in a matrix

I have build a matrix in my report that brings data for every month. I need to check if the data for current month is greater or lesser than the previous month. If the data is greater than the previous month, then the foreground colour will be…
xorpower
  • 17,975
  • 51
  • 129
  • 180
1
vote
0 answers

Hide Row Group header if child group has no rows

I have the following Row Groups structure: And then under each UnterlagGruppe there is an UnterlagProduct product row. Sometimes, products are not shown but their UnterlagGruppe group name is still shown, like this: As you can see, there are some…
Bernard Polman
  • 795
  • 2
  • 14
  • 31
1
vote
1 answer

SSRS How to set default parameter NOT select all, but using a where clause as the default?

I have a report with multi-value parameter from a sql query: SELECT USER_ID, USER_NAME FROM USERS I want to set the default of that parameter with a where clause. The default I want to set: SELECT USER_ID, USER_NAME FROM USERS WHERE STATUS =…
Alice Guo
  • 11
  • 5
1
vote
2 answers

Reporting Services Installation in SQL Server 2008 [Release] 1

We have the full version of SQL 2008 Server (first release) installed and licensed from download (a couple years ago). Now we are getting into Reporting Services; however, it seems only the Express version of Reporting Services is installed. In…
Dave
  • 4,949
  • 6
  • 50
  • 73
1
vote
0 answers

Multi select on same MDX query

First, my knowledge of MDX is very limited Basically, I have 2 queries; one with HQ sales per departments and one with stock room sales per departments. I would like to return the results of the department sales of the stock room followed by the…
Flesym
  • 573
  • 2
  • 9
  • 18
1
vote
1 answer

iif Function Expressions ( IsNothing Conditioal formating SSRS)

I'm receiving the following output as I try and add in an expression to give me FAIL based on a blank condition. =iif(Variables!PAT_ID_Count.Value = 0, "PASS", "FAIL", iif(IsNothing(Variables!Summary.Value), "FAIL","" )) I'm getting Too many…
Diego83
  • 73
  • 7
1
vote
1 answer

SRRS how to check if there is a certain value in dataset

I am trying to make a new ssrs report: There is a details group that prints lines from datasource detailsDS. I also want to make a textbox in the footer(or anywhere, doesn't matter) where if there was any(or more than one) line in detailDS with…
zygbie
  • 11
  • 3
1
vote
0 answers

How to add text between double quotes i.e. "word" on SSRS

I need to export an ssrs report to csv and when I open it on notepad ++ or notepad each column text needs to be between double quotes , for example "word1" 1- I've tried to change the csv render format to FTP-8 but the words did not have the double…
Samayoa
  • 185
  • 1
  • 2
  • 12
1
vote
3 answers

Need to scheduled an SSRS report to save to a SharePoint document library

I want to schedule an SSRS subscription to save directly to a SharePoint document library and I can't. I get the error "Failure writing file \server\path\report.pdf: Access to the path '\server\path\report.pdf' is denied. Here are the facts: - I…
JHFB
  • 441
  • 1
  • 5
  • 20
1 2 3
…
99
100