I.T. Discussion Community!
-Collapse +Expand
Paradox
Search Paradox Group:

Advanced
-Collapse +Expand Paradox To/From
To/FromCODEGuides
-Collapse +Expand Paradox Store
PRESTWOODSTORE

Prestwood eMagazine

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

   ► MB LobbyCorel Paradox / ObjectPAL Coding Board   Print This     

Paradox Reports Topic

 Show:
New Activity New Threads Oldest Unanswered Most Active Most Read
  


25 Threads:

Add New ThreadRandom Thread

Thread 25 of 25
Thread Starter  

afhynes2
Paradox 11 not printing to network printers
I have just re-installed my Paradox 11 on a Windowsx64 laptop and I cannot get it to print reports from Paradox reports themselves. However, they work perfectly if I call them up from a form in objectPAL. When I just try to print in a new Paradox sessionm I get a dialogue box that says: Printer interface setup error/ LCAppPrint Initialize failed!  Then Windows 10 just closes the program. I'm not all that good with finding out where my problem lies. Could anyone point me to some solution, please? Tony
4 days ago
3 replies. Last post:

Steven.G
wow.. just did some searches, and the few pdox-lcapp errors are all about a decade old.. the solution that seemed to have the most reliable sources was "not logged in as admin".. but mixed results, for anything that was suggested
64 hours ago
New Stuff Since Your Last Visit
14
Hits

Thread 24 of 25
Thread Starter  

rum
Windows 10 (Creators update) Print issue
I recently converted another user over to the Paradox 11 Runtime. I now have 10-12 users on the runtime This particular user is experiencing a strange error.  Any report that is sent directly to a Printer causes the runtime to crash.  Sending the same reports to the screen works,  but then subsequently attempting to print another crash Using a PDF Printer works without error. The printers are networked printers,  Paradox V8 on Win 10 had no problem printing to them. I have one other user with a similar problem,  in that users case, they are running Pdox11 runtime in a Remote Desktop environment,  They get the error if they are sending the job to a REDIRECTED printer.   If they send the job to a printer that is not redirected,  then the progam works correctly. Any thoughts?? Jeff
8 days ago
3 replies. Last post:

Steven.G
{Too Long!}
5 days ago
Nothing New Since Your Last Visit
22
Hits

Thread 23 of 25
Thread Starter  

Lothar.K
Prints with Problem (but scrolls properly...)
Hello, I have a particular mailing label report that just started to behave oddly: When I print the report, the result looks like this: GOOD LABEL 1, BLANK LABEL EJECTED, GOOD LABEL 2, BLANK LABEL EJECTED, GOOD LABEL 3, BLANK LABEL EJECTED, , To diagnose the problem, I viewed the report on screen, and it displayed LABEL 1. I clicked to view the next page, and expected to see a blank label, but instead, LABEL 2 appeared. As I clicked along, each label displayed in sequence properly, with no blank pages. So, when scrolling, all looks fine, but when printing, I get the alternation with blanks as I have described. What would be causing that situation, and how can I fix it? Many thanks, Lothar
5 days ago
3 replies. Last post:

Steven.G
yes, paper size mis-match can always do strange things if you kick it to pdf first, you can see what's coming, before you start.. but with something like labels, that might get weird, too, cuz that's not normal paper size
5 days ago
Nothing New Since Your Last Visit
14
Hits

Thread 22 of 25
Thread Starter  

Lothar.K
Document Source Report broken...?
{Too Long!}
78 days ago
4 replies. Last post:

Lothar.K
Hi Steve, When I read your comment, I thought "Of course... that would explain it." But, I searched with care, and there is no mention of "fldDate" in the code on the form. I'll try another approach and will get back here if I can't work it out. Many thanks, Lothar
77 days ago
Nothing New Since Your Last Visit
117
Hits

Thread 21 of 25
Thread Starter  

Peter Dissing
How To use a variable as the name for a report
Hi I would like to have our delivery-note number as the report name, so when we print it with a PDF driver, the pdf attachement would have the same name as it corresponding deliverynote. In order words how would the syntax be for renaming the report before printing ?  Rgds Peter
8 months ago
2 replies. Last post:

skalform
Hi Bill We still are looking for an answer, so thank you for your reply. Yes, we do use PDF Creator.  So using file system method for renaming is the path.  Thank you.  Peter
5 months ago
Nothing New Since Your Last Visit
329
Hits

Thread 20 of 25
Thread Starter  

andwye
Windows 7 Paradox 9 report crash
I've successfully installed Paradox 9 on a windows 7 workstation linked to SBS 2008. However, when I went to amend a report by redefining a field, Paradox crashed. I've tried to do this on two different reports and on two different machines. Why would this happen? Does anyone know how to solve the problem?,
7 years ago
10 replies. Last post:

Anonymous
Great article , Apropos , if someone are interested in merging of two images , my friend merged a service here <a href="http://www.altomerge.com/" >ALTO-Merge</a> and also here http://pdf.ac/49I2EK. --- MAMMIE HAGINS
21 months ago
Nothing New Since Your Last Visit
5576
Hits

Thread 19 of 25
Thread Starter  

Archana.P
Report formatting issue.. please help
Hi All, I am struglling to format 2 fields in RSL file. Can anybody pls tell how to group two fileds? so, always they appear on same line? Thank you.
23 months ago
Nothing New Since Your Last Visit
670
Hits

Thread 18 of 25
Thread Starter  

FlaglerMuseum
Report vs Form size
I'm having a bit of an issue with the window size of my reports and forms.  I want my forms to remain at the full size of the screen.  Under Form Data Properties I have checked off size to fit, I have several forms and when I open them they remain at full screen. The problem is that when I run reports they always come up a smaller screen size eventhough I have size to fit checked off under properties.  This wouldn't be much of a problem except for the fact that whenever I do open up a report not only does it shrink the report size but it shrinks the size of all the open forms, then after I close the report I have to maximize all my forms again.  This is driving me nuts as I run reports all day long.  Any suggestions? Thanks,  Teresa
10 years ago
3 replies. Last post:

Anonymous
Thoughtful post . Apropos , if your business wants a 1996 USDA VS 17-129 , my husband filled out a blank form here http://pdf.ac/a3CZL6. --- ISAURA RASCON
23 months ago
Nothing New Since Your Last Visit
1481
Hits

Thread 17 of 25
Thread Starter  

OzPaul
Calculated field and treat blank as zero
First I should mention that I have "treat blanks as zero" ticked in settings of Pdx10 running on Win7 at work. On my report  I have numeric fields which are covered by undefined calculated fields that show a text value of "Absent" when the corresponding numeric value is 0.0. Otherwise the numeric value is shown. The problem is that when the field is left blank, I want a calculated field to show "Not Done". When I set up an iif isBlank() condition in a calculated field, the calculation treats the blank field as a 0 and reports 0.0 rather than "Not Done". It is as if the treat blank as zero over-rides the isBlank() request.... This does not seem right to me because  the underlying table value certainly is blank... Can you help? Regards. Paul
39 months ago
4 replies. Last post:

OzPaul
FYI, I have discovered that if I use the syntax fieldname = blank() rather than the isBlank() approach, then it works!
39 months ago
Nothing New Since Your Last Visit
1898
Hits

Thread 16 of 25
Thread Starter  

afhynes2
Setting up a report to use a specific paper tray
I am relatively amateurish in developing applications, but have been doing it on and off for many years. I am setting up an application for my daughter's rural veterinary business that will store information about her business, clients and animals and which  will print invoices and statements of account for her clients. She runs Windows 7 operating system and has Corel Office X4 installed on a small network of two computers and two printers. My problem is that I want the invoices to print on her Lexmark T632 printer, which works okay, but I cannot find a way of telling the application to take the paper from Tray 2 on that printer. Is there some code I can write into the application that directs the report to a particular tray on the printer? Tony Hynes
7 years ago
2 replies. Last post:

Anonymous
Is there an option to declare paper type such as Letterhead? --- Jeff
42 months ago
Nothing New Since Your Last Visit
2863
Hits

Thread 15 of 25
Thread Starter  

PaulHoran
report problem
{Too Long!}
59 months ago
1 Reply:

Dan
Hi Paul You are going to need to convert the numerical data to a string and append spaces to the right side of the string using the fill function.  If you want to convert the numerical field values into positional values you will probably have to resort to opal.
59 months ago
Nothing New Since Your Last Visit
1782
Hits

Thread 14 of 25
Thread Starter  

owensct
Paradox 11 decimals not showing up calc rpt field
{Too Long!}
5 years ago
1 Reply:

BradleyWood
Gordon, The problem is that the count() method casts its results as a smallint data type. Therefore, make the following small change to your calculated field to get the results you desire: "number(count([MASTER.PRT_NAME]))/3" Also, ensure that the field is formatted as "Windows #" or some other number format other than "integer".
5 years ago
Nothing New Since Your Last Visit
2139
Hits

Thread 13 of 25
Thread Starter  

Karen.M
I have a report that has a tab...
I have a report that has a table on it.  The table is located in the PRIV file.   Object Pal code copies the table from the PrivMaster to the Priv folder and then Data is inserted into the table.  A report has the table on the data module and the table on the report is defined to the table in the PRIV folder.   The report will not print the first row in the table, but all subsequent rows will print.  I moved the data around in the table to make sure that it wasn't a specific piece of data, but  it appears to be only the first row in the table that is omitted when the report is printed.  Run Time property for the table on the report has the YES radio button selected on the Show All Records.  Any idea's of what I can check when the first row of the table will not print?  ,
5 years ago
Nothing New Since Your Last Visit
1608
Hits

Thread 12 of 25
Thread Starter  

coconut73
pdxwin32.exe hungapp while printing in paradox 10
Hello All, I just started getting a pdxwin32.exe hungapp while printing in paradox on one computer only. We have paradox 10 on 7 nodes with no problem except this particular one. The error just started in the past 2 weeks or so. When paradox starts to print, most of the window turns white and hangs indefinitly. I can print from any other program with no problem. I uprgraded from paradox 10.0.0.663 to 10.0.0719 to see if it would fix but it did not help. What would you guys suggest? Thanks scott
8 years ago
7 replies. Last post:

Anonymous
ATTN: ALL UNDER PRINTERS & FAXES, DELETE THE ADOBE PDF DRIVER & RESTART PDOX 10. --- TOM
6 years ago
Nothing New Since Your Last Visit
3884
Hits

Thread 11 of 25
Thread Starter  

OzPaul
Align text in a text object with embedded fields
I have always had a problem with this and it has come up again so time to ask, am I missing something? I have a text object in a report with fixed wording and two embedded fields containing variable information. Fonts are all the same formatting (Arial 8 Regular) but the alignment between the fixed text and the embedded text is never correct in the final print out. The embedded fields align OK but not with the fixed text.... The result does not look neat. So am I missing something? Thaks, Paul.
6 years ago
1 Reply:

OzPaul
Well I have found a solution which works! If I create an unbound calculated field which combines the fixed text plus the field values, with spaces inbetween, all is displayed in a pleasing manner with no misalignments. eg: "The response to flicker at 30c/s was " +[:NEUROLOG:ERGLIGHT.FLICKERSATUN]+" "+[:NEUROLOG:ERGLIGHT.FLICKER]. Shame the simpler approach doesn't achieve this!
6 years ago
Nothing New Since Your Last Visit
2481
Hits

Thread 10 of 25
Thread Starter  

davidc
Adding line # in table report
I'm sure there is a simple way to do this, but I can't find it! I have a simple tabular report, based on a table with 3 dependant tables. For the report, I'm using a sort and a filter. I'd like to add a field to the table which is the filtered record number rather than the "real" record number (meaning 1, 2, 3, etc. rather than 23,49,123, etc.). Is there a simple way to do that? (Worst case, I can run a query with the filter and do the report off of the result, but that seems like a lot of work.) 
6 years ago
2 replies. Last post:

dcheney
Perfect! Thanks! (minor additional detail: have to select a field to do the summary on)
6 years ago
Nothing New Since Your Last Visit
2440
Hits

Thread 9 of 25
Thread Starter  

Paul Castelow
Hi, The following code appear...
Hi, The following code appears in a undefined field on the record band of my report. Sum([New.Number]*[New.Cost]) I wish to get the AVG of those calculations based on a Group Band. How do I achieve this ? Many thanks, Paul
6 years ago
8 replies. Last post:

1311
Have just cracked it, -used an exclusive field in the table to use for the UniqueCount. Thanks once again.
6 years ago
Nothing New Since Your Last Visit
2465
Hits

Thread 8 of 25
Thread Starter  

Shores
changing non master table in report data model
{Too Long!}
6 years ago
2 replies. Last post:

Dan
{Too Long!}
6 years ago
Nothing New Since Your Last Visit
2510
Hits

Thread 7 of 25
Thread Starter  

kevin_baker
#Record is too big to fit in report Error
In Paradox for Windows, I'm getting this when trying to print a report. #Record is too big to fit in report.
6 years ago
1 Reply:

mprestwood
Sounds like a reports properties problem. Does your report have a TableFrame? If so, is the TableFrame breakable property checked or unchecked? What about Show All Records? Try changing the settings for the Breakable and ShowAllRecords properties.
6 years ago
Nothing New Since Your Last Visit
2109
Hits

Thread 6 of 25
Thread Starter  

Jon
Printing forms as reports doesnt get all pages
I have a 3 page form that I need to open as a report.  When I open it, however, I only get the first page and a half.  Any ideas?  I have to do it this way because the form has some fields that are checkboxes and i need all the possible choices to print on the report.
7 years ago
1 Reply:

jondm
Figured it out - has to do with the page size - ended up having to create 3 seperate reports but it works.
7 years ago
Nothing New Since Your Last Visit
1925
Hits

Thread 5 of 25
Thread Starter  

jglumb
blank in calculated field
Is it possible to check for a null (blank) value from within a calculated field. I currently have a calculated field using an iif statement that checks to see if the value of the field is 0 then it returns a string on the report. I would like to also check if the field is blank and return a different string on the report. 
7 years ago
1 Reply:

AIBreveleri
1. Turn off "Treat Blanks as Zeros".  Interactively, pick Edit | Preferences | Database and uncheck "Treat blank fields as zeros".  In code, use session.blankAsZero(false), 2. Use this model for your statement., iif(isblank(TT.FF]),"this field is blank",iif([TT.FF]=0,"this field is zero","this field contains "+string([TT.FF]))) -Al.
7 years ago
Nothing New Since Your Last Visit
2107
Hits

Thread 4 of 25
Thread Starter  

OzPaul
First page of report printed for day is garbage
Hi all, One of my Paradox 9 runtime (Windows XP) users has recently , started having a problem printing on our hospital network. Each day , the first page printed of a single page Paradox report is blown way , oversize so only a small amount appears on the page and two pages of , rubbish print. If she prints again, no problem. This seemed to begin , at the time I re-designed the print control to include a small dialog , form allowing her to choose which of her printers to use. It also , coincided with the introduction of a new printer. We have not done , extensive troubleshooting but another user has not complained and she , is sharing the same printer and has the same software application , installed. I don't think it should be a Paradox problem but I am , wondering if anyone has encountered this? Regards, Paul. ,
8 years ago
2 replies. Last post:

OzPaul
Hi Mike, I have been on leave so I checked with the user who has been having this problem and it seems to have mysteriously resolved itself. So no, I have not solved the puzzle but currently all is well. Thanks for your concern. Paul.
7 years ago
Nothing New Since Your Last Visit
2774
Hits

Thread 3 of 25
Thread Starter  

KevinHart
Any Print closes Paradox
When trying to print anything (report, screen print, etc) from Paradox the printer dialog does not show and Paradox immediately shuts down with no error message. (Pdox 11 full, Windows 2000), Printing works fine with Wordperfect 11.
12 years ago
2 replies. Last post:

mprestwood
Also, I've had great luck deleting and reinstalling the printer drivers. Seems to clear things out. That's the first thing I try.
7 years ago
Nothing New Since Your Last Visit
1922
Hits

Thread 2 of 25
Thread Starter  

ASPT
Form feed problems
Hello FYI, do not write  a note then run the spell check, then down load the spell checker.  You may well lose your note in the interim. My problem in a nut shell is that no matter what I try and what I do I can not get a PDOX 10 report form from overwriting the printer settings. I am trying to print a 4x6 track feed post card.  Paradox has a 4x6 template and Okidate Microline 186 has a method of changing page lengths ergo form feeds.  I change the form length on the printer and on a fresh start the buffer is clear and when I push the form feed button, the paper is advanced 4".  When I go to print the first record prints and then there is an 11" form feed. I can not find a custom form set up in the Oki driver and the set up in Pdox does not work either.  Any suggestions or anything I may not have thought of would be greatly appreciated. Thanks Ralph Maxwell  
8 years ago
1 Reply:

ric_shumack
Hi, Have you tried defining a custom form via the Print Server?  Open the Printers dialog in Windoze - then go to the menu option File--> Server Properties, and you should be able to add a custom form with your form length. Ric
8 years ago
Nothing New Since Your Last Visit
4172
Hits

Thread 1 of 25
Thread Starter  

tsensor
fields in reports change on their own
I recently changed one of my computers. It is an HP running XP.  We have been running a particular paradox database for years and started using it on this new computer.  When I go to run a report as soon as I open it paradox changes some of the fields to a date field or sometimes another field.  I go back change the form, save it, it may work one or two times then I might change a filter and presto fields change on their own.  If I run the program on another computer it does not happen.  I have uninstalled paradox twice as well as wordperfect.  even reinstalled word perfect x3 and then upgraded to x4 to see if that had an affect to no avail. I am stumped.  Anyone have any suggestions?
8 years ago
Nothing New Since Your Last Visit
2241
Hits

New Thread
-
   Contact Us!
 
PrestwoodBoards.com was developed and is maintainted by me. Do you have a question or suggestion? Do you see a problem? Contact me now. My goal is to build an ad-free and spam-free source of I.T. information with many contributers (ok to promote your website/company in your bio). Yes, my company Prestwood IT Solutions is mentioned in my bio which shows with every post, but you can contribute and promote your pet project too!

2,055 People Online Now!!  
Sign In to see who's online now!  Not a member? Join now. It's free!
Show more stats...


©1995-2017 PrestwoodBoards  [Security & Privacy]
Professional IT Services: Coding | Websites | Computer Tech