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

How do I change the width of parameter drop down box in SSRS?

Is there a way to control the size of the parameter drop down box? In my current drop down box, the width increase according to the option with label of the longest length, in which causes my report's width to increase out of my control. Thanks in…
Lakhae
  • 1,809
  • 5
  • 25
  • 40
14
votes
4 answers

Generate report from URL - SQL Server Reporting Services 2008

I have SQL Server Reporting Services 2008 and when I open the following URL: "http://localhost/Reports/Pages/Report.aspx?someReport" I'm getting report screen in which I fill my parameters and generate a report, My question is how can I do this…
Dor Cohen
  • 16,769
  • 23
  • 93
  • 161
14
votes
8 answers

How to copy a report in SQL Server Reporting Services 2008

I have a report that I created in SQL Server Reporting Services 2008. I now want to create a new report, that is very similar that the one I already created. How do I do that without writing the report from scratch? Can I just copy the .rdl to a new…
Amarundo
  • 2,357
  • 15
  • 50
  • 68
13
votes
3 answers

Text over image displaced when publsihed

I have a banner image on a report with three labels, some with params in them, on top of it. It all looks fine in design mode but when I save and view it the text is then displaced above and below the image. How do I stop it doing this? Thanks.
Pete North
  • 150
  • 1
  • 1
  • 8
13
votes
2 answers

How to configure/Enable the form based authentication in SSRS 2008 RS

I have two reports , one is for internal users and another one is for external users, For internal Users i need to enable form authentication to view the report instead of creating the user accounts in the server. For external User i do not want to…
karhtik
  • 506
  • 3
  • 15
13
votes
5 answers

How to change the SSRS input parameters position in report

My SSRS report contains 7 input parameters and while running my report the size of the parameter(i.e. length) is increasing. One of my input parameter(drop down list) may contain 100 characters so the size is not constant but i want to place all…
VInayK
  • 1,501
  • 6
  • 34
  • 47
13
votes
1 answer

Conditional Action in SSRS

I want my textbox to have an action ONLY if the condition is true, otherwise no action. This is what I have as my current action expression for going to another report: =IIf(Fields!MyTextbox.Value = "0", "Report2","") This does not produce my…
Jesse
  • 2,043
  • 9
  • 28
  • 45
13
votes
4 answers

Entire Table is pushed to the next page when rendering a SSRS 2005 Report (as .pdf) in SSRS 2008

I have a SSRS 2005 report that I'm rendering in SSRS 2008 as a .pdf. The report contains (among other things) a table that's very simple: header row, details, no footer, no aggregation, no grouping, keep together = false, pageBreakAtStart = false,…
Mark Carpenter
  • 17,445
  • 22
  • 96
  • 149
13
votes
4 answers

SSRS how to add in New line

I am creating a string from stored procedure like this Name1 , Name2 , Name 3.... etc(This string is in one column). I want to display these name in a new line in my SSRS report like Name1 Name2 Name3 I tried changing the string to Name1 VbCrlf…
Thinna
  • 267
  • 2
  • 3
  • 10
13
votes
2 answers

SSRS Grey out Parameter based on result from other Parameter

I wondered if it was possible to grey out a parameter based on the the result from another parameter? In this case, if specify date is set to 'No' then Start Date and End Date should be greyed out. As you can see from the screenshot this hasn't…
Zakerias
  • 356
  • 2
  • 3
  • 18
13
votes
1 answer

Changes to parameter not showing on Report Server after deployment

I have 7 parameters (3 multi select of string, 1 DateTime, 3 string values) in my SSRS 2008 report, and I have set all the parameters as null in the default value. It's working fine in my preview window of Visual Studio 2008. But after deployment…
MAC
  • 6,277
  • 19
  • 66
  • 111
13
votes
6 answers

How to pass multiple values to single parameter in stored procedure

I'm using SSRS for reporting and executing a stored procedure to generate the data for my reports DECLARE @return_value int EXEC @return_value = [dbo].[MYREPORT] @ComparePeriod = 'Daily', @OverrideCompareDate = NULL, …
Neo
  • 15,491
  • 59
  • 215
  • 405
13
votes
5 answers

divide by zero/null workaround in SSRS 2008 report

I have a report with a field whose value was the expression: Fields!TotalPrice.Value/Fields!TotalSlots.Value Although sometimes TotalSlots was blank and thus I was getting a divide by zero runtime error. So I changed the expression to…
jsmith
  • 565
  • 3
  • 14
  • 28
12
votes
3 answers

SSRS - Expression using different dataset fields

I have a report with multiple data-sets. Different fields from different data-sets are used in different locations of the report. In one part of the report, I need to do a calculation using fields from two different data-sets. Is this possible…
Zolt
  • 2,761
  • 8
  • 43
  • 60
12
votes
1 answer

Pivot a table in reporting services?

Is it possible to pivote a table in reporting services 2008? If so, how? I'd like to pivote it 90 degrees. Thanks
Johan
  • 753
  • 2
  • 11
  • 31
1 2 3
…
99 100