• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 2150
  • Last Modified:

RDLC report parameters c#

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
rishaan
Asked:
rishaan
  • 3
  • 3
1 Solution
 
puffdaddy411Commented:
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
 
rishaanAuthor Commented:
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
 
puffdaddy411Commented:
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
Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

 
rishaanAuthor Commented:
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
 
puffdaddy411Commented:
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
 
rishaanAuthor Commented:
PERFECTOOOOO
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

  • 3
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now