Have you checked the connection to make sure it is pointing to the correct database?

When you create the sub report, you actually can go the properties windows of the subreport and set the parameter to be the selected employee id. This link should...

Sounds like you need to toggle the visibility of the subreport. Or create a parameter to show the sub report.

A copy of your query may help. Is it possible the that tuple does not exist.

In SSRS you use IIF and not IF. Can you try that?

My newsletters have stopped again. Anyone else having the problem?

A little self promotion, but take a look at this MSSQL Tip which uses a linked server and some SSAS DMVs.

Scott

http://www.mssqltips.com/sqlservertip/2603/build-a-sql-server-analysis-services-data-dictionary/[/url]

You can actually adjust the drill through text to a logically expression based on some other value including a parameter.

As an example, you may have a parameter that that has...

You need data in a tablix in order group and drill down.. once you have the tablix, you can easily add groups

You need to make sure the parameter is set to refresh on change... Go to the parameter properties... Then to the advanced window... make sure the Refresh data when parameter...

yes... take a look at:

http://msdn.microsoft.com/en-us/library/dd255197.aspx

I still think you should run profiler and see what is different between running straight sql vs SSRS.

to get the "sub percentages" you do need to change the label values formula. I would do that first and then see about removing that item from the legend.

You can hide the legend.

Youl will need to adjust the label to not use #Percent and use an actual calculation of the detail value divided by the grouped value.