Set Sort Order Dynamically

Comments

• ipong

  October 2016 edited 3:10AM

  change sort order via script (in frx file) :
  
  1, suppose you have 2 textobject, text1 and text2 in databand
  2. text1 bound to column [AccCode] and text2 bound to column [AccName]
  3. create click event

       private void Text1_Click(object sender, EventArgs e)
      {
        DataBand abc = (DataBand)Data1;
        abc.Sort.Clear();
        abc.Sort.Add(new Sort("[MainReport.AccCode]"));
        Report.Refresh();      
      }
  
       private void Text2_Click(object sender, EventArgs e)
      {
        DataBand abc = (DataBand)Data1;
        abc.Sort.Clear();
        abc.Sort.Add(new Sort("[MainReport.AccName]"));
        Report.Refresh();      
      }
  
• Rexxrally

  October 2016 edited 3:10AM

  Thanks, ipong, that works great!
• Kang

  October 2016 edited 3:10AM

  ipong wrote: »

  change sort order via script (in frx file) :
  
  1, suppose you have 2 textobject, text1 and text2 in databand
  2. text1 bound to column [AccCode] and text2 bound to column [AccName]
  3. create click event

       private void Text1_Click(object sender, EventArgs e)
      {
        DataBand abc = (DataBand)Data1;
        abc.Sort.Clear();
        abc.Sort.Add(new Sort("[MainReport.AccCode]"));
        Report.Refresh();      
      }
  
       private void Text2_Click(object sender, EventArgs e)
      {
        DataBand abc = (DataBand)Data1;
        abc.Sort.Clear();
        abc.Sort.Add(new Sort("[MainReport.AccName]"));
        Report.Refresh();      
      }
  

  
  Tks u, i try
  customize Email Template Magento 2 - Enable Canonical Meta Tag Magento 2 - Magento 2 Odoo