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

enable caching for all SSRS reports in batch and not one by one

I have more than 40 SSRS reports that i want to add the caching option to it. The problem is that currently, i enable this option on each report, one by one. is there a way that i can build a batch of reports that i can enable the caching on…
Eddie Rozenblat
  • 832
  • 3
  • 11
  • 21
1
vote
1 answer

Using constants in SSRS's Error Bar Chart

I have a SSRS 2008 report with a Error Bar chart. It plots dates (x-axis) versus score (y-axis), with +10/-10 for the upper/lower error range. But in the dataset, I also have two sets averages (the US and the company's). I would like to display…
spong
  • 1,222
  • 3
  • 16
  • 29
1
vote
1 answer

how to create duplicate report on a same server

My manager asked me to update the .rdl file from prod to dev. But before doing that I have to keep that old report as it is and have to create a duplicate report on same server and that too be I am working on browser. I have downloaded the the .rdl…
Shahsra
  • 981
  • 6
  • 18
  • 30
1
vote
1 answer

Execute Stored Procedure Code using a button in SSRS

I've created a report which shows all active Subscriptions on our Report Server and have currently got a table showing all the reports by name and I've also included 3 columns, one which shows you the code to Enable the subscription, one which shows…
Alex
  • 21
  • 4
1
vote
1 answer

Report Builder 2.0 Sort by Value Column

I have a drill down table and I can sort by the Group columns, but sort by the Value column (Quantity) doesn't work. I'm right-clicking the header, selecting textbox properties, selecting interactive sorting, selecting Detail Rows, Selecting Sort…
Dave
  • 4,949
  • 6
  • 50
  • 73
1
vote
1 answer

ReportSize in Excel not the same as in PDF

I have done already a lot of small (and also bigger reports) with report viewer 2010. In most cases I give the user the possibility to select the destination-format (PDF, Excel and sometimes also word). However I always encouter the problem that the…
HCL
  • 36,053
  • 27
  • 163
  • 213
1
vote
0 answers

An ssrs problem:how to display separation line below the row with condition

I have created a report in ssrs 2008. In this report we are displaying the records of current product and their match records of each product description. Each current product has one match records or more than one match. There is a requirement of…
Vikram SE
  • 307
  • 2
  • 7
  • 23
1
vote
0 answers

is it possible to get multiple subrows for one row and 2 columns SSRS?

I would need to do a report looking like this : For any given "person" there is a single firstname, last name and age, but I can have as many surnames as the user sees fit. Each surname has a corresponding "apparition surname order". The column…
Amon
  • 296
  • 1
  • 14
1
vote
1 answer

SSRS Call external URL/web service

We're designing report with multilingual interface. We have developed web service which return translation of specific words. Is there any way to call the translation of labels used in report through web service or specific URL. For e.g. something…
kodvavi
  • 111
  • 2
1
vote
2 answers

Desktop Application SSRS Report Rendering Out Of Memory Exception on single user PC

We have a .NET desktop Application Running One of my user is facing OutOfMemory Exception while SSRS Report Rendering Though, I am able to run SSRS through Browser Report Link. All other users are working fine User PC Configuration i5 10th Gen 8 GB…
Parshuram Kalvikatte
  • 1,616
  • 4
  • 20
  • 40
1
vote
2 answers

How do I set expression for a parmater in sql server reporting services?

Hi All, How do i set expression for a parameter in sql server reporting services r2? Is it even possible? The expression button is not even there. Thanks.
Aharon Muallem
  • 1,143
  • 3
  • 13
  • 20
1
vote
1 answer

Set the reference from a report to its Data Source using SOAP?

I am writing a script for RS.EXE tool to deploy reports onto a server running Microsoft SQL Reporting Services 2008 R2. Using the Mgmt2010 SOAP endpoint, I am able to upload the reports (rdl files) just fine, but they need a bit of additional…
mac01021
  • 745
  • 4
  • 13
1
vote
1 answer

group by month and week in SSRS graph

I have a got a line graph report in SSRS 2008 R2. when I do the grouping in graph I first group by year, then month, then week and I get Sum(Count) as data value.(see below) Count Date Week Month Year 10 datex 26 6 2010 15 …
AnarchistGeek
  • 3,049
  • 6
  • 32
  • 47
1
vote
1 answer

How to report on the last day of each month SSRS

What is the best way to run the report every month on the last day in report service web portal? It seems pretty straightforward but I could not seem to find a direct way to do this.
nilsinelabore
  • 4,143
  • 17
  • 65
  • 122
1
vote
5 answers

Reporting services cascading parameter not working

I want the report to pick default date time values based on a location parameter the user picks, but the problem is that the date time parameters don't update when the user picks a different location. I made sure to put the location parameter above…
camelCaseWarrior
  • 369
  • 2
  • 8
  • 19
1 2 3
…
99 100