Printing Data Details (Formatting for Printing)

parsifal — Tue, 23 Feb 2010 21:24:34 GMT

This site has been a tremendous boon to me. I am hoping that it can come through one more time on a specific issue.

I have am using an Access database because I cannot put up a SQL database for several reasons, not the least of which is that some places where data will be collected will not have Internet access. So, I am putting the InfoPath forms out on a jump drive that is connected to an Access db on the same drive.

Prior to finishing the data collection, our collectors will need to verify the data they have entered into about 65 variables. Virtually all are Yes/No and listed by case (record). I have a fine looking data display form with one problem -- if there are too many cases, the data run out of the section and display without their correlating variable names (just 65 variable values with no variable labels). That is a bad, bad result.

The cases (records) are selected by a SQL query. Only the cases from a specific school (selected in the query) are displayed.

Vertically, the names of the variables are displayed on the left-most column. Each of the values for that variable across the cases is displayed in rows. The top of each column other than the variable label column is the case number. So, it looks something like this:

Variable Labels Case #1 Case #2 Case #3 Case #4 etc ...

Variable 1 Yes No Yes Yes

Variable 2 Yes Yes No Yes

Variable 3 No Yes Yes Yes

The second page is a continuation of the first... same format but with:

Variable Labels Case #1 Case #2 Case #3 etc...

Variable 31

Variable 32

Variable 33

This works well up until we get to the point of having about 8 cases. Then case #9 will display like this, without a Variable Labels column:

Case #9 Case #10 Case #11 etc....

Yes Yes No

No Yes No

Yes No No

The data formatting is ugly at this point. How can I fix this problem?

General

Printing Data Details (Formatting for Printing)