AnsweredAssumed Answered

Multiple input parameter in Crystal Report

Question asked by Deepak on Jan 8, 2011
Latest reply on Jan 27, 2011 by CAulds
Hello All,

I have a created a sample Crystal Report based on following query..


SELECT I.ID PROJECT_KEY,
I.CODE PROJECT_ID,
I.NAME
FROM INV_INVESTMENTS I
WHERE (I.ODF_OBJECT_CODE = 'project')
AND ((( I.ID ) IN {?PARAM_PROJECT} AND 0 NOT IN {?PARAM_PROJECT}) OR 0 IN {?PARAM_PROJECT})


1. If I enter '0' as a input parameter then it shows me all results.
2. If I enter 'Project Id ' as a input parameter then it shows me results for that project.

Now,I changed the Parameter setting : - Made Allow Multiple Values True. Now if i enter two project ID, then i am expecting result for that two project,But it shows 'Failed to retrieve data from database'


Could anyone help me, how to achieve this.

Thanks in Advance :-)

Regards,
Deepak

Outcomes