1.I am writing store Procedure in sql server like this give below -
Hi Friends, Can any one help me about Store Procedure. In data base ResuleSet: 2007-06-10 7:00:56.107 I am getting like this. I want in this format 2007/06/10. for my paramater This is my data base field -EST_START_DATE This is my input paramater - @start_Date and @End_Date I have a code like this : -
CREATE PROCEDURE SP_Job_Details @Job_Status varchar, -Input paramater @Start_Date datetime, -Input paramater @End_Date datetime -Input paramater AS SELECT distinct job_no as Job_Number, dealer_name as Customer_Name, customer_name as End_user, foreman_user_name as Supervisor, billing_user_name as Project_Manager, pri_furn_line_type_name as Furniture_Line FROM JOB_SERVICES_V WHERE job_status_type_name = @Job_Status and EST_START_DATE BETWEEN @Start_Date and End_Date GO -
This is one problem and when I open crystal reprots software I am connecting to data Expert
connect to data base-storeprocedure.Here it is asking for report parameters to enter.I am getting 1.STATUS 2.START DATE AND END DATE FOR 2 AND 3 IT IS SHOWING DATE PICKER so my results are not getting why? bocz it is showing AM and PM so that my data is not displaying so any once can do this logic please sir........
I've written many Crystal Reports based on SQL Server. I think I could help you. However, I'm not sure what version of SQL Server you are using.
In any event, it might be good to post the code used in the stored procedure. In your test, I see -input parameter. That is not needed. You might have put that to clarify for your message.
Here is the syntax that I use for writing stored procedures with Crystal:
Select customer, city, state and account from myTable
where date1 >= @beginDate
date2 <= @endDate
In the above, Crystal would give me as available fields customer, city, state and account.
Let us know how we can help!
Edited by: Glenn Tucker on Jul 15, 2008 6:25 PM