Home› General
ReportBuilder 22.06 now available including Delphi 12.2 support!
New Blog Posts: Merging Reports - Part 1 and Part 2

About the datasource of Report SQL query

rbuserrbuser
edited February 2002 in General
Hi... My question is a little complicated to explain, I'm from Spain.

Well, I have a Report Designer that lets end-users to edit their own
reports. The program is a POS application, with many companies support. Each
company has its won subdirectory.
So, the database files (Paradox + BDE) for company 1 are located in
subdirectory ...\Data\1 of the application directory

If the user has two companies, the database files of company 2 are located
in ...\Data\2 subdirectory

If I make/edit a SQL query for a report made for company2, it works. I save
it to a RTM file and I can load it later...
BUT it doesn't work for company 2, because it was saved for database files
of company1 (located in another subdirectory)

So, if I load a RTM made for Company1 but I'm using company2 right now, the
report loads, but it shows/prints the data from Company1

How can I prevent it?

Thenks, and forgive my english!

Comments

  • rbuserrbuser
    edited February 2002
    Santy,

    First, your English is fine!

    Is it possible to store your reports in a table instead of individual files?
    ReportBuilder lets you do this. You could create separate folders for each
    company's reports. See the documentation on using the Report Explorer, and
    saving reports to tables.

    John

This discussion has been closed.