Search results for query: *

Thank you.

I need help with the formula to get the week range. I am thinking that I want to set up a formula for the start_date := cdate("12/26/2009") then start building the week ranges for the 52 weeks. Then group on the week range.

I am using Crystal XI, Oracle database. What I am trying to do: Week Range APP DEC DEP 12/27/2009 - 01/02/2010 12 1 2 01/03/2010 - 01/09/2010 10 2 1 01/10/2010 - 01/16/2010 5 1 1 The numbers under APP, DEC and DEP represent dates that...

Thank you lbass. This works.

This is a report of athletes with their AT Codes. They may play more than one sport (AT Code).

FTB takes precedence over all men’s sports (usually that will only mean MBB, MTF, WRS, BSB and MSC). MBB takes precedence over MTF. MTF takes precedence over MCC and WRS. WBB takes precedence over all women’s sports (usually that will only mean WTF and SFB) WTF takes precedence over...

If there is more than one AT code for an ID then I want to suppress one of the records. If either the first or second record, for the ID, is MBB I want to suppress MTF. Also, if one of the records is MTF and the other record is either MCC or WRS then MTF takes priority. Thank you lbass for...

I am using Crystal XI, Oracle database. I have a list of AT codes that should take priority when a person has more than one record (i.e. they have more than one AT code). AT CODE PRIORITY FTB takes priority over XBB, XTF, XCC. MBB takes priority over MTF. MTF takes priority over MCC and WRS...

lbass, You helped me with it over a year ago and I was just trying to help. Sorry it looked so much like your exact post. SP

Go to the field explorer->SQL Expression->new and name it "Maxdate" and enter: ( Select MAX(A.'eff_date') from table A where A.'person' = table.'person' ) Then, go to report ->selection formula ->record and enter: {%maxdate} = {table.eff_date} You will need to use the punctuation that...

If you group on Postcode and put the information in the Group Footer thqat should bring it all back just the way you want it to.

It does work as long as you go into File - Report Options and Check Convert Database Null values to default and leave Convert other null values to default blank. Thank you for your help! SP

Closed Thread This thread has been Closed. Feel free to start a new thread with your question. If you wish to reference this thread in your post, the system will automatically create a link to this thread if you use the term thread767-1465862 in your post.

I am using Crystal XI. Oracle database. I am using a formula that LBASS posted in what is now a closed thread, it returns 0 instead of Null. How would I get it to return NULL? Copied From Previous Post: Open and save a new formula {@null} without entering anything. Then change your formula...

To Find a Top N/Sort 1. Select the field you want to Top N/Sort 2. Select Report ?Top N/Sort Group Expert 3. Select Top N, Bottom N from the drop down menu on the left. 4. Select summary field for group selection, value for N, and Others options 5. Click OK

You should be able to create a formula similar to @CheckOwners If A.Owners.field = B.Owners.field then "Yes" else "NO"; Put this formula in the same row as the fields generating A1,B1

LBass, Thank you for your help.

Scholarship 1 could be any of 5 or 6 scholarships. It is just blindly getting the first scholarship and amount, then the second one etc and putting them on the report. I tried the crosstab and it works great, but I am trying to add these scholarships to a rather extensive report. Thanks,

The scholarships are random. One person would not have any more than 3 scholarships. I understand inserting maximums, but what is my condition to make sure that I get three seperate listed scholarships on my report when I don't know if it is scholarship1 or scholarship2?

I don't want to use the crosstab. The last scholarship should have been 3333, it should not repeat. Why do my formulas not work to populate the variables and diplay on the report?