Stack Overflow
Stack Overflow

Questions tagged [ssrs-2008-r2]

Microsoft SQL Server 2008 R2 Reporting Services provides a server-based platform designed to support a wide variety of reporting needs enabling organizations to deliver relevant information where needed.

Microsoft SQL Server 2008 R2 Reporting Services provides a complete, server-based platform designed to support a wide variety of reporting needs enabling organizations to deliver relevant information where needed across the entire enterprise.

This is a version of Reporting Services provided by SSRS

2305 questions
6
votes
1 answer

Merged or blank columns when exporting report to excel in ssrs 2008

I have a table in ssrs 2008 like: What my problem is, when I execute the report and export the output to the excel, I see that there is a mess for the excel columns, and somehow some of the columns are not used, they are blank. Please see the…
Eray Balkanli
  • 7,752
  • 11
  • 48
  • 82
6
votes
1 answer

SSRS Sorting the PIe Chart data value

I have a pie chart that has a calculate Result value in percentage (%). I need to sort the % value from highest to lowest. I found the CategoryGroups->Sort Expression from Chart Properties, but it is not allowing me to put a sort expression.
Arsee
  • 651
  • 2
  • 11
  • 36
6
votes
14 answers

SSRS Performance

I Have created an SSRS Report for retrieving 55000 records using a Stored Procedure. When executing from the Stored Proc it is taking just 3 seconds but when executing from SSRS report it is taking more than one minute. How can I solve this…
Sinshith
6
votes
1 answer

How to sort SSRS Matrix report by Grand total field

I created a matrix report. The report looks like this: I want to sort the output so the region with highest sales should come on top. e.g. From the above report South should show on top then West, Central and East. How can this be done in SSRS…
MSBI-Geek
  • 628
  • 10
  • 25
6
votes
4 answers

SSRS - weekday name

any advice appreciated I have as a column heading the expression =WeekdayName(weekday(fields!date.value)) This returns the day of the week, however, it is returning a day of the week one day in advance, eg when I put Monday's dates in the parameter…
Will F
  • 417
  • 2
  • 6
  • 17
6
votes
1 answer

How to freeze First Column in tabular Report?

I have a Table Report with 70 columns. My requirement is to freeze the First Column as I scroll horizontally. I have tried checking row headers in Tablix properties, but still it's not working. How can I freeze the first Column?
SqlLearner
  • 763
  • 8
  • 23
  • 37
6
votes
2 answers

Show message "NO DATA FOUND" in SSRS report

I have created SSRS report having 3 columns in it. Now, I have to show "NO DATA FOUND" message below report header. How can I achieve it. I cant not use report property "NO ROW" as I have to show Report Header also. Followings are the fields in my…
Prashant Khadatkar
  • 200
  • 1
  • 3
  • 18
6
votes
1 answer

SQL Server Reporting Services 2008 R2 - Folder and Report Security

Is there any way I can list (either using a SSRS report or querying through SQL code), the Username or Group security that has been assigned against root folders, sub-folders or reports ? I've been asked to identify as an audit, which AD groups have…
Learner74
  • 143
  • 1
  • 3
  • 9
6
votes
3 answers

How to pass credentials when accessing SSRS report through URL

I am trying to access a SSRS report using URL like below http://MyServerIP/ReportServer?/FolderName/ReportName&Param1=ParamValue&rs:Command=Render&rs:Format=HTML4.0&rc:Toolbar=false When I try to access above Url, I am asked for my network…
TechnicalSmile
  • 1,387
  • 5
  • 16
  • 30
5
votes
0 answers

SSRS Remove xml header from SOAP message

I have created an SSRS report that connects to a third party web service. I am trying to then flatten out that xml using the ElementPathNode. My xml is like this
DasDave
  • 801
  • 1
  • 9
  • 28
5
votes
1 answer

Need help in calculation using two Datasets using Expression SSRS

I am creating an SSRS report where In Dataset15, I have value Jan - 100 & Feb - 110 in Dataset16, I have value Jan - 80 & Feb - 100 Now I want to calculate same thing in a line chart using expression - Jan - 80/100 which should be 80% & Feb -…
Abhirup Dash
  • 75
  • 1
  • 2
  • 5
5
votes
2 answers

Export all reports in RDL format from SSRS Server Automatically

SSRS gives you the ability to export a report into the original RDL format: http://sql-articles.com/articles/general/download-export-rdl-files-from-report-server/ What I am wondering is if there is a way to export all reports (via a command-line…
Chris K.
  • 153
  • 2
  • 12
5
votes
1 answer

Does SSRS run multiple queries at once?

I'm trying to optimize a report that uses multiple stored procedures on the same table. Unfortunately, each procedure is reading millions of records and aggregating the results. It's a very intense read for a report, but each stored procedure is…
Fastidious
  • 1,249
  • 4
  • 25
  • 43
5
votes
3 answers

SSRS Conditional Formatting

I am working on SSRS Ranking report, where Rank 1 should have background of Green and last Rank should have background of Red. Example below: I tried using custom code but that's not working for me as below: SSRS Expression used as…
user2827587
  • 231
  • 4
  • 15
5
votes
3 answers

How to implement 'Not In' Filter in SSRS?

I have a field in SSRS that i need to filter on. For 3 table I can use a IN filter. But I am in need to use a NOT IN operator. The field contains numeric values. I need to be able to say not in (30,31,32,33,34,35,36,37,38,39) I cant do it within…
MJCookie
  • 135
  • 1
  • 3
  • 10
1 2
3
…
99 100