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

Sum Fields in SSRS

I have two cloumns in ssrs 1. Column10 Expression(column1 + column2 + column 3) 2. Column11 Expression(column4 + column5 + column 6) Now I want to subtract column 11 from column 10 I am doing now =(Fields!column1.Value) + (Fields!column2.Value) + …
Virender Thakur
  • 327
  • 3
  • 12
1
vote
1 answer

Does SQL Server Express SSRS support using custom assemblies as a datasource?

I am trying to find out if SQL Server express SSRS supports using custom assemblies as a datasource. My assumption is no but I would like a concrete answer. Based on this http://msdn.microsoft.com/en-us/library/cc281020.aspx it seems like my…
Tony
  • 1,684
  • 1
  • 18
  • 29
1
vote
0 answers

SSRS ReportViewer Design breaks in first and last page and flickering issue in pagination

I am using Microsoft.ReportingServices.ReportViewerControl.WebForms for viewing SSRS reports in aspx page facing following issues In first page previous page buttons are misaligned In last page next page buttons are misaligned. Flickering…
Anson Aricatt
  • 391
  • 2
  • 8
1
vote
3 answers

SSRS: ASP.NET ReportViewer parameters reset to default when clicking View Report

I have a SQL Reporting Services report (SQL 2008 built using Report Builder v2.0) which has a multi select integer parameter (in this case a list of stores). The default value is 0 ("All Stores"). The parameter is passed to a stored procedure as a…
Andrew
  • 31
  • 1
  • 3
1
vote
2 answers

SSRS SELECT ALL emulation in ASP.NET Dropdown List

I have a multi-value parameter for SSRS report. This parameter being a multi-select will have SELECT ALL option that selects all values under the drop down list. Challenge is emulating the same using ASP.NET drop down list as parameter source. I…
Santosh Chandavaram
  • 2,430
  • 2
  • 24
  • 22
1
vote
1 answer

SSRS - Visual Studio

Hi I am a newbie Learning SSRS While using concatenate function in expression i am getting an error =(Fields!Bathroom.Value, "PropertyDetails") & " " & "Bathroom" & " " & (Fields!Bedroom.Value, "PropertyDetails") & "Bedroom" Please help me in this…
Rahul MARNE
  • 11
  • 2
1
vote
1 answer

SSRS report with multi-column content and fixed dimensions

I need to design a report that has some very specific requirements that I am having problems with. The report needs to have fixed margins at the top and bottom (to allow for pre-printed content on paper). In the body of the report, there needs to…
Bill
  • 11
  • 2
1
vote
1 answer

SSRS Report giving error for Join expression

I have declared a multi value parameter in my SSRS report. The parameter is a Date and it has multiple values like: 06/01/2021 05/01/2021 04/01/2021 Now when I select date as 06/01/2021, 05/01/2021 then the expression should show as Reportname_…
user14944204
1
vote
0 answers

InnerChannel = 'webServiceProxy.InnerChannel' threw an exception

I am trying to Consume WCF Service for SSRS Reports. I have tried to exceed the message size limit to But it gives me with the exceptions which is as follows : InnerChannel = 'webServiceProxy.InnerChannel' threw an exception of type…
Shanu Garg
  • 21
  • 3
1
vote
1 answer

SSRS 2008 - Line Chart - How to shade an area of the chart?

I have a line chart. The line represents the average thickness of material we apply to glass. The Y Axis represents the thickness and the X axis represents time. Say the range of values on the Y axis is between 1 and 10. The average thickness is say…
Randy Minder
  • 47,200
  • 49
  • 204
  • 358
1
vote
1 answer

SSRS reports timing out when downloading using System.Net.WebClient

UPDATE See the bottom for the solution. I'm trying to download reports in my ASP.Net MVC app in a loop. The first two always succeed, and the third always fails. It doesn't matter what order I run them in, it's always the third one that fails…
Michael Meadows
  • 27,796
  • 4
  • 47
  • 63
1
vote
3 answers

Excel formulas are not being generated by Reporting Services

I'm working on a report for my employer where the end product is a SSRS report, but one that will almost ALWAYS be exported to Excel for further manipulation. In this report, there is a row that is really just a row of calculations based on other…
Robert Iver
  • 711
  • 2
  • 9
  • 14
1
vote
1 answer

To populate all dates in a month in SQL and SSRS

We need to create a report based on employee, say Kumar, logged 3 hours. For example, if a person is logged Hours in system for 1-1-2021. But he didn't log for 2-1-2021. We have a join query to get the date and worked hours for each employee. Our…
Anna Vincent
  • 21
  • 2
1
vote
2 answers

Creating a Directory Listing type Report in SSRS

I was wondering if there was a way to create a directory listing report in ssrs and if so, how would i go about creating it. I'm mostly familiar with creating tabular and some somewhat complex reports, but nothing like this; so any help would be…
zSynopsis
  • 4,854
  • 21
  • 69
  • 106
1
vote
1 answer

SsrsMsbuildTasks - adding images files to ssrs report deployment using AddResource task

I've been using the excellent ssrsmsbuildtasks for a couple years to automate ssrs report/folder/datasource deployment. Thumbs up. On the current gig they have 'loose' image files that need to be deployed to the reports folder. Looks like the…
John Dhom
  • 1,022
  • 9
  • 21
1 2 3
…
99 100