Skip to Content
0
Former Member
Mar 03, 2010 at 10:48 AM

Error retrieving data when using filter (where in)

15 Views

Hi,

I'm fairly new to using Crystal Reports 2008 version 12 and no programming engineer, but can someone help me.

I'm using a filter in my report in which i try to filter on specific items in a table. In the filter i can specify which items should be seen in my report by using "is one of" (i'm using the dutch version). In the selection-expert the formula will look like: {vwais007_prognosetotaal1.sberekend} in ["AFSCHRIJVING", "HUURLASTEN", "RENTEKOSTEN", "RENTEKOSTENFIN", "VERGOEDINGIN"]

No problem, but when i to refresh the data i get an error retrieving data. Next clue is the sql statement of my report. This shows the following (partial):

WHERE (`vwais007_prognosetotaal1`.`sberekend`=0xAFSCHRIJVING OR `vwais007_prognosetotaal1`.`sberekend`=0xHUURLASTEN OR

`vwais007_prognosetotaal1`.`sberekend`=0xRENTEKOSTEN OR

`vwais007_prognosetotaal1`.`sberekend`=0xRENTEKOSTENFIN OR `vwais007_prognosetotaal1`.`sberekend`=0xVERGOEDINGIN)

Please help. Working around this problem is no option.