Encrypting subscription generated emails SSRS 2000 or 2005

I need to be able to encrypt emails and/or attachments that are generated by
subscriptions but I have been able to find a way to set this attribute the
same way you can with traditional emails.
Any pointers would be very appreciated
--
John ShahanOf course I MEANT to write "I have NOT been able to find a way..."
Sorry
--
John Shahan
"jp" wrote:
> I need to be able to encrypt emails and/or attachments that are generated by
> subscriptions but I have been able to find a way to set this attribute the
> same way you can with traditional emails.
> Any pointers would be very appreciated
> --
> John Shahansql

Encrypt Report Attachments (through Subscriptions) -- possible?

We currently email out reports as either PDF or Excel attachments using Data Driven subscriptions in SSRS 2005. I've been asked to be able to encrypt the attachments and am wondering if anyone has done this or can point me in the right direction.

There's been a couple of mentions about "encrypted email" -- but I don't know where to find further information. Is this possible using SSRS subscriptions?

Thanks in advance,

- Jesse Wolgamott

Currenlty, the way to do this is to write a custom delivery extension. The one provided with reporting servcies does not support encrypting the report.

-Lukasz

|||Thanks!

For people who are reading this later on, more information about custom delivery extensions is here: http://msdn2.microsoft.com/en-us/library/ms154050.aspx

Encrypt Report Attachments (through Subscriptions) -- possible?

We currently email out reports as either PDF or Excel attachments using Data Driven subscriptions in SSRS 2005. I've been asked to be able to encrypt the attachments and am wondering if anyone has done this or can point me in the right direction.

There's been a couple of mentions about "encrypted email" -- but I don't know where to find further information. Is this possible using SSRS subscriptions?

Thanks in advance,

- Jesse Wolgamott

Currenlty, the way to do this is to write a custom delivery extension. The one provided with reporting servcies does not support encrypting the report.

-Lukasz

|||Thanks!

For people who are reading this later on, more information about custom delivery extensions is here: http://msdn2.microsoft.com/en-us/library/ms154050.aspx

Encrypt Report Attachments (through Subscriptions) -- possible?

We currently email out reports as either PDF or Excel attachments using Data Driven subscriptions in SSRS 2005. I've been asked to be able to encrypt the attachments and am wondering if anyone has done this or can point me in the right direction.

There's been a couple of mentions about "encrypted email" -- but I don't know where to find further information. Is this possible using SSRS subscriptions?

Thanks in advance,

- Jesse Wolgamott

Currenlty, the way to do this is to write a custom delivery extension. The one provided with reporting servcies does not support encrypting the report.

-Lukasz

|||Thanks!

For people who are reading this later on, more information about custom delivery extensions is here: http://msdn2.microsoft.com/en-us/library/ms154050.aspx

enabling anonymous access to reports

I'm developing an SSRS 2000 solution that will require allowing anyone in
the company to view certain reports but only a select few to create them
(while I administer the site).
I understand how to add users specifically (Windows NT logins) and assign
them roles, so I'm partway there. What I can't see is how to also enable
anonymous access, either generally or to specific reports or report folders.
If I turn anonymous access on in IIS for the Reports and/or Reportserver
folders, I lose the ability to administer the site. If I turn it off,
anonymous users can't get in. Security seems either black or white and I'm
looking for some shade of grey. I've tried numerous combinations of
settings and nothing has worked. I've added the server's IUSR account to
the SSRS solution but it didn't make any difference. Guest account is
disabled on the server.
What am I missing here? Is it an IAS problem? Note that IAS is on but not
registered in Active Directory for this server (IT is resisting enabling
that) so I hope that's not the problem here.
Thanks all,
Randall ArnoldSorry, posted to wrong group.
Randall
"Randall Arnold" <randall.nospam.arnold@.nokia.com.> wrote in message
news:1158332929.797373@.xnews001...
> I'm developing an SSRS 2000 solution that will require allowing anyone in
> the company to view certain reports but only a select few to create them
> (while I administer the site).
> I understand how to add users specifically (Windows NT logins) and assign
> them roles, so I'm partway there. What I can't see is how to also enable
> anonymous access, either generally or to specific reports or report
> folders. If I turn anonymous access on in IIS for the Reports and/or
> Reportserver folders, I lose the ability to administer the site. If I
> turn it off, anonymous users can't get in. Security seems either black or
> white and I'm looking for some shade of grey. I've tried numerous
> combinations of settings and nothing has worked. I've added the server's
> IUSR account to the SSRS solution but it didn't make any difference.
> Guest account is disabled on the server.
> What am I missing here? Is it an IAS problem? Note that IAS is on but not
> registered in Active Directory for this server (IT is resisting enabling
> that) so I hope that's not the problem here.
> Thanks all,
> Randall Arnold
>

enabling anonymous access to reports

I'm developing an SSRS 2000 solution that will require allowing anyone in
the company to view certain reports but only a select few to create them
(while I administer the site).
I understand how to add users specifically (Windows NT logins) and assign
them roles, so I'm partway there. What I can't see is how to also enable
anonymous access, either generally or to specific reports or report folders.
If I turn anonymous access on in IIS for the Reports and/or Reportserver
folders, I lose the ability to administer the site. If I turn it off,
anonymous users can't get in. Security seems either black or white and I'm
looking for some shade of grey. I've tried numerous combinations of
settings and nothing has worked. I've added the server's IUSR account to
the SSRS solution but it didn't make any difference. Guest account is
disabled on the server.
What am I missing here? Is it an IAS problem? Note that IAS is on but not
registered in Active Directory for this server (IT is resisting enabling
that) so I hope that's not the problem here.
Thanks all,
Randall ArnoldSorry, posted to wrong group.
Randall
"Randall Arnold" <randall.nospam.arnold@.nokia.com.> wrote in message
news:1158332929.797373@.xnews001...
> I'm developing an SSRS 2000 solution that will require allowing anyone in
> the company to view certain reports but only a select few to create them
> (while I administer the site).
> I understand how to add users specifically (Windows NT logins) and assign
> them roles, so I'm partway there. What I can't see is how to also enable
> anonymous access, either generally or to specific reports or report
> folders. If I turn anonymous access on in IIS for the Reports and/or
> Reportserver folders, I lose the ability to administer the site. If I
> turn it off, anonymous users can't get in. Security seems either black or
> white and I'm looking for some shade of grey. I've tried numerous
> combinations of settings and nothing has worked. I've added the server's
> IUSR account to the SSRS solution but it didn't make any difference.
> Guest account is disabled on the server.
> What am I missing here? Is it an IAS problem? Note that IAS is on but not
> registered in Active Directory for this server (IT is resisting enabling
> that) so I hope that's not the problem here.
> Thanks all,
> Randall Arnold
>

enabling anonymous access to reports

I'm developing an SSRS 2000 solution that will require allowing anyone in
the company to view certain reports but only a select few to create them
(while I administer the site).
I understand how to add users specifically (Windows NT logins) and assign
them roles, so I'm partway there. What I can't see is how to also enable
anonymous access, either generally or to specific reports or report folders.
If I turn anonymous access on in IIS for the Reports and/or Reportserver
folders, I lose the ability to administer the site. If I turn it off,
anonymous users can't get in. Security seems either black or white and I'm
looking for some shade of grey. I've tried numerous combinations of
settings and nothing has worked. I've added the server's IUSR account to
the SSRS solution but it didn't make any difference. Guest account is
disabled on the server.
What am I missing here? Is it an IAS problem? Note that IAS is on but not
registered in Active Directory for this server (IT is resisting enabling
that) so I hope that's not the problem here.
Thanks all,
Randall Arnold
Sorry, posted to wrong group.
Randall
"Randall Arnold" <randall.nospam.arnold@.nokia.com.> wrote in message
news:1158332929.797373@.xnews001...
> I'm developing an SSRS 2000 solution that will require allowing anyone in
> the company to view certain reports but only a select few to create them
> (while I administer the site).
> I understand how to add users specifically (Windows NT logins) and assign
> them roles, so I'm partway there. What I can't see is how to also enable
> anonymous access, either generally or to specific reports or report
> folders. If I turn anonymous access on in IIS for the Reports and/or
> Reportserver folders, I lose the ability to administer the site. If I
> turn it off, anonymous users can't get in. Security seems either black or
> white and I'm looking for some shade of grey. I've tried numerous
> combinations of settings and nothing has worked. I've added the server's
> IUSR account to the SSRS solution but it didn't make any difference.
> Guest account is disabled on the server.
> What am I missing here? Is it an IAS problem? Note that IAS is on but not
> registered in Active Directory for this server (IT is resisting enabling
> that) so I hope that's not the problem here.
> Thanks all,
> Randall Arnold
>

enabling anonymous access

I'm developing an SSRS 2000 solution that will require allowing anyone in
the company to view certain reports but only a select few to create them
(while I administer the site).
I understand how to add users specifically (Windows NT logins) and assign
them roles, so I'm partway there. What I can't see is how to also enable
anonymous access, either generally or to specific reports or report folders.
If I turn anonymous access on in IIS for the Reports and/or Reportserver
folders, I lose the ability to administer the site. If I turn it off,
anonymous users can't get in. Security seems either black or white and I'm
looking for some shade of grey. I've tried numerous combinations of
settings and nothing has worked. I've added the server's IUSR account to
the SSRS solution but it didn't make any difference. Guest account is
disabled on the server.
What am I missing here? Is it an IAS problem? Note that IAS is on but not
registered in Active Directory for this server (IT is resisting enabling
that) so I hope that's not the problem here.
Thanks all,
Randall ArnoldYou don't have to do individual users. You can also use groups. Almost all
domains have a group that includes everybody (for instance a group called
Users). Just add this group to the browser roll.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Randall Arnold" <randall.nospam.arnold@.nokia.com.> wrote in message
news:1158332996.554286@.xnews001...
> I'm developing an SSRS 2000 solution that will require allowing anyone in
> the company to view certain reports but only a select few to create them
> (while I administer the site).
> I understand how to add users specifically (Windows NT logins) and assign
> them roles, so I'm partway there. What I can't see is how to also enable
> anonymous access, either generally or to specific reports or report
> folders.
> If I turn anonymous access on in IIS for the Reports and/or Reportserver
> folders, I lose the ability to administer the site. If I turn it off,
> anonymous users can't get in. Security seems either black or white and
> I'm
> looking for some shade of grey. I've tried numerous combinations of
> settings and nothing has worked. I've added the server's IUSR account to
> the SSRS solution but it didn't make any difference. Guest account is
> disabled on the server.
> What am I missing here? Is it an IAS problem? Note that IAS is on but not
> registered in Active Directory for this server (IT is resisting enabling
> that) so I hope that's not the problem here.
> Thanks all,
> Randall Arnold
>
>|||We have a User group that I tried but no luck. But your general idea should
be sound so I'll keep digging, thanks.
Randall Arnold
"Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
news:eQh%23kfO2GHA.1040@.TK2MSFTNGP06.phx.gbl...
> You don't have to do individual users. You can also use groups. Almost all
> domains have a group that includes everybody (for instance a group called
> Users). Just add this group to the browser roll.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Randall Arnold" <randall.nospam.arnold@.nokia.com.> wrote in message
> news:1158332996.554286@.xnews001...
>> I'm developing an SSRS 2000 solution that will require allowing anyone in
>> the company to view certain reports but only a select few to create them
>> (while I administer the site).
>> I understand how to add users specifically (Windows NT logins) and assign
>> them roles, so I'm partway there. What I can't see is how to also enable
>> anonymous access, either generally or to specific reports or report
>> folders.
>> If I turn anonymous access on in IIS for the Reports and/or Reportserver
>> folders, I lose the ability to administer the site. If I turn it off,
>> anonymous users can't get in. Security seems either black or white and
>> I'm
>> looking for some shade of grey. I've tried numerous combinations of
>> settings and nothing has worked. I've added the server's IUSR account to
>> the SSRS solution but it didn't make any difference. Guest account is
>> disabled on the server.
>> What am I missing here? Is it an IAS problem? Note that IAS is on but
>> not
>> registered in Active Directory for this server (IT is resisting enabling
>> that) so I hope that's not the problem here.
>> Thanks all,
>> Randall Arnold
>>
>|||What I do that simplifies things for me is I create a local group (called
something like Reports). I then add the domain groups and users to it. I
then use this local group to add to a role.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Randall Arnold" <randall.nospam.arnold@.nokia.com.> wrote in message
news:1158362815.849245@.xnews001...
> We have a User group that I tried but no luck. But your general idea
> should be sound so I'll keep digging, thanks.
> Randall Arnold
> "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
> news:eQh%23kfO2GHA.1040@.TK2MSFTNGP06.phx.gbl...
>> You don't have to do individual users. You can also use groups. Almost
>> all domains have a group that includes everybody (for instance a group
>> called Users). Just add this group to the browser roll.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "Randall Arnold" <randall.nospam.arnold@.nokia.com.> wrote in message
>> news:1158332996.554286@.xnews001...
>> I'm developing an SSRS 2000 solution that will require allowing anyone
>> in
>> the company to view certain reports but only a select few to create them
>> (while I administer the site).
>> I understand how to add users specifically (Windows NT logins) and
>> assign
>> them roles, so I'm partway there. What I can't see is how to also
>> enable
>> anonymous access, either generally or to specific reports or report
>> folders.
>> If I turn anonymous access on in IIS for the Reports and/or Reportserver
>> folders, I lose the ability to administer the site. If I turn it off,
>> anonymous users can't get in. Security seems either black or white and
>> I'm
>> looking for some shade of grey. I've tried numerous combinations of
>> settings and nothing has worked. I've added the server's IUSR account
>> to
>> the SSRS solution but it didn't make any difference. Guest account is
>> disabled on the server.
>> What am I missing here? Is it an IAS problem? Note that IAS is on but
>> not
>> registered in Active Directory for this server (IT is resisting enabling
>> that) so I hope that's not the problem here.
>> Thanks all,
>> Randall Arnold
>>
>>
>

Empty page 1 on short reports?

I have a suite of several SSRS reports that differ essentially on the stored procedure called. All have very the same one-page header block and all have a footer. Those where a large number of pages are produced, page without fault when printed or converted to PDF.

Two page reports often break down on printing, so that page 1 only has the header and a footer and all the detail lines are printed on page2 (together with the footer). However on the screen the report paged correctly.

I have checked all the obvious problems such as page dimensions exceeding that of the print medium. (A series of such problems was fixed earlier in development.)

I have observed this behaviour with SQL2005 SP1 and SP2 (i.e. SP2 did not provide any fix in this area). The host OS for development and production is Windows 2003 server. The tests were done by viewing in IE6 and the fault only became apparent when going to print preview, printing or in PDF production.

This has the appearance of a bug in SSRS hereby intermediate length reports are not handled correctly. It appears to happen when the amount of detail lines just fills page 2. As soon as the report has sufficient lines to be 3 pages long (page 1 is header plus some details lines plus footer, page 2 is full of detail lines plus footer and page 3 is remaining detail lines plus footer then the problem is no longer seen! Where the detail lines will all fit on page 1, then the problem is not seen.

I observe this variation in behaviour since I am able to switch between different sized datasets and thus switch between the different scenarios described above. I should also note that the reports are in landscape mode.

This behaviour has since been reproduced in a test scenario. There is one detail missing from the above scenario - instead of printing each record from the dataset, the records were (unneccessarily) grouped. The grouping was unncessary insofar as the table the program reports from is already grouped.|||

Further testing has show some rather odd behaviour. Using a test system I have arranged that I can readily select for the report a dataset with from 1 to 100 records.

The following tests are for running the report, bringing up the print dialog and going to the print preview. (I have previously established that the print behaviour is the same as the print preview behavious in respect to the blank first page problem.

With from 1 to 15 records it prints the first page heading, detail lines and a footer. This is expected behaviour.

From 23 to 40 records it prints the first page heading, detail lines, a footer, new page, detail lines and a footer. This is expected behaviour

From 41 records it prints the first page heading, detail lines, a footer, new page, detail lines, a footer, new page, details line(s) and a footer. This is expected behaviour.

However from 16 to 22 records it prints the first page heading, a footer, new page, detail lines and a footer. This is unexpected behaviour as details should be printed on both page 1 and page 2.

I have repeated the test with a report that just prints details lines as opposed to grouping then and this anomalous behaviour does not occur.

|||

Have you set the KeepTogether property of your table to true?

Shyam

Empty page 1 on short reports?

I have a suite of several SSRS reports that differ essentially on the stored procedure called. All have very the same one-page header block and all have a footer. Those where a large number of pages are produced, page without fault when printed or converted to PDF.

Two page reports often break down on printing, so that page 1 only has the header and a footer and all the detail lines are printed on page2 (together with the footer). However on the screen the report paged correctly.

I have checked all the obvious problems such as page dimensions exceeding that of the print medium. (A series of such problems was fixed earlier in development.)

I have observed this behaviour with SQL2005 SP1 and SP2 (i.e. SP2 did not provide any fix in this area). The host OS for development and production is Windows 2003 server. The tests were done by viewing in IE6 and the fault only became apparent when going to print preview, printing or in PDF production.

This has the appearance of a bug in SSRS hereby intermediate length reports are not handled correctly. It appears to happen when the amount of detail lines just fills page 2. As soon as the report has sufficient lines to be 3 pages long (page 1 is header plus some details lines plus footer, page 2 is full of detail lines plus footer and page 3 is remaining detail lines plus footer then the problem is no longer seen! Where the detail lines will all fit on page 1, then the problem is not seen.

I observe this variation in behaviour since I am able to switch between different sized datasets and thus switch between the different scenarios described above. I should also note that the reports are in landscape mode.

This behaviour has since been reproduced in a test scenario. There is one detail missing from the above scenario - instead of printing each record from the dataset, the records were (unneccessarily) grouped. The grouping was unncessary insofar as the table the program reports from is already grouped.|||

Further testing has show some rather odd behaviour. Using a test system I have arranged that I can readily select for the report a dataset with from 1 to 100 records.

The following tests are for running the report, bringing up the print dialog and going to the print preview. (I have previously established that the print behaviour is the same as the print preview behavious in respect to the blank first page problem.

With from 1 to 15 records it prints the first page heading, detail lines and a footer. This is expected behaviour.

From 23 to 40 records it prints the first page heading, detail lines, a footer, new page, detail lines and a footer. This is expected behaviour

From 41 records it prints the first page heading, detail lines, a footer, new page, detail lines, a footer, new page, details line(s) and a footer. This is expected behaviour.

However from 16 to 22 records it prints the first page heading, a footer, new page, detail lines and a footer. This is unexpected behaviour as details should be printed on both page 1 and page 2.

I have repeated the test with a report that just prints details lines as opposed to grouping then and this anomalous behaviour does not occur.

|||

Have you set the KeepTogether property of your table to true?

Shyam