Questions tagged [reportparameter]

37 questions
3
votes
2 answers

Limit the options for a dropdown list in ReportViewer Control

I have a reportviewer control in remote mode which loads a report that has nine parameters. Under certain conditions, I want to limit the options of one of those parameters (a dropdown list) in the report. If I do this: protected void…
drowned
  • 530
  • 1
  • 12
  • 31
3
votes
3 answers

Multi-value parameter truncation

On my SSRS report I have a multi-value parameter which contains 250+ uniqueidentifier data type values. This works fine with a small selection of values in the parameter dropdown, but when user chooses (select all), they get this error: An error…
Dr. Greenthumb
  • 2,280
  • 5
  • 27
  • 33
2
votes
1 answer

Using Report Parameters in Header

I've read other posts that recommend using parameters when displaying dynamic data in the header because it renders correctly in pdf. I am trying to implement that solution but have run into an issue. It works when data is returned for a…
2
votes
3 answers

c# Reporting Services -- ReportParameter value that isn't a string

Ok I'm working on a little project at the moment, the Report expects an int but the ReportParameter class only lets me have a value that's a string or a string[] How can I pass an int? thanks dan
danswain
  • 4,171
  • 5
  • 37
  • 43
2
votes
2 answers

Why are my reports throwing an exception while setting report parameters?

Ok so my scenario is that I have a single report viewer on a form, that connects multiple reports based on a choice. I have all of my reports set as an Embedded Resource for the build action. I am loading the reports like this before I set my…
Steven Combs
  • 1,890
  • 6
  • 29
  • 54
1
vote
1 answer

Date-Timestamp parameter in pentaho reporting

how to add/display timestamp while creating a report using pentaho report designer 3.6, having date as a parameter and when the user chose the date, the timestamp should be displayed
lourdh
  • 449
  • 2
  • 12
  • 30
1
vote
0 answers

Passing parameter to crystal report and link it to database fields to get specific record and show it

I have build crystal report with vs 2013 and I did the following add the database fields for the tables I need. I am calling the report from form1 and it display the data so it is good but what I need to is get an ID from textbox in the form1…
sam
  • 2,493
  • 6
  • 38
  • 73
1
vote
1 answer

Setting ReportParameter that's not a string

In C# I'm trying to set the report parameters for an SSRS rdlc file. First of all, am I doing this correctly? GetParameters() to return a collection of the parameter info Create a list of new ReportParameter objects, assigning name and values Call…
1
vote
2 answers

passing a null datetime to reportparameter class?

How can I put a null value on datetime variable type? I tried to make it nullable value, but I need to use it in ReportParameter() method to send it to my report but ReportParameter() constructor cannot take a nullable value and the…
1
vote
0 answers

Reset Parameters in Report Services

I have a report that lists people and flag. idPerson | nmPerson | Flag 01 | Carl | 0 02 | Eva | 1 03 | Jhon | 1 I want to update the flag when I click on the flag field. To do this, I created a dataset that calls a…
1
vote
1 answer

SSRS report parameter - single selection dropdown with ''select all''

I am re-creating a report that have been built with some obscure reporting technology and the report have some parameters (dropdown box filters). All the dropdown allow only one value to be selected at a time, but also include the 'All' selection at…
1
vote
2 answers

How to create MDX parameters for SQL Server Reporting Services (SSRS)?

In SQL Server Reporting Service, when I connect to my cube to create a dataset, in Query Designer I create my query with a filter. It creates the following MDX for me: SELECT NON EMPTY { KPIValue("KPI1"), KPIGoal("KPI1"), KPIStatus("KPI1") } ON…
Bob
  • 22,810
  • 38
  • 143
  • 225
1
vote
0 answers

Reading parameters from RDL file from web UI - SSRS

I have a set of reports and I need to use only a single UI for the parameter section for all the reports, that is the intention was for the report parameters layout screen to read the parameters collection in the reports RDL file and dynamically…
sudheshna
  • 1,150
  • 1
  • 13
  • 24
1
vote
1 answer

Strange behavior of SSRS Report Parameters

Has anyone else experienced this issue ? I am designing a report in SSRS 2008 using Development tools for Dynamics AX 2012, I have several datasets and parameters in my report, the problem is that when I made any change in my main dataset, and…
0
votes
1 answer

Auto select cascading multi-valued parameters in VS Reporting Services

I have a couple of multi-valued parameters in my report created using visual studio reporting services, one filtered against the other. I want that each time there is any change in my first parameter drop-down list, the values appended in my second…
1
2 3