How to show a Subreport inside a grp header static once per group when group header is showing on every page?
I have a report where I have a group header that needs to show on every page. I do this by setting ALL the static members on the group to: KeepWithGroup: True, RepeatOnNewPage:True and first row of group gets, FixedData: True. This works fine but within one of those static members I have a Subreport embeded and so this subreport is repeated on every page along with the Group header and I don't want that, just want it on the first page of the group. If I set the property for RepeatOnNewPage:False, for the static member of the group which contains the subreport then I get the following error: The tablix 'tblxUnitTotalDetails' has an invalid TablixMember. The TablixMember must have the same value set for the RepeatOnNewPage property as those following or preceding the dynamic TablixMember. (Expected Value: "True"; Actual Value: "False") So, how can i show a subreport in a group only on the groups first page?? --ACG
January 26th, 2011 10:53am

Hi ACG, Just as the error message TablixMember must have the same value set for the RepeatOnNewPage property as those following or preceding the dynamic TablixMember. Could you please have a try to hide the subreport in group header's member based on page number's value. Please have a try and give the feedback. Thanks, Challen FuChallen Fu [MSFT] MSDN Community Support | Feedback to us Get or Request Code Sample from Microsoft Please remember to mark the replies as answers if they help and unmark them if they provide no help.
Free Windows Admin Tool Kit Click here and download it now
January 31st, 2011 3:20am

Thanks for your reply. I cannot use the page number value because I don't know ahead of time how many pages a particular group will have.--ACG
February 1st, 2011 2:24pm

As you just want to display the subreport in first page, it doesn't matther how many pages you will get, just type in the expression for subreport's hide property =IIF(Globals!PageNumber<>1,true, false)Challen Fu [MSFT] MSDN Community Support | Feedback to us Get or Request Code Sample from Microsoft Please remember to mark the replies as answers if they help and unmark them if they provide no help.
Free Windows Admin Tool Kit Click here and download it now
February 3rd, 2011 5:14am

I want to display the subreport on the first page of every new group. I know the subreport will show on the first page of the first group, but I can't know what the first page of the second group will be.--ACG
February 6th, 2011 9:20am

I want to display the subreport on the first page of every new group. I know the subreport will show on the first page of the first group, but I can't know what the first page of the second group will be.--ACG
Free Windows Admin Tool Kit Click here and download it now
February 6th, 2011 9:20am

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

Other recent topics Other recent topics