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
0
votes
1 answer

Changing Background Color on Weekends

I have a report that I need to change the background color (ex. gray) if the Day falls on the weekend (highlighted) in yellow. Have the code below that I have placed in row fill, but did not work. The yellow is manually…
Arsee
  • 651
  • 2
  • 11
  • 36
0
votes
0 answers

SSRS - XML query issue

I'm modifying an SSRS report that uses XML datasource. The XML document look like this: In the SSRS report, the datasource is set to an embedded datasource: The report has a dataset to read data from xml file using XML query:
SJaka
  • 712
  • 13
  • 40
0
votes
1 answer

Trying to get 0 as minimum value vertical axis in chart of SSRS

I am working on a SSRS report which requires a chart to show vertical axis in 'M' or 'K' like 0, 2M, 4M. I got a custom formatting formula which adds an 'M' or 'K' with numbers - =Switch(Fields!TotalSpendCurrent.Value < 1000, "0.#",…
AmiV
  • 1
  • 2
0
votes
0 answers

SSRS - Using multiple datasets in calculated expression giving unexpected results

I have a report that has two datasets. One contains detail with a total amount. The second is a dataset that contains data for breaking down totals by description. The expression I am having difficulty with is one the second tablex for dataset2.…
PadreBob
  • 1
  • 2
0
votes
2 answers

SSRS Web page(Hope Page) is Blank

I have installed SSRS 2014 and Configured. When I open the web link from Report Server Configuration Manager I get below message, I can't see any home page. I am not sure what is missing.
user2331670
  • 335
  • 2
  • 6
  • 15
0
votes
1 answer

SSRS 2 column groups in matrix, 1 row reads from 1, the rest read from the other? (pls help)

Is there a way in SSRS to have an additional row within your row group, to look at a different column group than the rest of the row group Let's say I have STATES, SALES, MONTH, and BUCKET_MONTH as my dataset fields BUCKET_MONTH is already…
Jay
  • 455
  • 3
  • 17
  • 34
0
votes
1 answer

How to display empty chart instead of "no data available" in ssrs 2008

I inserted a pie chart in my SSRS 2008 report. When there is no data coming from sql, it basically shows "no data available", but what I would like it to display is an empty chart instead. I could not find a way to provide this. Any help would be…
BalkDal123
  • 13
  • 9
0
votes
1 answer

SSRS - Why the sub-report is printed multiple times?

I'm new to SSRS and know little about groupings in SSRS. I've an order confirmation report. The report has two groups (orderHead and orderLines). I've added a table row at the bottom of the report to contain a sub-report (that must run for some…
SJaka
  • 712
  • 13
  • 40
0
votes
1 answer

SSRS - How to hide parent report's header in a subreport?

I've to create a report that must be printed along with an existing report. Since the dataset is largely the same, I've created this new report as a sub-report to the existing report, and have added a before page break. So now both the existing…
SJaka
  • 712
  • 13
  • 40
0
votes
3 answers

SSRS IIF expression

In my SSRS report I want PolDiscountPerc textbox from my query to make blank when PolStockCode in a row is empty or empty string, however if PolStockCode contains a value then format PolDiscountPerc textbox to display it as a…
user1800674
  • 223
  • 1
  • 7
  • 18
0
votes
1 answer

How to sum of each column in ssrs

I am new to ssrs, I have a table that has record of student admissions, in report i have a matrix with row group on "school_branch" and column group on "classes", each class of each branch has specific number of class_section and students. My…
Usf Noor
  • 219
  • 1
  • 5
  • 21
0
votes
1 answer

Hide subreport on ssrs preview(even dont want to show white blank tab).But show while exporting to excel

I want to hide sub report on SSRS preview(even don't want to show white blank tab).But while exporting it should show sub-report too Thank You!!!
anonymous
  • 55
  • 1
  • 9
0
votes
2 answers

Something like Data Driven Subscriptions SSRS Standard Edition 2008

I'm fairly new to MSSQL and SSRS. I'm trying to create a data driven subscription in MSSQL 2008 Standard SSRS that does the following: I need to send out/email which includes report to my users just in case the report has data in it. This would use…
Marianna
  • 1
  • 1
0
votes
2 answers

How to get the previous value of a row in SSRS

My SSRS report has two groups (Account, Month). Account is Parent and Month is child group. Now I want to show the ending balance of each Month as the Beginning balance of next month. A sample report is given bellow. Red font indicates the SUM of…
Rashedul Alam
  • 156
  • 1
  • 14
0
votes
1 answer

Reporting Service (SSRS) : Report Footer is not working when exported to excel

I am using reporting service 2008 for create report and I found the problem about export excel. The problem is as follows : Report Footer is not working when exported to excel. How I can render footer when export to excel. When I print an excel.…
Dev Ch.
  • 1
1 2 3
…
99 100