Your Stored Procedure should look like the following: CREATE PROCEDURE sp_Branch_Report @branch_id nvarchar(20) = NULL, @fromdate datetime = NULL, @todate datetime = NULL when you call the above stored procedure: ALL->sp_Branch_Report BranchId->sp_Branch_Report 'BRANCH1' Date->sp_Branch_Report null,'01/05/2007','30/05/2007' another example->sp_Branch_Report 'BRANCH1','01/05/2007','30/05/2007' hope this could resolve your problem. ensure the date format before you pass it. Karthik

sonia_basangar wrote: or is it so that create the report in crystal report & then use crystal report viewer to see that report & print it. This will be the good solution Navaneeth My Website

ya Thanks in advance

You can use this code make AutoPostback property true of the Checkbox Write this code in Page load if (CheckBox1.Checked) { RadioButtonList1.Enabled = true; } else RadioButtonList1.Enabled = false; Thanks and Regards Sandeep If If you look at what you do not have in life, you don't have anything, If you look at what you have in life, you have everything... "

When you post this in the ASP.NET forum, check 'Ignore HTML tags in this message (good for code snippets)', and your post will make sense :-) Christian Graus - Microsoft MVP - C++ Metal Musings - Rex and my new metal blog "I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )

Hi, Do not covnert you date column to varchar but set the DataFormatString property of the column in which you are displaying the date value. Design Time I hope this will help you. Thanks and Regards, Chetan Ranpariya

try like this MyDateColumn >= "01-Apr-2007 12:00:00 AM" AND MyDateColumn <= "01-Apr-2007 11:59:59 PM" Make sure urself - the value i gave in double quotes for just sample. So u have to convert this into date in the SQL Regards R.Arockiapathinathan

This is Code Horros Forum, hence you (perhaps us?) missed something... :zzz: If the Lord God Almighty had consulted me before embarking upon the Creation, I would have recommended something simpler. -- Alfonso the Wise, 13th Century King of Castile.

It's easy. Because you have write: ViewState["SortOrder"] = ""; in Page load So everytime it will make if(ViewState["SortOrder"].ToString() == "") true I think you may write this in page load : if(ViewState["SortOrder"]==null) { ViewState["SortOrder"] = ""; } Hope it works. Regards, Mayank Parmar Senior Software Engineer Amba Tech Gandhinagar, India

I think the best way to sort something is usually in a DataView. If you current datasource is a datatable then you need to do something like: DataView dv = dataSet.Tables[0].DefaultView; //This assumes you only have one table in your dataset dv.Sort = "columnName ASC"; //or you can do "columnName DESC"; datagrid.DataSource = dv; datagrid.Databind(); Hope that helps. Ben

try following, SELECT distinct * from ( select distinct(ps.pax_id),ps.barcode_no,ps.modified_date,ps.passport_no,pd.pax_fname+' '+pd.pax_mname+' '+pd.pax_lname as pax_name,ps.fromBranch,ps.passport_status,ps.toBranch,ps.consulate,pv.travel_date,pv.tour_code,ps.entered_date,ps.branch_id,ps.status_type,bm.branch_name from passport_status_tran ps,pass_branch_mst bm,passport_details pd,pax_visarequirments pv where bm.branch_id=pd.branch_id and bm.branch_id='9' and ps.fromBranch='5' and ps.barcode_no=pd.barcode_no and pd.pax_id=pv.pax_id and ps.passport_status='out' and ps.entered_date between '03/24/2007' and '03/27/2007')ttemp order by ttemp.entered_date Mubashir Software Architect Storan Technologies Inc, USA Every job is a self portrait of the person who did it.