Tabular Report

[Guest]

I want to create a report that is in the format of a 8x9 table. I want to
group my data by date and have the dates displayed horizontally across the
top row of the table. I then have static lables that would be displayed
vertically in the first column. The middle cells would be filled with the
coresponding data for the category listed in the first column and the date at
the top. For example: I am using this to track medical data. I have a date
and time for each number I record - i.e. blood pressure, blood sugar, etc. I
have a query that will pull all the records between specific dates (say
10/18/04 -10/24/04). I would want the column headings in the report to read
- 10/18/04, 10/19/04, 10/20/04, 10/21/04, 10/22/04, etc. and the row lables
would be blood pressure, blood sugar and so on - these remain the same each
time the report is run. Then the cells would contain the blood pressure
readings recorded on 10/18 and the one below would be the blood sugar
readings for 10/18 - there can be multiple readings for each day. Any
thoughts on how to make this happen? I know how to group by date but I can't
get it to display in the table format with the variable headers (dates)
across the top. One other thing - there may be many blank cells in a record.
Each record has a field to record all my readings (blood sugar, blood
pressure, weight, input, output, etc.) I may only record one thing - such as
blood pressure at that date and time - how do I supress those blank fields in
the report?

Thanks
Suzanne

 

[Duane Hookom]

There is a calendar report demo at
http://www.invisibleinc.com/divFiles.cfm?divDivID=4. The calendar displays 5
days across as 5 copies of the same subreport. This could be modified to be
any number of days. I have modified it to show 7. You would need to set the
week starting date be your specific date.