Dynamic parameter to crystal report using SQL Command

[Lost User]

Please help; For a couple days I've been battling with writing a report that has to tables linked by a Inner join. I think I found a work around. I'm using an SQL SERVER database. Crystal was creating the following query: SELECT t_EMPINFO.c_EmpFName, t_EMPINFO.c_EmpCode, t_Employee_Salary.c_TotalIncome, t_Employee_Salary.c_TotalDeduction, t_Employee_Salary.c_TotalSalary FROM t_EMPINFO INNER JOIN t_Employee_Salary ON t_EMPINFO.c_EmpID = t_Employee_Salary.c_EmpId WHERE (t_EMPINFO.c_Softdelete = '1') AND (t_Employee_Salary.c_SoftDelete = '1') AND (t_Employee_Salary.c_Year = 'PARAMETER1') AND (t_Employee_Salary.c_Month ='PARAMETER2') IN Above Query In place of :rose: PARAMETER1 and :rose: PARAMETER2 I want to pass Differnt value at the run time (e.g 2007 , 01 ) how it's set dynamically I have questions though: 1) Is it possible to change the sql that crystal generates without writing my own sql command? Thanks again for all of your help on this!

[Reza Raad]

you can use PARAMETER FIELD in crystal report for handling this. more about parameter fields here: http://support.businessobjects.com/documentation/product_guides/cr_net/vs_2005/html/crtsktutorialsrdparametersdiscretecreatingreport.htm[^]

Human knowlege belongs to the world

[alav]

Hi, If you are using VS2005. I think the following will helps to you. 1) Make the EnableParameterPrompt to false. 2) For your example create two text box and a button. 3) In the button click event add the following code. CrystalReportSource1.ReportDocument.SetParameterValue(0,TextBox1.Text) CrystalReportSource1.ReportDocument.SetParameterValue(1,TextBox2.Text) Thats it.