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...
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...
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...
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...
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...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.