×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Grouping Dept. in differente Pages

Grouping Dept. in differente Pages

Grouping Dept. in differente Pages

(OP)
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.

RE: Grouping Dept. in differente Pages

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
 

RE: Grouping Dept. in differente Pages

(OP)
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.

RE: Grouping Dept. in differente Pages

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)

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login


Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close