How To Set Page Orientation To Landscape?
Jan 28, 2007
How can I set the page orientation to landscape? I tried to set "printDocument.DefaultPageSettings.Landscape = true;" but it didn't work. I have spent hours fixing the problem but I couldn't get it work. Below is the code:
private void printDocument_PrintPage(object sender,
System.Drawing.Printing.PrintPageEventArgs e)
{
e.HasMorePages = false;
printDocument.DefaultPageSettings.Landscape = true;
System.Drawing.Font printFont = new System.Drawing.Font("Arial",
12, System.Drawing.FontStyle.Regular);
e.Graphics.DrawString("Set the page orientation to landscape!", printFont,
System.Drawing.Brushes.Black, 30, 30, new StringFormat());
}
Could someone please tell me what is wrong with it, or what I should do to get it work? Your help is very much appreciated.
Thannks.
View 6 Replies
ADVERTISEMENT
Jun 1, 2007
Design a report by setting the layout with:
width = 8.5 in
height = 3 in
By default, the page orientation will set to "landscape"
Is there anyway to code it and make the page orientation to "potrait"?
thanks for the reply.
View 1 Replies
View Related
Jul 9, 2007
Tweaking a report that was imported from Crystal Reports. Report has three pages, the first two are landscape, the last page is portrait.
Can this be done in RS or will I have to split up the report to render the 1st two pages separately from the last page (in two reports)?
Thanks in advance.
My two cents worth: It would really really be nice if RS had 1.) a rich text box and 2.) the ability to rotate labels and text boxes.
View 3 Replies
View Related
Dec 5, 2007
Hi
I'd like a parameter for the report layout: Portrait Or Landscape. So is it possible to set the page high and width using an expression or in code based on my parameter?
Also on a similar note. I want a parameter for 'Page Break After X'. Is it possible to apply a page break after my table group X based on this parameter? I know if I edit the group I can tick 'page break at end' but I can't apply an expression to this.
Cheers
View 8 Replies
View Related
Dec 14, 2007
Hi, This is because there are many columns need to display ,when users export to excel ,now they have to manually adjust the worksheet as one page . Therefore,as the title,can anyone help me?
View 3 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
May 22, 2008
Hi All,
I'm new to SQL Reporting service. some how i tryed to manage and create reports. I have a small question. when i start creating report i wanted to change the orientation of report from Potrait to Landscape so i can get a bit more space. i can see report getting expanded as we keep working. but when i tryed to export to Acrobat PDF, the content getting into next page insteed in same page. to over come this issue i wanted to generate report with landscape orientation, i have seen this kind of option in Crystal report, but i dont know how to make the same in this report.
View 1 Replies
View Related
May 29, 2006
Hi,
I want to setup my report in landscape format.
How do I do it?
I have altered the report margin in report properties.
However if we export the report to PDF €“ still goes to portrait format.
Even though in pdf itself I have changed the print setup to landscape, but it doesn€™t change anything.
Can anyone give suggestion?
Thanks,
Susan
View 6 Replies
View Related
Feb 5, 2008
Hello,
I have a need to present a different orientation of data, and I would normally do this with CASE. I've tried to go that route in this instance, but it hasn't worked.
The following query expresses the data as it currently is:
SELECT TOP 10
Prod,
Acct,
TC,
SubmitRep1,
SubmitRep2,
SubmitRep3,
Percent1,
Percent2,
Percent3
FROM
dbo.tbl_CYProcessedSales
WHERE
Proj IN (100,200)
AND Percent1 < 80
AND NOT SubmitRep3 = ''
AND Prod = 'RETA'
The result looks like this:
Prod Acct TC SubmitRep1 SubmitRep2 SubmitRep3 Percent1 Percent2 Percent3
RETA PA0065 T2 OJOYNER CAPARRSH SBEVERLY 34 33 33
I need for the result to come out like this:
Prod Acct TC Rep Percentage
RETA PA0065 T2 OJOYNER 34
RETA PA0065 T2 CAPARRSH 33
RETA PA0065 T2 SBERVERLY 33
Do I want to use CASE here, or a cross join?
Thank you for your help!
cdun2
View 7 Replies
View Related
Aug 16, 2007
Hello.
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
View 4 Replies
View Related
Feb 11, 2008
Hello,
I have a table with data laid out as follows:
Acct JanRev FebRev MarRev AprRev
BR549 150 125 175 180
I need to express the (x)Rev columns in a single Revenue column. Nornally, I would do this with CASE, but the column has to follow the current month of the year minus one month DATEADD(MONTH,-1,GETDATE())) and be cumulative.
For example, if the current month is March then:
Acct Revenue
BR549 150
BR549 125
If the current month is April then:
Acct Revenue
BR549 150
BR549 125
BR594 175
Any ideas on this?
Thank you for your help!
cdun2
View 3 Replies
View Related
Jun 4, 2007
Hi Guys,
I have a report which I can print in landscape if I want to see all columns(by manually selecting Lanscape).
When exporting to PDF it defaults to portrait so the last column get cut off to another page.
Is there a simple solution fo this?
thanks
sonny
View 3 Replies
View Related
Nov 11, 2015
I have created one reports but all the records are displaying on one page.find a solution to display the records page by page. I created the same report without group so the records are displaying in page by page.
View 3 Replies
View Related
Apr 25, 2008
Hi, I need help please!
Apologies for the silly question.
I have a problem where i need to show 18 columns in 1 row but can get it in one row, the most the user wants is 2 rows but the first 4 columns cant be touched.
eg.
row1 Col1 Col2 Col3 Col4 Col5 Col6 Col7 Col8 Col9 Col10 Col11
row2 12 13 14 15 16 17 18 19 20 21 22 23 24 25
I am kind of lost on how to show this in a nice format.
Does anyone have any creative idea, as i would like to capture the users.
The Fields are also lengthy so it makes it difficult.
Please!
Regards
View 5 Replies
View Related
Jan 14, 2008
Hi,
Is there a way to set the default page settings to landscape view when im exporting to adobe?
I have set the page settings off the report to be
width 21cm
height 28cm
thanks
View 2 Replies
View Related
Feb 17, 2007
Hello
I have a report which I can print on legal paper, once I choose the landscape settings on print menu. When the same report is set to export to a file share in pdf format, it renders in portrait format. Is it possible to have the pdf document look like the landscape view so that the user can just hit print.
Thanks
Inder
View 5 Replies
View Related
Oct 12, 2007
Hello, I have a report that I am creating in sql reporting services, I want my report to be exported in landscape PDF file format. I Went to the report properties then set the width = 11 in and height 8.5.
When i export my report to a PDF file it did not display it in landscape format!
Do i need to make the report go sideways? if yes how! for example
how would i write a textbox which has the label Time sideways?
Thanks
View 4 Replies
View Related
Aug 30, 2006
I have a report that is setup to print landscape.
I deploy to Report Manager, print it, and everything works great.
If I create a linked report from the deployed report, the linked report prints portrait.
Does anyone know of a workaround or am I just doing something wrong?
Thanks!!
BobP
View 6 Replies
View Related
Jul 18, 2007
I ahve a report, that has 24 fields in the layout. When I tried to print the reprot, it prints BLANK pages, in between and at the start. I have confirmed that the width BODY of the report, < width of the report properties. It still prints blank pages.Pl advise.
View 1 Replies
View Related
May 6, 2008
I have a report that needs to be on landscape, but am only limited to printing portrait style when I render a PDF report in reporting services. Is it possible to render a report in landscape or even better, size the PDF via reporting services.
Eytan
View 3 Replies
View Related
Sep 23, 2005
I've thrown together a homegrown Reporting Services viewer that is basically a wrapper for a browser control. It will reside in our app alongside the Crystal report viewer until we have phased out Crystal.
View 3 Replies
View Related
Apr 28, 2008
All of my reports that are formatted 11x8.5 are outputting to PDF correctly. When I open the PDF in Adobe Acrobat, it appears in Landscape on the screen. However, when I click the print button, by default it is printing it in portrait. I can go to File-->Print Setup and change the orientation from Portrait to Landscape, but why doesn't it translate from the file orientation? This may just be a bug in the Adobe Acrobat software, but I want to make sure there isn't something I can do.
Thanks.
View 1 Replies
View Related
Apr 15, 2008
We have a report that prints correctly (in landscape) in the folder that is deployed to but the linked report in a different folder prints in portrait?
can anyone shed some light on this.
View 2 Replies
View Related
Jul 25, 2008
I am trying to set default print settings for a report on Reporting services.
I need to make to make a page print out on landscape by default.
Â
I cant seem to find this option anywhere.
View 7 Replies
View Related
Jan 23, 2007
I have reports, set to print on Landscape and Legal ie 14 * 8.5. However, when certain users try to print the report, it prints it in Letter, even though the report is set to print in legal /landscape.
The strange part is that for most users it prints correctly in legal, only for some it is on letter. Any idea why this would happen?
View 4 Replies
View Related
Nov 22, 2007
Does anyone know how to prevent automatic landscape setting?
I need it to print an invoice/receipt-like form which using custom paper size (width: 8.5in, height 5.5in)..it is half of letter size and must be printed as portrait.
RS has problem that it turns landscape automatically if the width is longer than height, which is not expected.
By the way Crystal Report can do this successfully but CR has another different problem also......
Can RS do the same as CR in term of page layout? Please help...
View 3 Replies
View Related
Feb 5, 2008
My company has a .Net app that embeds the reportwriter for displaying (and printing) reports. This seems to work fine visa vis printing reports in landscape mode, although odly if you look at the printer properties it SAYS it is priting in portrait. In any case, the problem comes when this default reportwriter isn't used but rather an rdl file is generated programmatically. No matter what width and height settings we use, the document unfailingly prints in portrait mode. I've looked to see whether there is any way to force the printer mode, but it seems there isn't, at least not through an rdl. Or what SHOULD work (setting the width larger than the heigh) does not. I'm wondering if anyone else here has run into difficulties like this if there are any solutions or places I might look for answers? Thanks!
View 1 Replies
View Related
Sep 27, 2006
The goal is to produce a single PDF consisting of a number of subreports. Some are landscape, others are portrait. The subreports may also be run as independent reports. The master report defaults to the width of the widest subreport, which is landscape. This causes all portrait subreports to spill over. Your suggestions / comments are appreciated.
Thanks!
View 1 Replies
View Related
Nov 6, 2015
I have a report that I need to develop in landscape format. Also I need it to be landscape when converting to PDF and taking printouts. let me know the exact height and width measurements in inches for the report and report body?
I need the margin to be 0.5 inch.Â
View 4 Replies
View Related
Jan 16, 2007
Hello,
I am trying to print a report in landscape mode from VS 2003 from designer preview or at run time. The users don't want to change a mode manually. I tried to make width 11 or 11.5 in and height 8.5in with zero margins and 0.5in (tried a lot of combinations) - doesn't work! still printing in portrait. Please help! Thank you
View 7 Replies
View Related
Nov 28, 2006
Hello I have a project that uses a large number of MS Data access pages created in Access 2003 and runs on MS SQL2005.
When I am on lets say my client, (first page in a series) data access page and I have completed the fields in the (DAP), I am directing my users to the next step of the registration process by means of a hyperlink to another Data access page in the same web but in a linked or sometimes different table.
I need to pass data entered /created on the first page to the next page and populate the next page with some data from the first page / table. (like staying on the client name and ID when i go to the next page)
I also need the first data access page to open and display a blank or new record. Not an existing record. I will also be looking to creata a drop down box as a record selector.
Any pointers in the right direction would be appreciated.
I am some what new to data access pages so a walk through would be nice but anything you got is welcome. Thanks Peter€¦
View 2 Replies
View Related
Oct 16, 2006
The following objects are placed on the Report body of the Report pane of SQL Server 2005 Reporting Services :
<textbox: expression1>
<textbox: expression2>
<table:table1 with at least 30 columns and 30 expressions>
<textbox: string1> - considered as the Title in the Footer section of the report
<texbox:string2> <textbox:expression3>
<textbox:string3> <textbox:expression4>
<textbox:string4> <textbox:expression5>
<textbox:expression6>
I can't find any explanation why is it string1 and string 2 of the footer section of my report displayed separately from the expression3 which is aligned on it and the rest of the object on the second page.
The expected design is that all Footer items should be displayed together of whether it is placed on the first page or on the last page.
As a workaround of this, I converted string 1 into an expression (Added = and enclosed the string with double quote).. As a result, all of the items in the Footer section are now placed together on the last page of the report.
I also remember one of the issue I encountered before where the Footer items where placed together on the first page and still have space at the bottom of the page, but then expression 6 is forced to display (alone) on the last page of my report.
I can't find any discussion related to this, I wish somebody could give me an idea why RS behaved like this.
Thanks in advance
View 1 Replies
View Related
Feb 14, 2008
Fit an intere table in same page without page break for save the excel export.
My table has a Group for order my dates.
I need to have the intere table in the same page, i don't care about blank space at the end of the page.
I can't use the page break beacuse i need an excel export in a unique sheet..
I have tested.. every page break..you'll have a different sheet in your excel export
I need something like this
page 1
Zone
1
2
3
4
5
6
7
7
8
9
..
page 2
Zone
1
2
3
4
5
6
7
7
8
9
..
but an unique sheet in the excel export
View 4 Replies
View Related