Search results for query: *

your idea of using the subreport to pass the sum to the main report worked great. thanks.

Yes, all records represented are in pf_security table. If that security is not in the model table i currently do not get a result and i can't use a left outer joint in this case since there are filters applied to the tables as well. Portfolio - {portfolio.portfolio} - string Security -...

Basically the need for the 3 formula method is because i need to sum values based on a group to get the values which are then summed for a grand total. The accumulation formula is placed in the GF2. Reset is in GH1 and Display in in GF1. The content of accumulation is: WhilePrintingRecords...

Yes, i'm trying to get an upgrade. The field names are as follows: {portfolio.portfolio},{pf_security.market_pct} and {model.market_pct}. The joint between portfolio and pf_security table is on {portfolio} and between pf_security and model table is on {security}. So I want to be able to see...

Sorry, can you please elaborate as to what {Your.Field} and {Amount} are as they relate to my example?

I've created a running total using the 3 formula method to get a sum of a number of records. Is it possible to then calculate the % of each record of the running total? The obvious issue is that Crystal evaluates each row at a time to generate the running total, so when I try to calculate the...

My appologies but I was on the road and couldn't reply sooner. I don't have full outer join option and the other suggestions did not seem to work. Lbass - for some reason I don't get the "Add Command" option in the database explorer. I'm assuming that's what you ment. I'm using Crystal 8.5.

Hi, I'm having trouble with left outer joint. I have two tables, Table 1 and Table 2. I need to compare both to make sure that the a record is in both. If no matching record exists I need to see a blank for that field. I tried using isnull, but i'm not getting the desire result. And left...

It worked great. Thanks again.

Yes it should have. I was too focused on getting the return column to multiply that forgot about the -1. I will give your suggestion a try over the next few days and let you know. Thank you again for your help.

I'm working with two column, one column has a date the other has a monthly return. I need to get the product of the entire monthly return column. So if my table is set up as follow Month Monthly Return Jan 1.10 Feb 1.05 March 1.20 The product is 1.10*1.05*1.20 = 1.386 The...

Hi I need to calculate an cummulative rate of return calculation when I only have monthly returns. For example, the table includes the following returns Jan- -0.45% Feb- 1.35% March- 0.25% etc.. The formula is basically [(1+January Return)*(1+Feb Return)*(1+March)]-1. I'm having trouble...

The problem is that the securities contained in the sub-report change. That's why I wanted a sub-report to ensure I'm constantly working with the most up to date data. I'm not sure I could do a conditional formula since I can't link the two reports together. Anyway, not being able to drill...

One more thing...it appears that if i hide detail-b, my count gets messed up. Once i drill down to the security level it shows correctly. I basically want to be able to drill down to the security level from summary level. Is there a way around this?

Forgot to check the suppress blank subreport...:) All good. Thanks for your help....

For detail-a, i just have supresse blank sections checked in the selection expert.

also, when i try to do a count of the securities not on the subreport, it still gives me a count of all the securities.

ok, i got the subreport working. However, even if i check supress blank sections in detail-a, i'm still showing blank lines when i preview the report.

for whatever reason i'm still having issues. the main report is not suppressing the securities which are on the sub-report ....from the looks of it i've followed the steps so not sure what the problem is at this point....

thanks...will give it a try first thing Monday....