Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Report Design
Message Icon Topic: parameter Post Reply Post New Topic
Author Message
Florina
Newbie
Newbie


Joined: 23 May 2011
Location: United States
Online Status: Offline
Posts: 9
Quote Florina Replybullet Topic: parameter
     Posted: 29 May 2011 at 5:21am
I created a report that has the following information:
 
Customer
 
Year 2009, 2010, 2011
Program  A, B, C
Territory North, South, Central
 
I would like to isert a parameter for year, program and territory
 
Thank youCry


Edited by Florina - 29 May 2011 at 5:21am
Florina
IP IP Logged
Florina
Newbie
Newbie


Joined: 23 May 2011
Location: United States
Online Status: Offline
Posts: 9
Quote Florina Replybullet Posted: 29 May 2011 at 5:26am
One column on my report has commission.
Commission rates are different depending on a program
Program A 10%
Program B 5% and so on
 
I would like to have at the bottom of the report as a footnote a summary stating what rates have been used. How can I do that?
 
Also, pertaining to the quesiton above with the parameter, How can I have the parameters stated on the header?
 
Thank you bunch
Florina
IP IP Logged
sharona
Senior Member
Senior Member
Avatar

Joined: 16 Oct 2008
Location: United States
Online Status: Offline
Posts: 255
Quote sharona Replybullet Posted: 31 May 2011 at 5:02am
use a join formual for the parameter display, only works with string fields.
and that is usually on for multiple selection parameters.
you can just put your parameter in a text box and it will display the distinct value selected.
you need to create formulas for your commision percent, then use manual running to totals to show a sum on the formula in a group
sharona
IP IP Logged
Florina
Newbie
Newbie


Joined: 23 May 2011
Location: United States
Online Status: Offline
Posts: 9
Quote Florina Replybullet Posted: 31 May 2011 at 8:03am
Thank you
Florina
IP IP Logged
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