Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Report Design
Message Icon Topic: Cross Tabs - adding column from different tabel Post Reply Post New Topic
Author Message
Valmont
Newbie
Newbie
Avatar

Joined: 29 Jan 2007
Online Status: Offline
Posts: 39
Quote Valmont Replybullet Topic: Cross Tabs - adding column from different tabel
    Posted: 06 Apr 2007 at 3:24am

First I'll show you what the cross tabel should look like, then I'll explain the things you see, then I'll ask my question.

This is what my chief would like to see:
 
                   FailedCode                                      |   successCode
                   Ftype                AvgHandlingTime            |   Scode                AvgHandlingTime
Date               CountOfMachine       Avg of MachHandlingTime    |   CountOfMachine       Avg of MachHandlingTime
 
FailedCode, SuccessCode, Ftype and Scode are all in the very same table column: {Stats.Result}
But AvgHandlingTime is in a different column: {Stats.Time}
How do I add the AvgHandlingTime column to the cross table the way as demonstrated above? You can't do that with standard cross table expert features, so it seems.


Edited by Valmont - 06 Apr 2007 at 3:26am
IP IP Logged
EscApe
Newbie
Newbie


Joined: 13 Nov 2006
Location: Finland
Online Status: Offline
Posts: 37
Quote EscApe Replybullet Posted: 07 May 2007 at 2:43am
Can you get that avghandlingtime to your report and get it counted as you want?

If you can add your table with handling time to a normal report, you can also use it in cross-tab.
IP IP Logged
Valmont
Newbie
Newbie
Avatar

Joined: 29 Jan 2007
Online Status: Offline
Posts: 39
Quote Valmont Replybullet Posted: 11 May 2007 at 2:56am
Offcourse I can use it in a crosstab. But HOW?
 
Don't forget, avghandlingtime resides in an entirely different field of a table!
The standard Crosstable features in CR allows you only to group (columns)  varying results from the SAME FIELD IN THE SAME TABLE.
But I want to add a new column from a DIFFERENT FIELD in the same table. Or perhaps even a different TABLE!
IP IP Logged
BrianBischof
Admin Group
Admin Group
Avatar

Joined: 09 Nov 2006
Online Status: Offline
Posts: 2458
Quote BrianBischof Replybullet Posted: 11 May 2007 at 8:27am
CR lets you use any fields in your report in the cross-tab. As EscApe was saying, if you can design your report so that the Stats.Time field can be displayed on your report, then you can also select it for use on the cross-tab. If you do have it in your report, but it can't be added to the cross-tab, then that is a new problem that would have to be investigated.
Please support the forum! Tell others by linking to it on your blog or website:<a href="http://www.crystalreportsbook.com/forum/">Crystal Reports Forum</a>
IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum



This page was generated in 0.031 seconds.