View Complete Post
In Sql server reporting service the blank spaces or white spaces are coming in between the subreports, when we place the subreports in the main reports.
If any one know how to remove the blank spaces between the subreports, please reply me. Its very urgent.
I have a footer that I want to show up on the last page only.
I use the following expression for the text box under text box properties --> visability
=IIF(Globals!TotalPages = Globals!PageNumber,
When I run the report in reporting services, it does only print the footer on the last page. When exported to Word, footer prints on all pages.
1. Is my expression ignored in Word for the footer, so I will not be able to do this in the footer?
2. Is there another way to have something print at the bottom of the last page that will be recognized when exported to MS Word (report size will vary based on data returned)?
Any help is appreciated.
Is there any way to supress blank pages from being printed when columns are hidden? This will be a complete annoyance to customers.
What I what to do is set some setting that will cause the blank pages to be omitted when hidden colums shrinks the data down to the point that the width of the document is wider than that of the shown columns.
I created a report with multiy pages and in between every page of data is a blank page. If the Report is Sixteen pages longÃÂ i get eight blank pages. The Body size of the report is 8.5in, 25.475in. The Report porperities or 8.5 x 11in. Each page hasÃÂ a table with a page break at startÃÂ set to true. But I still get blank pages in between the report.
I am getting every other page blank while exporting to the PDF format in SSRS 2008. I have checked the page size, page margin or anything that is crossing my page size.
Everything looks fine, and still I am getting blank pages.
Your suggestions will be really helpful. Thank you in advance.
I am new to SSRS Reporting 2008 and most of the reports I have developed required to export to Excel. This reports are embedded into ASP.NET, developed in C#. Now there is some questions I would like to ask:
1) When I am exporting to Excel, I would like to insert some comment in the some cells in the Excel (comment like where you see a red dot in each cell in Excel, and when mouse over you can see comment of this cell)
2) Is there anyway to put a filter to the header after export to Excel?
I am developing a report with almost 25 columns table and the width of the report is 20pt. But I am changing the visibility of a few columns in run-time so that the resultant width will fit in one page (11pt)(I checked all the margins and resultant width of table. Sum of all the widths are with in the pagesize only). Everything is working fine when i check the report in browser, but when i try to Export to PDF there are alternate white pages, which are corresponding to the hidden columns width i guess.
How to achieve PDF Export without white pages? Also, is there any way to shrink the report to a single page?
I am using SSRS 2005
This is siddiq ali have a problem on sharepoint controls,I hope you will respond to me.
I am trying to add sharepoint controls in sharepoint page or sharepoint blank template but getting problem how can i solved to .My question is cant we use sharepoint or asp .net controls in cant be used directly and save information
without writing code by using designer controls.