SSRS List and Table error -

This is driving me nuts. I coul;d do it in 2005. All I want to do is drag a list to the report,
populate the groups in the list from the dataset and then add a table to the list to bring back the details. I keep getting the error that  "The tablix ‘Tablix7’ has a detail member with inner members. Detail members can only contain static inner members." Please help!
Laura2112Asked:
Who is Participating?
 
GKaloskyCommented:
This should help you understand the differences in the types of tablix.  I haven't used the list type because it didn't feed the needs for any of my reports.  You may need to use a different type of tablix based on what type of data you are trying to present.

http://technet.microsoft.com/en-us/library/bb934258.aspx
0
 
GKaloskyCommented:
In a Tablix you cannot put dynamic member in a Detail row.  You have to put it into a Group header or Group Footer row.

Steps:

Insert a table into your report.
Set the DataSetName for the Tablix (either in the Properties pane or by dragging a field into the tablix).
In Row Groups, right click the (Details1) group.  Select Add Group –> Parent Group…
In the Tablix group dialog, Select your Group by: clause.  
Check the Add group header checkbox.
Press OK.
0
 
Laura2112Author Commented:
Is Tablix synonomous with list?  Do I insert a table in the report body or list?
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

 
GKaloskyCommented:
I don't know what you are referring to as a list, but this link should help you understand what a tablix is.

http://msdn.microsoft.com/en-us/library/cc627578.aspx
0
 
Laura2112Author Commented:
when I look at the toolbox in 2008, I am bringing over the List. It does say tablix for properties.
0
 
Laura2112Author Commented:
List. Use a list to create a free-form layout. You are not limited to a grid layout, but can place fields freely inside the list. You can use a list to design a form for displaying many dataset fields or as a container to display multiple data regions side by side for grouped data. For example, you can define a group for a list; add a table, chart, and image; and display values in table and graphic form for each group value, as you might for an employee or patient record. This is what I need to do for the freeform aspect of it. I was able to do it in 2005.
0
 
GKaloskyCommented:
Did you define the group for the list?  The error indicates you have a grouping issue.
0
 
Laura2112Author Commented:
Lets do this step by step. Starting with a new report. I bring over a list. Tablix properties. Please refer to attached. Then I add the group, then I add the table for details
042210---Step-1---bring-over-lis.doc
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.