var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
I'm new to crystal reports and trying to learn the SQL behind it.
I have a crystal report label that is currently pulling all the locations for an SKU in the "Pick Ticket" (attached image)
I would like for the label to just pull 1 location that has the oldest In Date.
Here is where I think I need to add something around the "Locations.loc_desc" since it is pulling multiple locations.
So comparable to Excel, something like a "Max=1" function.
I'd handle this in the underlying SQL, given the choice. Much better performing!
If you can't do that, then you'll need to do a running count (or similar) numbering function that you can filter on... this is tricky, messy and slow, though!
Home | Blog
Log in with your username and password
Forgot your password?
Subscribe to dBforums Brief to receive special offers from dBforums partners and sponsors