Search results for query: *

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!

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

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

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

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

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

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

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

Perfect. Still efficient and working as hoped. Thanks!

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

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

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

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

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?

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

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

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

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

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

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