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
17
votes
4 answers

How do I open an .rptproj in Visual Studio 2010?

I have a Visual Studio 2010 solution that contains an .rptproj type of project. One of my colleagues is able to open that solution in Visual Studio 2010 SP1 just fine. I've seen it work. However, when I try to do it, I get "this type of project is…
GR7
  • 5,083
  • 8
  • 48
  • 66
17
votes
1 answer

Trying to Add Sub Row Group inside Parent but flush left in the nested cell

What I am trying to do: I am trying to create nested groups but I want the sub row group to show directly underneath the parent, flush to the left like the parent. So in this case You'd have: Market SubMarket so results for example would…
PositiveGuy
  • 46,620
  • 110
  • 305
  • 471
16
votes
3 answers

Query runs fast but report renders slow: how to debug this?

I'm running SSRS 08. My query has four parameters (all varchars). I can run the query through management studio and it runs in under 10sec. I get the same performance if I run the query in Visual Studio's query designer. However...if I try to…
Ahd
  • 271
  • 2
  • 3
  • 7
16
votes
6 answers

SSRS won't expand the row height when exported to Excel

I have a report I am doing with SSRS 2008 with some rows that have multiple elements inside them. On the preview the row automatically expands to support the extra elements but however when I export the report to Excel it appears only as a single…
BenYeomans
  • 383
  • 2
  • 7
  • 15
16
votes
2 answers

How to sum the Group totals only?

I'm trying to sum only group HourTarget totals. 7:00 8:00 HourTarget Line 1 2715 1008 3224 A 2307 1008 3224 B 408 0 3224 Line 2 2308 2432 2656 A 2308 …
Whistler
  • 1,897
  • 4
  • 29
  • 50
16
votes
2 answers

Joining two datasets to create a single tablix in report builder 3

I am attempting to join two datasets in to one tablix for a report. The second dataset requires a personID from the first dataset as its parameter. If i preview this report only the first dataset is shown. but for my final result what i would like…
mushcraft
  • 1,994
  • 1
  • 19
  • 27
16
votes
2 answers

Report footer is not exported to Excel

I am using SQL Server Reporting Services 2008 for reporting. When we export the report to Excel, the footer image or textbox is not exported. Header image is getting exported successfully. Does anybody know a solution for this?
Kalpesh
15
votes
4 answers

SSRS report subscriptions cannot be created

I am not able to create subscriptions for SSRS reports as it gives the following error: Subscriptions cannot be created because the credentials used to run the report are not stored, or if a linked report, the link is no longer valid. My set…
paranjai
  • 531
  • 2
  • 5
  • 26
15
votes
2 answers

SSRS Pull Variables Or Values From Sub Report Into Main Report

I have a main report with several sub reports, each of these with slightly different queries and different ways to show the data. So, in my situation, I have a textbox that needs to compile data from a few different reports with varying criteria.…
Elias
  • 2,602
  • 5
  • 28
  • 57
15
votes
5 answers

SSRS Stop group in tablix being split across printing pages

I have a tablix in SQL REPORTS (SSRS) that has many grouped items. It fits roughly 3.5 groupped item per page when printnig, however I dont want the groups to be split up over the 2 pages, I want a pagebreak to happen whenever the group needs to be…
Michael
  • 8,229
  • 20
  • 61
  • 113
15
votes
6 answers

Hide Column if all Rows are empty

I have a a Tablix in SSRS 2008 and I have a Column that sometimes has data and sometimes doesn't. I want to hide the column if NO rows have data. So this would hide Column 2: Column 1 Column 2 Column 3 Column 4 1 …
user482375
14
votes
2 answers

SSRS only displaying first row

I have a very basic report in SSRS that displays a grid of data. The query correctly returns multiple rows but the report only displays the first row. The query is as simple as SELECT * FROM... I dont have any special formatting and the tablix is…
Blaze
  • 1,863
  • 7
  • 23
  • 40
14
votes
3 answers

What is the difference between ReportService2005.asmx and ReportExecution2005.asmx Web Service Endpoints in SSRS?

Does anyone know what the difference is between the two web service endpoints ReportService2005.asmx and ReportExecution2005.asmx in SQL Server Reporting Services? is there an article that I can go through? Thanks.
user384080
  • 4,576
  • 15
  • 64
  • 96
14
votes
5 answers

Using dropdown parameters in SSRS report

I can see the text box for my data set that having the "select col1 from table name " as query. I want to populate dropdown instead of text box. I have created the parameter for it . what to do?
Red Swan
  • 15,157
  • 43
  • 156
  • 238
14
votes
2 answers

Is it possible for me to include a sub report in a tablix row that is grouped by an ID?

Is it possible for me to include a sub report in a tablix row that is grouped by an ID and pass that ID into the sub-report to be ran? Basically, the sub-report would return data from a second dataset based off of the ID that is being used in the…
Nick G
  • 1,209
  • 8
  • 34
  • 58
1 2 3
…
99 100