Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2008 Forums
 Analysis Server and Reporting Services (2008)
 error:Detailed members can only contain static inn

Author  Topic 

jassie
Constraint Violating Yak Guru

332 Posts

Posted - 2010-04-01 : 08:27:42
I am getting the following error:
'The tablix 'Table1' has a detail member with inner members. Detailed members can only contain static inner memmbers.

I am getting the above error message in sql server reporting service 2008 when do the following when there is nothing on the design surface

(creating a report without the report wizard):
a. I drag on a 'list' item from the tookbox onto the 'design surface'.
b. I drag a few columns from the dataset onto the 'list' item.
c. I then place a 'table' toolbox item within the 'list' item.
d. I then preview the report.

I think I want the control 'row' group to work, but I am having trouble getting that setup.

Basically what I am trying to do overall is have:
1. The report parameters work,
2. I want the table to redisplay every time I come across a new secondary level control break,
3. I want to use the report parameters to only select a of the 'general' population.

Note: I have also used the report wizard and I can get each of the following items to work alone but not together:
1. I can get the report parameters to work,
2. I can get the the report to display everytime there is a change in the change in the control group.

Basically I want to be able to do something like the following:

1. In the parameters, I want to be able to select the country I want.
2. I then want to display a fresh copy of the report everytime the state/province changes.

Let me know what combination of solutions may work here.

kjk_kjp
Starting Member

18 Posts

Posted - 2010-07-09 : 10:14:47
Jassie,
I'm having the same issue as you are having - have you been able to get this error fixed.

Thanks!
Go to Top of Page
   

- Advertisement -