convert to Columns...Urgent!

[SMosley804]

Sorry for posting 2x but there is additional info.


Crystal Reports ver11
DB-IBMDB2

I have a report that I need to display 3 values for by ServerName. Currently the report looks like:


Server-LBDDEV25
Resource Property Value
Partion0 freespace 37
Partion0 totalspace 64
Partion0 mountpoint D:\

I need to convert the rows into columns for each property, so that the report looks like this:


Server-LBDDEV25
FreeSpace TotalSpace MountPoint
partion0 37 64 D:\


I can't use a crosstab because I need to perform additional calculations. ie.. convert bytes to GB, determine space used. As it stands now I am unable to accomplish this. Please Help...

 

[dgillz]

Create 3 formulas:

If {Property}="Freespace" then {freespace} else 0
If {Property}="totalspace" then {totalspace} else 0
If {Property}="mountpoint" then {mountpoint} else ""

Put these 3 formulas in the detail section, and insert summary maximums on them by Server. Hid the detail section and group header. Drag any other field you want to display to the group footer.

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz

"What version of URGENT!!! are you using?

 

[SMosley804]

Thanks! That works. Is there a way that I can sum the group totals so that they are the total for the previous group.

 

[lbass]

I am a little peeved--Please do not crosspost. I just responded to your original post.

-LB

 

[dgillz]

Do you mean running totals or grand totals?

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz

"What version of URGENT!!! are you using?

 

[SMosley804]

Running totals. For instance,My report now looks like the following:

HardDisk
totalspace freespace Usedspace mountpoint
hdd0 68.37
hdd1 68.37
_____
136.73
Partion
Part1 25.00 10.00 5.00 c:\
Part2 25.00 10.00 5.00 d:\
_______ ______ ______
50.00 20.00 10.00


The totals are running totals for totalspace and freespace. The total for UsedSpace is a formula that takes the difference between the two running totals for totalspace and freespace. I would like to also show the used space value for the harddisk group, which means I would need to take the difference of the running total for the totalspace for the HardDisk group and the UsedSpace formula from the Partion group.

Can this be done?

 

[SMosley804]

BTW. My apologies go out again to LBass.

 

[lbass]

Did you use the conditional formulas I recommended in the other thread? Or did you decide to use running totals? The solution varies depending upon which method you used.

-LB