Recent content by sjjustina

I have a matrix report with Theatre Name as the row and grouping on the theatre name. The columns are items like candy, popcorn, drinks, food etc. The problem is that not all theatres have all the items so when it gets to say Ice Cream some theatres there is no Ice Cream column and then the...

THANK YOU markros, I've been searching the web for HOURS trying to figure this out. thank you again!

(CASE WHEN @Group = 'Amstar' THEN ('1562', '1564', '1565', '1566', '1567', '1568', '1569', '1570') WHEN @Group = 'Grand' THEN ('1552', '1553', '1554', '1555', '1556', '1558', '1560', '1563') END) same error

Thanks, but I've been trying every variation of a case statement including using one case statement like you said and two and neither works??? When I change it like your example I get the same error???

I'm stumped on this one and it seems simple enough but it just isn't working. I've tried using an if statement with no luck either. I don't care which as long as it works. WHERE ti.TheatreId in (CASE WHEN @Group = 'Amstar' THEN ('1562', '1564', '1565', '1566', '1567', '1568', '1569', '1570')...

I figured it out, thanks

This is a totally new router and my first cisco router. We had a 870 that my predicessor setup just before he left. Some bad weather came through and ZIPPPP all kind of stuff is toast including the 2 month old router. I used the CLI Excel template from the 870 for the 871 and it's working fine...

Thanks, I've added them to the correct ACL list but it's still not working. Any other ideas? ip access-list extended Internet-inbound-ACL remark SDM_ACL Category=17 permit icmp any any echo permit tcp any eq ftp any log permit icmp any any echo-reply permit icmp any any traceroute permit...

I'm trying to allow remote desktop connections from the internet on a cisco 870 router without success. I set the access control list to wide open for udp just to see if that's the problem and I know I should secure it better but that was just for testing. I've natted port 3389 to the server's...

I have a table that gets written to every time there is an inventory transaction. I need to write a report that returns the last record for a given fiscal period, either the current period or a period in the past. I want only one record per location, type, product and costid of the fiscal period...

You guys are soooo wonderful. It works!!! Hurricane Katrina made me change jobs and I went from Healthcare to a Lumber Import/Exporter. They do hardwoods, flooring, decking, plywood in just about every unit of measure. We're upgrading to the latest version of the inventory software and there...

Sorry for not posting some data, I'm new to this! I'm sorry I wasted your time but in looking through the data I forgot about the milimeters. I do appreciate all the quick answers! 08 10 10 11 11 12 12 8 3/8 8 3/8 04 04 04 04 04 04 04 04 04 04 142M 142M 142M 142M 142M 142M 142M 142M 142M 142M...

Thank you thank you thank you. But one more thing, it's saying and invalid parameter has been passed and I think it's because the field can be blank. Can you return nothing if its blank? Thanks again, Sarah

Yes but without any punctuation other than the slash.

That works great for the lengths since they are integegers but what the widths are numbers like 4 3/8"? Thanks