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

Binding C# Entity Framework dataset to SSRS (.rdlc) from inside ASP.NET MVC 5

//My Controller. public ActionResult ExpectedSales(string[] Quarter, int Year, string[] Divisions) { try { int myQtr = GFIHelper.GetQuarterNumber(Quarter); …
Scavenger
  • 47
  • 2
  • 9
0
votes
2 answers

SSRS show parameter values in header

I am trying to add an expression in header section, which would display parameter value chosen by users (if everything selected, display "ALL" instead). I am having trouble with "Property" parameter. Report structure: Report is a matrix report that…
NonProgrammer
  • 1,337
  • 2
  • 23
  • 53
0
votes
0 answers

SSRS ReportViewer control report parameters Visible and PromptUser properties always true

I have some VB.net code that retrieves all the report parameters for an SSRS report. According to the MSDN documentation the Visible and PromptUser properties should correlate to whether the report displays a prompt for that parameter (rather then…
nuander
  • 1,319
  • 1
  • 19
  • 33
0
votes
0 answers

SSRS External image expression

We are using External image source for dynamic client logo. Using =Code.Portal.GetClientLogo(Lookup(Parameters!P_CLIENT_KEY.Value, Fields!Client_Key.Value, Fields!Client_Name.Value, "Clients")) expression for client logo. I don't seem to find…
XYZ
  • 41
  • 7
0
votes
1 answer

SSRS Stepped reported based on number

Using SSRS with SQL Server 2008 R2 (Visual Studio environment). I am trying to produce a stepped down report based on a level/value in a table on sql server. The level act as a indent position with sort_value been the recursive parent in the report.…
danwright
  • 93
  • 2
  • 5
0
votes
1 answer

Format Tablix with Row Grouping in SSRS

I am trying to format a dataset in SSRS for readability and to meet design specifications. My dataset is returning expected values and I have created appropriate Row Groups, or at least I believe I have, for the report and when I preview the report…
MISNole
  • 992
  • 1
  • 22
  • 48
0
votes
4 answers

SSRS - How to pull previous Friday with SSRS expression

I'm needing help to pull the previous business days and excluding the weekends in SSRS. I use the following code, however this code doesn't look past the weekends. Here's the code I normally use: =DateAdd(DateInterval.Day ,…
BIReportGuy
  • 799
  • 3
  • 13
  • 36
0
votes
1 answer

CRM 2011 - Reports not updating

I made a change to a report today that displays some financial data - it was being displayed incorrectly so I made a change to ensure it displays the correct data. In Visual Studio the data is now correct when I run the ssrs report but when I import…
MarkB
  • 47
  • 6
0
votes
2 answers

Expression to colour font

I've used the following expression to change the colour of my font, its working to an extent apart from values that are zero, which are remaining black. =Switch( Fields!Colour.Value="Orange","#ff8812" ,Fields!Colour.Value="Blue","Blue" , …
whitz11
  • 229
  • 2
  • 23
0
votes
1 answer

Depending Parameters in a text box (SSRS 2008-R2)

I am working on a SSRS Report and I have two Parameters in the Prompt section, EmployeeID and EmployeeName respectively. EmployeeName prompt depends on the EmployeeID prompt selected, can the EmployeeName be populated in a textbox once EmployeeID…
Vaibhav Sinha
  • 67
  • 1
  • 2
  • 10
0
votes
1 answer

Export dataset to Excel or CSV in SSRS

I created a report via SSRS and my tablix contains values/fields from a data set and holds other sub reports. When I export as Excel/CSV ,I am getting all this in One Excel sheet. I JUST need to export all the values from dataset (even if i'm not…
user4872443
0
votes
1 answer

Show percentage values in stacked bar in order

How can I sort the series in descending order in each category group and show them up in a single bar for each group? This is how the project and report looks like: Thank you
Stackoverflowuser
  • 203
  • 3
  • 12
0
votes
0 answers

Filter on a Total Field

Edit As suggested to me below, I wasn't filtering the visibility on the rows. Having done this using the below line, I realize its not quite working properly =IIF(Fields!Number.value = 0, True,False) 2014 2015 2016 Total Employee A…
whitz11
  • 229
  • 2
  • 23
0
votes
1 answer

Combo chart line and bar in SSRS 2008 R2 chart

I have a chart which has 3 series- 2 of them needs to be a bar chart and 1 should be a line chart. I tried the various solutions mentioned online to change the chart type of only the series that needs to be changed. Whenever I do that, all series…
user728148
  • 159
  • 1
  • 6
  • 19
0
votes
1 answer

SSRS reports gap in the end of group

I am building SSRS report for invoices using SSRS 2008 R2 each invoice has list of items I have built the report successfully but there was a little problem that we need to display page number of the invoice (i.e Page 1 of 3) the page number is…
asmgx
  • 7,328
  • 15
  • 82
  • 143
1 2 3
…
99 100