Stack Overflow
Stack Overflow

Questions tagged [reportingservices-2005]

SSRS (SQL Server Reporting Services) is a server-based report generation software system from Microsoft. This version was released as part of SQL Server 2005.

SSRS (SQL Server Reporting Services) is a server-based report generation software system from Microsoft. This version was released as part of SQL Server 2005. More info in the tag.

918 questions
109
votes
21 answers

The permissions granted to user ' are insufficient for performing this operation. (rsAccessDenied)"}

I created a report model using SSRS (2005) and published to the local server. But when I tried to run the report for the model I published using report builder I get the following error. Report execution error:The permissions granted to user are…
jbcedge
  • 18,965
  • 28
  • 68
  • 89
85
votes
17 answers

Fast query runs slow in SSRS

I have an SSRS report that calls out to a stored procedure. If I run the stored procedure directly from a query window, it will return in under 2 seconds. However, the same query run from an 2005 SSRS report takes up to 5 minutes to complete. …
user275554
  • 2,211
  • 2
  • 14
  • 6
54
votes
6 answers

Tracking report usage

Is there an easy way to track who is running a given report in SSRS 2005, and at what time they are running that report? We have about 80 reports in our SSRS implementation, and are trying to see if there's any that we can safely put out to…
Chris Valdivia
48
votes
2 answers

Set a table's visibility to false when it has no rows (in reporting services)

Is there a way to set a table's visibility to false, if the table has no rows? I want to hide a table in Reporting Services when it has no rows. Setting NoRows to ="" isn't sufficient in this case as space is still left for the table, and some of…
Sophia
  • 5,643
  • 9
  • 38
  • 43
35
votes
8 answers

How do I best display CheckBoxes in SQL Server Reporting Services?

One of the many quirks of Reporting Services we've run across is the complete and utter lack of a CheckBox control or even something remotely similar. We have a form that should appear automatically filled out based on information pulled from a…
Sean Hanley
  • 5,677
  • 7
  • 42
  • 53
35
votes
2 answers

SSRS - Checking whether the data is null

I've the following expression in my report. =FormatNumber(MAX(Fields!Reading.Value, "CellReading_Reading"),3) Now when the dataset is empty 'Fields!Reading.Value' becomes empty and finding their maximum is invalid. How can i check if the entire…
NLV
  • 21,141
  • 40
  • 118
  • 183
35
votes
3 answers

Can't see "Report Data Pane" when creating reports

I cant see "Report Data Pane" when creating reports. I've already tried the shortcurt Ctrl+Shift+D, and looked for Report Data in the "View" menu. I am using Microsoft Visual Studio 2005 and I have my report open. All I see is data sets. I already…
user1532113
  • 385
  • 1
  • 4
  • 7
33
votes
10 answers

How to get named excel sheets while exporting from SSRS

Whenever a single page report is exported to excel, sheet in excel is named by the report name. If a report has multiple pages, the sheets are named as sheet1, sheet2,.... Is there any way to specify sheet names in SSRS 2005 ? solution: Found this…
rao
  • 1,024
  • 2
  • 11
  • 17
29
votes
10 answers

Why is my SSRS report showing old data?

I have a live report that's somehow showing cached data despite the fact that I've disabled all caching (that I'm aware of). When I run the query in the BIDS query editor, it shows the current data. But in the BIDS preview and the actual deployed…
Kon
  • 375
  • 2
  • 4
  • 7
24
votes
3 answers

How to filter rows with null values in any of its columns in SSRS

I want to filter out the output without rows containing null values or blank columns. I am using SQL Server 2012 there is no option named 'Blank' as in SS2005 where I can filter the rows. I also tried following expression but it gives me error or…
Rajaram Shelar
  • 7,537
  • 24
  • 66
  • 107
22
votes
3 answers

How do I display 'No data available.' when there are no rows to show on the report?

I am building an SSRS 2005 report using BIDS. My report filters on date. When the selected date returns no data rows the report is blank, just the title is displayed, no table or column heading. How can I change this to display a message like No…
Tony Borf
  • 4,579
  • 8
  • 43
  • 51
21
votes
9 answers

SSRS giving a blank page at the end of report

I am getting a blank page, at the end of my report in SSRS 2005. I have a header logo and footer date values, and I have set the both to PrintOnLastPage = False, but I am still getting a blank last page. Any ideas how to eliminate it? Thanks!
Frank
  • 2,015
  • 10
  • 36
  • 57
20
votes
2 answers

Detecting NULL dates and showing empty string in SSRS

I'm trying to format some cells in a Reporting Services report that will contain DateTime? values - or not. If the underlying data has a NULL for that DateTime?, I'd like to show nothing (empty cell) - and if that data source contains a value, I'd…
marc_s
  • 732,580
  • 175
  • 1,330
  • 1,459
20
votes
3 answers

Does the iif function compute both paths in SSRS or is it short-circuited?

I am trying to evaluate a Price per Kilo ($/Kg) based on sales of a product. This works fine if the product was acutally sold during the period specified. However if the product is not sold the Kg (the denominator) ends up being 0 (zero) and an…
Nathan Fisher
  • 7,961
  • 3
  • 47
  • 68
19
votes
1 answer

Two chart types (bar and line) in same SSRS chart

How can SSRS 2005 represent two chart types (i.e., bar and line) on the same chart? I am trying to create a graph that looks like the professionally crafted image below: The chart would have one series represented as bar graphs and then two other…
Devin Burke
  • 13,642
  • 12
  • 55
  • 82
1
2 3
…
61 62