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

Summarized Production Report (Static Filters)

I have a report to be developed with specific static format: for each row I have to filter based on the requirements mentioned in the screen shot i.e. for Property I should generate Premium for Current Year and Previous Years for both Non KSA and…
0
votes
0 answers

Drop down parameter is not getting updated

I have a drop down with three options(report 1, report 2, report 3), and on selecting one of them nothing gets update as I try to view my report. SELECT ProjInfo.ProjName, ServerInfo.ServName, ServerInfo.Type, ServerInfo.Version FROM…
LooperBoy
  • 39
  • 4
0
votes
1 answer

Data in 2 Tablix to be summed in a 3rd

I'm trying to add two fields from two different tablix's in a 3rd tablix. The same dataset for all. I've tried using field referencing, custom code, variables, but I can't get anything to work. ...Fustrated... Tablix14, Group4, field name…
0
votes
2 answers

How to get total from another tablix column? (SSRS)

Hello awesome people of stackoverflow! I need help with a simple problem with my SSRS expression. How could I do this in SSRS? As you can on the 2nd table below in my excel screenshot. for each row we divide -BC5...-BC10 to column/row BC4. To get…
0
votes
1 answer

SSRS Printer pop up not showing in Internet Explorer 11

I cannot get SSRS base report print pop up in Internet Explorer 11. But it successfully worked with ie 8.. Server os is 2012, SQL version is 2008 R2, client Pc is windows 10.
0
votes
1 answer

SSRS - Font with spaces

I have a font with a space in its name, and it is not recognized when displaying the report with IE11 (which is the browser I have to work with). Strangely, it is recognized with IE8, but I can't use it... If I manually change (via F12) the CSS from…
Rafalon
  • 4,450
  • 2
  • 16
  • 30
0
votes
1 answer

Multiple reports generation in SSRS

I have a fairly long report with about 20 pages, mainly charts (about 40) all using a subsample of the same dataset. This "master" report is iterated about 200 times by passing a parameter with such 200 different values. I was wondering whether…
pcava
  • 103
  • 1
  • 8
0
votes
1 answer

SSRS currency not showing as CAD

Need to show the SSRS currency as CAD 200,000.00 but not able to achieve the same. Changed the text box properties to Custom and Format as "C". If the language is passed "en-US" or "en-CA" the format remains the same i.e. $200,000.00. Please Help!
0
votes
1 answer

SSRS - remove the 'loading' popup every time report refreshes

I would like to NOT show the 'loading' popup when the report refreshes because this is displayed on several monitors and it catches viewers' attention. Report is deployed to a SQL report server. Is there a way to achieve this?
0
votes
1 answer

Query is executing in sqldbx but not in SSRS ( Visual Studio 2010 )

My query is as follows : SELECT LBrCode, PrdAcctId, EffFromDate, ACTUALDATE, ACTUALDATENEW, IdealBalDate, IdealBal, SancDate, TotSancLimit, ExpDate, NoOfInstl, InstlstartDt, InstlAmt, DpDate, TotalDpArrived, TotalDpAllowed, NEWDATE, IdealBalNew ,…
0
votes
1 answer

SSRS 2008 r2 column group writing mode does not work on CRM

I have a report column group which I set WritingMode property to "Rotate 270" as I need the text presented vertically. It works like a charm when previewing on visual studio or when exported to excel/pdf but when I execute the report on CRM, theese…
0
votes
1 answer

SSRS server impersonation error - Could not obtain information about Windows NT group/user

We are trying to implement RLS on SSRS reports so that the user viewing the reports gets to see only records he is permitted to. For this purpose we are required to use the following settings while connecting to the data source (that is an…
0
votes
1 answer

Report Builder Bar Start on a Gauge pointer

I am trying to configure a Linear Gauge in Report Builder. I have defined two pointers one is the sum of valid items, the second is the sum of items affected by data quality. There is a property called "Bar Start" which has two default values…
iainc
  • 862
  • 6
  • 20
0
votes
1 answer

report builder exclude column from row total

I have a matrix which works nicely. I want to add a row total but exclude data from one column within the column group. So if my column group has columns for Development, Software, Data Quality and Valid, I want to total only the first three columns…
iainc
  • 862
  • 6
  • 20
0
votes
1 answer

SSRS not using data source specified in Report Manager

I am using Visual Studio 2013 to create reports that are run in SSRS on MS SQL Server 2008. I am able to successfully create reports that run on Sybase, Oracle and PostGresql databases. Recently we added an SQL Server database that I need to…
BrandonLB
  • 1
  • 2