Reporting Services Questions

Hi there,
Just started using Reporting Services instead of Crystal Reports and have a
few questions:
1.) In Crystal, I can add a details section and hide it 'not
onfirstrecord'...which essentially hides all instances of it except the first
one. This allows me to add headers to details in drill-down down reports and
not have them repeat. Is there any way in RS to reference the first instance
of a record and thereby suppress the other instances of it in the Visibility
section?
2.) Is the printing issue in RS going to be addressed anytime soon? (you
have to export RS to excel or adobe for it to print properly right now). I
heard this will be addressed in the next service pack...any idea when this is
going to be out?
Thanks for any ideas on this!
CraigI don't know the answer to #1. MS has stated that client side printing will
be in SP2. No date yet for SP2 has been announced.
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Craig R" <Craig R@.discussions.microsoft.com> wrote in message
news:2544345C-7E15-42F9-A27D-13FDF1D16B06@.microsoft.com...
> Hi there,
> Just started using Reporting Services instead of Crystal Reports and have
a
> few questions:
> 1.) In Crystal, I can add a details section and hide it 'not
> onfirstrecord'...which essentially hides all instances of it except the
first
> one. This allows me to add headers to details in drill-down down reports
and
> not have them repeat. Is there any way in RS to reference the first
instance
> of a record and thereby suppress the other instances of it in the
Visibility
> section?
> 2.) Is the printing issue in RS going to be addressed anytime soon? (you
> have to export RS to excel or adobe for it to print properly right now).
I
> heard this will be addressed in the next service pack...any idea when this
is
> going to be out?
> Thanks for any ideas on this!
> Craig
>|||The answer to your first question is yes - you can do that. In the grid, go
into the cell that contains the value that you don't want to have repeated.
Go to its properties and check the box labeled "hide duplicates". Then in
the box below it, select the grouping field that you don't want duplicated.
It will then only display that field value on the report when it changes. It
works - I'm using it on several reports.
sebring1130
"Craig R" wrote:
> Hi there,
> Just started using Reporting Services instead of Crystal Reports and have a
> few questions:
> 1.) In Crystal, I can add a details section and hide it 'not
> onfirstrecord'...which essentially hides all instances of it except the first
> one. This allows me to add headers to details in drill-down down reports and
> not have them repeat. Is there any way in RS to reference the first instance
> of a record and thereby suppress the other instances of it in the Visibility
> section?
> 2.) Is the printing issue in RS going to be addressed anytime soon? (you
> have to export RS to excel or adobe for it to print properly right now). I
> heard this will be addressed in the next service pack...any idea when this is
> going to be out?
> Thanks for any ideas on this!
> Craig
>