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 Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Grouping Dept. in differente Pages

Status
Not open for further replies.

ale379

Technical User
May 21, 2010
2
US
Hello,

I'm a current user of Report Smith and I'm sort of stuck in creating a report that meets my needs.

Here is what I want to accomplish.

- Dept 100 is on Page 1 and contains 10 rows with all sorts of data.
- Dept 300 is on Page 3 and contains 4 rows with all sorts of data.

I want to able to group both departments in a single page to distribute to the appropriate manager. I just don't want to print several pages of information.

Any help would be appreciate it.
thanks.
 
I would create a Derived Field such as:

CASE
WHEN TBL_NAME.DEPT_FIELD = '100'
THEN TBL_NAME.MANAGER_FIELD
WHEN TBL_NAME.DEPT_FIELD = '300'
THEN TBL_NAME.MANAGER_FIELD
ELSE
END

Put this Derived Field first in the Sort Order and in the Report Grouping.

Next go to Format -> Section. In the box at the top, choose the Report Footer for this Derived Field and check the box below that says New Page After.

After you do this, you can remove this Derived Field from printing on the report by deleting the field.

Good Luck,

RSGeek
 
Thanks for the information and for the derived field.

I entered the deried field as described above but I always get "missing right parenthesis" message. I wasn't able to fix that problem.

How can fix the "missing right parenthesis" issue?

thanks for the help.
 
Does this derived field test ok? If so, your error is coming from another derived field. I would open each and test each to find which is throwing the error.

Missing right parenthesis typically has to do with a missing single/double quote or a missing parenthesis.

Good Luck,

RSGeek


RSGeek
(currently using Crystal Reports XI with Lawson 8.03)
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top