Is it possible to have Different field's data in the Crosstab rpt

[sohrab]

Hi,

I would like to know if is possible to have different columns in crossTab report with different data from different fields.Any help will be greatly appreciated.

Thanks;
Sohrab

 

[Andie]

You can have more than one summary field, if that is what you are looking for. You simply click on the second field in which you are interested, and select "set summarized field".

 

[sohrab]

Hi Andie;

Thank you for your response, but let me explain myself more clear. what i have now, is the row of users and column of activity name and Crossing each user is the time entered against that activity for that specific user, and then the total of all those activity's timeentries for that user. what else I need now is that I want to add the percentage of that timeentry in another column right beside the time entry. Is that possible?

 

[Andie]

I'm not sure if that is possible - I'm just starting to understand the full capabilities of cross-tabs myself. But I recommend that you read another thread that has recently started up. It was posted by "geoffreyg" on 4/23 titled "Formula within a Cross-Tab". He is also trying to get a percentage in his cross-tab. That thread might be helpful to you. (It is listed within the Crystal Reports General Forum)

 

[sohrab]

Hi Andie;

I appreciate your help,

Thanks a million

 

[kenhamady]

You can't do a any calculations that rely on numbers within the cross-tab.

You can create a manual crosstab (lots more work) which allows calculations. This is described in my FAQ on common formulas. Ken Hamady

http://www.kenhamady.com/

Crystal Reports Training/Consulting and a
Quick Reference Guide to VB/Crystal (including ADO)

 

[sohrab]

Hi Ken;

Thank you for your help, I will use my own formula instead of crosstab.

 

[Bensta]

My Friends I have a problem designing a cross tab report.
The layout should be something like this.
The lableID is the row section. There can be multiple identical LableID's but with Different Characteristics: So if I have 3 LableID's with a value of 3 then each of them will have different Charactiristics displayed one after the other in the colum section. The problem I don't want to summerize them. I want to disply each value for the corresponding LableID. If have 3 lableIDs. I want to diplay only one LableID and all the values, if any, for Lowerbound, UperBound, and taget in the same colum. The problem is cross-tabs is that it uses summaries, which I don't want to do.

LableID Characteristics
LowerBound |UperBound|Target

For example. I have 3 lableID's with a value of 300
LableID Characteristics
LowerBound |UperBound|Target

300 10 10 12
300 10 10 14
300 23 12 10

I want my report to look like this:

LableID Characteristics
LowerBound |UperBound|Target
300 10|10|12 10|10|14 23|12|10

I will appreciate any help
Bensta

 

[lbass]

Because of your special display requirements, I think you would have to create a manual crosstab. First group on {table.labelID}, and then create three sets of three formulas, all using the syntax as shown below for lower bound:

//{@resetlowbd} to be placed in the group header:
whileprintingrecords;
stringvar lowbd := "";

//{@accumlowbd} to be placed in the detail section:
whileprintingrecords;
stringvar lowbd := lowbd + {table.lowbd} + "|";

//{@displlowbd} to be placed in the group footer:
whileprintingrecords;
stringvar lowbd;
left(lowbd,len(lowbd)-1)

Repeat for upper bound and target fields.

Then you would drag the group name (LabelID} into the group footer and suppress the group header and details section.

Also, for future reference, it is best to start a new thread rather than tag onto a very old one.

-LB