Crystal Reports Lookup

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

Topic: Lookup

Author	Message
Westie Newbie Joined: 08 Jan 2015 Location: United States Online Status: Offline Posts: 2	Topic: Lookup Posted: 08 Jan 2015 at 9:54am
	I have an existing table with 4 parameters; item, location, period, and forecast. I want to show next period forecast for an item and location in a new column. In Access, I set parameters in query but cannot figure out how to write formula in Crystal. Can you help?
	Westie
	IP Logged

lockwelle Moderator Joined: 21 Dec 2007 Online Status: Offline Posts: 4372	Posted: 08 Jan 2015 at 12:16pm
	I think that I am bit confused. do you want to add another column to the table or just display another column on the report? is the value for the column in the table on the same row or on another row?
	IP Logged

Westie Newbie Joined: 08 Jan 2015 Location: United States Online Status: Offline Posts: 2	Posted: 09 Jan 2015 at 2:13am
	It is on another row in the table and I want to show it as a new column - next period forecast.
	Westie
	IP Logged

lockwelle Moderator Joined: 21 Dec 2007 Online Status: Offline Posts: 4372	Posted: 09 Jan 2015 at 4:59am
	if it is another row...and it is not the next or previous record your only option is to create a subreport, which could impact the speed of your report.
	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.