we have an application which uses crystal reports as the primary reporting tool. to date we have used versions upto 8.5 with great sucess, however we are trying to use versions 9 and beyond but are struggling. The problem come with how the later versions of CR deals with 'wildcard' values. bacisally when the application calls a report it uses crpe32.dll to interrogate the selection criteria and establish the names of formula fields in the criteria, based on this a set of input boxes are displayed for the user to enter values. the application then replaces the formula fields with these vaules and runs the report. if we wanted to select all records we would simply enter a value of -1, for example if you had a table with person records you could select a specific record be entering the person ID, however if you want everyone you need to enter a wild card, thus the value of -1.
can anyone suggest a suitable value to enter into the formula field to return such a record set, which will work with CR9+, or offer an alternative way of doing things (re-wrinting the applicaiton so as not using crpe32.dll is not an option, as much as i wish it were!!).
thanks in advance
Andrew
can anyone suggest a suitable value to enter into the formula field to return such a record set, which will work with CR9+, or offer an alternative way of doing things (re-wrinting the applicaiton so as not using crpe32.dll is not an option, as much as i wish it were!!).
thanks in advance
Andrew