Hi, All--
I have a report request that would show results of different medical lab tests over the course of different clinic visits over the year. The requested design is to have the test type as the row heading and the appointment date as a column heading, in a crosstab-type configuration. Unfortunately, the DB isn't designed that way. The different lab test types are individual fields in the table along with a date field. With this design, a reqular crosstab approach will not work (at least as I have been able to figure out).
Right now all I can seen to have is a regular report with the the date field and the multiple lab test fields be the column headers, but I'm not able to have the different lab tests as a row header with outcomes for the different dates across columns which is what is requested.
Does anyone have any ideas on how I could get the requested report design using the current table design?
I'm using A2K.
Much obliged!
Paul
I have a report request that would show results of different medical lab tests over the course of different clinic visits over the year. The requested design is to have the test type as the row heading and the appointment date as a column heading, in a crosstab-type configuration. Unfortunately, the DB isn't designed that way. The different lab test types are individual fields in the table along with a date field. With this design, a reqular crosstab approach will not work (at least as I have been able to figure out).
Right now all I can seen to have is a regular report with the the date field and the multiple lab test fields be the column headers, but I'm not able to have the different lab tests as a row header with outcomes for the different dates across columns which is what is requested.
Does anyone have any ideas on how I could get the requested report design using the current table design?
I'm using A2K.
Much obliged!
Paul
