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
27
votes
6 answers

Get Row Count in SSRS Report Builder

I have built a report using Report Builder 3.0 (that uses SQL Server 2008 R2). Now i wish to now how many records are being fetched from database to the report? This is possible either by count function in SSRS or by using RANK/ROW_NUMBER function…
xorpower
  • 17,975
  • 51
  • 129
  • 180
27
votes
8 answers

Issue re-deploying updated default parameters in SSRS report

I have an SSRS (SQL Server 2008 R2) report with several parameters. I'm having an issue where one of the parameters is not consistently choosing its default value when the report is first loaded. Specifically, it works fine in BIDS but works…
Mark Micallef
  • 411
  • 1
  • 4
  • 7
27
votes
2 answers

Add column to SQL query results

I'm putting together a report in SSRS. The dataset is populated with a SQL query of an MS SQL server. It's querying several similar tables using Union All. The problem is that there's some information loss. The different tables are for different…
Ben C.
  • 1,761
  • 5
  • 15
  • 24
26
votes
5 answers

Row color and Alternate Row color for Table in RDLC Report

How do I give row color and alternate row color for a Table in RDLC report? When I googled I found most of the result says something like = iif(RowNumber(Nothing) mod 2, "Red", "White") OK! But where should I place this stuff? Any help will be…
Jith
  • 1,701
  • 3
  • 16
  • 22
26
votes
4 answers

rdlc report in vs2010, how do i repeat column header on every page?

How do I repeat column header (captions) in RDLC reports? It says here http://msdn.microsoft.com/EN-US/library/735D1EE7-3C89-46D8-A346-504DB10F33E1.aspx#TableNoGroups: To repeat or freeze column headings for the tablix member, select the static row…
deerchao
  • 10,454
  • 9
  • 55
  • 60
25
votes
2 answers

Comments in SSRS Report Expressions

I'm using some complicated expressions in Reporting Services to control the value, format etc of data in a report (see MSDN). Is it possible to insert code comments into these expressions, and if so, what is the syntax? By code comments I mean…
Sophia
  • 5,643
  • 9
  • 38
  • 43
25
votes
1 answer

SSRS Conditional Formatting Switch or IIF

I currently have the following 2008 SSRS Report and I want to conditionally format background of the columns based on some logic. I have three columns and two of which I would like to change the background color. Columns "Current Risk Level",…
AKudla
  • 325
  • 1
  • 3
  • 9
25
votes
10 answers

Cannot create a connection to data source Error (rsErrorOpeningConnection) in SSRS

I'm working on integrating a report into a browser, and I get this error: An error has occurred during report processing. (rsProcessingAborted) Cannot create a connection to data source 'dsFederatedSample_SurveyLevel_STG'.…
Caffeinated
  • 11,982
  • 40
  • 122
  • 216
25
votes
3 answers

In SSRS, how does an "Internal" parameter differ from a "hidden" parameter?

I've been wrestling with this one report for a long time, and finally figured out what to do but it was serendipitous . Well I changed a parameter that depends on a previous one to be "Internal" - then everythig worked like I wanted! thanks How…
Caffeinated
  • 11,982
  • 40
  • 122
  • 216
24
votes
6 answers

In SSRS 2008, is there any way to add all dataset fields to a table at once?

I'm working with SSRS for the first time. When adding a table to a report, is there any way to add all fields of a dataset to it at once or does it have to be done individually? Drag & drop, insert column -> right is a pain when there are a lot of…
John Straka
  • 1,874
  • 5
  • 28
  • 49
24
votes
3 answers

Combining multiple PDFs using PDFSharp

I am trying to combine multiple PDFs into a single PDF. The PDFs come from SSRS, from some LocalReports that I processed. I am using PDFSharp, because it is already used through out the project. However, the outputDocument.addPage(page) methods…
Pierre-Olivier Goulet
  • 968
  • 2
  • 11
  • 18
24
votes
3 answers

How to filter rows with null values in any of its columns in SSRS

I want to filter out the output without rows containing null values or blank columns. I am using SQL Server 2012 there is no option named 'Blank' as in SS2005 where I can filter the rows. I also tried following expression but it gives me error or…
Rajaram Shelar
  • 7,537
  • 24
  • 66
  • 107
24
votes
1 answer

how to forward basic authentication challenge to report manager url

*The details of the environment is described at the bottom. I am trying to build an authentication solution for reporting services. Online costumers should be authenticated using our existing costumer database, while local administrative users could…
Thiago Dantas
  • 670
  • 6
  • 16
23
votes
3 answers

What are the rules for using "Internal" parameters in SSRS

There is an option to create "Internal" parameters in SSRS: In what context are they used? What are the general rules for using internal parameters?
whytheq
  • 34,466
  • 65
  • 172
  • 267
23
votes
1 answer

Positioning tables and charts in BIDS SSRS

See (image.1) - As you can see, in the design view I have my two tables on the left and two pie charts on the right, all neatly positioned. See (image.2) - Now I preview the report, and as you can see, I am not allowed the second pie chart along…
JsonStatham
  • 9,770
  • 27
  • 100
  • 181
1 2
3
…
99 100