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

How to use dropdown and textbox field for one parameter in same report on SSRS

I want to use two options. 1- If users want to use dropdown list for order they should use dropdown list parameter and textbox must be invalid or textbox must be set in dropdown value. 2 - Or if users want to type with keyboard manuelly for order,…
Aylin
  • 177
  • 5
  • 17
0
votes
0 answers

How to Disable a single reports export feature in ssrs without impacting the export features of other reports?

I have a report in SSRS 2014 where i need to disable the export feature. The export feature should get disabled only on a single report without impacting the export feature of other reports. This needs to be done in the Reports only as i am using…
sujit kumar sahu
  • 61
  • 3
0
votes
1 answer

SSRS 2008 - How to link 2 or more year parameters into 1

After some research, I see that blending parameters is a popular topic but I haven't found a solution to this specific situation. Shortly said, I have 3 parameters from various datasets all stating the same year and I want to blend them (visually)…
Bob
  • 467
  • 1
  • 4
  • 13
0
votes
1 answer

SSRS - Major/minor gridlines spacing

I have an SSRS report with a bar chart with multiple series by CountryName Category group. What I want to do is have gridlines which split each country like below: However in SSRS the major gridlines seem to interval with the line in the middle of…
chrissy p
  • 823
  • 2
  • 20
  • 46
0
votes
0 answers

SSRS export .txt tabdelimeited format is changing field names

SSRS .txt export format is changing my report field name. Days supply is showing as Days_Supplied Dispensing is showing as Dispencing Claim Number is Showing as Amount_Claim_Number Please suggest, I appreciate your help. Thank You!
XYZ
  • 41
  • 7
0
votes
1 answer

How can I create a parameter which choosing a number of top of values

I've created a report in SSRS 2008. The report contains fields: Number of requests, Organization of the initiator How can I create a parameter which choosing a number of top of values from field Number of requests Example, set value of parameter…
AleksTr
  • 77
  • 1
  • 6
0
votes
3 answers

Report Builder 3.0 - MDX - Moving Sum

I have poured over quite a few websites, including this one, and so far in vain. I need to create a graph depicting the employee turnover rate, which has to be calculated over 1 year. (As stated in my title I have the option of either going with 13…
Bob
  • 467
  • 1
  • 4
  • 13
0
votes
1 answer

SSRS - finding the average of field in last X weeks

=SUM(IIF(Fields!WeekEnding.Value)>= DATEADD(Week,-17,GETDATE()),Fields!Hours.Value / 17) I want to find the sum of all hours, in the last 17 weeks then divide by 17 to find the average hours per week. Thanks in advance
Lee
  • 1
  • 2
0
votes
1 answer

unable to refresh data fields in ssrs report

i am trying to update a report. i have stored procedure in my database for getting the fields for data set.i updated the stored procedure for new data fields, and the stored procedure is working properly. but when i try to refresh the fields in the…
Anupa Sankar
  • 491
  • 2
  • 7
  • 17
0
votes
1 answer

SSRS Expression - Alternate Row Color Based on Dense Rank function

I have an SSRS report in which I had been using the standard expression for alternating row colors: =IIF(RowNumber(Nothing) Mod 2 = 0, "LightGrey", "White") But this particular report shows customers with duplicate SSNs so I added a DENSE_RANK…
MISNole
  • 992
  • 1
  • 22
  • 48
0
votes
1 answer

ExecutionLogDaysKept paramter is set to -1 (SSRS)

I'm managing a SQL Server with reporting services running on it. The ReportServer database is getting too big. When I checked which table is occupying a lot of space, [ExecutionLogStorage] came up. I found out that the data stored in this log table…
RMu
  • 817
  • 2
  • 17
  • 41
0
votes
1 answer

Option statements must precede any declarations or Imports statements

I am putting below custom code in SSRS report, Option Explicit Private Sub Workbook_Open() Application.ErrorCheckingOptions.BackgroundChecking = False End Sub Private Sub Workbook_BeforeClose(Cancel As Boolean) …
Keval Patel
  • 925
  • 4
  • 24
  • 46
0
votes
0 answers

SSRS - How to get sum of values using reportitems!textbox1.value and reset to 0 for every group created in report?

How can I get sum of values using reportitems!textbox1.value and reset to 0 for every group created in report?
Jagdeep Singh
  • 1
  • 1
0
votes
1 answer

SSRS Report parameter not working

I am new to SSRS. I have a report whose report parameter is not working. No matter what value I select, it does not seem to get that value. It is only picking the defined value from the query. And if I define the parameter in query to null then it…
Qureshi
  • 13
  • 1
  • 5
0
votes
1 answer

SSRS Report Subscription

Please help me if i could append time stamp to SSRS report subscription. Time stamp should be in YYYYMMDD format. 'ReportName @timestamp' is giving me timestamp in 2017_03_17. My Datasource is oracle. I appreciate your help.
XYZ
  • 41
  • 7
1 2 3
…
99 100