Local - Printing Margins Are Off By ~1/8 Inch
Jul 19, 2007
I am printing my reports from my local report viewr, and the margins are off by just a little bit. It looks like printing shifts the contents of the report 1/8 inch to the right, borking the margins.
Report body is 7" wide
Margins are .75" inch on all sides
Print Preview mode displays the report properly, centered
Output is similarly skewed on all printers (tried 4)
This is using the VS SP1 version of the RS dll's.
However, when I print the report I get it shifted to the right by 1/8 inch. This leaves me with a 7/8" margin on the left, and a 5/8" margin on the right.
Setting the margins to Left: 0.625, Right: 0.875 (5/8&7/8) actually causes it to print centered, so I know it is paying attention. When I do this, the print layout mode shows the contents shifted to the left 1/8", as expected.
I assume that people print using this control, or at least it was tested, so has anyone else seen this or is it a confirmed bug?
//5ive
View 1 Replies
ADVERTISEMENT
Aug 1, 2007
I believe this is an extension of the problem described here:
http://connect.microsoft.com/VisualStudio/feedback/ViewFeedback.aspx?FeedbackID=115351
The service pack for Visual Studio has fixed the problem when I print my report from VS, however when I deploy and print my reports from the SSRS website they are still incorrect.
My SSRS server is running SQL 2005 with service pack 2 installed and the 9.00.3152 9333097 Cumulative hotfix package (build 3152) for SQL Server 2005 Service Pack 2 also applied.
I find it hard to believe the problem was fixed in the developer tool but NOT in the client tool?
How can I develop reports when the output from the developer tool is different to the output from the client tool?
For example I specify a box to be 5cm wide, and when printed from visual studio it is 5cm wide, but when printed from the SSRS website it is not 5cm wide!
Thanks.
View 6 Replies
View Related
Sep 20, 2000
Is there a way to print the source code from the local package. I know you can go in the source and cut and paste it into a word document. I was wondering if there was a way to do it when you are in designing the package so that it would print all the source codes of SQL statments/queries.
View 1 Replies
View Related
Oct 5, 2006
I have a local report for which i am binding the Dataset dynamically. I am trying to print this report using a seperate button on the page. I saw in the forums saying that the reportviewer can be converted to an EMF file, bind this to an image control and can Print this image using Javascript.
Can anyone help me with the sample code to print local report from the reportviewer (it may be in any approach.)
Thanks in advance.Sekhar T
View 9 Replies
View Related
Dec 20, 2007
I'm having a relatively big issue with printing my check report. The report continues, time after time, and regardless of the margins I choose for the report, to be displaced an additional 1" up from the bottom of the page. The printing method is through our newly designed application which sends the emf rendering to the printer. We have gone through the liberty of modifying the actual print document in VB with margins set at 0,0,0,0 (L, R, T, B) and have paid close attention to the printer's maximum printing area. We have come to the conclusion that the problem is coming from reporting services. In addition to the extra margin space on the bottom of the page, there is also a slight yet noticeable shrinking of the page. Despite the fact that those are trade symptoms of another issue after the emf rendering we have modified every possible function of the printdocument and printer settings. So we continue to push the question, is this reporting services? We are fairly certain. I'm asssuming this is a bug in SSRS 2005, yet, I have yet to hear of any similiar case. This is our VS version info just incase:
Microsoft Visual Studio 2005
Version 8.0.50727.762 (SP.050727-7600)
Microsoft .NET Framework
Version 2.0.50727
Installed Edition: Enterprise
Microsoft Visual Basic 2005 77642-113-3000004-41917
Microsoft Visual Basic 2005
Microsoft Visual C# 2005 77642-113-3000004-41917
Microsoft Visual C# 2005
Microsoft Visual C++ 2005 77642-113-3000004-41917
Microsoft Visual C++ 2005
Microsoft Visual J# 2005 77642-113-3000004-41917
Microsoft Visual J# 2005
Microsoft Visual Studio Tools for Office 77642-113-3000004-41917
Microsoft Visual Studio Tools for the Microsoft Office System
Microsoft Visual Web Developer 2005 77642-113-3000004-41917
Microsoft Visual Web Developer 2005
Visual Studio 2005 Team Edition for Developers 77642-113-3000004-41917
Microsoft Visual Studio 2005 Team Edition for Software Developers
Crystal Reports AAC60-G0CSA4B-V7000AY
Crystal Reports for Visual Studio 2005
Microsoft Visual Studio 2005 Premier Partner Edition - ENU Service Pack 1 (KB926601)
This service pack is for Microsoft Visual Studio 2005 Premier Partner Edition - ENU.
If you later install a more recent service pack, this service pack will be uninstalled automatically.
For more information, visit http://support.microsoft.com/kb/926601
SQL Server Analysis Services
Microsoft SQL Server Analysis Services Designer
Version 9.00.1399.00
SQL Server Integration Services
Microsoft SQL Server Integration Services Designer
Version 9.00.1399.00
SQL Server Reporting Services
Microsoft SQL Server Reporting Services Designers
Version 9.00.1399.00
I'm planning to talk to MS if nobody recognizes these symptoms. Any ideas would be greatly appreciated! Thanks!
UPDATE (12/20/2007 1:43:07 pm):
We have made a small break-through discovery. We found that that if we convert our report using a pdf rendering that the additional 1 inch added to the bottom margin is no longer there. So, pdf rendering would be an option if we became more desperate. However, this is too time consuming and we would much rather have the report directly sent to the print spooler instead of loading then spooling. Does anybody know what is going on with this apparent conflict between SSRS 2005 and our emf renderer?
View 6 Replies
View Related
Nov 16, 2007
I am in need of a format string or simple vb code that can add the local time zone to the end of a time field.. Something like:
9:36 AM EST
9:36 AM PST
This timezone will just come from the machine that the reporting server is on. I don't see this listed as a standard format, and I have come up empty so far in my research - anyone got a solution for this?
Thanks a bunch!
View 4 Replies
View Related
Aug 10, 2015
So I have been asked by our sustainability person to create report from our printing data that actually shows the number of pieces of paper used. This is easy enough for single-sided printing, but when printing in duplex the software does not take into account that 3 printing pages actually equates to 2 pieces of paper. I know this sounds simple, but say I have a print job record that looks like this:
Submitted printed total_pages duplex
8/10/2015 8/10/2015 42 1
This is a print jobs that if done correctly is actually 21 pages( duplex printing). If the job is say total_pages =5 I cant just divide by 2 because its actually using 3 pieces of paper ( yes they are wanting this data don't ask why). How can I adjust some sql to accurately depict 5 pages, front and back, as 3 pieces of paper?
View 2 Replies
View Related
May 3, 2007
I have deployed a report that is configured for landscape printing. It does print in landscape, however, only the first seven columns appear on the first page and the other five columns appear on the next page. Is there a method, like in print preview setup in MS Excel, where we can scale down the print (like to 80%) so all columns appear on each page?
Thanks!
View 3 Replies
View Related
Apr 22, 2008
Hi all,How to set Left,Right,Top Margins for Report at the time of Report Design.
Pls help me.
View 5 Replies
View Related
Jan 23, 2008
Hi,
I use Vs2008Pro. I can not set the correct margins for different printers.I set top margin to .5in .It works on a printer but doesnt on another one.I created a table for printers and save margin values that work for that specific printer and then load before printing.
So I need to set margin values before printing. I am using LocalReport rdlc files.
Thanks for help.
View 3 Replies
View Related
Oct 4, 2007
Hello AllDoes anyone know how can we set the margins (Left and Right margins) of the PDF which we export from the report server for the Sql Reports?
I cleart more hereSuppose I have a created a report using the SQL Reporting Service and then run the report from the report server itself. Here I got the option throuh which I can export report data in PDF format. does any one know how can we change the left and right margins for this PDF. Currently its default margins are very large.
Thanks In advance!!!
Warm Regards
Jitendra Jain09425349593
View 3 Replies
View Related
May 23, 2008
Hello, I've been trying the suggestions in the link below, and without success.
http://blogs.msdn.com/bwelcker/archive/2005/09/28/474898.aspx
This is supposed to allow us to build a linked report with these properties already set. This post works for a linked report that is already deployed. I want to set the properties on the report as I'm deploying the linked report. The instructions listed don't seem to work, it gives type errors and other related things when I try this approach, has anyone else had any luck doing this?
It says:
Error : rsElementTypeMismatch (The value provided for the PageHeight
field is not valid for its type. It cannot be converted from a string value to
the type that is required.)
What do I do to get around this? I tried changing it to a number, but no luck. I'm trying to do this in rs.exe:
Dim props(7) As [Property]
props(0) = New [Property]
props(0).Name = "Description"
props(1) = New [Property]
props(1).Name = "Hidden"
props(2) = New [Property]
props(2).Name = "PageHeight"
props(3) = New [Property]
props(3).Name = "PageWidth"
props(4) = New [Property]
props(4).Name = "BottomMargin"
props(5) = New [Property]
props(5).Name = "TopMargin"
props(6) = New [Property]
props(6).Name = "LeftMargin"
props(7) = New [Property]
props(7).Name = "RightMargin"
props = RS.GetProperties(basereportpath, props)
RS.CreateLinkedReport(name, parent, basereportpath, props)
View 1 Replies
View Related
Oct 2, 2007
We have a 64-bit VM server running SQL Server 2005. The SQL Server on this particular VM server has 6 local instances installed. On the Management Studio logon screen I can type the full name of the local instance and connect to it, however if I press the drop down in the Server name field, choose Browse and select the Local Servers tab there is nothing listed under Database Engines.
Any idea why the 6 local instances don't show up under Database Engines? This is preventing me from installing a vendor application because their installer looks for local SQL Server instances on this server, but if SQL Server won't even show the local instances then the installer doesn't see them either.
Any help is greatly appreciated.
Thanks,
Craig
View 3 Replies
View Related
Jun 7, 2006
I am facing a problem in connecting to the local database with server name as (local).
I have installed SQL Server 2005 in my machine. When I try to connect to the SQL server with the server name as SUNILKUMAR I am able to connect but when I try to connect to the same server with the server name as (local) I am not able to connect. SUNILKUMAR is my machine name and SQL server is running locally.
if anyone can help me what is the problem in this case it is highly appriciated.
View 7 Replies
View Related
Dec 21, 2005
Hi Everyone
I am at the stage of architecting my solution
My goal is to develop the system on a windows application and pda
There is a central server which will create a publication called inventory
The laptops which host the windows application will be subscribers to the central server using merge replication
The client now wants the PDA using SQL Mobile to synchronize with the local subscirber database on the laptop using active sync. They dont want to do it via WIFI to the IIS Server at the central server
I have been reading for days and I am still unsure whether this is possible to do.
I know Appforge provide a conduit for palm to access synchronization but not local sql databases
I would appreciate your help immensley
View 7 Replies
View Related
Jan 31, 2008
Being a very novice SQL Server administrator, I need to ask the experts a question.
How do I go about moving a database from 1 drive to another? The source drive (C is local to the server, but the target drive (E is on a Storage Area Network (SAN), although it is still a local drive for the server. I want to move the database from C: to E:. Can someone provide me with instructions?
Thanks,
Rick
View 4 Replies
View Related
Dec 7, 2006
This is my first time to deploy an asp.net2 web site. Everything is working fine on my local computer but when i published the web site on a remote computer i get the error "Failed to generate a user instance of SQL Server due to failure in retrieving the user's local application data path. Please make sure the user has a local user profile on the computer. The connection will be closed" (only in pages that try to access the database)
Help pleaseee
View 3 Replies
View Related
Jun 5, 2007
I looked through a couple of database books I have and I really didn't find anything about printing.
My question is can you print the data directly from a database in C# or do you have to write it all to a textfile then print the textfile?
Be easier just to do it from the database and eliminate the text coding, just not sure you can do that.
View 1 Replies
View Related
Mar 1, 2004
Hi,
I am developing an applicaiton through which, i want to print from pocket pc emulator 2003. I am using PrinterCE.NETCF SDK to do this task. I am able to print from my applicaiton like we do in ASP (Printing one line at a time). In PrinterCE, there is an option of printing the output to a file. But, I am not able to find how we do it.
So, I want to know how we can print the output through PrinterCe into a file. Can anybody help me??
thanx and regards
ramesh chandra
View 1 Replies
View Related
Apr 23, 2008
does anybody know why trying to print ™ character in 2005 does not work while same works in SQL 2000? The ascii value is 153
SELECT CHAR(153) returns ™ in sql 2000 but Ö in 2005.
View 7 Replies
View Related
Nov 5, 2005
Hey all,
I'm new to SQL and am having some troubles w/ a problem I was given.
I have two tables (OrderTableA & OrderTableB) which are linked by an OrderID. What I need to do is have the two tables printed out to two txt files. Below is the code I have so far.
CREATE TABLE OrderTableA(
OrderIDNUMBER,
OrderDateCHAR(24),
CustomerIDCHAR(8),
TotalDEC);
CREATE TABLE OrderTableB(
OrderIDNUMBER,
QuantityNUMBER,
DiscountNUMBER,
UnitPriceDEC);
SELECT OrderID, "#" + OrderDate AS OrderDate, "&" + CustomerID AS CustomerID, Total
FROM OrderTableA;
SELECT OrderID, Quantity, Discount, UnitPrice
FROM OrderTableB;
The txt file for OrderTableA has to look like this:
!!OrderID OrderDate CustomerID Total
---------- ----------- ----------- ------
123456 #123456 &123456 123456
with the !! before OrderID in the header, the # before OrderID in the table and the & before the CustomerID in the table.
I'm not sure my code above is correct so far, and I've no idea how to print this to two txt files.
Any help would be greatly appreciated!! Thank you!
View 3 Replies
View Related
May 9, 2007
I have a report with two columns. It works fine in SQL Reporting Services, but when I push it to the Report Server it only prints one column instead of the two that it's set up to print.
What am I missing?
D-Monk
View 4 Replies
View Related
Oct 29, 2007
Hi i'm having a problem in printing a reporting services report. Between each page it's giving me a white paper. What can i do in order not to get the white papers anymore? Any help?
View 4 Replies
View Related
Sep 1, 2005
I have a script or SP that takes a very long time to performmultiple tasks, and after each one there is a PRINT statementthat shows the time and what was just accomplished, to help memonitor what's happening and estimate how long it will take.In a script, I can put a GO after each PRINT to cause the outputto appear immediately, but that's not possible inside an SP.Instead, it seems the output goes to a buffer, and the bufferis only output when a PRINT causes the buffer to become full.Sometimes there is a long delay before the buffer fills. Isthere a way other than GO to cause immediate printing? (Iguess I could just use longer messages, and fill up thebuffer with every one, but that's not very elegant.)Thanks,Jim GCountrywide Home Loans
View 2 Replies
View Related
Jul 25, 2007
Hi! I recently begin to use reporting tools of SLQ 2005 instead of AR or CR. I found the DUI very easy to use and I'm partially sastify beause when I try to print my report, the printer always blow out a second white page. For one page report I can live with that but for 156 page report it's becoming a lot annoing. Is there somebody who experience the same problem? And by the way resolve it?
Here the dexcription of the report:
Is a list grouped by clientId with a sub report getting the clientId from the parent one as the parameter. Event with the insert page break after list true or false the result is the same while printing.
Thx you very much
Daniel
View 4 Replies
View Related
Apr 24, 2008
I have created a blank report in VS 2005. I set the pagesize to 21cm x 29,7cm (A4) and margins to 1cm. Body size is 19cm x 27,7cm. I set the body border to 1pt. When I print this blank report I won't get printed as I expcted. The printed margins are very different from the margins which I set. Hos can I solve this problem?
View 1 Replies
View Related
Oct 24, 2007
Dear All,
Kindly I need to infrom you that i make report in reporting service 2005 and there is an image in this report that i retrieve it from database
im sure that the error not in retrieveing and not the sp because that in report preview the image appear but in printing not appear
i put the some image propertise like:
mimetype:image/bmp and sizing :FitProportional
the second point :
i need to ask if can i make the report when printing can make it as default that appear in A4 not letter
I need Help as soon as possible
With my best regard
khalil hamad
View 1 Replies
View Related
Apr 10, 2007
Hi,
We are displaying the reports in Web Application using Report Viewer control.When we run the report and want to take printout we are clicking on Print button of Report Viewer then it is giving error "Unable to Load Print control" Install some activex control.
With out this error how can we print the report. How to overcome this waring.
Thanks in advance.
View 1 Replies
View Related
Nov 12, 2007
Hi All,
We have created reports with page size width : 11in and height : 8.5in so that we get pages printed in the landscape mode. We use HP LaserJet 3500 and reports were printing correctly in landscape format.
Everything was working fine till we introduced a new printer Dell 1110 laser printer to the environment.
When we have our Dell 1110 laser printers set as default, the page setup IS NOT set to landscape and when I manually change it to landscape, it prints in a compressed portrait image rather than landscape.
However when the HP LaserJet 3500 is set as the default, it prints correctly in landscape.
As the client is using Dell 1110 laser printers i need to fix this issue immediately.
Can someone guide me in resolving this issue..
Thanks!
View 1 Replies
View Related
Jun 21, 2007
Is there a way to save print settings with the report so that settings such as the size of paper (A4, legal...) and layout (landscape, portrait) do not have to be specified by user everytime she wishes to print the report?
View 5 Replies
View Related
Oct 1, 2007
Hi everyone,
For some odd reason the footer of my report never gets printed. The footer contains the page number and report name and is very important to my report. I made sure the margins are 1 inches for all sides, made sure Footers printing in first and last pages are checked in the properties section, and gave it a large amount of space around the textbox. Is there anything I am doing wrong? Also, the header and body prints correctly.
Thanks
View 8 Replies
View Related
Feb 6, 2007
Hi
Iam able to print only the first page in the local reports!!!
Also, can I give the user the choice of using the local version or the enterprise version of the reports?
Any suggestions plz help
Thanks
contractor
View 1 Replies
View Related
Jul 10, 2007
Hello everybody,
i have used report viewer control in my win app, (c#, .net 2.0) and from msql i get data, fill necessary tableadapters and print report. Everything works fine on my computer, i generate report from template, push Print button in report viewer, Print dialog appears and i print the report by clicking OK.
The problem occurs in another computer, where i launch my app, i generate report, push Print button, and when appears print dialog happen strange things:
1. In print dialog i push "Print" button once, and nothing happens, Print dialog is still on top, then i push second time Print and then i can see that to pages is sended to printer (but my report is only one page). Printer does nothing, in printer schedulles there is no jobs.
2. So i press Print button in report viewer second time, Print dialog appears again, i click Print button nothing happens, then i push second time Print button i can see that 1 page is sended to printer, Print dialog disapear and now printer print my report correctly.
and this mesh is everytime i generate report and want to print it. Printer is installed correctly, i tried newest drivers for it. For example with ms office word everything works fine.
Could it be report viewer bug? what are the ways to find out what is wrong?
View 4 Replies
View Related
