Data Report In Vb6|error:report Width Is Greater Than Page Width|what Can I Do?
i am building my report on vb6 data report. i have to make a wide report since i have so many fields to accomodate. but when i try to run the app. it says the report width is greater than the page width. how can i get over this situation.
i switched over to vb6 data report because..
( i tried making reports on crystal reports 8.5 but i can't adjust so many fields on the single report even after changing the page setup to landscape instead of portrait.)
can't i make bigger reports? please help.
View Complete Forum Thread with Replies
See Related Forum Messages: Follow the Links Below to View Complete Thread
Data Report In Vb6|error:report Width Is Greater Than Page Width|what Can I Do?
i am building my report on vb6 data report. i have to make a wide report since i have so many fields to accomodate. but when i try to run the app. it says the report width is greater than the page width. how can i get over this situation.
i switched over to vb6 data report because..
( i tried making reports on crystal reports 8.5 but i can adjust so many fields on the single report even after changing the page setup to landscape instead of portrait.)
can't i make bigger reports? please help.
Error In Data Report(VB6) &"Report Width Larger Than Paper Width&"
I am suppose to generate a Data report in VB6..
but i am geting an error like 'Report width larger than paper width'
my data report width is 10000
i have also tried it by reducing it to 8000
but still geeting the same error......
is it because of the few large datafields in the report....
please tell me the solution...i needit urgently
Changing Page Width Using Data Report
===================================
I have the following code into a module.
'============Code==========================
Option Explicit
Private Const CCHDEVICENAME = 32
Private Const CCHFORMNAME = 32
Private Const STANDARD_RIGHTS_REQUIRED = &HF0000
Private Const PRINTER_ACCESS_ADMINISTER = &H4
Private Const PRINTER_ACCESS_USE = &H8
Private Const PRINTER_ALL_ACCESS = (STANDARD_RIGHTS_REQUIRED Or _
PRINTER_ACCESS_ADMINISTER Or PRINTER_ACCESS_USE)
Private Const DM_MODIFY = 8
Private Const DM_IN_BUFFER = DM_MODIFY
Private Const DM_COPY = 2
Private Const DM_OUT_BUFFER = DM_COPY
Private Const DMORIENT_PORTRAIT = 1
Private Const DMORIENT_LANDSCAPE = 2
Private Const DM_ORIENTATION = &H1
Private Type DEVMODE
dmDeviceName As String * CCHDEVICENAME
dmSpecVersion As Integer
dmDriverVersion As Integer
dmSize As Integer
dmDriverExtra As Integer
dmFields As Long
dmOrientation As Integer
dmPaperSize As Integer
dmPaperLength As Integer
dmPaperWidth As Integer
dmScale As Integer
dmCopies As Integer
dmDefaultSource As Integer
dmPrintQuality As Integer
dmColor As Integer
dmDuplex As Integer
dmYResolution As Integer
dmTTOption As Integer
dmCollate As Integer
dmFormName As String * CCHFORMNAME
dmLogPixels As Integer
dmBitsPerPel As Long
dmPelsWidth As Long
dmPelsHeight As Long
dmDisplayFlags As Long
dmDisplayFrequency As Long
dmICMMethod As Long
dmICMIntent As Long
dmMediaType As Long
dmDitherType As Long
dmReserved1 As Long
dmReserved2 As Long
End Type
Private Type PRINTER_DEFAULTS
pDatatype As String
pDevMode As Long
DesiredAccess As Long
End Type
Private Declare Function OpenPrinter Lib "winspool.drv" Alias "OpenPrinterA" _
(ByVal pPrinterName As String, phPrinter As Long, pDefault As _
PRINTER_DEFAULTS) As Long
Private Declare Function SetPrinter Lib "winspool.drv" Alias "SetPrinterA" _
(ByVal hPrinter As Long, ByVal Level As Long, pPrinter As Any, ByVal Command _
As Long) As Long
Private Declare Function GetPrinter Lib "winspool.drv" Alias "GetPrinterA" _
(ByVal hPrinter As Long, ByVal Level As Long, pPrinter As Any, ByVal cbBuf As _
Long, pcbNeeded As Long) As Long
Private Declare Sub CopyMemory Lib "kernel32" Alias "RtlMoveMemory" (hpvDest As _
Any, hpvSource As Any, ByVal cbCopy As Long)
Private Declare Function ClosePrinter Lib "winspool.drv" (ByValhPrinter As _
Long) As Long
Private Declare Function DocumentProperties Lib "winspool.drv" Alias _
"DocumentPropertiesA" (ByVal hwnd As Long, ByVal hPrinter As Long, ByVal _
pDeviceName As String, ByVal pDevModeOutput As Any, ByVal pDevModeInput As _
Any, ByVal fMode As Long) As Long
Public Sub SetOrientation(NewOrientation As Long)
On Error GoTo eh
Dim PrinterHandle As Long
Dim PrinterName As String
Dim pd As PRINTER_DEFAULTS
Dim lpDevMode As DEVMODE
Dim Result As Long
Dim Needed As Long
Dim pFullDevMode As Long
Dim pi2_buffer() As Long
PrinterName = Printer.DeviceName
If PrinterName = "" Then
Exit Sub
End If
pd.pDatatype = vbNullString
pd.pDevMode = 0&
pd.DesiredAccess = PRINTER_ALL_ACCESS
Result = OpenPrinter(PrinterName, PrinterHandle, pd)
Result = GetPrinter(PrinterHandle, 2, ByVal 0&, 0, Needed)
ReDim pi2_buffer((Needed 4))
Result = GetPrinter(PrinterHandle, 2, pi2_buffer(0), Needed, Needed)
pFullDevMode = pi2_buffer(7)
Call CopyMemory(lpDevMode, ByVal pFullDevMode, Len(lpDevMode))
lpDevMode.dmOrientation = NewOrientation
lpDevMode.dmFields = DM_ORIENTATION
Call CopyMemory(ByVal pFullDevMode, lpDevMode, Len(lpDevMode))
Result = DocumentProperties(0, PrinterHandle, PrinterName, ByVal _
pFullDevMode, ByVal pFullDevMode, DM_IN_BUFFER Or DM_OUT_BUFFER)
Result = SetPrinter(PrinterHandle, 2, pi2_buffer(0), 0&)
Call ClosePrinter(PrinterHandle)
Dim p As Printer
For Each p In Printers
If p.DeviceName = PrinterName Then
Set Printer = p
Exit For
End If
Next p
Printer.Orientation = lpDevMode.dmOrientation
Exit Sub
eh:
End Sub
----------------------------------------------------
How can I change this to work for a user who's printing to a Windows NT network printer. Thank's.
Changing Page Width Using Data Report
I have created a report using Microsoft's Data Report (Visual Basic 6), that is to be printed on 11 x 17 paper with a landscape orientation. However, every time I try to run the report I get a message that says the report width is larger then the paper width.
How do I change this at run time?
Thanks for any help
Report Width Larger Than Paper Width Error In Datareport
I have to print a report (datareport), there is a predefined certificate on which I have to print my report
problem is, the certificate is a bit wide...and i am getting "report width larger than paper width error"
i have dragged the scale (width) to 8.1 or 8.2, beyond that if i drag, i am getting the error
i have set the datareport properties leftmargin, rightmargin, topmargin and bottommargin as 0.
i have increased the reportwidth property value, still no use
i want to increase the width of my report, (scale > 8.5), how to do it?
Srikanth
Error: Report Width Is Larger Than The Paper Width
i create few reports using Data Environment & Data Report. the reports r in A4 size (portrait), and some r in A4 size (landscape). when display the report which is portrait, it has no error. but when display the report which is landscape, an error says 'Report width is larger than the paper width'.
to display the landscape report, i must goto printer setting and set the paper orientation to landscape. then all my report can display.
BUT, the height of the portrait report is shorter. i mean the bottom of the portrait report will be blank (4 inch from bottom is blank)
i try to change the orientation before i open&display the report, but it doesnt work.
how to change the orientation, and the paper? pls help. Thanks.
Report Width Larger Than The Paper Width ERROR
Hi ,
I am using data reports for getting some reports from my application.While displaying or printing my reports, I get an error saying 'Report width is larger than the paper width.'
Now irrespective of the paper width settings of the printer I want that when I use the application at my client side, it should adjust the paper settings and printer settings so as to show and print the report.
Can anyone help me out on this....I have very little time at hand...and its ticking away...tick..tick...tick.....Help me
Thanks in advance.......
Data Report-report Width Not Exceding 12100
Hi All,
I have installed HP laser jet 2200 printer.The paper size is A4.If I take the printout in "Landscape" space is left on the both sides of the paper.My reportwidth property is 12100.If I increase the reportwidth property to say 12500 and few coloums in report at design time and then run the report.It gives the error that "Report width is larger then paper size."Is there any solution of this problem.Please relpy asap.
Waiting for the valuable advice with code.
regards
Sanjeev
How Increase The Page Width Of Crystal Report
Dearmost All,
I am making a report with CR, in my report their are many fields to show. They are not fit into the default a4 size.
So I want to increase the width of the designing window, and also preview window.
Plz Help me.
Thanks in Advance.
Fazal.
Report Width Problem With Data Report
Hi,
My data reports are running fine on my PC, but when i run my application on another PC, it gives error that Report width is out of paper. May be this is a printer problem. How can I solve it that report will run finely on all PCs
Thanx
Report Width Larger Then Paper Width
i get the above error when i try to generate a report in vb. i am using the report designer, but i have checked the report and there is not label or text field or anything lapping over page - what could be the problem? any help would be greatly appreciated!
Report Width Is Larger Than The Paper Width ???
Hello all,
I just make an data report.
but when i try to run the project, there is error :
"Report Width is Larger than The Paper Width"
How to set the Paper Width ? Can i set it by code ? And How ?
I was try to setting my printer default on Lanscape paper, but still not working..
Please help..
Thanks
Report Width Is Larger Than The Paper Width
Dear vbguru out there,
I have encountered this error message "Report width is larger than the paper width" while exporting my form to data report in vb. Can anyone here help me in this? I have checked the microsoft support website and it said to download the latest service pack. I have done that but still getting the same error. Not sure why...Do I need to do anything after installing the lastest service pack? Urgently needed help here. Thanks in advance...
REPORT WIDTH IS LARGER THAN PAPER WIDTH
can somebody help me fix this program?? i got a presentation in a day
thanks!
it keep giving error msg "REPORT WIDTH IS LARGER THAN PAPER WIDTH" when i click on booking details and cruise details
THANKS PPL
Data Report Width
I want to display information on a number of rtText Boxes, the problem is I can not put all of my rtText Boxes because of the error msg, keeps on coming saying "Report width is larger than the paper size".
How do I increase the report width to allow me to add more of my text boxes to display information.
Thanx in advance
Report Width Error
i have designed my report and keep on getting this error
report width is larger than page width
i have looked through all my class tutorials and they cannot offer any help. Can somone PLEASE take a look at the report (included below) and modify it as i am totally new to making reports and wouldn't know where to start to correct it
thanks for any help
nod31
Report Width Error
I have a program that includes a data report in vb6. This report is then exported to html. When I try to do this, I get an "error: Report width is wider than paper width". According to Microsoft, there is no workaround, and this bug was fixed in versions later than service pack 4. I'm running sp5, yet the bug remains. SO: does anyone know a workaround (in spite of micro$oft's denial), or, is there a way to change the orientation of the paper I'm exporting to so that it is landscape? Or (even better) both? Thanks a lot
Problem With Data Report Width.
I'm currently using a Data Report (unbounded to a Data Environment). I got everything working fine but I'm having problems with the report width on print preview. Currently, I designed the report width to be the width of an A4 size paper. but if a user changes the default paper size from the printer options to something smaller (Letter size paper), I get an error. Though it may be clear to the user that they have to change the printers default paper size, I'm afraid that there might still be some users who wouldn't understand it. Is there a way that I can set the report width according to the printer's default paper size or at least display the printer obtions dialog on the error is raised? Please help...
Set Paper Width In Data Report
I need help getting my data report to print correctly.
I am trying to print to a Genicom Line Printer using Green Bar Computer paper. The Printable area of the paper is 10.5"Hx14"W. I have tried to change the Report Width property to 20160 and the Height to 15120
the report width change takes, but the Height defaults to 11520.
When the report is called I get the "Report is wider than paper" error. I have changed the orientation to rptOrientLandscape, but the text prints vertically across the lines rather than along the lines on the paper.
How can I tell it that It is printing on the computer paper and not on a standard sheet of paper.
If this does not make sense or there is information that I need to include please let me know. I am on site trying to solve this problem and could really use someones help.
Thank you in advance for your help
Bart
Edit:
Is my question ill-posed, or is it just one of those bizarre questions that is difficult to answer? Or...is it one that should be in the Recycle Bin due to its simplicity
Thanks again in advance
Bart
Data Report Width Problem
Hi all!
Im trying to create a report which is in a landscape orientation and in a legal size paper. The problem is, I always have this report width problem, "Report width is larger than the paper width", in fact, the report width is larger than the set paper width. What really is the problem and could someone have some snippet on this? I'm using this following snippet:
With dtrSummary
.Orientation = vbPRORLandscape
.ReportWidth = Printer.Width - .LeftMargin - .RightMargin
End With
Set dtrSummary.DataSource = rsReport
dtrSummary.Show 1
any help will do. thanx in advance.
Can I Change The Width Of A Data Report
hi
please tell me if i can change the width of my data reports or get it in a landscape page setup as i am getting eroors if i put textboxes more than the width of the report
Width Property Of Data Report
hi pips.. how can i change the width property (not the reportwidth...) of the
data report? no matter what i do, the maximum value it can have is only 12000.. please help.. tnx in advance..
How To Increase The Width Of A Data Report
Hi
I'm working on a project and I designed some datareports as part of that project. There I caught by an error such as u'r report size is larger than the page size.
but I want to enlarge the width of that data report. if any of U know tell me plz..
How To Increase Data Report Width
there are many fields in my data report. thus they are not fitting in the given width.
so how can i make my data report in landscape format so that i can easily manage more data fields in the given report width.
please give reply at the earliest.
Problem Regarding Display & Width Of Data Report.
I want to display some of my labels & textboxes in Page Header section rather than in Detail section. Problem is that labels moves in Page Header but textboxes Doesn't move in Page Header. What's the solution? or Can we create any other section? If yes, how?
I know by using properties of report we can increase the width of report. But a run time error 'Report Width is larger than Papaer Size' occurs when i mention report width greater than 9360. Is it a maximum limit for width? If no, then how can i extend the width coz all fields that i require doesn't fit into the Page Header.
Plz, reply me as soon as possible at
ukailey@yahoo.co.in
Edited by - neetu_9 on 3/12/2005 2:45:13 AM
Data Report Width At Design Time
Hello,
So, after some digging, I finally was able to find and implement Microsofts fix to set the orientation of my data report to Landscape, and it is working perfectly. However, during Design, VB will not let me set the Object Width of the reports higher than 12000 (I want to design the report for landscape).
Can anyone give me a tip on how I can set it higher than 12000, or do I have to layout the report during run-time?
Thank you ahead of time.
Tom
Setting Paper Width In Data Report
Hello Everyone
I am using Data reports in my project. I want to take the print out of the report, on the Continuous Computer Paper(using dot matrix printer). I am unable to set the page width of the report to suit this dimension. Can anyone please tell me how can i do this?
Thanks in advance
Regards
Determine If Label Caption Width Is Greater Than Label Width
Is there anyway to add a check to deteremine if a caption of a label is longer than the label width, and if it is, omit the last few characters to make it fit and add "..."
Example: If "How are you doing?" doesn't fit in the label, it'll show "How are y..." instead.
CRYSTAL REPORT .......HOW TO INCREASE THE WIDTH OF THE REPORT
hi .. I am making a crystal report, using cross-tab designer and getting right results but.....I have 17 columns in my report. which I want to show together. crytal report shows all the columns together in preview section but when I open design section it just show only, those number of columns which it can mange only on one page......and it doesn't allow me to edit extreme right side columns
waiting for reply
thanks
Data Report : Data Is Larger Than Width Of Txt Box
I have a feild that can have max 200 chars
and in my data report text box is not long enough to hold it
how can I make it fit into the txt box (like we use multi line text box in the forms ) ???
Edited by - haahoou on 1/30/2004 11:42:18 AM
Report Width In Report Designer
Can anyone help me work how to set the width of a report in the report designer to landscape?
I have worked out that the report should be:
Max width 27.94cm * 567(twips) = 15841.98 twips
Max height 21.59cm * 467 = 12241.53 twips
I have tried setting height and width to only 12000 width * 6000 height (twips) but the error I get is:
Report width is greater than page width.
Please help me stop tearing my hair out.
Report Width
Dear Friends,
I'm overcoming a problem in data reports ,the error
it gives is "Report Width is larger than the Paper Width",i
checked all the print setup select all types of paper settings but
to no avail.
Also the report width is smaller thant the total width.
Please help if somebody has faced same problem.
Regards,
Prashant.
Report Width
i am generating a report. margins are so big (left, right, top, and bottom).
how can i reduce the margins of the report?
i am getting an error that says the the report width is larger than paper width
Thank you
How To Increase The Width Of Report
hi,
i want to know how can we increase the width of report .
i have to display so many fields row wise .
please suggest me some solution for it.
thanks
Full Report Width!
hello,
I hv silly problem!
I used CR 9 with Oracle 8 .
I called report from vb.
But the problem is in Vb report is not shown in it's full width.
Means i hv selected 8 X 11 in in CR.
But in VB i can't see full width i can see only 5 in.
Wht should i write to solve this problem so that one can see whole report without horizontal scroll.
Please help me.
Thanks a lot.
Width Of A Crystal Report
hi,
I'm using Crystal report 4.6. Is there anyway i can increase the width of the report? or is the width limited ?
Thanks
Report Width Limit?
I am not sure what units it is measured in but in Access 2003 I can only stretch it out to '56', which is about two and a half pages in landscape. Is there a way to stretch it further?
Report Height & Width
i Friends,
I have a receipt in vb6 and data in access2000. I want to get the print out of this receipt which is very small in height but my vb datareport gives me print in whole one page. I want to short the height and weidth of this report. is it possible.>> HOw??
with regards
pratik mehta
How To Set Paper Width In Report
I generate report use VB tools. It has problem in generate horizontal A4 paper report.It has error " the report length is exceed the paper width"
wky086
|
TRACKER
