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

Nested iif statement throwing #error in an SSRS expression.. any insight would really helps

="Reporting Months:- " & join(iif(Parameters!Month.Value ,"1" ,"January" ,iif(Parameters!Month.Value ,"2" ,"February" ,iif(Parameters!Month.Value , "3" ,"March" ,iif(Parameters!Month.Value ,"4" ,"April" ,iif(Parameters!Month.Value ,"5"…
sai
  • 1
  • 3
0
votes
0 answers

SSRS throws error on IP swap

We have swapped SQL existing IP of working DB server for new server and after that SQL reports when executed from web application throws error. Application work fine for CRUD operation; its reports fails. But as we swap back IP to old server it…
KD2000
  • 1
0
votes
1 answer

SSRS Expression to Populate Dynamic Parameter Drop down Based on Year and Financial Year (CRM)

how to dynamic current year to Previous 5 year display year in filter(Drop Down) how to dynamic Financial Year to Previous 5 Financial year display year in filter(Drop Down) Please find attachment screensort.enter image description here
user6349948
  • 33
  • 1
  • 6
0
votes
1 answer

Getting a Nan Error SSRS

Getting a NaN error. My original statement is: =SUM(Fields!Outstanding_Commitments.Value/Fields!Conversion.Value, "Cost") After getting the NaN error, i changed my code to the…
Ron McArthur
  • 63
  • 1
  • 2
  • 10
0
votes
1 answer

SSRS: How do you restrict the search box to only shortcut links?

I would like to put all original reports into a centralized folder and users can only access them through the shortcut links I've provided. This would only be effective if I can restrict the portal search to only showing shortcuts. How would I…
Mike B
  • 21
  • 3
0
votes
1 answer

YTD in SSRS Matrix

enter image description hereI need some suggestions on how do i calculate the YTD . i have highlighted in yellow the YTD values that i want to calculate in my report .This question is continuation of question i posted before to calculate the Totals…
Parkin
  • 13
  • 6
0
votes
1 answer

Add a page to SSRS report

I want to add a page to SSRS report, which can be toggle on/off based on a radio button selection. The reason I want to add a page is so I can add additional report logic information for the functional users. Is it possible to add a page (with…
NonProgrammer
  • 1,337
  • 2
  • 23
  • 53
0
votes
1 answer

UnCheck ALL checkbox not working while using cascading multi select dropdown in SSRS report

I am using SQL server 2008 R2. I have two multiselect dropdown in my report. Second dropdown values populate based on 1st dropdown selected value. Expectation Select ALL checkbox in 1st dropdown, second dropdown values are loaded.Then I deselect ALL…
Mano Johnbritto
  • 288
  • 1
  • 5
  • 16
0
votes
1 answer

Static Month Every Year Parameter SSRS

I want to have a parameter that selects the same month (which is September) every year. So this Parameter dynamically changes every year but still selects September.
Ron McArthur
  • 63
  • 1
  • 2
  • 10
0
votes
1 answer

Filter in pie chart not working SSRS

For some reason, I am unable to get the filter functionality to work properly. I have 4 options labeled as A, B, C, D. Then I have the values being represented in the chart are points. I go to Chart Properties and then the Data tab. I go to category…
Red Devil
  • 2,343
  • 2
  • 21
  • 41
0
votes
2 answers

Usage of the column "ExecutionId" in the table "[dbo].[ExecutionLog2]"

Can any one of you please help me by providing more details of the column "ExecutionId" in the table "[dbo].[ExecutionLog2]". I thought for each and every report execution from report server it will create one execution id. However I find one…
V A
  • 69
  • 1
  • 6
0
votes
1 answer

SSRS: How to add an condition in the expression while counting rows?

I need help with writing a conditional expression for counting specific rows of the dataset using which I determine to make a textbox visbile DataSet_Example Name value Level ABC 12345 PG1 DEF 45677 PG2 FEG 98098 PG1 I want to count…
ndavid9
  • 13
  • 3
0
votes
0 answers

SSRS Default empty multi-value parameter error

I'm linking 2 multi-value parameters together. So that when the user chooses "1" for Fields.P1.Label(0), I get "1" for Fields.P2.Label(0), "2" for Fields.P1.Label(0), I get "2" for Fields.P2.Label(0), etc. I made it work with the following switch…
Bob
  • 467
  • 1
  • 4
  • 13
0
votes
1 answer

Having a config file for SSRS report

I have Report pointing to 20-25 servers, Which Has Dataset Queries something like these #Dataset-1 Select A,B,C,D,E,F From Table1 where a>10 and a<15 #Dataset-2 Select A,B,C,D,E,F From Table1 where a>15 and a<13 #Dataset-3 Select A,B,C,D,E,F From…
Chetan Kulkarni
  • 404
  • 4
  • 15
0
votes
1 answer

multiple conditional formatting in SSRS report

Hi i have 2 conditions for a column in an SSRS report. if Expirationdate <= Begdate then red if Begdate
T Dang
  • 157
  • 3
  • 17
1 2 3
…
99 100