Crystal Reports 1st sale and last sale value

Report Design

Crystal Reports Forum : Crystal Reports 9 through 2022 : Report Design

Topic: 1st sale and last sale value

Post Reply

Post New Topic

Author	Message
Kalliz50 Newbie Joined: 28 Sep 2012 Location: United States Online Status: Offline Posts: 2	Topic: 1st sale and last sale value Posted: 28 Sep 2012 at 2:33am
	I'm doing a cross tab with years and i want to see what the first sales price was and the last sales price (from orders throughout the year) was and then do a variance ... can anyone help me figure that out?
	Karen
	IP Logged


Sastry Moderator Joined: 16 Jul 2012 Online Status: Offline Posts: 537	Posted: 05 Oct 2012 at 12:54am
	Hi It is not possible to pull values from cross tab. You need to place price and date fields on detail section. Now find out minimum date and price i.e. To find Minimum price. Numbervar MinPrice; If Minimum({table.date}) = {Table.date} Then {Table.Price} MinPrice:={Table.Price} To find latest price : Numbervar MaxPrice; If Maximum({table.date}) = {Table.date} Then {Table.Price} MaxPrice:={Table.Price} Now you can find the variance.
	Thanks, Sastry
	IP Logged

Kalliz50 Newbie Joined: 28 Sep 2012 Location: United States Online Status: Offline Posts: 2	Posted: 05 Oct 2012 at 6:53am
	once i have that in the detail can i pull it into a column in a cross tab?
	Karen
	IP Logged

Sastry Moderator Joined: 16 Jul 2012 Online Status: Offline Posts: 537	Posted: 07 Oct 2012 at 7:27pm
	No, you can't pull this values into your cross tab, because cross tab will always show the summaried values ie. aggregated values.
	Thanks, Sastry
	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