Search results for query: *

Here you go. Thanks again for your help. {PershingTrades.TradeDate} = {?Trade Date Range} and {@Random Number} <= 0.10 and not ({PershingTrades.Symbol} like "") and ( {PershingTrades.SecType} = "1" and {PershingTrades.SecMod} = "0" )or ( {PershingTrades.SecType} = "2" and...

Thanks for getting back to me, I actually realized that was the problem I was having right after I had posted before...It was such a stupid mistake too....The only problem I'm having now is that this selection formula seems to be superceding the date range parameter that I had instituted in the...

I tried that code and it didn't seem to work. It was saying a string was required where I was placing the numbers for the table type.

I am having trouble with the code to pull the following information. I need to pull data based on a Type and Modifier Column. I could pull all info for type 1,2,3,4,& 8 by using the select expert although I need to pull based on the modifier column that goes with those types. Example, I need to...

I am pulling information from an Access DB that houses trade information, and I cannot add a comments field into the DB.

HOw do I go about doing that? I'm not sure where I go to add a memo field.

Is it possible to put a free form comment box in the report so the user can type in their own comments. If so, how do I go about doing this so that it will be unique to the row that it resides on?

I followed your instructions word for word but nothing seems to happen. What is the tie between the random numbers and supressing the trade field to show 10% of the trades for the date range selected? I must be missing something.

So you're saying I put Rnd() as text in the detail section? or input that formula in the detail section through the Selection Expert and key it off of one of the DB's fields? I understand how to supress in the formula editor, but if I want to get 10% of a date the user chooses how do I do that...

I can't get that formula to work, could you explain in more depth or give me other suggestions. I am a Crystal novice and for some reason I keep getting an error in the formula.

I need to produce a report that will pull a 10% random sample for a specific date range chosen. I am pulling this info. from an Access DB via ODBC link. Could someone please help me with how to do this?? Thanks, Scott

Thanks for the help, that gives me a lot to work with right there.

I was able to connect the data to the specific days Maturity Date as teh control source so, however, I still can't the actual fields with information to show up all on the calendar. I guess it might just not be possible in the way I'm trying to build it.

I've created a Calendar using the Calendar Builder and linked it to a table containing maturity dates for CDs. I want the CD information to show on the calendar by the maturity date listed but I can't get the information to show up on the calendar. The fields will show up outside the calendar...

Your suggestion did work. I'm sorry I must have done something wrong with my initial grouping when I used the formula... Thanks very much for your help

9.0

I tried that but it didn't seem to work...still reading with the CN=

I'm not really following what you mean. Again, I am a novice so it may just be over my head. The Referral Field I'm pulling from contains information of this nature: Refd by: CN=Jane Doe/O=Nowhere Bank, CN=Bob Smith/O=Nowhere Bank, Mike User, Sarah User If I pull the field right into the...

I am pulling information from a specific field in a Lotus Notes DB. The field is a Referral Source field and can contain names of people from the "company" address book in Lotus Notes and can also contain free form names that aren't part of the company. When showing the field in my report, it...