Basically, you need to run the subreport before displaying/using any shared variables.

 

If you just need the results of the subreport, but not the report itself, here's what you can do (as DBlank reminded):

 

1) place the subreport in it's own section

2) suppress the display of all fields in the subreport

3) in the section that the subreport is in, go to section expert and check Suppress Blank Section

 

and remember to place the section above the section you want to utilize the values in.

 

HTH

 

Crystal processes from top to bottom, so when you are at the end of the report, it will only process for the last agent.  In addition, even it processed for every agent, you cannot calculate the average for an agent and display it with the agent's data in the main report, as it has been printed and Crystal has moved on...it won't go back and change anything...which is why the subreport has to be called during the time that the agent's data is being printed on the report, not at the end.

 

HTH

 

main

  gh agent

     subreport

  gf agent a b c (b+c+j)

 

If you are just looking at the summary, you can suppress gh agent and

'hide' the subreport. 

 

Having just done this (I don't use supreports too often, much less hidden) the step to 'hide' a subreport

1) place it in it's own section

2) in the section expert 'Suppress Blank Sections'

3) suppress all fields in the subreport

4) ...and this is the one I forgot, right click the subreport / format the subreport / subreport tab...'Suppress Blank Subreport'

 

now you can access the shared variable that the subreport is returning and use it to compute the values for each agent.

 

HTH