<pavmani@gmail.com> wrote in message
news:1177682795.912796.140650@r30g2000prh.googlegroups.com...
>I need some help on SQL reporting 2005 -Grouping and page break.
>
> I am displaying list of Lobbyist Names in one my reports order by
> Names.
>
> I want to Group all the names starts with 'A' and introduce page break
> at the end.
>
> Then all the names start with 'B' and show it in next page and so on.
>
> Any idea, please help.
>
> Thanks
>

> You will need to setup two groups, Group 1 with a group expression of the
> first letter of the Lobbyist's name:
>
> group expression:
> =LEFT(Fields!lobbyistname.Value,1)
>
> You can choose not to display group headers and footers.
>
> Also, set Page Break At End on the Edit Group Properties.
> The second group expression will be the name itself.
>
> expression:
> =Fields!lobbyistname.Value
>
> Do not set Page Break at End for Group 2.
>
> Hope this helps.
>
> Rodney Landrum
> Author, Pro SQL Server 2005 Reporting Services.
>
> <pavmani@gmail.com> wrote in message
> news:1177682795.912796.140650@r30g2000prh.googlegroups.com...
>>I need some help on SQL reporting 2005 -Grouping and page break.
>>
>> I am displaying list of Lobbyist Names in one my reports order by
>> Names.
>>
>> I want to Group all the names starts with 'A' and introduce page break
>> at the end.
>>
>> Then all the names start with 'B' and show it in next page and so on.
>>
>> Any idea, please help.
>>
>> Thanks
>>
>
>

On Apr 27, 12:28 pm, "Rodney Landrum" <rlandru...@cox.net> wrote:
> You will need to setup two groups, Group 1 with a group expression of the
> first letter of the Lobbyist's name:
>
> group expression:
> =LEFT(Fields!lobbyistname.Value,1)
>
> You can choose not to display group headers and footers.
>
> Also, set Page Break At End on the Edit Group Properties.
> The second group expression will be the name itself.
>
> expression:
> =Fields!lobbyistname.Value
>
> Do not set Page Break at End for Group 2.
>
> Hope this helps.
>
> Rodney Landrum
> Author, Pro SQL Server 2005 Reporting Services.
>
> <pavm...@gmail.com> wrote in message
>
> news:1177682795.912796.140650@r30g2000prh.googlegroups.com...
>
>
>
> >I need some help on SQL reporting 2005 -Grouping and page break.
>
> > I am displaying list of Lobbyist Names in one my reports order by
> > Names.
>
> > I want to Group all the names starts with 'A' and introduce page break
> > at the end.
>
> > Then all the names start with 'B' and show it in next page and so on.
>
> > Any idea, please help.
>
> > Thanks- Hide quoted text -
>
> - Show quoted text -