HOW TO CREATE A REPORT WITH MULTIPLE TABLES OR CURSORS?

[venado]

I NEED TO CREATE A REPORT FORM USING MULTIPLES TABLES. IN THE REPORT I HAVE TO DO SOME CALCULATION AND PRINT THE RESULTS ACCORDING TO CERTAINS CONDITIONS.

DOES ANYONE HAS DONE THIS BEFORE? ANY SUGGESTION!!!

THANKS,
venado

 

[spayne]

venado

You may want to create the report in code with @...SAY commands. Otherwise, I have had to use just a few fields from a second table in one report. I put these into variables. It took some tweeking, but I got it to work.

Steve

 

[jimstarr]

There isn't any particular problem creating reports using multiple tables. Assuming you have the tables coordinated the way you want them (SET RELATION TO...) you simply qualify the field names on the report: table1.idnum, table2.name, table1.amount + table3.amount, etc.

Jim