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 John Tel 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: BLKDAWG
  • Content: Threads
  • Order by date
  1. BLKDAWG

    How to pull all subreport data when no link to main

    CR9/Peoplesoft. My main report oulls FY budgets by chartfield string (fund/program/deptid/account). Information is pulled from a Peoplesoft query. I've created a subreport to pull all transactions that have hit a particular buget. Transactions are pulled from a union of about 12 records in...
  2. BLKDAWG

    Newbie to Java--Help with IndexOf in 2 dimensional array

    I have the below .dat file and I need to break it out into various components (firstname,lastname, gender, scores). I'm able to break out the first 3 components, but want the 5 scores of each person to be put into a 2 dimensional array. I can't figure out how to tell it the end of the line for...
  3. BLKDAWG

    color of an input box

    Is there a way to change the color of an input box? I would like to leave the center white, but change the color of the edges? Thanks.
  4. BLKDAWG

    How to join two rows of data into one & populate diff. fields

    I have a report that is summarized by deptid and the first number of the account (I've concatenated the field). I'm only pulling two types of accounts (4000 series and 5000 series). Therefore, each deptid has two rows of data-one for acct "4" and one for acct "5". I would...
  5. BLKDAWG

    Inserting summary field

    I'm using crystal 6 with Peoplesoft query and I am trying to summarize a field based on group criteria and field criteria. My PS query pulls Deptid, Account, Period and Posted Revenue. Here's a small example: Deptid Account Period Revenue 5800 4302 1 500.00 5800 4305...
  6. BLKDAWG

    Remove Trailing Zero's

    I have a bank file that I am trying to format in excel before loading as a .prn file into my financial software application for check recon. The dollar amount column must be imported in the financial database as a text field rather than a number field. The problem I'm having is that the file...
  7. BLKDAWG

    VB Macro for excel - copy column value for all rows

    I am creating a VB macro in excel which needs to be run once a month. This macro formats the excel file. Part of the formatting is to add a column(Col A) and repeat a value in that column for all rows in the file. The number of rows will vary each month. I need the macro to repeat the value...

Part and Inventory Search

Back
Top