HELP - Page break after 2 groups, 2 groups per page

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Rob 'Spike' Stevens - 29 Sep 2006 18:18 GMT

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?

Reply to this Message

Rob 'Spike' Stevens - 29 Sep 2006 23:49 GMT

Ok, I found a way, and thought I'd shart

> 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...
[quoted text clipped - 27 lines]
>
> Can anyone help me?

Reply to this Message

Rob 'Spike' Stevens - 29 Sep 2006 23:55 GMT

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.

> 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...
[quoted text clipped - 27 lines]
>
> Can anyone help me?

Reply to this Message