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!

  • Congratulations biv343 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: TJIT
  • Content: Threads
  • Order by date
  1. TJIT

    SQL Script that only fires every bi-weekly payday

    Few years ago someone created a script to set the condition where an email only gets sent on a Thursday of the week we get paid (which is every other week). It's been working for a few years but suddenly stopped in January. I'm guessing it has something to do with it being a leap year, but...
  2. TJIT

    Parameter to prompt which particular "page" (group header) to print?

    My report has multiple group headers with distinct static text at the top of each page. One section says "Startup"; another one "Shutdown"; another one "Restart"; etc. Currently, when they print all 3 pages print out. However, I'd like to offer them a prompt to only print the one or two pages...
  3. TJIT

    Sorting combined alpha-numeric fields properly

    I have a list of manufacturing part numbers similar to this: P-R-NTRL1 P-R-NTRL4 P-R-NTRL10 However, CR wants to sort them like this: P-R-NTRL1 P-R-NTRL10 P-R-NTRL4 I get why it does that but am not sure if/how it can be done correctly.
  4. TJIT

    Combing rows of data based on condition

    In the example below (in the Details section of my report), if the values in the first column, "order no." are the same in that section/group, there should only be one row instead of two and the "on hand Qty" should be combined equaling 3700 (3100 + 600) ...but only when the "order no." fields...
  5. TJIT

    Display first day of each subsequent quarter based on a date input.

    I have a user input field that someone enters a date into. Based on that date, the report should show the first day of the month of the very next quarter, and every subsequent quarter. For instance, if I put today's date in the user field, 8/6/2013, the report should show 11/1/2013. On...
  6. TJIT

    Labelview: combine two fields into one barcode?

    I have one field that uses OLE DB to connect to Excel to pull from a cell. This is a three digit number. I have another field that pulls from an Oracle database. This is a two digit number. Can I combine those to create a five digit number, and barcode it using Labelview 8.10 Gold?
  7. TJIT

    Time and Attendance Lunch Calculation

    I have two fields in a subreport that display punches for each employee for each day of the week. If, and only if, that employee takes a lunch, there will be 4 punch times listed. I need to subtract the first "out" punch from the second "in" punch. {V_TA_PREPOST.START_TIME} and...

Part and Inventory Search

Back
Top