?
Solved

visual studio report

Posted on 2014-08-14
1
Medium Priority
?
276 Views
Last Modified: 2014-08-30
I want to prompt the user to select from a list of values provided by another query. The selected value should be the filter for the main report query. What I have done so far does not acknowledge the selected value. The report displays all rows in the query even though I have selected a parameter
Report Data
-ReportParameter1
  Prompt=School
  DataType=Text
  Allow Multiple values
  Available values-get from query
    Dataset=school,
    Value=school,
    label=school
  No Default
 DataSet1
  Filter [school]=Parameters!ReportParameter1.Value(0)

What else should I do so the report will use the selected value to filter the results?
0
Comment
Question by:dwiseman3
1 Comment
 
LVL 12

Accepted Solution

by:
Tony303 earned 2000 total points
ID: 40262513
Hi,

When the Multiple Values is switched on,
you need to change your last line to "IN" instead of "=" and take the (0) off
"Parameters!ReportParameter1.Value(0)"

So...

Report Data
-ReportParameter1
   Prompt=School
   DataType=Text
   Allow Multiple values
   Available values-get from query
     Dataset=school,
     Value=school,
     label=school
   No Default
  DataSet1
   Filter [school] IN Parameters!ReportParameter1.Value

I hope this helps

Tony
0

Featured Post

Configuration Guide and Best Practices

Read the guide to learn how to orchestrate Data ONTAP, create application-consistent backups and enable fast recovery from NetApp storage snapshots. Version 9.5 also contains performance and scalability enhancements to meet the needs of the largest enterprise environments.

Question has a verified solution.

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

What my article will show is if you ever had to do processing to a listbox without being able to just select all the items in it. My software Visual Studio 2008 crystal report v11 My issue was I wanted to add crystal report to a form and show…
For most people, the WrapPanel seems like a magic when they switch from WinForms to WPF. Most of us will think that the code that is used to write a control like that would be difficult. However, most of the work is done by the WPF engine, and the W…
This is Part 3 in a 3-part series on Experts Exchange to discuss error handling in VBA code written for Excel. Part 1 of this series discussed basic error handling code using VBA. http://www.experts-exchange.com/videos/1478/Excel-Error-Handlin…
Screencast - Getting to Know the Pipeline

839 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