PARADOX 4.5 - Multitable Reports?

[M.Emmanuel]

I have successfully used linked tables to do things such as retrieve exchange rates for a particular date using a lookup exchange rate table.

However, I have not been able to identify a way to create a report which includes several tables that are not linked and that you just want to present sequentially in the report.

I have a use case where I want to group several tables in one report, one after another.

All tables are very similar in fields, but I find convenient to treat them as separate tables.

Was that possible in Paradox 4.5 DOS?

Thanks,

[Steven Green]

doesn't have to be one report.. it can easily be separate reports printed together in sequence 

Steve at Oasis Trading Post

--
You received this message because you are subscribed to the Google Groups "TheDBCommunity" group.
To unsubscribe from this group and stop receiving emails from it, send an email to thedbcommunit...@googlegroups.com.
To view this discussion visit https://groups.google.com/d/msgid/thedbcommunity/1a84239f-5339-4d2e-90d1-3cb148dfc6fbn%40googlegroups.com.

[Kevin Zawicki]

right

I have some situations where I have random reports (in and out Paradox) the client wants as one "report".

Just print them back to back in order.

Or

I create PDFs, join them all and present or print that.

One gotcha is that if printing double sided and you have a single PDF that has multiple reports are 1 page, the 1st page of next report is on back side of page 1 of first report. But there are ways around that, too.

[M.Emmanuel]

Thanks for the suggestions.

Just for reference, I finally created several tables with identical fields and added a temporary table to consolidate their contents. This table is emptied and repopulated before each report generation:

```
EMPTY "M21EXPEN"
ADD "M21EXP1" "M21EXPEN"
ADD "M21EXP2" "M21EXPEN"
ADD "M21EXP3" "M21EXPEN"
VIEW "M21EXPEN"
WINMAX
{REPORT} {OUTPUT} {M21EXPEN} {1} {SCREEN}
```

Since printing was mentioned:

DOSBOX-X can be configured to redirect LPT1 output to a file. This captures the report as a print file, which can then:
- Be sent to a dot matrix printer via RawPrint.exe, since Windows 10/11 no longer supports raw printing (matrix printers are indestructible and will outlast civilization), or
- Be converted to UTF-8 and used to generate a PDF.

I think DOSBOX-X defaults to code page 850 — that's what my legacy printer is set to, and German characters print fine.
It also accepts UTF-8 pasted from Windows and converts the characters on the fly.

Despite the age of the tools, the setup works — and you can still copy and paste between PARADOX DOS and the modern world.