Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Using Main Report Calculations in subreports 1

Status
Not open for further replies.

Ethelk2044

IS-IT--Management
Apr 6, 2004
8
US
I am using Crystal 9.0 I created a main report calculating a total number of tickets by associates. As well as a total number of tickets by group. The Parameter I am using with the between the main report and the subreport is a date field. I need to be able to calculate off the total number of tickets open per associate in the subreport. I need to know how can I pass this variable to the subreport. The information below is within the main report. Please help.

shared Numbervar Associate;

Associate:= Count ({1__Trouble_Ticket.CallOpened}, {1__Trouble_Ticket.NewCallAuthor})

I need to be able to pass this calculation for each associate to a subreport. I can I get this field to show up in a subreport.
 
You need to make sure that the formula that you have in the main report resides in a section above the section that the main report. You may need to just split your group header into an a or b section.

In your subreoport, make sure that you declare the variable exactly the same. After you ensure these things, you should be able to use the shared variable without a problem.

~Brian
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top