Paradox Reports Topic

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

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

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

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

Hi!I'm already using the ReportOpenInfo variant of the open method to change the master table that is used on a report, as to permit the user to restrict on which records to run the report on (something like "print the address book of clients beginning with letter A").I was wondering if there is a way to replace a table in the report's data model with another one, since there are times when it would be nice to filter the child table in a 1 to Many relation; for example, if I want to print the list of invoices with the associated payments, but I need to see payments status as if we were two months ago: I cannot put this filter on invoices, since this would exclude, for example, invoices that have no payment in the requested range, and I should instead pre-filter the list of payments that would be used as a child table.dmRemoveTable/dmAddTable cannot be used for this purpose, as they make the UI object become disconnected from the fields; I would need something as dmReplaceTable (that do...

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

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.

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

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. 

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.

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  

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?

Now, sorry if I am not using the correct terms here, but I'll try my best to explain whats happening: EDIT: using Paradox 7 for win 3.1 Have a report which we print off which gives us the reg numbers of all vehicles under a companies licence. In a particular licence, there are 65 reg numbers. When we print off the report for this licence, 67 rows are printing out. 2 of them are duplicate values. Now, I've gone into the table where I believe the data is coming form for the report, and there are only 65 rows in the table for that licence. So somewhere I am getting 2 duplicate values printing out. This does not appear to happening (yet anyways) in any other licence reports that we print out. I've no clue where to even start on this.. The only thing I can note is that it is a 6 page report, and the positioning of the duplicate rows are as such: page 1 - information page, no data page 3 - last row reg no=1234 page 4 - first row reg no=1234 page 4 - last row reg no=5678 page 5 - f...

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

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

I am running an application using Paradox for Windows 5.0. (I know this isn't current but it was working well and I saw no need to change). It is running under Windows XP with all current windows updatesThe printer I am trying to configure is a Nec P6 with a parallel cable. My original PC computer had a parallel printer port and everything worked just great. Now, with a new computer, I have to use a USB to parallel printer adapter, so I am using a Keyspan UPR-112 multiport replicator. Another change I have made is that I am running Windows XP on VMWare Fusion on an Intel Processor MacBook Pro. All my other applications work well from Windows running under VMWare Fusion and I can get the UPR-112 parallel port to show up in the printer setup window of Paradox and shows up in the VMWare Fusion Virtual Machine setup as UPSH 112i Parallel. In fact on one occasion I did manage to print appropriately, but now I can't repeat that, and I get an error message saying , "No printer installed or W...

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?

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 

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