Saturday, February 25, 2012

Multiple Sections in a Report

Hi
I was wondering, I previously worked with Crystal Reports and in this
offered the functionality of Multiple Sections, in the Report Header/Footer,
Page Header/Footer, Group Header/Footer and multiple Detail Sections, I
cannot seem to work out how to do this in SSRS, whilst building reports?
--
Kind regards
Ricky
(SS2005/SSRS2005)On Jun 23, 10:57 am, "Ricky" <r...@.msn.com> wrote:
> Hi
> I was wondering, I previously worked with Crystal Reports and in this
> offered the functionality of Multiple Sections, in the Report Header/Footer,
> Page Header/Footer, Group Header/Footer and multiple Detail Sections, I
> cannot seem to work out how to do this in SSRS, whilst building reports?
> --
> Kind regards
> Ricky
> (SS2005/SSRS2005)
As far as I know, in SSRS, you can only create a single header and
single footer (via the Layout view -> Report drop-down -> Page Header/
Page Footer). If you are using table/matrix controls, you are able to
use multiple group headers and footers; and using a table/matrix
control, you can have multiple detail rows. While this is not exactly
the same as in CR, it should get you by. Hope this helps.
Regards,
Enrique Martinez
Sr. Software Consultant|||Hi Enrique
Shame that this is the case, do you not think this is somewhat restricting,
I thought that MS would have been able to implement something like this
quite easily...
Perhaps SS2008, may bring some enhancements?
Kind regards
Ricky
"EMartinez" <emartinez.pr1@.gmail.com> wrote in message
news:1182645968.089622.279980@.p77g2000hsh.googlegroups.com...
> On Jun 23, 10:57 am, "Ricky" <r...@.msn.com> wrote:
>> Hi
>> I was wondering, I previously worked with Crystal Reports and in this
>> offered the functionality of Multiple Sections, in the Report
>> Header/Footer,
>> Page Header/Footer, Group Header/Footer and multiple Detail Sections, I
>> cannot seem to work out how to do this in SSRS, whilst building reports?
>> --
>> Kind regards
>> Ricky
>> (SS2005/SSRS2005)
>
> As far as I know, in SSRS, you can only create a single header and
> single footer (via the Layout view -> Report drop-down -> Page Header/
> Page Footer). If you are using table/matrix controls, you are able to
> use multiple group headers and footers; and using a table/matrix
> control, you can have multiple detail rows. While this is not exactly
> the same as in CR, it should get you by. Hope this helps.
> Regards,
> Enrique Martinez
> Sr. Software Consultant
>|||On Jun 24, 8:00 am, "Ricky" <r...@.msn.com> wrote:
> Hi Enrique
> Shame that this is the case, do you not think this is somewhat restricting,
> I thought that MS would have been able to implement something like this
> quite easily...
> Perhaps SS2008, may bring some enhancements?
> Kind regards
> Ricky
> "EMartinez" <emartinez...@.gmail.com> wrote in message
> news:1182645968.089622.279980@.p77g2000hsh.googlegroups.com...
> > On Jun 23, 10:57 am, "Ricky" <r...@.msn.com> wrote:
> >> Hi
> >> I was wondering, I previously worked with Crystal Reports and in this
> >> offered the functionality of Multiple Sections, in the Report
> >> Header/Footer,
> >> Page Header/Footer, Group Header/Footer and multiple Detail Sections, I
> >> cannot seem to work out how to do this in SSRS, whilst building reports?
> >> --
> >> Kind regards
> >> Ricky
> >> (SS2005/SSRS2005)
> > As far as I know, in SSRS, you can only create a single header and
> > single footer (via the Layout view -> Report drop-down -> Page Header/
> > Page Footer). If you are using table/matrix controls, you are able to
> > use multiple group headers and footers; and using a table/matrix
> > control, you can have multiple detail rows. While this is not exactly
> > the same as in CR, it should get you by. Hope this helps.
> > Regards,
> > Enrique Martinez
> > Sr. Software Consultant
I checked out the SQL Server 2008 White Papers and I haven't seen
mention of it so far; of course, it is still in Beta 1 at this point
so you never know.
Regards,
Enrique Martinez
Sr. Software Consultant
`

No comments:

Post a Comment