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 gkittelson 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: *

  1. cspuckett

    Suppress "Orphan" Group Header at bottom of page

    I had seen that one but due to uneven row heights, I wasn't sure if I could pull it off. I found a good line number (in my case, any count over 30) to use that will kick the "orphan" onto the new page. So, yes, it worked. Thanks!
  2. cspuckett

    Suppress "Orphan" Group Header at bottom of page

    CR2008 Question. I have searched and found answers on line counting, etc., but none seem applicable. I have two groups. Let's say Group A = State, Group B = City. Detail is list of people named "Bob Smith". In the "Group Expert", Group A is set to "Repeat Group Header on Each Page" (and...
  3. cspuckett

    Split positive and negative amounts into own columns

    PHV / BigRed: Comic relief? I couldn't find an AS/400 & SQL forum so I figured the guidance I found here would lead me to the eventual answer. Thanks for not busting my you know what too badly! CP
  4. cspuckett

    Split positive and negative amounts into own columns

    Guys, I figured it out! Thanks for getting the old gray matter working. select fiscal_year, company, division, account, sum(case when base_amount > 0 then base_amount else 0 end) as "Debit", sum(case when base_amount < 0 then base_amount else 0 end) as "Credit", sum(base_amount) from gl_table...
  5. cspuckett

    Split positive and negative amounts into own columns

    I definitely don't mind the multiple responses...thank you all. Okay, this is good, you have helped move farther (or further) down the path. But, I am using an SQL tool for the AS/400 and it does not like "iif". I did some searching and am getting close with "CASE" (if anyone is familiar with...
  6. cspuckett

    Split positive and negative amounts into own columns

    I have a table that is basically: Year, Month,Co, Division, GL account, amount (+ or -) It is a detail transaction table. I want to create a trial balance from this, which will list the debits (positives) in one column and credits (negatives) in a second column. It would also need to sum by...
  7. cspuckett

    Smart Propercase logic

    Genius! Worked like a charm just like you coded it. Thanks!
  8. cspuckett

    Smart Propercase logic

    Is there a way to include logic in a propercase scenario where some words do not get adjusted? For example, let's take two vendors: HARDWARE SUPPLY SHOP ABC HARDWARE USA, INC. Propercase will turn them into: Hardware Supply Shop (this is good) Abc Hardware Usa, Inc. (this is "okay") Prefer...
  9. cspuckett

    Handle number-like strings in Select Expert

    Perfect. Still efficient and working as hoped. Thanks!
  10. cspuckett

    Handle number-like strings in Select Expert

    I'm looking for an efficient way to build this selection. I have a table with vendor number. Problem is the value is actually an alpha value (9 char, right justifed, left padded with spaces). So, vendor 1234 is really ' 1234'. I have a report where the user could enter (optionally) a...
  11. cspuckett

    Suppress Group Header when top of page

    I have two groups in my report. Let's call them Company (group 1) and Division (group 2), with detail division records in the main report. Group 2 Header is blank, but I want to leave it in because it provides a nice visual break between the Group 2 footer subtotal and the start of the next...
  12. cspuckett

    Keep subreports together

    UPDATE: Through some trial and error, I think I have a good "new page before" logic. I did use the same "cnt" variable through out the main and subreport1 and the counter keeps increasing (which is what I wanted). I like the break when I use: cnt - (50 * (PageNumber - 1)) >= 35 Might make...
  13. cspuckett

    Keep subreports together

    Okay, that makes sense. However, subreport1 could start on line 5 of page 2 or line 20 of page 6...just depends on the detail in the Main report. So, it seems like I also need a counter in the Main report (detail section). Which leads to two questions: 1. Can I use the same variable (cnt)...
  14. cspuckett

    Keep subreports together

    LB, Once again you came to the rescue. I thought I had tried that one, but must not have. That worked. What would be the best conditional (and where, presumably under Paging of RF_b) to put logic that when subreport1 ends at line x (say 45), that subreport2 while start on a new page?
  15. cspuckett

    Keep subreports together

    I had a post yesterday where I have two report footer subreports that I wanted to appear back-to-back vertically. I got the tip of splitting them into their own report footers (i.e., RF_a and RF_b). Now, in a few scenarios, I have a new situation to address. It occurs when subreport2 is more...
  16. cspuckett

    Issue with two subreports in Report Footer

    Oh good grief. It always helps to have a fresh set of eyes look at an issue! Thanks, that solution worked perfectly!
  17. cspuckett

    Issue with two subreports in Report Footer

    I have a report with two subreports in the Report Footer. Each subreport calls a unique table (with distinct information) based on one parameter in the main report. For example, it might be "ITEM ID" in the main report. Subreport1 shows the item history for the past week. Subreport2 shows...
  18. cspuckett

    Merge multiple workbooks into current open workbook

    I used the ActiveWorkbook and it worked. I was forgetting the ".Worksheets" part! Thank you!
  19. cspuckett

    Merge multiple workbooks into current open workbook

    I am close, but I can't get past this hurdle. Using the following MSDN website: http://msdn.microsoft.com/en-us/library/cc837974.aspx#MergeDataFromMultipleWorkbooks_MergingRangefromAllWorkbooks I have working code for merging multiple workbooks into one summary workbook. However, the code...
  20. cspuckett

    Cross Tab Sort based on Calculated Member

    LB - thanks for your postings. Through this and a couple others you had responded to concerning sorting, I got it to work. Because I was looking to sort on the current month amount minus the prior 12-month average, I built the following formula: if {DBGLGLT.POSTING_DATE} >= {@MyCurrentDate}...

Part and Inventory Search

Back
Top