Paradox Reports Topic Most Read Threads

Hi We want to bring our order-number as a barcode on paper. The number is an Integer in the field. For this we use a Code 39 font, and the barcode looks all right on paper, but can not be read by the scanner. Only if we change the field to Alpha and put in * as start and stop character it works. Any idea how to aviod the asterisk, and anyone who knows a font where it works 'out of the box' ? Can the setup for scanner be changed  ? Using PDX11. Best regards Peter

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?,

I have Paradox running on an Acer desktop and when I print reports they come out looking all lovely, just as you would expect. But I also used to have Sony Vaio laptop and when I tried printing the same reports from an exact duplicate of the table, to the same printer, Paradox would hang (the report went blank with the Windows egg-timer appearing but staying forever). I eventually moved from the Vaio and now have an Acer laptop and the same thing happens, but not every time. Whereas on the desktop everything is fine. Am I alone in encountering this?

I am having trouble printing to a PDF driver unless I go out of paradox - change my default printer to the PDF Writer and then go back in. If I change the printer from the Print Dialoge box the PDF file is all messed up., , I can change the printer through code in the full Paradox version - but when this same code is run on a Runtime version - I get the same jumbled results. Any ideas?, , Using P9 with sp3 on runtime and full, Adobe Acrobat 5.0

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

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  

{Too Long!}

I have a form which runs a query to select data within a specfied date range.  The form then opens a report based on the queried data.  Can I pass the start and end dates to the report in such a way as to display this range on the report?

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

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

{Too Long!}

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.) 

I have been using Paradox 10 without too many problems for quite a while but recently installed Paradox 11 (full Wordperfect Office 11 suite) plus all service packs., , Now I am unable to print any reports from Paradox 10. Pdox 10 stops responding, the menu bar and open windows go blank and I need to stop the app through the task Manager. No problems printing from 11 but it won't open delivered reports compiled in 10., , Has anyone else experienced this problem?, Does anyone know a solution to this problem?, Should I uninstal version 11 and stay with 10?

{Too Long!}

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

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.

I am using Paradox 7 - 32 bit on a stand alone XP-Pro computer. When I try to create a new form and try to use "Form/Page Layout" I get an "Unexpected General Protect Violation".  I have done a clean re-install of Pdox and it did not fix the problem. Am I going bonkers?   I can't make custom forms without copying an old form and re-designing it to the new layout? 

{Too Long!}

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?

Pdox 10 -   I'm trying to copy and paste a bitmap image into a report and I get -  "Unexpected General Protection Violation" when i run the report in RT everytime..... Any tips on inserting an image into a report and tweaking it to fit right? Pdox seems pretty flaky when adjusting the bitmap image.... Thx, Shawn 

Using a group band, I have several records resulting. I wish to show only a field in the first record, and suppress the same field in the following 3 or 4 records - because they are identical and surplus to requirements. How do I do this ? Thanks, Paul

I am writing a routine in objectpal to get the top 25 customers into a table and subsequently a report. I can sort the table using "custTbl.attach" and "sort descending" like:, , custTbl.attach("sortme.db"), sort custTbl, on ":PRIV:revenue" D , to ":PRIV:sorted.db", endSort, , But I need some form of TCursor loop or similar method to peel off the first (top) 25 customers., , I could not find a 'Top n' feature in Paradox Reports, Currently using Paradox 11 with sp2. , Any assistance or links to a solution appreciated.

In Paradox for Windows, I'm getting this when trying to print a report. #Record is too big to fit in report.

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.