Technical Questions
 Crystal Reports Forum : Crystal Reports 9 through 2016 : Technical Questions
Message Icon Topic: Adding a row to Crosstab Post Reply Post New Topic
Author Message
Beso90
Groupie
Groupie
Avatar

Joined: 12 Jun 2014
Location: United States
Online Status: Offline
Posts: 48
Quote Beso90 Replybullet Topic: Adding a row to Crosstab
    Posted: 08 Jun 2020 at 9:34am
Hi there,

I have a crosstab in my report that has a grand totals row at the bottom of it.

I want to add a row below the grand total that is basically dividing the total by 7

Below is a picture:



Any help would be greatly appreciated.
Thank you
IP IP Logged
Beso90
Groupie
Groupie
Avatar

Joined: 12 Jun 2014
Location: United States
Online Status: Offline
Posts: 48
Quote Beso90 Replybullet Posted: 11 Jun 2020 at 6:53am
Got an answer elsewhere, but if anyone is curious:

Right click in the upper left hand corner of the Crosstab-->Advanced Calculations-->Embedded Summary...
1. Click 'New' and enter in a description
2. Click 'Edit Embedded Summary' button
3. Enter in this code: gridvalueat(currentrowindex, currentcolumnindex, 1) / 7
4. Save and Close followed by OK


Only thing is that it puts that calculation in every line including the totals line. This works but I'd be happy if I'm able to have it only show on the totals row.
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.