Lookup
Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2022
Forum Name: Report Design
Forum Discription: The best way to design a report and problems you have encountered
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=21263
Printed Date: 31 Mar 2025 at 12:35am
Topic: Lookup
Posted By: Westie
Subject: Lookup
Date 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
|
Replies:
Posted By: lockwelle
Date 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?
|
Posted By: Westie
Date 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
|
Posted By: lockwelle
Date 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.
|
|