Telling a group header on which database field to group by

Comments

• gpi

  March 2012 edited 5:20PM

  Try to use condition like FormatDateTime('dd.mm.yyyy', <Fisk."SysTm">)
• Svip

  March 2012 edited March 2012

  gpi wrote: »

  Try to use condition like FormatDateTime('dd.mm.yyyy', <Fisk."SysTm">)

  
  Thank you, that worked excellent. It was actually for a Memo.Text, but still; great. What confuses me, however, is because your suggestion - which works - contradicts what it says in the manual (albeit for 4.0, but I suspected such a major change to a common function would be unusual); any manual I can obtain that is updated with these subjects?
  
  I have a more difficult - unusual perhaps? - question. If a Memo's data is the same as it was in its previous occurrence, I want it to be invisible (Visible:=false), but visible once again the data changed. But it is also important for the data to reappear even if it the same as last time, but if a new GroupHeader has appeared.
  
  e.g. An illustration:
  

  [ GROUP HEADER ]
  Friday    2011-01-04  Time1  More data
                        Time2  More data
  Saturday  2011-01-05  Time3  More data
                        Time4  More data
  [ GROUP HEADER ]
  Saturday  2011-01-05  Time5  More data
  

  
  I hope that make sense. I realised it made it more readable to have the dates disappear if they are the same, because it is implied.
  
  Slightly unrelated; I also wonder about a highlight question. It's great that you can use conditioning for highlighting, like not <Line#> mod 2, however you may expect in this report, that after a group header, a highlighted row may appear, when this is undesirable. Essentially, after each group header's appearance, the condition should default to not highlighted and the highlight should continue the reverse. Is it possible to write an expression to ensure a highlight is based on whether the previous' row highlight was active?
  
  For instance: Memo.Highlight.Condition := 'not ' + Memo.Name + '.Highlight.Active';
  
  Then have the GroupHeader's OnAfterPrint be Memo.Name + '.Highlight.Active:=true'; or something.
• gpi

  March 2012 edited March 2012

  wrote:

  I have a more difficult - unusual perhaps? - question. If a Memo's data is the same as it was in its previous occurrence, I want it to be invisible (Visible:=false), but visible once again the data changed. But it is also important for the data to reappear even if it the same as last time, but if a new GroupHeader has appeared.

  Set TfrxMemoView.SuppressRepeated to True

  wrote:

  Slightly unrelated; I also wonder about a highlight question. It's great that you can use conditioning for highlighting, like not <Line#> mod 2, however you may expect in this report, that after a group header, a highlighted row may appear, when this is undesirable. Essentially, after each group header's appearance, the condition should default to not highlighted and the highlight should continue the reverse. Is it possible to write an expression to ensure a highlight is based on whether the previous' row highlight was active?
  
  For instance: Memo.Highlight.Condition := 'not ' + Memo.Name + '.Highlight.Active';
  
  Then have the GroupHeader's OnAfterPrint be Memo.Name + '.Highlight.Active:=true'; or something.

  Use <Line> mod 2 highlight expression
• Svip

  March 2012 edited 5:20PM

  That worked. I went a bit of a different method for the highlight condition, because the regular version would still highlight them regardless of the Group Header. So instead, I created a script variable that is increased on each print of a row, but set to 0 on each print of a Group Header and set the condition to 'not <Variable> mod 2'. Works great.