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
9
votes
3 answers

how to open ssrs report from asp web page using report viewer

I'm trying to open an ssrs report on my web pages using ReportViewer. For the Report Serverl URL I have: http://db_servers/ReportsServer_SENSORSQLSERVER and for my report path I…
Rick
  • 397
  • 3
  • 12
  • 23
9
votes
2 answers

Reporting services: Get the PDF of a generated report

I've a reporting services server which has already some running reports, and I need now to generate them through a custom website(running asp.net MVC3). I need to retrieve this report as stream/byte to send it to the user. No "report viewer" or…
J4N
  • 19,480
  • 39
  • 187
  • 340
9
votes
3 answers

Using Fields in Multiple Datasets in SSRS

I understand Crystal Reports has fallen out of favor with some in the development community and perhaps rightly so: I haven't used it in about 15 years. But when I did, I could make it sing. Perhaps that is why I find SSRS so disappointing. The…
Hello World
  • 93
  • 1
  • 1
  • 4
8
votes
2 answers

SSRS Performance Mystery

I have a stored procedure that returns about 50000 records in 10sec using at most 2 cores in SSMS. The SSRS report using the stored procedure was taking 20min and would max out the processor on an 8 core server for the entire time. The report was…
user101654
  • 223
  • 1
  • 4
  • 11
8
votes
3 answers

SSRS Detail members can only contain static inner members

I am developing an RDL in SSRS 2008 and am trying to move a subreport table directly into a main report so that I instead run this subreport in the same stored proc as my main report. However, I'm having trouble hooking this up. I got the stored…
salvationishere
  • 3,461
  • 29
  • 104
  • 143
8
votes
2 answers

Calculate percentage of total columns based on total column in SSRS Matrix

Looking to add a column in my SSRS Matrix which will give me the percentage from the total column in that row. I'm using the following expression, but keep getting 100% for my percentages (I'm assuming this is because the total is evaluated last, so…
Tom
  • 2,180
  • 7
  • 30
  • 48
8
votes
1 answer

RS2008 Background Image Sizing

So I'm attempting to create a report that is able to pre-fill a "government form" with Reporting Services 2008. Now this all falls down to the 96 DPI issue everyone seems to be having. Let's say I have a 300 DPI high res JPG file that I want to use…
James
  • 2,284
  • 1
  • 20
  • 29
8
votes
1 answer

SSRS Check Filtered Group RowCount

I would like to check the RowCount of a filtered group from without the scope of the group. I particularly would like to know when the group is empty so that I can set the Hidden property on another row in the table that is not in the…
Frank Pearson
  • 872
  • 5
  • 16
8
votes
6 answers

format number in ssrs report

argh! Can't stand it that i can't figure it out myself.... i've used this in the formatting of a number in my report: '€' #,0.00;('€' #,0.00) and that formats to € 1,212.89 which is not exactly what i want, because i want € 1.212,89 regardless of…
Michel
  • 23,085
  • 46
  • 152
  • 242
8
votes
2 answers

Get 2nd Value in Dataset in Reporting Services

This seems to be a very simple question, but I am trying to get the 2nd value in a dataset to display as a matrix's header value. In this report, lets say that I have 2 datasets. In Dataset1, I have a query that pulls down 3 values for a…
Nathan
  • 1,435
  • 5
  • 18
  • 28
8
votes
1 answer

How to remove Report Server Web Service URLs from Reporting Service Configuration Manager

To start with, I am completely new to SSRS reporting. Please excuse me if I miss any basic details here. I am trying to create a reporting service. Accidently, I have selected an existing Report Server Web Service Site Identification. Now I have 2…
Mahatma Aladdin
  • 2,027
  • 3
  • 17
  • 31
8
votes
4 answers

SSRS Procedure or function “” expects parameter '', which was not supplied

I have an SSRS report to which I am passing a Start Date and End Date parameter but I keep receiving the following error: Procedure or function 'MyReport' expects parameter '@startDate', which was not supplied. I have created a parameter in my…
ExceptionLimeCat
  • 6,191
  • 6
  • 44
  • 77
8
votes
1 answer

SSRS Calculating counts across row and column groups

I'm building a report of case results with a parent-child grouping on the row group and single column grouping: Parent Row Group: Location Child Row Group: Result Column Group: Month Running across the report are months in the year, and running…
RyanW
  • 5,338
  • 4
  • 46
  • 58
8
votes
3 answers

SSRS code variable resetting on new page

In SSRS 2008 I am trying to maintain a SUM of SUMs on a group using custom Code. The reason is that I have a table of data, grouped and returning SUMs of the data. I have a filter on the group to remove lines where group sums are zero. Everything…
Peter Tirrell
  • 2,962
  • 4
  • 29
  • 52
8
votes
4 answers

SSRS 2008 Datediff for Working Days

I have seen this question asked a lot and I cannot seem to find one clear answer about "how to calculate business days only between two dates?" The expression below will give me the total days but I am looking to exclude Saturday and…
Lance
  • 125
  • 1
  • 3
  • 7
1 2 3
…
99 100