Printing Issue in SSRS reports

Hi,
We developed around 70 ssrs reports for our new application.Its like,all the report names are mentioned in the left hand side and if we click it,.Net calls the SSRS reports and shows in the Right hand side.
The issue now is with the Printing.My client complains that they are not able to print the Reports properly.Some of the columns are moved to the next page,it seems.Reports are having different number of columns and we dont know how to resolve this issue.Should
I use Landscape or Portrait?..If I give the table's width in the place of Report's width,will it work?
Your help would be greatly appreciated.

More Related Resource Links

We are developing reports in SSRS 2008. When printing from the SSRS report page, we are seeing that that some text is "clumping" together or spaced oddly. I have tried a variety of printers so it's not printer-specific. If you export from the SSRS page to PDF or to Word and then print, everything prints as expected.

Nothing is as good as real text/names/data, but to reproduce, simply create several text boxes with...ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz123456789000,000,000.00

A workaround would obviously be to export to PDF and then print, but these are steps that our end users shouldn't have to (and won't want to) put up with to produce reports/invoices/etc. that ultimately go

I am having issues when I print reports with SSRS 2008. We have an web application that uses the Report Viewer control to preview our Reports in a popup window. The preview page shows the report in the correct orientation and so does any report that has
been exported to PDF or Excel file.

The problem arises when we print the report. For some reason any report set to landscape is still being printed in Portrait orientation. The reports have their heights and width properly set, i.e., for portrait reports we have the layout set to 8.5in x 11in
and for landscape reports we have the layout set to 11in x 8.5in.

I have done some research and I did not get a conclusive answer, it seems that this happens because of a bug or maybe because how my ReportViewer object in the aspx page is being set.

We developed reports for SSRS 2005 using SQL Server Business Intelligence Development Studio (Visual Studio 2005).

We migrated these reports for SSRS 2008 using SQL Server Business Intelligence Development Studio (Visual Studio 2008) by opening the Reports project folder in SSRS 2008.

After migration when the report is ran without any changes made in the design mode we get the correct output.

The issue arises when we try to edit the report in the Design mode. In design mode, it shows only 1 'Tablix Filter' Value and loses the rest of the 'Tablix Filter' values. Specifically,
If we try and edit the Tablix properties (In Design mode) all the values in the 'Filters' property disappear.

Our client has a SharePoint (moss2007) site on Windows 2008, SQL2008 R2 Enterprise, and Reporting service is integrated with SharePoint

The authentication on the share point integration is set to windows, else the authentication for the SSAS datasource gives and error

The extranet zone ( forms) and intranet (Customer Forms) and default (Windows) zones are all access from inside the firewall and the reports render in each with no issues, as the datasources are configured to pass a sql username and password.

However, report rendering is a problem from the internet (external site), the following error is displayed:

An unexpected error occurred while connecting to the report server. Verify that the report server is avai

I have a form with an auto-resizing textbox. There are three views on it (Default, Read-only and Print View). I put text until the textbox limit before it expands. I click "Print View". In the Print View, everything works fine, but when I click
"Print Preview", some characters do not appear in the textbox (and when I print, these characters do not appear too).

HI
i have a SSRS 2005 report with width as 32 inches
i have a requirement to print the report in a3 landscape
but when i print the report it comes in 3 page width
is there any way to auto scale the report into a3 size without affecting the view in the report viewer
Thanks
varun kumar

We are getting this error: "An error occurred during printing. (0x8000405)" from time to time - 70% of the time when we are trying to use a printer button within report manager. It happens if we preview report or just print it.
We noticed if we restart RS services, the error will stop for a little bit and then starts again. We don't print that much and it will come back after just a few reports printed.
Let me know if you had a similar issue. thanks!

Hi All,
Having an issue with SSRS 2008 at the moment, trying to setup subscriptions.
Our system is configured so that any one of 10 users can login to the SSRS website using their windows domain account, and then launch report builder to design and save reports. This all works very well, however, they have a problem when trying to
setup subscriptions - the famous "Subscriptions cannot be created because the credentials used to run the report are not stored....."
What the message says is true - the credentials are not stored as they are supplied by the user when they login to report builder.
Is the /any/ workaround at all that doesn't involve storing the credentials? It seems totally crazy that they cannot be prompted for them when setting up the subscription. For this application its 100% essential to make the user provide their
credentials when running reports, because they each see a filtered subset of the data in the report model (this is controlled DB side depeding on the login account), so their domain account needs to be passed to SQL server to enable this filtering to work.
If we saved their credentials then they would see all the data..and thats nasty.
The only workaround I can come up with would be to create a separate datasource for each user and upload a separate model, but thats really nasty to be hones

Hi,
I need a documentation which helps me to convert crystel reports to ssrs.
if any one having the procedural documentation you can email to my below mentioned email address that will be helpful to me in my new starting project.
naveenjustlikethat@hotmail.com

I've built a process to deploy several reports to SSRS in either native mode or SharePoint integrated mode. I'd like to programmatically hide several SSRS reports when deploying them to a sharepoint site. I believe I need to do something like
this - http://www.mssqltips.com/tip.asp?tip=1357. Any pointers? I'm new to SharePoint development.
Thx.

Issue: Users that have “My Reports” SSRS Role assigned to them can delete reports in other “shared” folders. My understanding was that they will be able
to do the tasks specified only in the “My Reports” workspace not everywhere.
I have “My Reports” enabled via SSMS.
Users have “My Reports” role assigned to them at the root level.
My SSRS Role “My Reports” has only the following tasks assigned:
1.
View Reports
2.
Manage reports
3.
View Folders
4.
Manage Folders
To test, I'm using Development version of SQL Server 2008 SP1.
Thanks in advance,
Martina

Hi,
I'm building a SSRS report, and I want to get data out of a SharePoint 2007 list.
The difficulty I'm facing is the following:
The SharePoint server is behind an ISA Server, and is configured for Form-Based Authentication.
Is there a way to keep the FBA and retreve information out of a SharePoint list with reporting services?
Kind Regards,
AVermaas

Hi,
we are currently evaluating SSRS and its features for making a decision on migrating from Crystal. I have read up on SSRS a bit and just need some confirmation on some of my findings.
My company develops Windows applications, distributable via MSI files. The backend is SQL Server 2008. We are currently using Crystal Reports to display reports to the end user using the Crystal .NET viewer control. Crystal Reports are saved as .rpt files
and contained in the msi file, therefore deployed to the clients.
As we are considering migrating away from Crystal, I had a look at SSRS. It is my understanding that there are two ways of using reports: First, in local mode, which is similar to the way Crystal works: Client-side deployed report files. However, unlike
Crystal, the application has to retrieve the data for the report from the database and pass a dataset to the viewer control whereas in Crystal, you just point the report viewer to the database you want to use and it pulls the data itself.
The other mode, remote or server mode, has the reports stored in the report server (i.e. SQL Server). The viewer control will be set to the URL of the report, and the report then pulls the data from the SQL database. I am unsure to how you could deploy reports
onto the Report Server using a MSI package; it sounds like quite a bit of work as the only way I have found by now is to consume webs

Hi Guys,
I am currently facing an issue with Enabling and Disabling Parameters in SSRS 2005.
Here is my scenario.
I am having the following 4 parameters - ParamType (has values 1,2,3), ParamMonth, ParamStartDate, ParamEndDate
Now What I want is When I select ParamType = 1 and 2 then ParamMonth should be enabled and ParamStartDate and ParamEndDate should be disabled.
When I select ParamType = 3 then ParamStartDate and ParamEndDate should be enabled and ParamMonth should be disabled.
I have done google search on this issue and found out that this is not possible at run time.
Is there any alternative for this issue?
If the above is not possible, I would like to get atleast in this way :
When I select ParamType = 1 and 2 then ParamMonth should show the values (from dataset named MonthDataSet and default should be the latest Month) and ParamStartDate and ParamEndDate should show as NULL.
When I select ParamType = 3, then I need to enter ParamStartDate and ParamEndDate values manually or pick via datepicker and ParamMOnth should show as NULL.
I am not sure whether this is possible or not....but just trying to get in some way.
Here is the query used in MonthDataSet :
Select Month_Code, Month_Name from MonthTable.
Thanks