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 the sheet name while exporting sql data to excel

i have designed a rdl form which contains 3 tables .. i gave page break for each table. when exporting the file to excel it generates 3 sheets .. three sheets name comes like sheet 1, sheet2 ,sheet3.. i dont want it to be like these.. instead of that i have to give my own name while generating reports from rdl form like this (s1,s2,s3)...

it is not possible to change the sheet name but have a label (Label property) for each table and that will give you document map in the excel sheet.

Shyam

|||

T hank you brother...

|||

Hi,

Thank you for the Tip.

Another question in the Document Map it creates an entry for the report Name and adds all the labels for that report.

Is it possible to change the report name in the document map without chainging it for the file?

Thank you,

Paul

Just found That http://forums.microsoft.com/TechNet/ShowPost.aspx?PostID=207848&SiteID=17

change the sheet name while exporting sql data to excel

i have designed a rdl form which contains 3 tables .. i gave page break for each table. when exporting the file to excel it generates 3 sheets .. three sheets name comes like sheet 1, sheet2 ,sheet3.. i dont want it to be like these.. instead of that i have to give my own name while generating reports from rdl form like this (s1,s2,s3)...

Sorry, but this isn't supported yet.

Jarret

change the sheet name while exporting sql data to excel

i have designed a rdl form which contains 3 tables .. i gave page break for each table. when exporting the file to excel it generates 3 sheets .. three sheets name comes like sheet 1, sheet2 ,sheet3.. i dont want it to be like these.. instead of that i have to give my own name while generating reports from rdl form like this (s1,s2,s3)...

it is not possible to change the sheet name but have a label (Label property) for each table and that will give you document map in the excel sheet.

Shyam

|||

T hank you brother...

|||

Hi,

Thank you for the Tip.

Another question in the Document Map it creates an entry for the report Name and adds all the labels for that report.

Is it possible to change the report name in the document map without chainging it for the file?

Thank you,

Paul

Just found That http://forums.microsoft.com/TechNet/ShowPost.aspx?PostID=207848&SiteID=17

change the sheet name while exporting datagrid data to

Hi,
I am having trouble renaming the excel sheet while exporting to excel.
we have a rdl file that contains some analytical data. I have the name to the
excel file as "temp.xls" inside the code. When the user clicks on the Export
to Excel button next to datagrid, it opens a popup with options Open, Save
and Cancel. When I click open, it opens the excel sheet with the sheet name
as .xls[temp[1] and the excel filename as temp[1].xls. As a result when the
user selects the data and try to use pivot table with that data it is giving
an error. I am thinking if I change the sheetname, then the pivot table would
work. Please let me know.
Thanks,
raj.
EggHeadCafe.com - .NET Developer Portal of Choice
http://www.eggheadcafe.comI use xslt to auto name the sheets.
<Worksheet>
<xsl:attribute name="ss:Name">
<xsl:value-of select="yourSheetName"/>
</xsl:attribute>
I export from Gridview to Excel, where I may have 100 sheets in my Excel so each sheet has a unique name.
Also see: george wesolowski's net blog and do a search on "excel" or "xslt".
Lynne
EggHeadCafe.com - .NET Developer Portal of Choice
http://www.eggheadcafe.com