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

Using SSRS report to pass multiple string parameter with single quotes

I am failing to pass parameter value to data set using , =split(Parameters!Status.Value,",") Parameter (@status)defult values -> C,P Returns Error: The value expression for the quer parameter '@status' contins ans error: Conversion from type…
Sam Bin Ham
  • 429
  • 7
  • 23
0
votes
1 answer

Calculation for Percentage of total (per row) giving #Error

I am using SSRS 2008r2. I need to add a column for the percentage of total which seems straightforward however I have been struggling with this for a week and have read numerous posts on percentage problems and have not found anything that…
Caroline Allen
  • 183
  • 14
0
votes
0 answers

In SSRS 2008 matrix, header freeze is not working when deployed

I have added a matrix in SSRS report and I want to freeze its headers. Listed below are the methods I tried, these methods are the popular solutions listed in internet for similar type of issues, but both of them are not working. Method 1:- in…
NiveaGM
  • 249
  • 2
  • 11
0
votes
0 answers

Font and color changing to default after exporting report to Excel from SSRS

I have a report which is rendering fine in my local VS and Reports Server but, when I export the report to EXCEL and opened it, the font of certain areas of the report are changing back to the default. The report is supposed to look like: But it…
pramod
  • 21
  • 4
0
votes
1 answer

SSRS Hyperlink to tab on the same spreadsheet

I have two set of data on 2 tabs of the same report in SSRS Employee Name, Employee Number, Department ID Employee Number, Department ID, Department Details I am trying to create a hyperlink on Department ID of tab 1 to link to Department ID of…
sql_dev1802
  • 35
  • 4
0
votes
1 answer

SSRS Report won't compile if 20+ values selected in multi-valule parameter

I am working on an SQL report that uses a multi-value parameter that contains a total of 41 users. The report works fine if I select 1 or up to 19 total users, but breaks if 20 or more are selected from the list. By break I mean it attempts to…
GKRobb
  • 37
  • 6
0
votes
1 answer

How to disable Autocomplete option in SSRS report Parameters?

enter image description hereHow to disable Autocomplete option in SSRS report Parameters ?For Example we can disable autocomplete option in telerik textbox by setting the property AutoCompleteType="Disabled"
Charanjot Singh
  • 1
  • 2
0
votes
1 answer

Series colours are different to legend colours in chart

I'm building an incident report with the below query: SELECT Incident_Logged ,Location_Name ,Incident_Type ,Body_Part_Name FROM Incident INNER JOIN Location ON Location_ID = Incident_Location_ID INNER JOIN Body_Part ON Body_Part_ID…
Aaron Mason
  • 310
  • 3
  • 11
0
votes
2 answers

Printing SSRS report to label printer x times

I am sorry if this is a duplicate question and please point me to the answer if it is. Here is my situation: I have an ASP.NET web forms site that uses SQL server database as its data source. The end user wants to print labels to a Zebra label…
mbcharney
  • 355
  • 1
  • 4
  • 15
0
votes
0 answers

SSRS Expression to Subtract Field Summation

I've got an expression that displays the summation of the values from my field: total ="Harvest Total: " & CStr(Format(Sum(Fields!total.Value),"#,##0")) But I want to subtract from this total the total summation for a specific value in another…
MISNole
  • 992
  • 1
  • 22
  • 48
0
votes
0 answers

Report Builder shows data, but Report Services doesn't

I have created a report in Report Builder 3.0 that has 3 parameters (var1, var2, and var3). The report uses dynamic sql that uses a cursor to select values from multiple locations. There are 3 datasets, "DataSet1", "DataSet2", and "DataSet3". The…
DiggityCS
  • 111
  • 7
0
votes
1 answer

SSRS - data source issue

I'm looking at some issues with a migration of a huge amount of rdl's, the guy that has done this has shifted them and they work, so that's good. But... if I download one of them the datasource is still the original datasource not the one he…
bloom
  • 1
  • 1
0
votes
0 answers

I need to add variable value in custom code of SSRS

Public Function SetVariableValue(val as Microsoft.ReportingServices.ReportProcessing.OnDemandReportObjectModel.Variable, newval As Integer) as Integer val.Value = val.Value + newval Return Val.Value End Function
s.keerthi vidhyasagar
  • 11
  • 1
  • 5
0
votes
0 answers

Use SSRS Expression to Open New Window / Tab from URL

I've looked at a couple of websites that explain how this works including: SQL Chick Brian Knight But so far, I am not able to get the formatting correct to open the link in a new window. Here is my expression that works, but doesn't open a new…
MISNole
  • 992
  • 1
  • 22
  • 48
0
votes
0 answers

hot to fix line graph broken image in ssrs line chart while rendering?

In SSRS dashboard line graph is not loading after 70 + line graphs(applying group by for line graph). it it showing broken image? how to fix this issue?
Udaya Kumar V
  • 1
  • 1
1 2 3
…
99 100