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
>

Reporting Services Preferences

Is it possible to default Zoom to 'Whole Page' instead of 100% in Reporting
Services (not through a custom application). I understand that I can
manually do it each time I ran a report but I was wondering about some kind
of custom preferences setting.
Thank you.No, this is only possible if you are hosting URL access yourself.
--
Brian Welcker
Group Program Manager
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"andrei" <andrei@.discussions.microsoft.com> wrote in message
news:75738583-F950-4E38-9773-5EC7743B1DD7@.microsoft.com...
> Is it possible to default Zoom to 'Whole Page' instead of 100% in
> Reporting
> Services (not through a custom application). I understand that I can
> manually do it each time I ran a report but I was wondering about some
> kind
> of custom preferences setting.
> Thank you.|||Thank you.
"Brian Welcker [MSFT]" wrote:
> No, this is only possible if you are hosting URL access yourself.
> --
> Brian Welcker
> Group Program Manager
> SQL Server Reporting Services
> This posting is provided "AS IS" with no warranties, and confers no rights.
> "andrei" <andrei@.discussions.microsoft.com> wrote in message
> news:75738583-F950-4E38-9773-5EC7743B1DD7@.microsoft.com...
> > Is it possible to default Zoom to 'Whole Page' instead of 100% in
> > Reporting
> > Services (not through a custom application). I understand that I can
> > manually do it each time I ran a report but I was wondering about some
> > kind
> > of custom preferences setting.
> > Thank you.
>
>|||Do you have any future plans to give more control over the page/menu setting?
Thank you.
"Brian Welcker [MSFT]" wrote:
> No, this is only possible if you are hosting URL access yourself.
> --
> Brian Welcker
> Group Program Manager
> SQL Server Reporting Services
> This posting is provided "AS IS" with no warranties, and confers no rights.
> "andrei" <andrei@.discussions.microsoft.com> wrote in message
> news:75738583-F950-4E38-9773-5EC7743B1DD7@.microsoft.com...
> > Is it possible to default Zoom to 'Whole Page' instead of 100% in
> > Reporting
> > Services (not through a custom application). I understand that I can
> > manually do it each time I ran a report but I was wondering about some
> > kind
> > of custom preferences setting.
> > Thank you.
>
>

Reporting Services on Internet

Hi,
I am doing some researches about how the reporting services can be use on
the public (internet) instead of just intranet. Could someone please give me
a hint (link / sample) about how this can be achived and how security is this
on the internet.
Thanks
EdOn Apr 22, 9:52 pm, Ed <E...@.discussions.microsoft.com> wrote:
> Hi,
> I am doing some researches about how the reporting services can be use on
> the public (internet) instead of just intranet. Could someone please give me
> a hint (link / sample) about how this can be achived and how security is this
> on the internet.
> Thanks
> Ed
These 2 links are to web hosting sites for SSRS. They might be able to
provide some detailed answers.
http://www.webhost4life.com/sql2005_hosting.asp
http://www.appliedi.net/shared-hosting/
Regards,
Enrique Martinez
Sr. Software Consultant|||You have probably read this background article on your topic already but
JIC:
http://www.devx.com/dotnet/Article/27133
As far as security goes,
http://www.webhost4life.com/kb/question.php?qstId=209 will show you how you
can do it if you don't *care* about security <shrug>.
One good idea would be to be sure and use SSL for this purpose on top of
whatever else you decide.
Another good idea would be to write a security extension for forms
authentication -- (but read this short post first
http://msmvps.com/blogs/anguslogan/archive/2004/10/03/14772.aspx)
I think there is a sample of doing this
http://blogs.msdn.com/bimusings/archive/2005/12/05/500195.aspx -- if you
can't find the sample read this blog post
http://weblogs.asp.net/plip/archive/2006/09/21/Microsoft-Documentation-_2D00_-Where-is-the-sample-code_3F00_.aspx
and here is an article (with source) doing something like what you need
http://www.sqlmag.com/Articles/ArticleID/93830/93830.html
I am wracking my brains for where I saw a good general overview on extension
writing for RS from an MS blog -- here it is, it's not long and it's very
useful perspective)
http://blogs.msdn.com/bryanke/archive/2004/03/16/90797.aspx
Last but not least, security issues have to be discussed with this caveat:
receiving permissions have to be handled differently if you are integrating
with Sharepoint. So if you're doing that be sure to ask the question "is
this applicable in a Sharepoint integration scenario" before sweating over
it!
HTH,
>L<
"Ed" <Ed@.discussions.microsoft.com> wrote in message
news:D11FD871-A11D-4472-B5ED-CCC27ED6F09A@.microsoft.com...
> Hi,
> I am doing some researches about how the reporting services can be use on
> the public (internet) instead of just intranet. Could someone please give
> me
> a hint (link / sample) about how this can be achived and how security is
> this
> on the internet.
> Thanks
> Ed