Post reply

Problem while displaying the report-Repat one list after another list

  • April 17, 2009 at 8:18 am

    #384387

    Hi All,

    I am trying to report two tables in a report. I have created two list. Both the tables are linked by parameters and they are working fine. In my report I select the data based on the Rank, so I give a range of rank say 1-10. While displaying this data my report generates table1 for all the ranks and then table2 for all the rank. I want it to display both the tables for particular rank. I tried the repeatwith option where the list2 has to reatwith list1, even then it displays the same way. Can anyone help me on this please.

    Thank You,

    Ashu

  • April 19, 2009 at 11:17 pm

    #980517

    create a single list, put both tables inside list and group list by rank and use a filter in the list (parameter value = field rank), assuming that both tables have same dataset

  • April 20, 2009 at 8:44 am

    #980770

    Thank you for replying.

    They are two different data regions. It uses data from different dataset. The list doesnt allow to get data from two different datasets. Is there any other way to do it?

  • April 20, 2009 at 12:53 pm

    #980971

    you can create two lists and use filter and parameter in the list. filter will be

    Fields!Rank.Value in =Parameters!Rank.Value

    parameter will be you can create a multivalued parameter from the data set

    ex: select distinct rank from tab1

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply