Multi-Valued Parameters

Hot Topic

timeout errors, and General Network Error messages
SQL Server Express and Oracle
which of these ways is the best to create dimensions
June CTP - Passing NULL value to a Sub-Report Parameter
2nd Post - Problem installing SQL Server 2005 Express SP2
need direction on SSB replacing existing technology
Converting a HEX string to its binary representation
Can't get Instanses of the Report Server through WMI using Non-Administrators access
Transaction logs growing
process analysis server objects from web via ASP.NET + C#

SQL Server

Understanding Estimated Execution Plan
Subcube in cube calculations
accessing another database in a stored procedure
trouble starting SQL Management Studio
SQL Server Management Studio and DTS
question on package configuration
Login failed for user ''. Reason: Not associated with a trusted SQL Server connection.
RS.exe and date-type parameter.
VIEWS With Columns set by NEWID()
experience a hard time to connect to the database my dbase is sql express ed 2005

Multi-Valued Parameters

Hi:

I have this page, it is runing fine for single value parameter. Now I am trying to pass multiple values from that parameter and to do so I checked mark the multivalued box for that report parameter. But, I am not able output any of the selected Items...please explain in detail. Thanks,

Rohit

Answer this question

Multi-Valued Parameters

  • sophmoricinbehavior

    Is your list dataset property set Another way is to put the charts and tables in a subreport and then call the subreport from a table sending it the parameter for witch you want it to display.It's hard to tell mor without any more info...



  • kalprin

    Thanks, I am not getting errors any more. But there is another problem that it is only giving me the first value. How can I get all the other values

    Thanks.

  • A.Issa

    if your problem is in the where clause of your dataset query try this:

    Instead of using "...WHERE field=@Parameter..." try "...WHERE field IN (@Parameter)..."

    Hope it works...



  • Evgeny Popov

    Now i think you have to set the group on the list to the field that you have the multivalue signed to.

  • anomolous

    Visual Studio

  • Rafael Leonhardt

    Are you in Report Builder or VisualStudio

  • Larry_t

    On "list Properties" in the "General" tab you have a "Edit Details Group Button", try that!

  • Kiumo

    Actually, I have a set of charts and tables, that I want to repeate with the respective data for each value selected. So for that I put them in the "list", but I don't know how is it going to work.

  • Hauri

    I tried that but it didn't work. I am still getting the same name repeated, also non of the charts and tables repeat either. The only thing that repeat is the text box where I have the name of the parameter. Can you show me how can I get the charts and tables and every thing in the list to repeat also I also have this hidden parameter which gives me the selected parameter. When I clicked on the multi value for the hidden parameter, I started getting the #ERROR instead of the name. Please help.Thanks.

  • Andrew Mayorov

    I didn't understand what to do. I went to "list properties" and I couldn't find Group on there, but I did find a sort on. Can you please explain me Thanks.
  • Multi-Valued Parameters
Answer this question