Monday, July 16, 2012

ASP.NET Crystal report Group Tree hide

It's really looking odd that when a crystal report load it also load the group tree. You can easily stop the group tree showing.

aspx :


 <CR:CrystalReportViewer ID="secondarySalesCrystalReportViewer" runat="server" EnableDatabaseLogonPrompt="False"  
             EnableParameterPrompt="False" AutoDataBind="true" EnableDrillDown="False"   
             GroupTreeStyle-ShowLines="False" HasCrystalLogo="False" Height="50px"   
             Width="350px" />  

and on the page loading  event you have to use:

 secondarySalesCrystalReportViewer.ToolPanelView =CrystalDecisions.Web.ToolPanelViewType.None;


for example



  protected void Page_Load(object sender, EventArgs e)  
     {  
       secondarySalesCrystalReportViewer.ToolPanelView = CrystalDecisions.Web.ToolPanelViewType.None;  
       if (!IsPostBack)  
       {  
         secondarySalesCrystalReportViewer.ToolPanelView = CrystalDecisions.Web.ToolPanelViewType.None;  
         LoadAllWingInformation();  
         LoadDivision();  
         LoadRegion();  
         LoadTeritory();  
       }  
     }  


thank you

SQL Get all Index create script from Database

To get all script from database as a create new index into another database you can use the following --Get all Index Script SELECT...