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.


New benefit for Premium Members - Upgrade now!

Ready to get started with anonymous questions today? It's easy! Learn more.


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

[Webinar] How Hackers Steal Your Credentials

Do You Know How Hackers Steal Your Credentials? Join us and Skyport Systems to learn how hackers steal your credentials and why Active Directory must be secure to stop them.

Question has a verified solution.

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

Hot fix for .Net Crystal Reports 10.2.3600.0 to fix problems with sub reports running on 64 bit operating systems ISSUE: Reports which contain subreports fail with error "Missing Parameter Value" DEPLOYMENT SERVER OS: Windows 2008 with 64 bi…
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…
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…
This tutorial will teach you the special effect of super speed similar to the fictional character Wally West aka "The Flash" After Shake : http://www.videocopilot.net/presets/after_shake/ All lightning effects with instructions : http://www.mediaf…
Suggested Courses
Course of the Month8 days, 22 hours left to enroll

764 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