Hi to all I want to know how to create the report for all Branches . I already created for the particualr branch when selected in dropdown box; but if i have ALL option in the DropDown Box then it should show me all the branch report for that i write the sp which takes branch_id, fromdate and todate parameter. and it shows me the rport but how to handle this ALL. Thanks.

Hi, to all i am looking for the solution on my problem & problem is that i suppose to perform the mass printing of one invoice & at least 5 additional invoices. can i create report in asp.net ???????? HOW????? or is it so that create the report in crystal report & then use crystal report viewer to see that report & print it.

ya Thanks in advance

Hi to all. I crate a software which runs on intranet & when we login by putting say, http://informationcenter/track\_system/login.aspx then browser should disappear so that the back button <-- should not be used by user. can u suggest to solve my problem.

Hi to all i used Radiobuttonlist for displaying the two radio buttons Gross & Net & also i am having a checkbox on form when i click this checkbox then this radio buttons should be enabled. I make this radiogross disabled on page load event. but it is not getting enabled.

Hi to all Gross Net & also i am having a checkbox on form when i click this checkbox then this radio buttons should be enabled. I make this radiogross disabled.on page load event

Hi to all Gross Net & also i am having a checkbox on form when i click this checkbox then this radio buttons should be enabled. I make this radiogross disabled.on page load event -- modified at 8:02 Wednesday 9th May, 2007

Hi ALL of you. i use view state for sorting code is given but problem is that it sorts perfectly on name but not on date .. What to do???? actually i chage the date into varchar in order to display in drid For Ex it shows 01 Feb 2007 in Grid but when i click on header it dont sort in correct way.. Bind(); oColumnCollection=dgHistory.Columns; if(ViewState["SortOrder"].ToString() == "" || ViewState["SortOrder"].ToString() == "DESC") { dv.Sort = e.SortExpression; // oCol.HeaderText = oCol.HeaderText + " (ASC)"; ViewState["SortExpression"]= e.SortExpression + "ASC"; ViewState["SortOrder"] = "ASC"; } else { dv.Sort = e.SortExpression + " DESC"; // oCol.HeaderText = oCol.HeaderText + " (DESC)"; ViewState["SortExpression"]= e.SortExpression + " DESC"; ViewState["SortOrder"] = "DESC"; } dgHistory.DataBind(); Thanks

Hi Colin Thanks for your mail but still my problem is not get resolved ........... MyDateColumn >= @SomeStartDate AND MyDateColumn <= @SomeEndDate this is perfect this is what i did but when @SomeStartDate and @SomeEndDate are same then it dont return the records .

Hi Thanks for reply MyDateColumn >= @SomeStartDate AND MyDateColumn <= @SomeEndDate this is perfect this is waht i did but when @SomeStartDate and @SomeEndDate are same then it dont return the records for same date not works.

Please tell me sql queery which returns the recordset between two date inclusive of two dates

Hi i want to change the header on sort for example when i click the header of grid pax_name it schould change to pax_name(ASC) and so on Descending pax_name(Desc) i write code int he sortcommand event of the datagrid by using viewstate. Bind(); if(ViewState["SortOrder"].ToString() == "" || ViewState["SortOrder"].ToString() == "DESC") { dv.Sort = e.SortExpression; ViewState["SortExpression"]= e.SortExpression + "ASC"; ViewState["SortOrder"] = "ASC"; } else { dv.Sort = e.SortExpression + " DESC"; ViewState["SortExpression"]= e.SortExpression + " DESC"; ViewState["SortOrder"] = "DESC"; } dgHistory.DataBind(); -- modified at 3:20 Tuesday 24th April, 2007

Hi Thanks for Reply But; What to write for ME keyword or if i write that property then where to write it.

Hi My grid has biunded columns and it sort on ascending but not on Desc Please help me in this i think after desc it is not able to display data. Thanks Snippets of Code is given In my page Load i write ViewState["SortOrder"] = ""; public void doSortDataGridItem(object sender , System.Web.UI.WebControls.DataGridSortCommandEventArgs e) { showReportsDetails(); dvDetails =dsDataset.Tables[0].DefaultView; if(ViewState["SortOrder"].ToString() == "" || ViewState["SortOrder"].ToString) == "DESC") { // DataView Name dvDetails dvDetails .Sort = e.SortExpression; //Change history no 9 ViewState["SortExpression"]= e.SortExpression; //End Change history no 9 ViewState["SortOrder"] = "ASC"; } else { // DataView Name dvDetails dvDetails .Sort = e.SortExpression + " DESC"; //Change history no 9 ViewState["SortExpression"]= e.SortExpression + " DESC"; /End Change history no 9 ViewState["SortOrder"] = "DESC"; } dgHistory.DataBind(); }//End of this event. showReportsDetails() this is used to display data in datagrid showReportsDetails() { dsDataset=SqlHelper.ExecuteDataset(com.sConnectionString(),CommandType.StoredProcedure,"SP_Reporting1",oSqlParameter); dgHistory.DataSource=dsDataset.Tables[0].DefaultView; dgHistory.DataBind(); }

Hi, In My Datagrid i have shoen the values from tables like passport no,passenger name,travel date,tour_code. But when i click on the column Heading it is convered to Passport_no(ASc) & againi click to Passport_no(Desc) that is it just changing the heading but not actually ascending the values or descending the values of a column. I have set all sort expression for each column and in onsortcommand i write < #region DataGridSortCommand Event public void doSortDataGridItem(object sender , System.Web.UI.WebControls.DataGridSortCommandEventArgs e) { SortingDataGrid.sortDataGridByValue(dgHistory,e); }//End of this event. #endregion > This is the method i used for the sorting < public string sortDataGridByValue(DataGrid datagrid, System.Web.UI.WebControls.DataGridSortCommandEventArgs e) { oColumnCollection=datagrid.Columns; foreach (DataGridColumn oCol in oColumnCollection) { if(e.SortExpression.CompareTo(oCol.SortExpression)== 0) { oCol.HeaderText=oCol.HeaderText.Replace(" (ASC)","").Replace(" (DESC)",""); if(e.SortExpression.IndexOf(" ASC")>1) { oCol.SortExpression = e.SortExpression.Replace(" ASC", " DESC"); oCol.HeaderText = oCol.HeaderText.Replace(" (ASC)",""); oCol.HeaderText = oCol.HeaderText + " (DESC)"; return oCol.SortExpression; }//End of inner If Block. else if (e.SortExpression.IndexOf(" DESC") > 1 ) { oCol.SortExpression = e.SortExpression.Replace(" DESC", ""); return e.SortExpression; } else { oCol.SortExpression = e.SortExpression + " ASC"; oCol.HeaderText = oCol.HeaderText + " (ASC)"; return oCol.SortExpression; } }//End of if block. }//End of For loop. return ""; }//End of method >

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' order by ps.entered_date This query is running but giving double entry. Passport No Consulate XYZ Belgium XYZ Belgium