Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: sjjustina
  • Content: Threads
  • Order by date
  1. sjjustina

    matrix and empty columns missing

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

    case when in a where statement

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

    Cisco 871 new setup

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

    RDP help on a cisco 870 router

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

    Max and inline query help

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

    convert a varchar to a number in a query

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

    Get just the last record based on a history sequence #

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

    Report based on a SQL Server View

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

    Passing variable from sub report to main.

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

    Pass a subtotal back to the main report

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

    Passing variable from sub report to main.

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

Part and Inventory Search

Back
Top