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

Reporting Services Parameter Constraint

I have a reporting services (SQL 2008) report with two Date/Time parameters - begindate and enddate. I need to constrain enddate to the same month and year as begindate. This seems like it should be an easy thing to do, but I cannot figure it out.…
jhale
  • 1,790
  • 3
  • 14
  • 21
9
votes
2 answers

Summing a column of expressions in SSRS

The detail row in my table contains a column with an expression: =sum(Fields!one.Value) / sum(Fields!two.Value) I want to sum that column, but the results I get are not the sum of the ratios, but the ratio of the sums. For example: …
Garius
  • 99
  • 1
  • 1
  • 3
9
votes
1 answer

Making text bold in SSRS depending on field's value

I want to make some text bold and underlined, if the the value of field in my database is, say "HD" I mean, I have two fileds in the database. Text1 and Header. I display the Text1 in my report and if Header's value is "HD", then Text1 should be in…
Furqan Sehgal
  • 4,917
  • 33
  • 108
  • 167
9
votes
2 answers

Reporting Services 2008: "HTTP status 401: Unauthorized" Issue

I'm getting the error "The request failed with HTTP status 401: Unauthorized" whenever I try to list the reports on my reporting server. The weird thing is, it works when I run the asp.net application on my dev machine hitting the server reporting…
jmm312
  • 618
  • 1
  • 6
  • 17
9
votes
3 answers

SSRS 2008 - The permissions granted to user 'computer\username' are insufficient for performing this operation. (rsAccessDenied)

I've looked through several other questions here and on other sites regarding this issue, and none of them have solved the problem I'm running into. Hopefully I'm just overlooking something simple. The scenario that I'm running into involves a new…
Shane
  • 305
  • 1
  • 2
  • 11
9
votes
1 answer

How to prevent autoresizing body in SSRS report

I have a report that has a header and footer that are both set up to fill the whole A4 length (minus margins of course) because I have some information on the far right and far left of each of them. Now in the body I have a List Element that allows…
nojetlag
  • 753
  • 2
  • 14
  • 27
9
votes
7 answers

Hiding menu in SRSS

I have created a few reports which like users to be able to access via url mainly. I want to hide the menu options in these URLs'. Not sure how to do this this. This link: remove-top-links-from-report-server would require one to modify the actual…
Arantuath
  • 243
  • 2
  • 5
  • 14
9
votes
1 answer

how to show entire report in single page using Report Builder?

I am using MS Report builder 3.0 to create one of my report.The report is the tabular report and sometimes the size of table grows long about 2 to 3 pages. But i want to show the entire report with in single page without having to click next page…
Ujjwal
  • 209
  • 2
  • 4
  • 10
9
votes
1 answer

Auto Row Number in SSRS Table with Grouped Rows

I am working with SSRS 2008. In one of my report I have a table with 3 columns. Sr. No, Column 1, Column2. Sr. No is -RowNumber("DataSet") and other are two are data set columns. I have grouped (Row Group) my table on Column 1 and Column 2. This is…
V.B
  • 1,191
  • 7
  • 29
  • 55
9
votes
3 answers

SSRS - Process dies/goes to sleep after not being used

Another SSRS question here: We have a development, a QA, a Prod-Backup and a Production SSRS set of servers. On our production and prod-backup, SSRS will go to sleep if not used for a period of time. This does not occur on our development or…
Roy Rico
  • 3,683
  • 6
  • 35
  • 36
9
votes
1 answer

Conditional Page breaks at group level in SSRS2008 R2 reports

I have a report in SSRS 2008 R2. This report consists of one table containing several grouping levels. If the customer requests to see all the detail them I want a page break at the second grouping level of the table. If only the summary details…
Roger Scoffield
  • 91
  • 1
  • 1
  • 2
9
votes
6 answers

SSRS 2008: User Does Not Have Required Permissions

I have already researched the following existing SO questions and the links that they reference: User '' does not have required permissions, SSRS 2008 on Windows 8 Reporting Services permissions on SQL Server R2 SSRS SQL Server Reporting Service -…
AJH
  • 365
  • 1
  • 4
  • 18
9
votes
1 answer

SSRS 2008 Fixing the Row Header

In SQL Server Reporting Services 2008, I cannot always fix the Header row of a Tablix. Right-clicking the tablix and checking Repeat header rows on each page accomplishes nothing. Expanding the group panes to Advanced View and right-clicking…
JonathanWolfson
  • 861
  • 4
  • 20
  • 30
9
votes
2 answers

Display Seconds Count in HH:MM:SS format in SSRS 2008

I have a table with a column, TotalTime that is an Integer value in seconds. In Visual Studio / SSRS 2008 I want to display it in HH:MM:SS format. Thanks!
Amarundo
  • 2,357
  • 15
  • 50
  • 68
9
votes
2 answers

Border formatting of SSRS row group

This is my report. Above row contains a parent row group and a child row group. I have done border formatting of the report . I simply right click each Text box and gives border accordingly. But, I am not able to set border for entire Group. In…
muhammad kashif
  • 2,566
  • 3
  • 26
  • 49
1 2 3
…
99 100