none
Reporting Services: find matching indexes in multiple multivalue parameters RRS feed

  • Question

  • Using VS2005, report viewer, reporting services, oracle

    If I am passing 2 arrays to multivalue parameters in a report, (one is used in a select statement in the dataset, but the other is not), how can I get the report to display the contents of the second array based on the matching index to the first array? The first is used in the select like so:

    SELECT NAME
    FROM P_USERS
    WHERE NAME IN (:P_1)


    When I try to display the the second array, it puts parameters!P_2.value(0) instead of moving through the indexes to match the indexes of :P_1.  Can this be done? How? What if I need to pass it to a subreport?

    Monday, July 6, 2009 4:57 PM

All replies

  • Hi,
    instead of using  parameters!P_2.value(0), try with Join(parameters!P_2.value,",")

    Aftab Ansari
    Tuesday, July 7, 2009 5:34 AM
  • Thanks for replying so quickly. The join works to a certain extent, now I can see all the elements of the second array, but what I have in my table is like:

         1     a,b,c,d
         2     a,b,c,d
         3     a,b,c,d
         4     a,b,c,d

    Whereas what I want is like this:

         1     a
         2     b
         3     c
         4     d

    How can I reference the index in the arrays to make the elements with matching indexes display together in one row of the table?

    Tuesday, July 7, 2009 1:58 PM