DATAREPORT-Paper Size And Orientation. URGENT Help Needed
I`m working on my first datareport.
So far, the report is already designed and I can preview it (in letter size), but I need to print it in 3 copies, 1/3 legal size, and landscape orientation.
This must be done automatically, I mean, I donīt want the user to be setting "number of copies" = 3 or anything at the printer panel. (if possible I donīt even want the printer panel to appear).
The result should be a 1 legal size page with the report printed 3 times in it (NOT 3 legal size pages with 1 report in it).
How do I achieve this?
Any help is very well appreciated.
View Complete Forum Thread with Replies
See Related Forum Messages: Follow the Links Below to View Complete Thread
Paper Orientation When Printing A Datareport From VB
I am using a datareport designed in vb and get the error "Report width is larger than the paper width". I have tried
but this does not seem to work.
Help would be appreciated.
How Can I Change Paper Orientation To Landscape At Datareport?
I tried to make a report using datareport object at VB6. Report width is wide so I planed to use landscape orientation. When I tested report, error message said Report width is more than paper width. I guess paper is still protrait orientation. How can I change to landscape orientation?
Printer Orientation And Paper Size
please help about printer orientation and paper size. any body here know on how to control the printer orientation and paper size. using vb.
Set Printer Orientation And Paper Size
Hi to all!
Please help me I am developing some application and I have a report
file. Now my problem is I want to set the printer orientation and paper size
Thanks to all,
How To Setup Paper Size Of A Datareport?
I am having this problem of setting the papersize of my datareport. When i initialize the datareport form i want its papersize to height=5.5 inches and width=8.5 inches.
pls. help on how to achieve this.
thanks in advance.
btw. i have tried using printer object but with no success. may be you can show me how to access programmatically the printer properties in a different way...
Is There Really A Way To Print Into A Legal Size Paper With DataReport?
I have been with this problem a big long ago. I tried the printer.papersize = vbPRPSlegal and nothing, it still prints into a letter size paper (8 1/2 X 11). I don't have the enough budget to buy Crystal Reports and don't know if it can print into different types of paper sizes.
Is there any way to print into a legal size paper with DataReport?
If not, is there a way to tell the printer that I would like it to forward 1 to 2 inches so that I can start printing from the 2nd inch of the legal size paper and print the 11 inches long permitted of a letter size paper to be able to print into the legal size paper till the 13 inch ?
Any help will be appreciated.
Settings Custom Paper Size To DataReport
Is there a way thru which i could instruct the datareport to print on a 6 inch X 6 inch paper. After Printing, the paper should not scroll out. It's Just like the bills printed out at the cost price shop. Thanx in advance
Printing - Custom Paper Size ( Urgent )
I am developing a program in which i need to print some text at a specific location on a pre printed stationary of size 10" X 6" (Width = 10" and Height = 6" ) How ever every time I print it takes 10" as Height in Windows Xp
Pl. Answer me as early as possible
DataReport Problem(Urgent Help To Be Needed)....
I am using VB 6.0 with access database.
And i have 2 tables with same fields.
I am using ADO concept in my program and i've used Datagrid to view,add,modify the records in run time.
I've placed 2 datagrid in 1 form.
1. Is there any solution, for printing datagrid contents. I want print 2 database tables in 1 page.
2. I got one solution from net, using UNION Sql query to join 2 tables and display in report. Its working , but i want the tables with Title . Take an example
Table 1 : Engineer 1
Table 2 : Engineer 2
Both have same fields like name,staff no
I want to display the data report in 1 page like below
Engineer 1 ( Title 1)
Staff no Name
Engineer 2 (Title 2)
Staff no Name
Is there any solution available in datareport. Pls. someone help me.....
Thanks in Advance,
I have 2 reports. One report's width is greater than 8.5 inches so i made the orientation as Landscape. I understand that this setting is not enought if we make it in the vb program at run-time. The default printer should be made as landscape in its properties.
My other report is a normal A4 paper size report which has to be displayed in Portrait. When i change the orientation using the printer object at runtime, its not working. It still remains Landscape.
Can someone guide me. Its very urgent
Thanx in advance
Is there anybody who can tell me how to change paper orientation on default printer or to scale form to fit paper width ?
I use VB6
Setting The Paper Orientation
How can I change paper orientation before printing ?
I tried :
dim p as printer
but the orientation property is readonly
CHANGE PAPER ORIENTATION
i want to check the orientation of paper in the default printer (wheterit
is landscape or portrait?) and if it is set on portrait i want to changeit
to landscape before showing up crystal report. i need this featurebecause
i have made my crystal report in landscape orientation.
Paper Orientation Using Vb And Crystal Reports
I have made 2 reports in crystal reports 8.5
one is designed on landscaped orientation
other is designed on portrait orientation
to view them properly i have to change paper orientation of the default
printer before running each report.
how can i avoid the above step using vb code?
Chaning Crystall Report Paper Orientation
Hi, How can I change the orientation of crystall report. I don't mean in run time I mean in design time, when I am designing the reports.. I need to do these because I don't have enough space to put all the database fields... I really appreciate any help.... By the way it's good to be back.... (I was Cut off from the internet for a week)
Thanks in Advance
*** RESOLVED *** I Need Help Setting Up Paper Orientation With Data Reports
This is a redirection of my earlier post about data reports.
I am trying to print out a report that needs to be in the landscape orientation to contain all of the data being produced in each line. When ever I try to widen my report past a certain point it gives me an error that the report is wider than the paper. This is true for the portrait orientation but not for the landscape orientation.
My question is: How do I change the setup of data reports, or whatever in my program, to use the landscape orientation?
I can get my data on the report and I can even change to landscape in the dialog box that is given when you go to print the report. It won't spread the report out any wider than the approx. 7 inches of width that it uses for portrait printing.
The amount of data I need to print will not fit on one line using the portrait orientation so this is very necessary for me to resolve this.
Any help is greatly appreciated. Later,
Check out my website at http://crogers.org
Being an organ donor is giving the greatest gift that someone can give.
It is giving the gift of life. Please register to be an organ donor.
Edited by - crogers on 9/12/2005 8:28:41 PM
I Cannot Get Or Set DataReport.Orientation Property
I have done a search for this topic on this forum. For this question, the answer is "install Service Pack 5". Yes, I already installed SP5 before. Although my DataReport has no Orientation property.
My problem is exactly same with the problem discussed at this link. I want to design a report that too wide, because I have too much fields to report. For this reason, I want to make my report design landscape. Also I tried
Printer.Orientation = vbPRORLandscape
before showing my DataReport. But I get this error message:
Report width is larger than the paper width
Yes, my report is larger, but not larger than landscape! I want to make my report landscape!
Now, I am downloading SP4 and will try it. Can this solve my problem?
Please tell me, Why does not my DataReport have Orientation property?
Thanks for all.
DataReport And Print Orientation
I have a data report that prints lenghty records ie name, address, phone
etc. To make each record fit on the width of the page, I want to change the
orientation of the print preview and the actual print to landscape
Can anyone tell me how I go about this?
VB6: Datareport.orientation Property Not There Even In SP5
I am using VB6 but the orientation property of datareport is not seen even after installing VB6 Service pack 4 and there after SP5 also. Should i change some settings in Project --> Reference? Please help.
Edited by - haritas on 5/11/2004 7:36:33 AM
Need Help To Change DataReport Orientation From Portrait To Landscape At Run Time
The following is the source code to change the default printer's orientation:
If Printer.Orientation = 1 Then
Screen.MousePointer = vbHourglass
Printer.Orientation = 2
Since I need to print the report in Landscape, so, if the user default printer is set as "Portrait", the programm has to change it to "Lanscape" before the data report show.
However, when I run that, an error always comes up:" Report width is larger than paper width". What should I do?
I checked some information. It looks like this is a bug in DataReport itself. Is it true? if not, is there a way to fix that?
I really really trully deeply appreciate if some one can help me fix that.
Datareport Paper Resizing
I'd like to know how to print datareports in papers with the size similar to those of concert tickets or something. Does anyone know how to do it? Because when i preview a datarepot it always show the report on a A4 size paper....
DataReport Paper Alignment
I am trying to get a DataReport to print records onto tractor-fed slips of paper. The slips of paper are 3 1/2 inches in height and perforated together.
I built the report to have a height of 5040. The first three slips of paper print beautifully, but every three records, the spacing between the top of the slip and the beginning of the printing increase by half an inch.
I assume the system thinks it's printing on 11-inch paper, but three of these slips only make 10 1/2 inches. If it's possible, what is best way to get a VB DataReport to print on 10 1/2" paper?
P.S. I have the option of switching this report to Crystal Reports if it would better suit this type of printout.
Datareport Paper Width
Whe I increase my datareport width the error says
"report width is larger than paper width".How to overcome this
Can Anyone Help me
URGENT: VB6 Reports Orientation
I need to change the orientation of the printer so that my landscape reports print out properly.
Any help would be greatly appreciated.
Datareport Paper Width Problem
Greetings; In Use: Access 2000. VB6 & ADO 2.7
I created various reports using the datareport. The reports are all less than 80 columns each. One is 40 columns. On my test system they display and I can print with out proplems.
When I tried putting them into production, I get the following error:
Report width is larger than the paper width
Can someone tell me how to correct this problem?
As usual I thank you in advance for your response
DataReport Printing On Continuous Paper
i'm still learning the ins and outs of data reports, and here's my problem:
after displaying data in a listview, i'll be using data report for printing. however, i don't know how to set the program up so that it prints ok on continuous paper (the kind dot matrix printers feed on, with the holes in the sides). from the datareport preview, it looks to me like it's normally set up for printing on 8.5" x 11" paper.
is there a way to set it up so that the program automatically prints data on continuous paper, without fiddling with the printer? could anyone show me some sample code for that?
i tried searching this site for tips on that, but so far i've come up blank. any help would be appreciated.
thanks a lot.
Datareport Printing :Paper Ejection
Hope all are in fine tune.
I have got a problem to be solved.
I have a datareport which shows the bill for a particular customer. Now the number of items purchased by a customer will vary for diferent customers. I want to stop the ejection of paper as soon as all the items are printed. But my paper is ejected till the end of the paper until it reaches the perforation. I am using continuous sheet and I can't set the papersize. Can anybody help me out.
Thanks in advance
Orientation Of Vb Control Text[Urgent Please...]
can v change orientation of vb controls? or text of any control.
I want it in label because person can place mark on designed form ie. ==paid== or ====checked! ok === or anything else.
for that i want to rotate object text at 45 degree....
can i do???
thanx in advance
Get Paper Size Using VB
does any one know how to get the printer paper size ie height and width.
What dll do I use and if you have an example that would help.
Hi, Just Asking on How to set the Paper Size of a DataReport to Legal (8.5x14)?
I try using CommonDIalog Box but it doesn't work..
CommonDialog1.Flags = 64
I always go to the Printers and Faxes and set the Paper Size to Legal..
But my other projects, need only Letter(8.5x11) that's why I am going to back it's paper size to (8.5x11)..
What code should I write, so that everytime I run this program, the Paper Size will automatically set to Legal (8.5 x 14)
Hope you can help me with this?
anyone have idea on how to set custom papersize for crystal report 8.5?
does any gurus/newbies/fanatics know how to change the data report size from A4 to A5... is it possible?
thanks for any avail!
Get Paper Size
How can get all paper size which are available in the system to a list box?
How do I set the paper size to 8.5* 3.66 (default 8.5 * 11)??
This is because I have to print form in dot matrix printer in a 1/3 lenth of a regular paper size.
hello. good day.
how can i retrieve all the supported paper size for a printer?
and how can i set the paper size?
i have tried using the printer collection, but always causes an error.
thanks for the help.
How Can I Automaticaly Fit The Paper Size?
Let me try to explain what I want exactly
One of my program is successfully populating the records into many excel worksheets with the given format.
Some of those details are going to many coloums (horizontaly from 'A' coloum to 'O' coloumn). When I am trying print those excel worksheet is A4 size paper, it is coming into more than one paper ('A' to 'K' in one sheet and remaining into another sheet)
How can i automaticaly fit into the A4 size paper width by coding wise?
I know that manually we can go and adjust the size by a draging the lines in print view page. Can I do that through excel automating coding? Is it possible to do? Now everytime user has to go and manually set the lines to fit into the page width
Pls shed some lights on this
Define Paper Size
Can we define Paper Size (A4 or Legal or Letter) while printing thro macro?.
By giving this below code, it is taking defalut paper size. any idea regarding this.
ActiveWindow.SelectedSheets.PrintOut Copies:=1, Collate:=True
Paper Size Names
I'm using the DeviceCapabilities API funciton to retrieve the paer sizes my printer support. I want to display these paper sizes in a combo box. However, the function only returns numeric constants. How do I find paper size name (ie. A4 or Legal) corresponding to a given constant?
Change Paper Size
what is the cording to change paper size and set as landscape .. what is the right cording i m trying like this
printer.papersize = 9
printer.oriantation = 2
its not working
y is that ??
what should i do
Printing Paper Size
I am printing a Data grid to the printer in my application and use a the common dialog box to get the settings. The user can in the advanced settings set the paper size. How do I go about getting this infomation so I can set the paper size when I print. There isn't a property in the Object to get this.
Maybe a API Call????