Changes related to PDF in SQL Server 2005 Reporting Services

Hi All,

I am working on SQL Server 2005 reporting services. In reports I am required to make changes related to exporting report to PDF. Following are those changes:

1) Change PDF export page format to letter from legal

2) Fix page break to ensure that all details related to a specific issue are viewable on the same page

In reports exporting is done through the control given by services itself. So can any one please guide me regarding how this changes can be done. Please help me ASAP...

Thanks....

For (1), it seems like you should be able to just change the page size of the report. Or do you need to change the size just for PDF? If you are using URL access or SOAP, you can specify page sizes via device info settings. See http://msdn2.microsoft.com/en-us/library/ms154682.aspx

For (2), you will need to modify the RDL; try looking into the KeepTogether and RepeatWith settings on report items.

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RSRDL/htm/rsp_ref_rdl_elements_ae_4ak3.asp|||

With regard to page breaks I can see a KeepTogether property that refers to the whole report but not to individual groups. There is no RepeatWith setting within my rdl (SQL2005).

I would like my report to group on a particular field but don't want it to break before or after the report header / footer. Any idea how I can do this?

Change Password on Database Master Key

We are implementing PCI (Payment Card Industry) and one thing that is required is that we change our encryption keys once a year or when a key custodian leaves. The only way that I have seen to do that is to decrypt all the encrypted data, drop and recreate the symmetric key, the certificate, and database master key, and then re-encrypt the data.

Is there any way to just change the password on the database master key? I understand that if the actual symmetric keys have been breached, that would not be enough, but for routine maintenance, just changing the password on the database master key would seem to be enough.

I have looked and looked, but have not found anyone else that is doing this type of thing. Maybe I am just not looking in the right places. Can anyone offer some guidance? Thank!!!

Jim Youmans

You can regenerate the database master keys (DbMK) using the REGENERATE clause of the ALTER statement. This only re-encrypts the keys encrypted by the DbMK, not the entire set of encrypted data. It is also possible to change the password of a master key; you can have in fact multiple password encryptions of a master key, so you can add a new password encryption and drop the old one.

You can also change the certificate encrypting a key - just encrypt the key with a new certificate and then drop the encryption done with the old certificate.

If you actually want to change the key that encrypts the data, then there is no other way than by decrypting the data and re-encrypting it with a new key.

Thanks
Laurentiu

|||

Thank you so much!!!

Jim Youmans