Ok, I figured it out, and thought I would share it with you.
1. Placed code below in the Code section of your report properties:
Public GroupRowCounter As Integer = 0
Public GroupName as string =""'
Function IncrementCounter(strGroup as string) As string
if GroupName <> strGroup then
GroupRowCounter += 1
GroupName = strGroup
end if
Return (GroupRowCounter -1)\2
End Function
2. In the dataset for you Report, add a calculated field, I called mine
Grouper.
3. Code.IncrementCounter(Fields.TheOneYoureTryingToGroupNperPage.value)
4. On your report, add a group immideately above the group level you want
per page using Grouper. Set page break at end.
5. Remove page breaks from any internal grouping that no loner need them.
[quoted text, click to view] "Rob 'Spike' Stevens" wrote:
> I have a requirement to condense my report length. Each group is about 40%
> of the page length, so 2 per page would fit nicely...
>
> ...but I can't figure out a way. For performance reasons, I have the data
> filtered in the table object.
>
> I have tried several things:
> 1. (Runningvalue(Fields!StoreID.Value,CountDistinct,nothing)-1) \ 2 counts
> my groups correctly, but I am not able to use it RunningValue in a SRS
> grouping.
>
> 2. Created a counter with code found in this newsgroup. This also counts my
> groups correctly, and I can use it in a Group, but it doesnt seem to help me
> no matter where I put the IncrelentCounter or GetCounter statements.
> Public GroupRowCounter As Integer = 0
>
> Function IncrementCounter() As Integer
> GroupRowCounter += 1
> Return GroupRowCounter
> End Function
>
> Function GetCounter() As Integer
> Return GroupRowCounter
> End Function
>
> 3. I've tried putting the Increment in group2 and the Get in group1, and
> that didnt help. I tried putting the increment in group1 and the get in
> group2 and nothing changes. I admit I may be putting the Increment and Get in
> the wrong places, but I can't seem to see it.
>
> Can anyone help me?
