Hi,
Im just getting back into writing Crystal Reports after probably 5 years plus. I cant remember how you create a report based on a parameter? So I have created a parameter which points to a company name but the report returns all values instead of just those relating tot he company entered in the parameter.

Any help would be appreciated - thanks :)

Hi Kevlray,

I managed to overcome this (the problem was due to my unfamiliarity) I remember in Crystal Reports 2008 you had a select expert, in this version you use interactive filtering which looks like the same thing :) Thanks!!

Its Crystal Reporting built into SAP Business which is what your referring to by the sounds of it. I couldn't find the select expert filtering, I don't suppose you know where it is?

Edited by shabbaranks - 25 Jul 2018 at 10:20am

I found it (I think)its just called record filter?
One thing I am struggling with, it would seem the query needs to be in uppercase to work. I have converted the SQL view to uppercase but this has no impact on the parameter? If I use uppercase I get results and if I use lowercase it returns nothing?

Well - I'm making progress. I found that if I manually create a parameter using the formula process I can get results which work. Below is my code:

IF {?Select Supplier} = "Select All"
THEN ({SS_Supplier_View.Company Name}) like '*'
ELSE ({SS_Supplier_View.Company Name}) like "*" & uppercase({?Select Supplier}) & "*"
AND
{@RecordDate} >= {?Date From} and {@RecordDate} <= {?Date To}

But it seems to ignore the from and to criteria if you leave the search as "Select All"