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 Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by TJIT

  1. TJIT

    SQL Script that only fires every bi-weekly payday

    Last Thursday I systematically changed the two numbers at the end of this part of the script using combinations of 0's, 1's, and 2's: where mod(to_char(sysdate,'IW'),2)=0 I found that ,2)=1 resulted in no action being performed (in my case an email didn't get sent out) I also found that ,2)=0...
  2. TJIT

    SQL Script that only fires every bi-weekly payday

    If I run the procedure manually, it runs just fine. It's been running great for a few years. It was only when it needed to run the first time in January that it stopped working. That's why I think it's calendar related. The software this runs in is called IQALERT and is part of our...
  3. TJIT

    SQL Script that only fires every bi-weekly payday

    This is used in an automated emailing software as a "condition statement". It tells the software to only run and email a particular report every other week. It was working consistently right up until the first payroll of January. Nothing in the report or any other area of the software...
  4. 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...
  5. TJIT

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

    Suppression formula did the trick. I created a parameter called "Label Type" (I'm working with labels so that's simply what I called them...could have called them anything) with "Allow multiple values" set to 'true' in the Value Options section of the "Edit Parameter:" window. I set the Type...
  6. 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...
  7. 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.
  8. TJIT

    Combing rows of data based on condition

    I love you, man!
  9. 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...
  10. TJIT

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

    Pete, The "first review date" is when the vendor came online with the company. Once that first review is done, their schedule synchronizes with all other existing vendors, which is currently 11-1-13. I added your new formula and got additional dates: http://i.imgur.com/QAd19Sp.jpg I have an...
  11. TJIT

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

    I think we're onto something here, Pete. I am getting a couple rogue dates showing up which, if figured out, will call this one done. I am attaching a screenshot of the report with the two fields highlighted: http://i.imgur.com/5TIZfzV.jpg But otherwise, I think we're barking up the right tree.
  12. TJIT

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

    Let me know if this helps. This first picture shows the front end user field asking for the "Original Review Date." http://i.imgur.com/ORCHPYv.jpg Once this date has been established, the report should show the first day of the next quarter...of this current year. The date in my...
  13. TJIT

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

    Fisheromacse, I'm getting the same results using your formula as I was Pete's. I am pasting the formula below showing my input date (which is a formula called @Start_date): ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ numbervar m1; numbervar y1; IF Month({@Start_date}) in [2,3,4] then m1:=5 else if...
  14. TJIT

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

    Actually I jumped the gun on my last post, Pete. Some of our starting dates are from 2001 and the formula: DateSerial(Year(CurrentDate),Month(CurrentDate)+3,1) Works only through the following year but then stops working; so that an input date of 11-2-2001 shows 2-1-2002 on the report I run...
  15. TJIT

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

    This works perfectly! I just needed to change "(CurrentDate)" to coincide with my field and was done. Thank you so much, Pete. Ted
See more

Part and Inventory Search

Back
Top