-Collapse +Expand
Paradox
Search Paradox Group:

Advanced
Paradox To/From
To/FromCODEGuides
Paradox Store
PRESTWOODSTORE

Prestwood eMagazine

May Edition
Subscribe now! It's Free!
Enter your email:

   ► MB LobbyCorel Paradox / ObjectPAL Coding BoardObjectPAL Topic   Print This     

report printing from a form

report printing from a form in ObjectPAL topic (part of our Corel Paradox / ObjectPAL Coding group).

Quick Search: printing   report printing   report printing form  
pumkinjay
 (Inactive)
uk
Hi
When printing from a form my report has a comments field on it with three fields within it in total. They are lined up on top of each other.
ie comments field
---------
| field 1 |
| field 2 |
| field 3 |
|______|
When I push the button on the form the code takes data out of table 1 and puts it in table 2 then a report is printed out from the data in table 2.
My problem is that when printed out of the form with this code
 Var
qq Query
tblVar Table
stockRep Report
orderTC TCursor
siNCopies SmallInt
stPrompt String
prnOptions PrinterOptionInfo
reOrders Report
FormVar Form
lastName, firstName String
input,testinput String
repInfo ReportPrintInfo
endVar
active.Action(DataBeginEdit)
active.action(datapostrecord)
input = "Type in IWS Quotaion Number "
input.view ("which quote ref")

qq=query

labmast.DB | No | Pallet No | EA Number | Proper shipping name |
| Check | Check | Check | Check |

labmast.DB | Technical name | Un No | UN Hazclass | Sh | Pg |
| Check | Check | Check | Check | Check |

labmast.DB | Fisher Location | No cntr | Qty | UOM | C/T |
| Check | Check | Check | Check | Check |

labmast.DB | Physical form | Comments | Waste producer | Date prepared |
| Check | Check | Check | Check |

labmast.DB | Listed By | UN Name | UN Num | UN Class | UN Sec | Un Pg |
| Check | Check | Check | Check | Check | Check |

labmast.DB | Tef | Origin | DN. | Date | IWS No | Full label type Y |
| Check~input | Check | Check | Check | Check | Check |

labmast.DB | Trem card | Hcodes1 | Hcodes2 | Hcodes3 | Hcodes4 | Hcodes5 |
| Check | Check | Check | Check | Check | Check |

labmast.DB | Hcodes6 | Hcodes7 | Hcodes8 | EWCodes |
| Check | Check | Check | Check |

EndQuery

ExecuteQBE(qq,"ocd1.db")



qq.readFromFile("ocd1.qbe")
ExecuteQBE(qq,"ocd2.db")





stockRep.open("ocd.rsl", WinStylemaximize)
stockRep.menuaction(MenuPropertiesZoomBestFit)


siNCopies = 0
stPrompt = "Print how many copies?"
siNCopies.view(stPrompt)
if siNCopies > 0 then
repInfo.nCopies = siNcopies
repInfo.makeCopies = true
repInfo.panelOptions = printClipToWidth
repInfo.name = "ocd.rsl"
stockRep.print(repInfo)

endIf

stockRep.close()



stockRep.close()
endmethod
(That all the code from the button)

What happens is that in the comments field the three fields over lay each other if they are bigger than the comments field (all fields are set to word wrap), but if the report is opened normally then printed it prints how it should.
Can anyone give me an answer to this problem?

Jay
 Posted 23 years ago (Thread Starter)
Comment Quote
About pumkinjay
Visit Profile
Inactive member.
Member does not subscribe to this thread.
Email Not Verified!
Once email is verified, we will review and approve the account.
Web Presence Hidden.
Once above is taken care of, full Profile content will display including back links, about me, my message, custom Profile html, social networking links, message board signature, company profile, etc.

Post ID #9766, 1 replies
Thread Started 7/2/2003 3:42:00 AM
View Counter=1781
Last Reply Posted 1/13/2004 6:14:00 AM)
Location=uk  
Joined=24 years ago   MB Posts=20  
Most Recent Post
Moderator
Mike Prestwood
Prestwood IT
Prestwood IT office in Citrus Heights, CA
I know this is an old post, but I wanted to reply in case someone searches.

With reports, their are Run Time properties. I suspect if you work with those properties of these objects you'll be able to get this to work. I suspect either the Fit Height property needs to be checked or more likely the Pin Vertical needs to be unchecked.

Also, you might want to make sure the Design properties Pin properties are not checked for these objects.

--
Mike Prestwood
Prestwood IT Solutions

 Posted 22 years ago
Comment Quote
About Mike Prestwood
Visit Profile
Approved member.
Member subscribes to this thread with a verified email.
About Mike Prestwood

Mike Prestwood is a drummer, an author, and creator of the PrestwoodBoards online community. He is the President & CEO of Prestwood IT Solutions. Prestwood IT provides Coding, Website, and Computer Tech services. Mike has authored 6 computer books and over 1,200 articles. As a drummer, he maintains play-drums.com and has authored 3 drum books. If you have a project you wish to discuss with Mike, you can send him a private message through his PrestwoodBoards home page or call him 9AM to 4PM PST at 916-726-5675 x205.

Web Presence
Facebook, Prestwood IT Facebook page -- fan page. (Visit Me)
Twitter, Follow Prestwood IT on Twitter. (Visit Me)
LinkedIn, Prestwood IT company page on LinkedIn. (Visit Me)
YouTube, Prestwood IT YouTube Channel (Visit My Channel)
Website, My drum website where I sell my drum books. (http://www.play-drums.com)

Post ID #10185 (Level 1.1)  Reply to 9766
Thread Started 1/13/2004 6:14:00 AM
View Counter=2
Location=Prestwood IT office in Citrus Heights, CA 
Joined=26 years ago   MB Posts=1410   KB Posts=1805   KB Comments=53   BLOG, Topics=4  

Revive Thread!

Add a comment to revive this old thread and make this archived thread more useful.

Write a Comment...
Full Editor
...
Sign in...

If you are a member, Sign In. Or, you can Create a Free account now.


Anonymous Post (text-only, no HTML):

Enter your name and security key.

Your Name:
Security key = P1145A1
Enter key:
Icon: A Post    Thread    Idea    Important!    Cool    Sad    No    Yes    Includes a Link...   
Thread #9766 Counter
1781
Since 4/2/2008
Go ahead!   Use Us! Call: 916-726-5675  Or visit our new sales site: 
www.prestwood.com


©1995-2026 Prestwood IT Solutions.   [Security & Privacy]