April 8, 2010 at 7:19 am
I have a report with three data regions based on nearly the same set of data. What I want to do is allow the users to click a hyperlink as a toggle item and make one visible while making the others invisible so that they can all sit at the top of the page without overlapping each other. My requirements state I have to do this all on one report, so I can't use the hyperlinks to actually switch reports on them.
I should be a little more specific and add that the item I want to toggle from is a value in a small dataset - which is making things much more difficult. I'm sure there's an easy answer here. The Iif statement isn't difficult. What I'm having difficulty with is allowing the users to click a row in the first small dataset to determine which data region becomes visible.
April 8, 2010 at 9:52 am
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.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
April 8, 2010 at 10:32 am
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.
April 8, 2010 at 12:25 pm
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 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply