Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win


Cross Tabs and labeling rows/columns

Posted on 2004-09-08
Medium Priority
Last Modified: 2008-02-01
I've built a cross tab and got the data to lay out the way i want.  However, I would like to put a textual label outside the grid and have it carry onto multiple pages which I can't seem to to inside the cross tab and if I put a text object with the labels, it doesn't print on pages after page 1.  The cross tab is in the group header (i've also tried it in the report header with the same results).  I'll try to layout what I'm asking below:

                                    Sample:|  001     |    002  |   003   |  004
Analyte:                                    |
pH                                            |   7.5           2.3       1.3       4.4
Conductivity                               |  2300          123      98.7      45.5
Hardness                                   |   3                43        52        65              

So what I'm trying to achieve is getting "Sample:" and "Analyte:" onto all pages of the report.

Thanks for your help.
Question by:smeyer4314
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 6
  • 3
LVL 42

Expert Comment

ID: 12007646
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.


Author Comment

ID: 12008734

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.

LVL 42

Accepted Solution

frodoman earned 1500 total points
ID: 12008884
Okay, now that I understand your question more clearly...

Create a text object and put the word "sample" in it and place this object in the page header (top left corner of course).

Now use Report -> Section expert and for the Page Header check the box for "Underlay following section".  Still in Section Expert, select Group Footer and check the box for "New Page After".  This forces each group to start at the top of a page and puts the static text in the page header.  The underlay option will position it over the crosstab.

This doesn't help with your alignment issues but there's no good fix for that.  Your only option is to play around with it until it looks right.  Using a fixed width font will help, but that's not always desireable.

I believe this is the closest you will be able to get to what you want.


Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.


Author Comment

ID: 12009395
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 ...........

Author Comment

ID: 12047772

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
            Keep together
GF :  FF Place
        New Page After
PF : Supress
RF : FF Place
       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 ?


Author Comment

ID: 12048961

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.


Steve M

Author Comment

ID: 12053505
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.


Author Comment

ID: 12060083
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.

LVL 42

Expert Comment

ID: 12063527

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



Featured Post

Ask an Anonymous Question!

Don't feel intimidated by what you don't know. Ask your question anonymously. It's easy! Learn more and upgrade.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Crystal Reports: 5 Tests for Top Performance It is complete, your masterpiece report.  Not only does it meet your customer’s expectations, it blows them out the water, all they want is beautifully summarised and displayed in a myriad of ways. …
Hello everyone, Hope you find this as helpful as we did. We have on the company I work for an application built in Delphi V with Crystal Reports 8. We all know that Crystal & Delphi can be temperamental sometimes and the worst thing is, nearly…
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…
Have you created a query with information for a calendar? ... and then, abra-cadabra, the calendar is done?! I am going to show you how to make that happen. Visualize your data!  ... really see it To use the code to create a calendar from a q…

618 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question