Group by Expression

Comments

• AlexTZ

  September 2009 edited 7:26AM

  Hello,
  
  Please show how you do this. What do you pass in the parameter?
• dba

  September 2009 edited 7:26AM

  In the code
  
  report1.SetParameterValue("Grupo", "[Products.Field1]");
  
  
  In the designer of the report I have a Group Header with the following condition in the "Edit Group" form:
  
  Group condition
  Select data column or type an expression
  +

  ---

  +
  | [GRUPO] |
  +

  ---

  +
  
  Thanks
  
  
• AlexTZ

  September 2009 edited 7:26AM

  That's not correct. You have to set the parameter's Expression property, instead of Value (which is set by SetParameterValue method).
  Correct code:
  
  Parameter parameter = report1.GetParameter("Grupo");
  parameter.Expression = "[Products.Field1]";
  parameter.DataType = typeof(int); // set correct data type here
  
  another way is to set the group condition directly:
  
  GroupHeaderBand group = report1.FindObject("GroupHeader1") as GroupHeaderBand;
  group.Condition = "[Products.Field1]";
• dba

  September 2009 edited 7:26AM

  Ok, It works....
  
  
  Thanks a lot...