Cross Tabs and labeling rows/columns

If I understand correctly, you should be able to create this header and place it into the page header on your report so it'll print at the top of each page.

If I misunderstood what you want please let me know.

frodoman

Frodoman;

That doesn't seem to work.  I tried putting something in the PH but when there are more columns then the page can support in preview mode it doesn't treat it as multiple pages, it puts them side by side with a light dashed line separating them.  Upon printing it does go to multiple pages but no header on the 'second' page.

Also,  I'll have a problem formatting them to be lined up correctly. I simplified the example, it really has more columns and rows and looks like this:


                                                     Sample ID |
                                                Sample Name |
                                                Date Sampled |

Analyte         |  Unit |   Method                         |

So getting that into the PH in the right places will be tough because the cross tab will be 'below' it.

Thanks

ugh,  I feel like an idiot.  i followed your advice and it worked, so i put in the other titles and i don't know what i screwed up because it aint working now.  tried to quit without save and start over still can't get it to come back to life.  sometimes ...........

frodoman;

I still can't get this to work.  The virtual pages (ie the over flow columns) are still not getting the 'text' objects (and I swear I saw it do it once, but never again).  I think its because it is still only seeing one page even though it's two on the virtual screen and the printer.

The data (samples) are linked via a project field so the record select is project = xxx.
The grouping is on project (although there is only ever going to be one project for the report).  The cross tab is in the group header.  My 'text labels' are in the page header, nothing in the report header.  In section expert only the following are checked:

RH : Free Form Placement
PH : FF Place
       Underlay following Sect
       Keep Together (greyed out though)
GH: FF Place
Detail :  FF Place
            Hide
            Suppress
            Keep together
GF :  FF Place
        New Page After
PF : Supress
RF : FF Place
       Hide
       Supress
       New page after (grey)
       Keep together

I've tried bunches of combinations and I just can't seem to get the text over to the virtual pages.  Any ideas ?

Thanks

Frodo;

Any possibility of doing the grouping on a formula basis.  I know how may samples are in the project, and I know from my layout that I can fit three across.  So if we could find a way to group every three samples together, then I can get the headers out on  each page of the report.

Thanks

Steve M

I've increased the points, since I'm still struggling with this one.  I think the best bet is to figure out how to do some type of formula based  grouping.  My back's up against the wall on this one so help would be appreciated.


Thanks

ok, I found a solution, since I know I can only get three columns on the page and my sample ids are generally sequential (and i can control the record select sort to the sample ids which will at least put them in order).  I created a formula like

sam_id \ 3 (interger divide)

placed that in the group expert on what to group and I think I'm out of the woods. then did a new page after the group footer (cross tab is in the group footer)

Frodo;  I'm giving you the points because I hadn't thought about the underlay technique and you still need to underlay the page header to get the titles to show up.

Thanks

Steve,

Thanks for the points.  Sorry I didn't respond to your last few posts - I was unexpected unavailable for a few days.

Cheers,

frodoman