Detail members can only contain static inner members.
Hi ironryan77, Thanks for your post. Based on the information you provided, you should place the table control (‘table2’) in the details row cells, the details row cells are only used to the show the static inner members, whenever you place a control which contains dynamic members in it, this error even would be triggered. If you truly want to nest the table in your main report, I would suggest you to place it in the group column field cell in the tablix. Thanks, Bill Lu Please remember to mark the replies as answers if they help and unmark them if they provide no help.
October 18th, 2011 12:25pm

I am developing an RDL in SSRS 2008 and am trying to move a subreport table directly into a main report so that I instead run this subreport in the same stored proc as my main report. However, I'm having trouble hooking this up. I got the stored proc to run successfully. But now when I try to copy this table into the main report I get the following errors: Error 1 [rsInvalidDetailDataGrouping] The tablix ‘table2’ has a detail member with inner members. Detail members can only contain static inner members. \\operations\userfiles\R15D\Documents\Visual Studio 2008\Projects\Test\Test2\DischargePlan.rdl 0 0 <br> Report item expressions can only refer to fields within the current dataset scope or, if inside an aggregate, the specified dataset scope How do I do this? I have tried various workarounds I found on the internet but none have worked. I have tried moving the table into the group level and deleting the details grouping. I have removed sorting elements, etc. But the only way I got this error to disappear is to delete all of the groupings for this table and all textbox values. Ryan D
Free Windows Admin Tool Kit Click here and download it now
November 19th, 2011 7:02pm

Hi ironryan77, Thanks for your post. Based on the information you provided, you should place the table control (‘table2’) in the details row cells, the details row cells are only used to the show the static inner members, whenever you place a control which contains dynamic members in it, this error even would be triggered. If you truly want to nest the table in your main report, I would suggest you to place it in the group column field cell in the tablix. Thanks, Bill Lu Please remember to mark the replies as answers if they help and unmark them if they provide no help.
November 20th, 2011 6:18am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics