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!
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!
ASKER
Is Tablix synonomous with list? Do I insert a table in the report body or list?
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
http://msdn.microsoft.com/en-us/library/cc627578.aspx
ASKER
when I look at the toolbox in 2008, I am bringing over the List. It does say tablix for properties.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
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.
Did you define the group for the list? The error indicates you have a grouping issue.
ASKER
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
042210---Step-1---bring-over-lis.doc
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.