I'm trying to find out if there is any way I can embed anything in a report to tell it which paper tray to print to. So far, the only references I've found to such a capability are involved in using the Printer Delivery Extension. Does anyone know if this is indeed possible with that, or by any other means? Thanks!
View 3 RepliesHi All,
Could you guys please help me with printing reports invoked thru command line/ URL access to print automatically to specific printers and specific trays and also is it possible to set the specific printer and tray as parameters.
Any suggestions is appreciated
Thanks A lot in advance
e,g :
http://localhost/reportserver?/testreports/employee sales&UserID='ABC'&LName=Lastname='victor'&rs:Command=Render
how can i set the paper size and paper layout programmatically in RS. im using c#.net as prog. lang. for this. Pls help thanks!
View 11 Replies View RelatedSo 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?
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!
Hey,did anyone know a good paper or a good ms link about SQL Server 2005 -because I have problems to install the Beta Version..thanks very much
View 1 Replies View RelatedDear Forum Members,
We've been working on a white paper targeting SSIS connectivity which we hope will help answer some of the key questions in the following areas :
What are the SSIS components and their support level for ADO.NET, ODBC, and OleDB?
How to deal with 64-bit connectors? what is supported, what is not?
Special sections on popular data sources such as SAP, Oracle, DB2, Flat File, XML.
A comprehensive list of data sources and available connectors from Microsoft and other 3rd parties.
You'll also find answers to why some of the things are the way they are today.
Note that this white paper is currently under official editing and publishing in Microsoft. It'll be a while before it goes public officially, but I wanted to share it with you, as the rich content it offers can't really wait. You'll find the paper in my blog, which is really a wiki site about SSIS connectivity fully open to public, so feel free to add/update content in there as you feel proper, and help the SSIS community with your wisdom!
A lot of feedback went into this white paper not only from Microsoft, but also from some of our partners and MVPs. I'd like to extend special thanks to Bob Beauschemin for authoring this challenging white paper.
Enjoy!
Deniz Erkan
Program Manager - SSIS
I would like to refer to the following technical article
SQL Server 2005 Security Best Practices - Operational and Administrative Tasks
http://www.microsoft.com/technet/prodtechnol/sql/2005/sql2005secbestpract.mspx
Among best practices for SQL Server service accounts on page 8, it is recommended to 'use a separate account for each service'. I created separate account for each service as advised and assign account to relevant Windows group created for each SQL Server service during SQL setup.
Now when I run Best Practices Analyzer, its report seemed to contradict what the above article said. For example, BPA reports excerpts:
"We recommend that the service SQLBrowser on host MachineName be run under Network Service Account". I get similar recommendation for SQLSERVERAGENT account as well. Most importantly, it recommends that MSFTESQL be run under SQL Server Service Account.
Can anyone of you shed some light on it?
Thanks,
Asaf
How to display the paper number that is co authored by authors from the same department?
The database structure:
Department(DeptNum, Descrip, Instname, DeptName, State, Postcode)
Academic(AcNum, DeptNum, FamName, GiveName, Initials, Title)
Paper(PaNum, Title)
Author(PaNum, AcNum)
Field(FieldNum, ID, Title)
Interest(FieldNum, AcNum, Descrip)
Thanks for help a lot
I am looking for some published paper regarding database performancetunning performance strategies. This is for academic purpose so itneeds not to be any commerical database specific. It will be evenbetter if the paper has some kind of methods to quantify/measureperformance. Has anyone come across with any interesting paper aboutthis?Thanks,ewong
View 2 Replies View RelatedHello.
I have a report but by default it prints Portrait and 1.0inch Margin. I would like to programmatically set the values of my report to 0.2 inch margin and Landscape. I am using RDLC (Local Report).
Does anyone has an idea how to achieve this?
Jose
Hi,
I have been trying to configure the Paper Size to be default "A4" instead of "Letter".
My Report is configured to 21cm x 29,7cm and margins 1,5cm.
The Body is configured to 18cm x 26,7cm.
Everything looks fine in the Preview but the Size is always "Letter". The printers are all configured for A4 printing.
Is there a way to set these default values in the Page Setup Toolbar or is it supposed to figure it out?
Thanks,
steinar
While working in the report project in Visual Studio, I set my Report Layout to 14w x 8.5h with .25 margins on all sides, and the page size to be 13.5in (to take into account the margins). When I print from the report viewer control in Preview mode, the report prints as it should, in Landscape on Legal paper without me changing any settings.
When I deploy the same report to the report server, and print from there, the report prints in Landscape on Letter paper (which causes some columns to print on a second page).
Why is there a difference in the two environments? Is there something I'm missing?
The goal is for the users to be able to print the report correctly without having them change any print settings in the dialog.
Hi all,
I am searching for days for a paper explaining in details the decision tree algorithm that Microsoft uses. It would be very nice if parameters are described in details and the theory basis illustrated. I will be very happy to know in depeth fro this algorithm and how its parameter it affects the results.
Thank you in advance
Manolis
Hi,
I have create a report with A3 size as there are too many fields., but i
wanna to print out on A4 paper properly. is that possible to do?
Cheers
Nick
I am trying to print a stored procedure in color to read it on paper.
But it prints in BW even on a color printer with color options.
I have printed the code in color using Rapid SQL. All I have now I query analyzer (SQL SERVER 2000)
any way to do this in SQL SERVER 2000
Ashley Rhodes
Does anyone know how to get SQL Reporting Services, when it runs a report, to tell Adobe Acrobat to "Choose Paper Source by PDF page size", which is an option in the print dialog box?
When I, or a user, runs a report in Visual Studio or live:
The report is set to render on 8.5" x 14" paper (legal)
The report is exported to a PDF
The report opens in Adobe Acrobat
The report is formatted on the screen to fit 8.5" x 14" paper (legal)
When "Print" is selected, the Preview has it on 8.5" x 11" paper (letter)
If I select "Choose Paper Source by PDF page size", then it fits it to the 8.5" x 14" paper (legal)
How do I tell it to "Choose Paper Source by PDF page size"?
Paper is 21cm x 9cmPrinter is Epson LX-300..When I set this paper size, SSRS turns orientation to landscape and prints as if clockwise right rotated!I tried creating custom paper on print server options without success. I also tried setting the same paper size in Report Builder and Print Server but failed again.
View 3 Replies View RelatedHello All!
Many of you have seen the draft version, but we finally have it out the door. You can download the new version directly from Microsoft's official site.
The momentum in our connecitivty wiki is growing! so check back and see if you can get useful information on 64bit, Office 2007 connecitivity, and samples.
Some of the recent activity in our connectivity portal:
***************
The new connectivity white paper is now officially available, click here (http://download.microsoft.com/download/2/7/c/27cd7357-2649-4035-84af-e9c47df4329c/ConnectivitySSIS.doc) to download.
***************
There's a new article from Deniz Erkan on Office 2007 Connectivity (Data Sources/Microsoft Office (2007)).
***************
Bob Beauschemin provided us a sample package to connect to Excel 2007.
***************
Microsoft's Partner ETI has a new separate page for connectivity offerings for SSIS (Data Sources/ETI High Performance Data Integration).
***************
Microsoft's Partner Persistent (Data Sources/Persistent Systems Products for SSIS) has put together a list of options for SSIS connectivity.
********************************************************************
Evening,
I am very well versed in the proper way to set up a SQL Server server prior to installation.
In this I mean, the proper process in placing your MDF, LDF and NDF(s) on seperate spindles/discs and also to place TempDB on its own spindle/disc and such.
There are numerous other points to cover in setting up the server based on memory, security, processor and such but I am sure you understand.
What I am looking for is the link(s) to the whitepapers discussing these Best Practices methodologies for pre-installation setup.
I looked on the Best Practices page but did not seem to find a doc that contains all the Best Practices that should be followed, if possible of course, in setting up a server prior to the SQL Server 2005 installation process.
Can anyone please point me to a link(s)/doc(s) that describe what I am looking for.
I need to pass this information down to other members of my team.
Thanks and have a great day!
Hi,
I am new to reporting services and I'm really stuck on a design problem. Can someone please help me?
I would like to design my own print function. When a user clicks on the print icon (preferably the one that came with reporting services), the report is automatically printed twice, once with "For Person A" and the second time with "For Person B" on it. It doesn't matter where these two labels are placed on the page. These two reports need to be printed on letter-size paper regardless of user's selection. How do I do this with minimum amount of code?
Any help would be greatly appreciated!
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.
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
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.
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!
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
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 RelatedI 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 RelatedHi! 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
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
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
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.
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!