I'm developing a database with medical lab reports and I'd like to generate a Report page displaying multiple lab values on one page. I'm displaying 390 different values from the Test table which are distinguished by Date and Name. However, I'd like to do this without having to create 390 relationships between the report and the data tables.

More specifically, the Report layout will have 6 columns each representing a different date. Within each column there will be 65 different results, each with a different name.

It would be nice if I could name the objects on the report layout and then use the name in a relationship in order to display different values in each one. For example this sort of relationship would be nice (if it were possible):

Test::Date = Report::ColumnDate

AND

Test::Name = Report::ObjectName

Is there any way to use an object name in a relationship, or does anyone have a suggestion about how to go about this?

Thanks in advance!

Import the data fro the 390 other labs into a temporary table, and generate the report from this table.

Interesting... Do you mean I should transfer data to a temporary table with a script? I guess in that way I could use object names somehow.

This can also be done with conditional formatting. You can make complete reports and subsummary reports that accumulate their values by processing conditional formatting statements that declare variables.

Conditional formatting? I thought that was supposed to change the color and fonts of a field. You guys are killing me.

Conditional formatting has lots of uses. It can perform calculations on any layout object and collect data into variables. See script "Get Variables Found Set and Report" in attached file.

cfreporting.zip

Wow. That's crazy stuff.