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!
  • Students Click Here

*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


Crystal Rpt 9 Cycle Count Report Group Field Results

Crystal Rpt 9 Cycle Count Report Group Field Results

Crystal Rpt 9 Cycle Count Report Group Field Results

We have created a Cycle Count report which shows a status of either; Create Task for First Count, Create Task for Second Count, Cycle Count Outstanding or Yearly Cycle Count Completed for each location being counted. There is a minimum of 2 counts required for each location for our fiscal year.

At any given point in time we may have a cycle count which has been completed and a cycle count task which is created but not yet completed for any location. On the report the completed cycle count task shows YES based upon a formula on the report and the task not completed shows NO.

Attached is a picture of what the report is showing a location G1M3050200 which has a open task showing a counted Y/N of NO and a completed task of Counted Y/N of Yes. The open task shows a status of Cycle Count outstanding but the closed shows Yearly Cycle Count Completed. The grouping for the report is showing for Group 2 Location that the Yearly Count is Completed. I would like to have it show for the Grouping Cycle Count Outstanding since the open task shows NO. How an I do this is there a way at the group level to put in a formula for the status field to indicate if any record is NO then the default is Outstanding Cycle Count?

Hope this makes sense.

Once again appreciate any help with this situation


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!

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