Paradox Reports Topic

To all, I have a report that includes dates of birth when printed.  I have 4 digit year set as true in the BDE. For one particular dob (2/29/1996), the date of birth prints as 2/29/2996!  In the table, it is 2/29/1996.  This is a leap year birthday.  Although obviously not correct, it concerns my users. This report has printed tens of thousands of dates of birth and this is the first one they have noticed is wrong. Any thoughts? Greg

Anyone know If there is a way to add a subreport to a report?   This is not a Parent/child data issue.   Essentiall I need to cross tabulate data and give a summary of the report data by specific categories. Thanks

I recently sent a project designed in P9 to friend and he is now using P11. He gets this error message when printing 1 type of report. The report is a multi page the error does not show in reports delivered in P11. Is there anyway I can get around this error without re devloping the report.  It is very tedious and time consuming report to design. Report: Layout settings(Page size,paper orientation) have been changed within the print dialog. This will require each page to be regenerated. This can take a long time for large reports. Do you wish to continue? Cheers Bill

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

Greetings, We used a pushbutton method on a form to print a report in Paradox 8 and Windows 7.  Upon upgrading to Paradox 11 the report began failing with a "#Bitmap7 is too big to fit in report." error.

• #Bitmap7 is a full-page 8.5x11 image
• The error is printer independent, and fails even with a PDF printer
• The report still works fine on any printer if you open the report and print directly from that
• Shrinking the image and placing it in the middle of the page solved the problem too
• Recucing the file size dramatically didn't help if left at 8.5x11
It must be that Paradox 11 is trapping an error based on image size that Paradox 8 didn't.  Is there any way to prevent it from doing this, or to tell the method to ignore the error and print anyhow? Might there be anything else obvious that I am missing? Thanks!

Is it possible to fix the number of rows in a MRO table frame even if only the first 4 or 5 are populated? I'm trying to make a complex form and report which fills the total area available.

Hi! I have an application for driving school management, and on most computers where it is installed, from windows xp to 10, when I press a button to choose another printer, the paradox stops running. thank you for your support

I just set up Paradox on a new system running the latest ver of Win 10 (1809).  My reports on the new system required a complete revision of the fonts used in the report.  I've been using the same ones for years and the fonts have always migrated to the new system.  This time, however, the fonts are not available in the properties, font drop down for any of the fields in my report.  The fonts are installed in the usual place and are available to the other myriad programs.  I installed Paradox from an X9 disc which I know doesn't make a difference.  I even uninstalled Paradox from the system and reinstalled using the X8 disc in the hope that it would make a difference.  It, of course, did not.  I am using other fonts that provide a similar impact.  But, not the same. Any body have any suggestions? Thanks in advance. Karen

Upgraded to Office 365 & got the LCAppPrint Initialized Failed error.  Installed the Hotfix Runtime patch after un/reinstalling Paradox 11.  Now, when i try to print, the program closes.    Any ideas are welcomed.  (Using Paradox for single user database & reports.)

My client closed a large amount of jobs in November and cannot generate reports. The error is '#Record_band is too big'. They are able to use the same report but for a different time period. For example, reports from Jan thru July work. Is there a setting we can change that will accommodate a larger dataset?  Thanks! Tim Albertson, Great Divide IT Consulting LLC, 2995 Skyline Blvd., Suite # 208, Reno, NV 89509, tim@greatdivideit.com, 775-229-4415 (direct), 775-636-5047 (mobile), 775-229-4398 (fax), www.greatdivideit.com

Hi. About 7 users use Paradox in a shared environment. Today we saw a new error which we are having trouble resolving. We have backups. When the user opens a *.qbe using Paradox 11 the error is  "Cannot open : WORK:Invoice_Jobs Closed THIS year.qbe". Could not open query file. The same error dialog box reads "Do you want to replace: WORK:Invoice_Jobs Closed THIS Year.qbe in the". That message is truncated.

What can cause this error?

What files are necessary to restore? It seems there is a related *.rsl file and *.db file

What is the reference to "WORK:filename)? There is no WORK in the actual file name.

Some users access this file using an older version of Paradox. Those users see a different message: "Record_Band is too big to fit in report".

We don't do much Paradox support and have been directed here in the past. Any clues would be appreciated. Thanks! Tim tim@greatdivideit.com

Hello everybody, I hav a long running application of mine that has some reports (only landscape ones, as far as I can see) that have begun to show the dreaded message "Report layout settings (page size, paper orientation) have been changed"... Any hint on what can I do to make them behave properly again? I'm running PDX11 (X6 edition) and/or the latest Pdx Runtime 11... I've tried resetting the page size, both to printer specific page size (I'm in Italy so the standard page format is A4) and printer specific A4, to no avail. I've tried both the DynArray report.print and the ReportPrintInfo variant, they both do the same. I'm banging my head on the wall, but no idea seems to help! Thanks for any hint, Shores

Dear all,  I just got a paradox report on our legacy system - paradox 7 for windows. I need to find out what is the underlying data for the report. I opened the report in design mode and look at the data model. It has three tables, two of them linked. Two of them are priv table. I can find the two priv tables - one empty and the other one has data. how can I find which query makes the process? thanks for your help!

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

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?

Dot matrix printer, printing invoices 8.5 x 11 ... after every invoice I get a formfeed (an empty invoice).. I have ran into this problem before and I believe what I have done is recreate the report and the problem goes away.  Anyone know how to fix this in a different and easier manner? This error only shows it ugly face after an edit to a well running report.  Out older epson took a dump and we bought a new oki 320 turbo 9 pin.. so I made some adjustments to the report to compensate to the printers start of form. This basically meant moving things up a bit. Grouped on order# with a table frame. report    page      group         all records         table frame ETC .. ETC..     

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

{Too Long!}

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

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

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.

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

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

{Too Long!}