Solved

RDLC report parameters c#

Posted on 2011-03-09
6
2,103 Views
Last Modified: 2013-11-27
One more question in continuation...What if the parameter value is not chosen in front end ..Then I want all values in dropdown to be passed...I guess the filter should be IN..and there should be  a check in frontend that if no value  is chosen--all the values in dropdown will be concatenated and passed.. Is this the way to do it or is there any otherway...
0
Comment
Question by:rishaan
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 3
6 Comments
 
LVL 5

Accepted Solution

by:
puffdaddy411 earned 125 total points
ID: 35095856
Sounds like you are using a combo box on a form to select filters for your report, correct?  So if nothing is selected the table should display all records, correct?

What you need to do then is make your parameter a "MultiValue" parameter.  There is a checkbox on the parameter dialog box of your report.  Then you can pass a string array to the parameter.  Change your "=" to "IN" in your table filter.  This should work for a single value or multiple (all) values.  Just pass a string() array to the parameter with all of your desired values (or one).

Use this in your filter value.

=Parameters!YourMultiValueParam.Value
0
 

Author Comment

by:rishaan
ID: 35096515
Thanks  again..for correct understanding and perfect answer.
Since you are report specialist I wanted to ask you ..I wanted to create a MS-Access like strong filter functionality on the form and then generate reports accordingly.. What would ur suggestion be to proceed with it ? Or Has this kind of work already done by some one already..
0
 
LVL 5

Expert Comment

by:puffdaddy411
ID: 35096560
Do you have a picture of an example or a bit more detail of what you are doing?  Perhaps an example of the MS Access functionality you need?
0
Instantly Create Instructional Tutorials

Contextual Guidance at the moment of need helps your employees adopt to new software or processes instantly. Boost knowledge retention and employee engagement step-by-step with one easy solution.

 

Author Comment

by:rishaan
ID: 35099318
If u have a MS Access table open and it has the filter functionality on each column whcih cahnges data dynamically or in Excel where filters can be applied to column headers and they filter whole sheet on each selection....
0
 
LVL 5

Expert Comment

by:puffdaddy411
ID: 35099579
Ah I see.  Well you can't build this functionality into the local report itself.  Once the report is rendered, it is in its final state.  You can enable interactive sorting on columns to reorder them but that's about it.  If I needed to do this, I might use comboboxes on the form for each column and refresh the report on the combobox.SelectedIndexChanged event.  Or select the values of each combo box and refresh the form on a button click.  Again, you can't change the report once it's rendered, but you can manipulate the back-end data and refresh the report as much as you need.
0
 

Author Closing Comment

by:rishaan
ID: 35109008
PERFECTOOOOO
0

Featured Post

On Demand Webinar: Networking for the Cloud Era

Did you know SD-WANs can improve network connectivity? Check out this webinar to learn how an SD-WAN simplified, one-click tool can help you migrate and manage data in the cloud.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This document covers how to connect to SQL Server and browse its contents.  It is meant for those new to Visual Studio and/or working with Microsoft SQL Server.  It is not a guide to building SQL Server database connections in your code.  This is mo…
Many of us here at EE write code. Many of us write exceptional code; just as many of us write exception-prone code. As we all should know, exceptions are a mechanism for handling errors which are typically out of our control. From database errors, t…
This tutorial covers a step-by-step guide to install VisualVM launcher in eclipse.
The viewer will learn how to use and create new code templates in NetBeans IDE 8.0 for Windows.

631 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question