Search results for query: *

Thank you. That worked great.Im using SQL Server. The only issue I seem to have now is that not all the customer names are being displayed when the user is prompted to pick a customer. I set up a dynamic parameter to enable the user to select the relevant customer. The customers are on the...

Thanks for you response. I can recreate in SQL but as Im using a FULL OUTER JOIN to join two tables a NULL value is returned for every column of the table that lacks a matching row. I would like if there was no match that it returned text Heres an example of my statement: SELECT table1.Opp_Id...

I want to create a parameter which has a dropdown list of Customers. However this list is coming from a formula and crystal doesn’t seem to allow this. Is there any way that this can be done?

Thanks so much. That worked perfectly!

Thanks so much that worked really well! The only issue now is that I need a formula to work out how much each engineer will generate. So now there are duplicates in the CaseNo field (which is fine as this only happens when there is more than one engineer dealing with the case), however if there...

I trying to create a report that will calculate the total value an engineer generates from his customer service cases. I have four fields in my report: Case No: Unique ID for each Customer service case Case Fee: Value of case (currency) Engineer1: Engineer Name Engineer2: Engineer Name The...