I need some help in trying to figure out how to set up the printout of a DB report in Alpha4 V6.
I want to create a DB Set of two DB's for tracking investments and keeping track of the acct value, nbr of shares, share price, amount added or subtracted, total nbr of shares, total acct value and total cost basis of account.
The set consists of:
Header records, one to many of child DB records.
Fields = Owner name(s), Acct name, Acct nbr, Type of acct(I.E.: stock(IRA),mutual fund(IRA),savings,checking), Date, Dollar amount, # of shares, Share price, Total shares, Initial account value.
Child DB: Many records for each header record, linked by Acct nbr.
Fields = Acct nbr, Type of transaction(I.E.: investment, dividend, fee), Date of transaction, Dollar amount,# of shares, Share price, Total shares, Acct value.
My trouble is that I would like the reports to print out across the page for each Account, first the header record then with each transaction record going across and down the page by date, I.E.:
Owner acct name acct# type acct Date Dollar Amt #shares
John Vanguard Co. 1234567890 Mutual Fund 01/18/2003 $5,000.00 125.75
Share price Tot shares Acct Value
$25.50 125.75 $5,000.00 03/31/2003 06/30/2003 Date Dividend Fee Trans type $23.15 -$4.55 Dollar amt
6.7680 -0.1234 #of Shares
$26.35 $27.15 Share price
131.9999 130.9999 Tot shares
$5,125.95 $5,124.75 Acct value
Robert IBM 987654321 Stock 04/23/2001 $1,000.00 25.00
Cindy
$40.00 25.00 $1,000.00 03/31/2003 06/30/2003 Date Dividend Fee Trans type $12.00 -$.55 Dollar amt
6.7680 -0.0234 #of Shares
$46.35 $47.15 Share price
31.7680 30.9999 Tot shares
$1,125.95 $1,124.75 Acct value
So for each transaction, the info would print down the page for 7 rows, with each following transaction across the page going down for 7 rows! And at the far rightmost of the page I would compute the total cost basis of each account.
I just have NO idea how to do this in AlphaDB. If I was programming in Cobol, I could set up "IF" statements and such, but I am totally lost in Alpha about how to do it!!
Any help would be MOST appreciated!
Sincerely,
Cindy
PS: I know the math doesn't add up in each transaction, but I didn't want to figure it out by hand, but I hope you get the idea of what I am trying to do?!
I want to create a DB Set of two DB's for tracking investments and keeping track of the acct value, nbr of shares, share price, amount added or subtracted, total nbr of shares, total acct value and total cost basis of account.
The set consists of:
Header records, one to many of child DB records.
Fields = Owner name(s), Acct name, Acct nbr, Type of acct(I.E.: stock(IRA),mutual fund(IRA),savings,checking), Date, Dollar amount, # of shares, Share price, Total shares, Initial account value.
Child DB: Many records for each header record, linked by Acct nbr.
Fields = Acct nbr, Type of transaction(I.E.: investment, dividend, fee), Date of transaction, Dollar amount,# of shares, Share price, Total shares, Acct value.
My trouble is that I would like the reports to print out across the page for each Account, first the header record then with each transaction record going across and down the page by date, I.E.:
Owner acct name acct# type acct Date Dollar Amt #shares
John Vanguard Co. 1234567890 Mutual Fund 01/18/2003 $5,000.00 125.75
Share price Tot shares Acct Value
$25.50 125.75 $5,000.00 03/31/2003 06/30/2003 Date Dividend Fee Trans type $23.15 -$4.55 Dollar amt
6.7680 -0.1234 #of Shares
$26.35 $27.15 Share price
131.9999 130.9999 Tot shares
$5,125.95 $5,124.75 Acct value
Robert IBM 987654321 Stock 04/23/2001 $1,000.00 25.00
Cindy
$40.00 25.00 $1,000.00 03/31/2003 06/30/2003 Date Dividend Fee Trans type $12.00 -$.55 Dollar amt
6.7680 -0.0234 #of Shares
$46.35 $47.15 Share price
31.7680 30.9999 Tot shares
$1,125.95 $1,124.75 Acct value
So for each transaction, the info would print down the page for 7 rows, with each following transaction across the page going down for 7 rows! And at the far rightmost of the page I would compute the total cost basis of each account.
I just have NO idea how to do this in AlphaDB. If I was programming in Cobol, I could set up "IF" statements and such, but I am totally lost in Alpha about how to do it!!
Any help would be MOST appreciated!
Sincerely,
Cindy
PS: I know the math doesn't add up in each transaction, but I didn't want to figure it out by hand, but I hope you get the idea of what I am trying to do?!