Use toggle to switch between data regions

  • So you want to have 1 visible and 2 hidden when you click a single hyperlink? There is no way to know which one is currently visible, so I think you'd need a hyper link for each data region.

  • Well, one thing I tried was to have the hyperlink link back to the same report but save the value of the record as a parameter. Then I used an Iif statement in the visible field for the data regions based on the value of the parameter. But its returning no records at all now. I'm troubleshooting now, but it seems to me that this method should work, its just clunky.

  • I figured it out. It really wasn't very hard. Since the data regions were just reflective of a where clause, I simply put If statements into my query with begin..end based on the parameter passed by the hyperlink results of the first data region. Worked first try. On reflection, it was pretty obvious.

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

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