Hi Amit,

I too am also trying to figure out how to make tabbed reports in SSRS, but I'm using 2005, it's probably a lost cause. ANYWAY, I'm writing...

Nevermind yall. Got it.

Ok, I think I understand...

If we upgrade to SQL Server 2012, then we should upgrade reporting services to 2010. Got it.

So we're currently running with SQL Server 2005 with...

Not sure how it would reflect in the tablix report BUT (depending on what software youre using) you could code your order in the query...

At the end of your query,...

So is that a no? Meaning if I go through with the upgrade, I cannot access my exisitng reports and they will all need to be re-created?

I see, makes perfect sense. Thanks for the tip.

Thanks. Can you provide a simple example of the switch function? I might use it in the future.

Thanks for the response, but I got it figured out. It's a two part formatting process, one for the parenthesis and one for the color.

In the properties dialog box...

So with the link I created OUTSIDE of report manager, Im running IE8 on one of my desktops (getting the error message) and on my other desktop Im running IE7...

Thanks for your help Jack, much appreciated. However, changing the word Municipality did not work. So, per your advice, I exported to a web archive to see if...

When you say you created a link, do you mean you created a link on a web page other than the report manager web page?

YES.

I should note that some...

Hmmmm...

When you select <NewDataset...> from the data pane, you should be directed to a new dataset dialogue box. In the dialogue box, you should see the option "Query String:"...

Sorry everyone, nevermind.

I simply had to SELECT DISTINCT on the parameter query. My bad.

Genius! haha. Worked like a charm. Thanks brutha.

Is that the code you're using in your dataset query pane?? Or the code your using in our layout pane?? Either way, I'm curious to know if it...