Need Drill down into a report help

[katekis]

In Report Manager I am trying to drill down into a Report.

Officer Branch Name Product # of Accts
------ ----------- ------- ------------
1234 APV INVESTMENTS 3
MONEY MANAGER 1
SHARE SAVINGS 7
Total 11
Total of Accounts Opened: 11


An example report is above.
When I click on the any of the "# Of Accts" numbers I get the below error

An error has occurred during report processing.
Semantic query compilation failed: e GroupingNotFound One of the GroupingValue.Name properties of the DrillthroughContext refers to the Grouping 'Current Account Status ', which does not exist. (DrillthroughContext '').

The person that created the report says she can drill down into the report just fine. She gets a list accounts when she clicks on any of the '# of Accts'.

Another person that is also trying to drill down into the report gets the following error

The permissions granted to user 'xxxx' are insufficient for performing this operation. (rsAccessDenied).

Please help me with information on how I can get this report fixed so we can all drill down into the report.

Thanks,

 

[jymm]

is the acct drill down a sub report that may have it's data access defined differently?

better question - was the report done in report builder or Visual Studio?

one more question - which version of SQL? 2005??? if 2005 is it Enterprise or one of the others (Standard or... something else)???