Recent content by spcc07

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