Solved

Cross Tabs and labeling rows/columns

Posted on 2004-09-08
9
271 Views
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.
0
Comment
Question by:smeyer4314
  • 6
  • 3
9 Comments
 
LVL 42

Expert Comment

by:frodoman
Comment Utility
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
0
 

Author Comment

by:smeyer4314
Comment Utility
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
0
 
LVL 42

Accepted Solution

by:
frodoman earned 500 total points
Comment Utility
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.

HTH

frodoman
0
 

Author Comment

by:smeyer4314
Comment Utility
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 ...........
0
Why You Should Analyze Threat Actor TTPs

After years of analyzing threat actor behavior, it’s become clear that at any given time there are specific tactics, techniques, and procedures (TTPs) that are particularly prevalent. By analyzing and understanding these TTPs, you can dramatically enhance your security program.

 

Author Comment

by:smeyer4314
Comment Utility
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
0
 

Author Comment

by:smeyer4314
Comment Utility
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
0
 

Author Comment

by:smeyer4314
Comment Utility
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
0
 

Author Comment

by:smeyer4314
Comment Utility
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
0
 
LVL 42

Expert Comment

by:frodoman
Comment Utility
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
0

Featured Post

Highfive Gives IT Their Time Back

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

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. …
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…
This video discusses moving either the default database or any database to a new volume.
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

728 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

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now