Crystal 9.0
Hopefully I'm not too confusing....
Have a report displaying Order#, Delivery Date, Item Name.
Have two subreports displaying current status of production - what station the order is at and has left to go.
MAIN RPT:
Del. Date -- Customer -- Order#
SRPT A:
Station -- Order#
SRPT B:
Station -- Order#
Due to the nature of our setup we have three kinds of orders: Inventory, Release, Make&Ship
Release orders are not actually "produced". Release orders are smaller amounts "pulled" or withdrawn from a larger "Inventory" order.
Whereas, Make&Ship are orders that go straight to customer from plant floor.
Main report displays orders due to ship out on the parameter date.
Subreports display orders undergoing production.
- SRPT A only displays information if the order is a Make&Ship
Because SRPT A is linked to MAIN RPT by Order#
- SRPT B displays information if the order is Inventory or Release.
Because SRPT B is linked to MAIN RPT by Item#, it will show the Inventory order (an order with no delivery date) and where it is.
I currently have a problem where SRPT B displays all Inventory Orders attached by Item# to the current Release Order scheduled for delivery. I was able to limit this by filtering SRPT B to only show OrderDate < 30days old.
I would like to make SRPT B blank (and pull no records to inflate the space) if the OrderType = Make&Ship.
This is okay because all Make&Ship orders will show up on SRPT A
I read on a few other threads that I could conditionally suppress a section. However, both of these reports are side by side in the details section. I need at least one to display at all times.
I was able to make the order# and station disappear from SRPT B by filtering based on the OrderType, but the space remained as I had just turned the font color white - still there but just not visible. I'm hoping there's a way to keep them from being accessed at all.
I thought about filtering SRPT B somehow so that if MAIN RPT's Order# = SRPT B's Order# and MAIN RPT's DeliveryDate = SRPT B's Delivery Date then Null
But I'm not sure if that coding is possible or if even if it were, I don't want to change the current link of Item# between MAIN RPT and SRPT B.
p.s. Side Request:
I'm relatively new to Crystal. I have the Crystal User Guide and "The Complete Reference" for CR9 from McGraw Hill (which isn't quite as "complete" as I would have liked) - but a code dictionary would help. Any suggestions?
Hopefully I'm not too confusing....
Have a report displaying Order#, Delivery Date, Item Name.
Have two subreports displaying current status of production - what station the order is at and has left to go.
MAIN RPT:
Del. Date -- Customer -- Order#
SRPT A:
Station -- Order#
SRPT B:
Station -- Order#
Due to the nature of our setup we have three kinds of orders: Inventory, Release, Make&Ship
Release orders are not actually "produced". Release orders are smaller amounts "pulled" or withdrawn from a larger "Inventory" order.
Whereas, Make&Ship are orders that go straight to customer from plant floor.
Main report displays orders due to ship out on the parameter date.
Subreports display orders undergoing production.
- SRPT A only displays information if the order is a Make&Ship
Because SRPT A is linked to MAIN RPT by Order#
- SRPT B displays information if the order is Inventory or Release.
Because SRPT B is linked to MAIN RPT by Item#, it will show the Inventory order (an order with no delivery date) and where it is.
I currently have a problem where SRPT B displays all Inventory Orders attached by Item# to the current Release Order scheduled for delivery. I was able to limit this by filtering SRPT B to only show OrderDate < 30days old.
I would like to make SRPT B blank (and pull no records to inflate the space) if the OrderType = Make&Ship.
This is okay because all Make&Ship orders will show up on SRPT A
I read on a few other threads that I could conditionally suppress a section. However, both of these reports are side by side in the details section. I need at least one to display at all times.
I was able to make the order# and station disappear from SRPT B by filtering based on the OrderType, but the space remained as I had just turned the font color white - still there but just not visible. I'm hoping there's a way to keep them from being accessed at all.
I thought about filtering SRPT B somehow so that if MAIN RPT's Order# = SRPT B's Order# and MAIN RPT's DeliveryDate = SRPT B's Delivery Date then Null
But I'm not sure if that coding is possible or if even if it were, I don't want to change the current link of Item# between MAIN RPT and SRPT B.
p.s. Side Request:
I'm relatively new to Crystal. I have the Crystal User Guide and "The Complete Reference" for CR9 from McGraw Hill (which isn't quite as "complete" as I would have liked) - but a code dictionary would help. Any suggestions?