SQL Server Performance

error:Detailed members can only contain static inner memmbers.

Discussion in 'SQL Server 2008 Reporting Services' started by jassie, Apr 1, 2010.

  1. jassie New Member

    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.
  2. FrankKalis Moderator

    Is your problem still current?

Share This Page