click one grid, populate several others

  • Matthew Cushing

    SSCrazy

    Points: 2898

    I know that it's possible to have one main grid, say with people, where if you click on a row, you can use the information to populate several other grids, I'm just drawing a complete blank on where to start. Can someone remind me what the functionality is even called so I can look it up?

    Example: I click on my name in the people grid, and my address info comes up in the address grid, my position history comes up in the HR grid, and my family info is populated in a third grid.

    I'm attempting to do lookups and display things in different tablix based on the choice that's made in the first box. Again, it's been about two years since I have even opened Visual Studio and I don't want to spend too much time remember what's it called and THEN relearning it 🙂

  • vecerda

    SSCrazy

    Points: 2532

    This sounds like a sub-report where you are passing a parameter to other data regions.

    Petr

  • happycat59

    One Orange Chip

    Points: 29189

    This sounds like visibility being toggled by a report item. Try right clicking on the rows that you want to show when you click on the name and select "Display can be toggled by this report item:" and then from the drop down list select the field contain the name.

  • Matthew Cushing

    SSCrazy

    Points: 2898

    I think it might be, but every time I put an action in, it pops out to a different report on a new page. I kind of wanted to get it so that there's one grid visible on top and several below it. The ones below don't populate until you click on a row in the main grid, and i'm hoping to pass an id from the main grid to the smaller grids and populate based on that.

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

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