Friday, 6 September 2013

Suppress Crystal Report Footer On last Page

 Supress Line in Last Page

Right Click on Report--->Report-->Section Expert---->Page Footer-->Suppress (No Drill Down)

Click on Formula Image and Write the following formula

if(pagenumber=TotalPageCount) then
 true
else
false;

 Change Orientation in Crystal Report

Right click--->Design--->Page SetUp--->Orientation--->LandScape format



Find a Control (Textbox) in Crystal Report

  public void BindCompDetails(ReportDocument Obj)
        {
            DataTable dtCompany = objCommon.GetCompAddress();
            if (dtCompany.Rows.Count > 0)
            {
                TextObject CompName = ((TextObject)Obj.ReportDefinition.Sections["Section1"].ReportObjects["txtCompName"]);
     
                TextObject ToDate = ((TextObject)Obj.ReportDefinition.Sections["Section2"].ReportObjects["txt_To"]);
                ToDate.Text = Session["BadDebtToDate"].ToString();
            }           

        }

No comments:

Post a Comment