Seal Report Forum
	 » 
	General
	 » 
	General Discussions/Other
	 » 
	Display of repeated values in report output
	 
	
        
            
            
    
        
	Rank: Member
  Groups: Registered
 Joined: 6/9/2017(UTC) Posts: 29  Thanks: 1 times
  
	 
	
     | 
    
        
            
		      
                Hello,
  Are there options available to turn a report like this:
  Incident#	Reported Date	Incident Type	Office Code	Count of Office Code 22034423	3/15/2022	INFO		MAIN		1 22034438	3/15/2022	PS		MAIN		1 22034352	3/15/2022	MSEIZ		MAIN		1 22034082	3/15/2022	ALRMS		MAIN		1 22034412	3/15/2022	PS		MAIN		1 22034183	3/15/2022	MEDIC		MAIN		1 22034364	3/15/2022	INFO		MAIN		1 22034156	3/15/2022	MEDIC		MAIN		1 Subtotal							8 22034184	3/15/2022	DOA		OTH		1 Subtotal							1 22034131	3/15/2022	PS		REM		1 22034305	3/15/2022	PS		REM		1 22034136	3/15/2022	PS		REM		1 22034125	3/15/2022	PS		REM		1 22034228	3/15/2022	PS		REM		1 22034249	3/15/2022	PS		REM		1 Subtotal							6
 
 
  Into a report where the sorted values (Office Code) are only displayed when the values change instead of displaying all values?
  Incident#	Reported Date	Incident Type	Office Code	Count of Office Code 22034423	3/15/2022	INFO		MAIN		1 22034438	3/15/2022	PS				1 22034352	3/15/2022	MSEIZ				1 22034082	3/15/2022	ALRMS				1 22034412	3/15/2022	PS				1 22034183	3/15/2022	MEDIC				1 22034364	3/15/2022	INFO				1 22034156	3/15/2022	MEDIC				1 Subtotal							8 22034184	3/15/2022	DOA		OTH		1 Subtotal							1 22034131	3/15/2022	PS		REM		1 22034305	3/15/2022	PS				1 22034136	3/15/2022	PS				1 22034125	3/15/2022	PS				1 22034228	3/15/2022	PS				1 22034249	3/15/2022	PS				1 Subtotal							6
 
 
  
            
	  
         
     | 
    | 
         
             
     | 
    
         
            
         
     | 
    | 
        
	
     | 
        
        
        
            
        
            
            
    
        
	Rank: Administration
  Groups: Administrators
 Joined: 12/20/2013(UTC) Posts: 1,209  Thanks: 14 times Was thanked: 206 time(s) in 199 post(s)
  
	 
	
     | 
    
        
            
		      
                there is no simple option to do that (could be a feature request). to achieve this, you should write some specific code in a task to modify you model result (check sample 503-Final Script - Change result table.srex)  
            
	  
         
     | 
    | 
         
             
     | 
    
         
            
         
     | 
    | 
        
	
     | 
        
        
        
    
        
            
            
    
        
	Rank: Member
  Groups: Registered
 Joined: 6/9/2017(UTC) Posts: 29  Thanks: 1 times
  
	 
	
     | 
    
        
            
		      
                It would be better handled as a new feature since our users create their own reports dynamically using the Web Designer.  How should I go about to make a new feature request?
  Yves 
            
	  
         
     | 
    | 
         
             
     | 
    
         
            
         
     | 
    | 
        
	
     | 
        
        
        
            
        
            
            
    
        
	Rank: Administration
  Groups: Administrators
 Joined: 12/20/2013(UTC) Posts: 1,209  Thanks: 14 times Was thanked: 206 time(s) in 199 post(s)
  
	 
	
     | 
    
        
            
		      
                Yes, it was already mentioned in the TODO list but was not really a priority, I just update the TODO list again... Note that you may always sponsor a new feature to make sure to have in in a future release.
 
  
            
	  
         
     | 
    | 
         
             
     | 
    
         
            
         
     | 
    | 
        
	
     | 
        
        
        
    
        
            
            
    
        
	Rank: Administration
  Groups: Administrators
 Joined: 12/20/2013(UTC) Posts: 1,209  Thanks: 14 times Was thanked: 206 time(s) in 199 post(s)
  
	 
	
     | 
    
        
            
		      
                Here is a Task sample to do what you want for SubTotals columns. The task must be executed at the 'Before rendering' step. Please check if it works and we may consider to add a flag in the element to make it standard... Code:@using System.Data
@{
    ReportTask task = Model;
    Report report = task.Report;   
    foreach (var model in report.Models) 
    {
        foreach (var page in model.Pages) 
        {
            var dataTable = page.DataTable;
            foreach (var line in page.DataTable.Lines) 
            {
                int i = dataTable.BodyStartRow, cols = dataTable.ColumnCount;
                string[] lastValues = new string[dataTable.ColumnCount];
                for (int j = 0; j < cols; j++)
                {
                    //init first values
                    var cell = dataTable[i, j];
                    if (cell.Element != null && cell.Element.ShowSubTotals) {
                       lastValues[j] = cell.DisplayValue;
                    }
                }
                i++;
                
                while (i < dataTable.BodyEndRow)
                {
                    string currentValue = "";
                    for (int j = 0; j < cols; j++)
                    {
                        var cell = dataTable[i, j];
                        if (cell.Element != null && cell.Element.ShowSubTotals) {
                            if (lastValues[j] == cell.DisplayValue) {
                                cell.Value = "";
                             }
                             else {
                                lastValues[j] = cell.DisplayValue;
                             }
                        }
                    }
                    i++;
                }
           }
        }
    }
}
 
  
            
	  
         
     | 
    | 
         
             
     | 
    
         
            
         
     | 
    | 
        
	
     | 
        
        
        
            
        
            
            
    
        
	Rank: Member
  Groups: Registered
 Joined: 6/9/2017(UTC) Posts: 29  Thanks: 1 times
  
	 
	
     | 
    
        
            
		      
                I'm not sure I understand where this script could be added, I can't find a 'Before rendering' stop anywhere. 
            
	  
         
     | 
    | 
         
             
     | 
    
         
            
         
     | 
    | 
        
	
     | 
        
        
        
    
        
            
            
    
        
	Rank: Administration
  Groups: Administrators
 Joined: 12/20/2013(UTC) Posts: 1,209  Thanks: 14 times Was thanked: 206 time(s) in 199 post(s)
  
	 
	
     | 
    
        
            
		      
                Actually it is the task 'Execution Step' : Models generated, before rendering. I just added this as a standard option in the incoming 6.6 version. Edited by user Friday, March 25, 2022 3:45:17 PM(UTC)
 | Reason: Not specified  
            
	  
         
     | 
    | 
         
             
     | 
    
         
            
         
     | 
    | 
        
	
     | 
        
        
        
            
        
            
            
    
        
	Rank: Member
  Groups: Registered
 Joined: 6/9/2017(UTC) Posts: 29  Thanks: 1 times
  
	 
	
     | 
    
        
            
		      
                I found the task "'Execution Step' : Models generated, before rendering" in the 'fat client' Report Designer, but not in the Web Report Designer.  I added the script you provided to the report definition using the 'fat client' and saved the report definition.  It did not make a difference when I executed the report from the Web Report server.  Hopefully, the feature you added in Ver. 6.6 will do the trick.
  Yves
  
            
	  
         
     | 
    | 
         
             
     | 
    
         
            
         
     | 
    | 
        
	
     | 
        
        
        
    
                           
	Seal Report Forum
	 » 
	General
	 » 
	General Discussions/Other
	 » 
	Display of repeated values in report output
	 
	
    
        Forum Jump
         
	
    
    You cannot post new topics in this forum.
	
	You cannot reply to topics in this forum.
	
	You cannot delete your posts in this forum.
	
	You cannot edit your posts in this forum.
	
	You cannot create polls in this forum.
	
	You cannot vote in polls in this forum.