Search results for query: *

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...

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')...

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...

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...

Hopefully this is an easy one. I'm trying to get an average of a length field but the field is varchar(8). This is my query: SELECT AVG(CONVERT(varchar(8), pcslength, 0)) AS AvgLength FROM tag_detail GROUP BY tagnum The convert doesn't seem to be working. Is there another way to do...

This is my query: SELECT product, loc, protype, ohvolumequantity, histseq FROM dbo.pro_itm_hst ORDER BY loc, protype, product, histseq Every time the inventory is changed a history record is writting into this table to reflect the current on hand quantity. The first three fields are...

I made a simple report based on one View but I needed to add a field and change an alias on a field in the view. Crystal is not reflecting the changed fields. I've Refreshed everywhere I can think of. Removed the view and added it back in. Renamed it. Logged off the server back on. Closed...

I have a main report printing values from a parent table in the Details section of the report. In the child table is a length field that I need to print the average of. How do I do this? thanks, Sarah

I have a subtotal in the report footer of a subreport. I also want to print that subreport on the main report in a report footer. Can I assign it to a variable to return to the main report? And if so how? Thanks, Sarah

WhilePrintingRecords; Shared numberVar TotalMAC; TotalMAC := {far_item.pricequantity} formula name is TotalMACSub This is the main report WhilePrintingRecords; Shared numberVar TotalMAC; TotalMAC; formula name is TotalMACMain. The subreport prints data and the subtotal fine, it is not an...