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 Rhinorhino 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: cspuckett
  • Content: Threads
  • Order by date
  1. 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...
  2. 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...
  3. 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...
  4. 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...
  5. 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...
  6. 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...
  7. 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...
  8. 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...
  9. cspuckett

    Cross Tab Sort based on Calculated Member

    I've searched all over for this and do not have an answer. I have your standard financial report with Actual and Budget numbers. Then, I have a calculated "difference" column showing the dollar variance. The issue is that, for this report, I want this report to sort based on this variance -...
  10. cspuckett

    How to pull monthly history when query spans two fiscal years

    I have a table with financial information with the following (basic) layout: Year, GL Account, January, February, March,...December. So, for GL Account 40000, you might see: 2007, 40000, $100, $110, $90,....$150 2008, 40000, $105, $120, $95,....$160 The report will show the current...

Part and Inventory Search

Back
Top