Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Report Design
Message Icon Topic: Referencing a value in a sub-group Post Reply Post New Topic
Author Message
taspeakin
Newbie
Newbie


Joined: 07 Oct 2007
Online Status: Offline
Posts: 1
Quote taspeakin Replybullet Topic: Referencing a value in a sub-group
    Posted: 07 Oct 2007 at 3:18pm
How can I reference the value in a summary group of a sub-group. Very basic I'm sure but I'm new to CR...I have an Income statement with totals summarized first by account ( ie Sales to Customers, Depreciation or Telephone Expense). Then I have a group summary for custom groups to total items by catagory (ie Total Sales, Office Expense, G&A Expense). I need to reference the Total Sales value to compute all other item values as a percentage of Total Sales (ie... "Telephone Expense/Total Sales * 100"). Thanks,
 
taspeakin
IP IP Logged
jkwrpc
Senior Member
Senior Member


Joined: 19 Jun 2007
Location: United States
Online Status: Offline
Posts: 432
Quote jkwrpc Replybullet Posted: 07 Oct 2007 at 6:18pm
This may help it is from the CR help
-------------------------------------------

Shared variables use the same memory block to store the value of a variable throughout the main report and all of its subreports. Thus shared variables are even more general than global variables. To use a shared variable, declare it in a formula in the main report as in the following example:

Shared x As Number

x = 1000

and declare it in a formula in the subreport as in the following example:

Shared x as Number

To use shared variables, the variable must be declared and assigned a value before it can be passed between the main report and the subreport.

---------------------------------------------
As you see you use the shared variables to move data.
 
Hope this helps.
 
Regards,
 
John W.
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.016 seconds.