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

SSRS: Filter 1 field based on 2 possible values in another field

I don't if I'm being a knucklehead, but I've searched considerably and tried several options: can't make it happen. Here is the issue. I have the following Data Query: First of all, sorry it's French. Secondly, as you see, the fields are "File…
Bob
  • 467
  • 1
  • 4
  • 13
0
votes
1 answer

default value of parameter that is dependent on another parameter not updating in SSRS report

Hi I have 2 parameters @begdate and @enddate. When I select the @begdate ,I want @enddate to dynamically be set to the end of that current month. I have @enddate default value as =Format(DateSerial(Year(Parameters!BEGDATE.Value),…
T Dang
  • 157
  • 3
  • 17
0
votes
2 answers

SQL - ignore where clause if null / no input

I'm building a SSRS report and would like one of my parameters to be optional where data is entered or not. Here is an example query for a better understanding: SELECT C1 ,C2 ,C3 FROM db_Database..tb_Table WHERE tb_Table_DateTime between [THEN]…
db-rocker
  • 51
  • 1
  • 6
0
votes
1 answer

SSRS Report Footer

I know about Page Footer, and I know I can make it look like Report Footer by controlling the visibility of Page Footer. I want Report Footer it only shows in the very last page of the report. The problem with the work around above is that it will…
asmgx
  • 7,328
  • 15
  • 82
  • 143
0
votes
1 answer

SSRS Dynamic Columns that change on Row Groups

First Question: let me know how I messed this up. I am trying to make a Budget vs Actual report. I have a SQL Stored Proc that returns data based on a few parameters, such as Customer and Project Number. The data comes out as Invoice data by date,…
BBackSoon
  • 1
  • 1
0
votes
1 answer

SSRS Date Parameter Default

I have a report that I need to set-up a default date for @Star and @End date parameter to Last Sunday for @Start and Last Saturday for @End. Found the code to Last Day of previous week (Sunday) =DateAdd(DateInterval.Day,…
Arsee
  • 651
  • 2
  • 11
  • 36
0
votes
1 answer

Report Builder 3.0 Combing parameter values

I'm adding a prompt to my report that selects records based on Status. Here are the available values: Approved = 1 Cancelled = 2 Suspended = 3 Unapproved = 4 The SQL statement in my report uses an IN clause to select the records to return. My…
Shaves
  • 884
  • 5
  • 16
  • 46
0
votes
1 answer

SSRS Improve performance of a multiselect dropdown parameter

I have a SSRS report which has a multiselect dropdownlist parameter which loads data from database. The problem is, I have to load 130000 records in the parameter dropdown and it takes so much time to load the dropdown. But when I check my query…
tarzanbappa
  • 4,930
  • 22
  • 75
  • 117
0
votes
2 answers

Working with SSRS dynamic fields

SSRS matrix table is a great way to generate dynamic fields as long as values exist. However, is there a way to "always" show these dynamic fields even if a value doesn't exist for them? The report field locations varies based on data…
NonProgrammer
  • 1,337
  • 2
  • 23
  • 53
0
votes
1 answer

SSRS Coumn Visiblity Expression

I have a report that Show or Hide certain report column based on the parameter selected. I have a table grid in SQL that should control which column to hide and which column to show when the report is rendered. The parameter to control the show or…
Arsee
  • 651
  • 2
  • 11
  • 36
0
votes
1 answer

Oracle procedure with date parameter in SSRS

we have following Oracle procedure with date parameter: CREATE OR REPLACE PROCEDURE R_T.Test1 ( Test1 IN OUT Reports.rep_type, date_parameter IN system_days.daytime%TYPE) AS BEGIN OPEN Test1 FOR select * from (select sum(max(case when code…
Joe Green
  • 209
  • 2
  • 11
0
votes
1 answer

Why isn't my report changing the sorting based on the input radio button being toggled?

I have a report that I want sorted differently based on 2 radio buttons (boolean input parameter). If the true radio button is selected, sort by Sum(Fields!plannedPallets.Value), otherwise sort by Sum(Fields!lbrHrsPlanned.Value). However, I'm having…
loltospoon
  • 239
  • 1
  • 9
0
votes
1 answer

SSRS Chart Group by Dataset

I have a chart in SSRS where I use data from two different datasets. Currently I have 2 values from dataset 1 and 2 values from dataset 2 but they are all grouped up into 1 category. Is there a way to group the data by datasets so I can display the…
TheProgrammer
  • 1,314
  • 5
  • 22
  • 44
0
votes
1 answer

SSRS 2012 Report Page Breaks

Wondering if someone can point me in the right direction. I currently have a report with 5 sub sections of data, each surrounded with a Rectangle. I am wanting each sub section to appear on a new page and then be able to export to Excel and each…
PJD
  • 743
  • 2
  • 12
  • 38
0
votes
0 answers

Dynamic tablix creation on SSRS

Scenario: I have a table of open orders by vendor, I need to be able to generate an excel file with a list of every vendor's open orders separated on each tab. I need then need to set up a subscription that would send this excel file to someone who…
H.Ben
  • 117
  • 1
  • 10
1 2 3
…
99 100