Search results for query: *

I did find it. I didn't search through the sub menus well enough. Now that I tried the whole solution, it works! Now I just need to fit it properly into my template... Thanks LB.

lbass, I tried this and was able to implement everything you mentioned, except for the maximum (wasn't available on right click for me). The report now shows only the addresses that match this {ADDRESS.ADDR_TYPE_CDE} <> 127, which is perfect, but it still shows the {table.box} field value twice...

Mike, I do have a table with all of the box numbers. I created the left outer join to the address table and that worked! Cheers! Now I have a problem, in that one of my selection formulas ({ADDRESS.ADDR_TYPE_CDE} = 127}) is now conficting with that join. There are two address type codes (127...

Hey Turkbear, It wouldn't be false results for this report. The list of numbers represents box numbers that have addresses associated to each one. If a box is not in our data set, it exists, but has no address associated to it. The users of the reports want to see what box is full(ie has an...

I am using CR10 with an Oracle 9i database. Thanks to all the help so far!! It is much appreciated! I am returning a field that has numbers from 1-15. Sometimes there are a couple of missing numbers. I want to show those numbers, since it shows an blank result for the report reader. How do I do...

That is all that was needed. I just found out where to find the Record Selection function. Missed it before! Thanks for the help! Geoff

Hey Turkbear, I will state that I am really new to CR and you might have to take me a step back! I entered the simplified formula like you mentioned, dropped it on the report, and I get a True/False value returned on my report. I still want to see the {CMB_CMPTMT.CMBC_NUM} when...

Using CR 10 and Oracle DB. I have a column that returns duplicate values (see below). I have been able to 0 out the duplicates, but I don't know how to remove the 0's from my returned list. Here is my formula that 0's out duplicate values: if {ADDRESS.ADDR_TYPE_CDE} = 127 then...

Thanks LB. That pretty much does what I am looking for. How can I define that I only want 2 columns, not unlimited?

I am using Crystal 10 with an Oracle Dbase. I have a report that returns a list of addresses that currently appear in one column. I would like to know how to display the results over two columns on the same page? Any suggestions that could help? Thanks, Geoff

I am new to CR10. We have CR10 installed connecting to an Oracle 9 server. I have created links around the 10 tables to be used in the report. I have set one field (alpha-numeric) to be the parameter criteria for the user to select. I would like to create formulas to display the corresponding...