Search results for query: *

A colleague has resolved this for me as follows: Insert a summary on company name (eg. Maximum) for the companyid group Use the TopN function to return ALL records. This worked.

I am using Crystal 8.5 to report from a Pivotal database. I am grouping my report by COMPANY.companyid but want to see the records in alphabetical order of company name, not ascending order of company id. Is this possible? Thanks Janice

That has worked. Thank you very much. Didn't realise was case sensitive but am aware of performance issues - no way around though unfortunately. Thanks for your help.

Are there any known restrictions/problems with the LIKE operator? I have a very simple selection formula: {CONTACT.JOBTITLE} like "*director*" which is returning 0 records. I have also tried: {CONTACT.JOBTITLE} like "*" + "director" + "*" which also...

I have used the Group selection and running totals suggestion and this has worked. Thank you so much for your help.

Hi I am fairly new to Crystal and not that technical so hope you can help. I have a report grouped by an ID field eg. Group Header: 21189 Detail: Company A Value 1 Company B Value 2 Group Footer: Count({Company}) I want to set the value field for all records in the detail...

Sorry - I did try dumping the groupname. Same result. I can get my sub totals in because each group has just one commission rate. So my sub total formula is: (Sum ({Reporting_Product_Needs.Total Contract Value to Break}, {Reporting_Product_Needs.Sale Type})*{@CommRate})/100 However for my...

Thank you for your help. I did the following: Amended my formula as suggested: ({Reporting_Product_Needs.Total Contract Value to Break}/100 * if GroupName ({Reporting_Product_Needs.Sale Type})="New Sale" then 1.25 else 0.5 ) That bit worked fine. However, despite the change, I am...

Thanks for your reply. Here is the formula: ({Reporting_Product_Needs.Total Contract Value to Break}*{@CommRate})/100 where @CommRate is: if GroupName ({Reporting_Product_Needs.Sale Type})= "New Sale" then 1.25 else 0.5 It is in the Detail section. Hope this helps.

Yes - that is the way that I tried first of all but when you have a formula field, you don't get the option to insert summary fields in the same way you do for standard numeric fields.

I am new to Crystal and have a very simple problem: I have a formula field calculating commission based on a 'Total Value' field in the report. For example, the formula reads: if product_type = "XXX" then (sale_value*5)/100 else (sale_value*2.5)/100 All I want to do is add a...