null Date in CountDistinct group header field causes runtime exception

dcleyne · Post by **dcleyne** » Sun Sep 12, 2010 9:32 pm

Folks,

Have another issue with aggregate fields in a group header situation. This time it involves CountDistinct and Date fields. When I have a dataset with null date values the report throws a runtime error. Is there a way to work around this?

Cheers,
Dan

The report is:

Code: Select all



  
    
    
    
      
        Source
        0
        
          CodesSource_Name,System.String
          CodesSource_CreatedOn,System.DateTime
          CodesSource_ModifiedOn,System.DateTime
          CodesSource_FolderLocation,System.String
          CodesSource_Id,System.String
          ReportRecordID,System.String
        
        
        Source
        C:\Users\dcleyne\Desktop\NullDateTestData.csv
        C:\Users\dcleyne\Desktop\NullDateTestData.csv
      
    
    
    
    
  
  EngineV2
  
  
  
    
      None;Black;2;Solid;False;4;Black
      Transparent
      
        
          Transparent
          0,0.4,19,1.4
          
            
              Transparent
              0,0,19,1.4
              
              Arial,20,Bold
              Center
              0,0,0,0
              ReportTitleText
              
              
              Source
              Black
              Center
            
          
          
          ReportTitle
          
          
        
        
          Transparent
          0,2.6,19,0.8
          
            
              Transparent
              True
              0,0,3.2,0.8
              
              Arial,10,Bold
              0,0,0,0
              HeaderText1
              
              
              CodesSource_Name
              Black
              HotkeyPrefix=None, LineLimit=False, RightToLeft=False, Trimming=None, WordWrap=True, Angle=0, FirstTabOffset=40, DistanceBetweenTabs=20,
              Center
            
            
              Transparent
              True
              3.2,0,3.2,0.8
              
              Arial,10,Bold
              0,0,0,0
              HeaderText2
              
              
              CodesSource_CreatedOn
              Black
              HotkeyPrefix=None, LineLimit=False, RightToLeft=False, Trimming=None, WordWrap=True, Angle=0, FirstTabOffset=40, DistanceBetweenTabs=20,
              Center
            
            
              Transparent
              True
              6.4,0,3.2,0.8
              
              Arial,10,Bold
              0,0,0,0
              HeaderText3
              
              
              CodesSource_ModifiedOn
              Black
              HotkeyPrefix=None, LineLimit=False, RightToLeft=False, Trimming=None, WordWrap=True, Angle=0, FirstTabOffset=40, DistanceBetweenTabs=20,
              Center
            
            
              Transparent
              True
              9.6,0,3.2,0.8
              
              Arial,10,Bold
              0,0,0,0
              HeaderText4
              
              
              CodesSource_FolderLocation
              Black
              HotkeyPrefix=None, LineLimit=False, RightToLeft=False, Trimming=None, WordWrap=True, Angle=0, FirstTabOffset=40, DistanceBetweenTabs=20,
              Center
            
            
              Transparent
              True
              12.8,0,3.2,0.8
              
              Arial,10,Bold
              0,0,0,0
              HeaderText5
              
              
              CodesSource_Id
              Black
              HotkeyPrefix=None, LineLimit=False, RightToLeft=False, Trimming=None, WordWrap=True, Angle=0, FirstTabOffset=40, DistanceBetweenTabs=20,
              Center
            
            
              Transparent
              True
              16,0,3,0.8
              
              Arial,10,Bold
              0,0,0,0
              HeaderText6
              
              
              ReportRecordID
              Black
              HotkeyPrefix=None, LineLimit=False, RightToLeft=False, Trimming=None, WordWrap=True, Angle=0, FirstTabOffset=40, DistanceBetweenTabs=20,
              Center
            
          
          
          Header
          
          
        
        
          Transparent
          0,4.2,19,0.8
          
            
              Transparent
              True
              3.2,0,3.2,0.6
              
              Arial,10,Bold
              e071274b21b341f1b1c866771d33fbd8
              Right
              0,0,0,0
              FooterText1
              
              
              {CountDistinct(Source.CodesSource_CreatedOn)}
              Black
              HotkeyPrefix=None, LineLimit=False, RightToLeft=False, Trimming=None, WordWrap=True, Angle=0, FirstTabOffset=40, DistanceBetweenTabs=20,
              Center
            
            
              Transparent
              True
              6.4,0,3.2,0.6
              
              Arial,10,Bold
              fcb5179e3ce74ff0ada859774b237094
              Right
              0,0,0,0
              FooterText2
              
              
              {CountDistinct(Source.CodesSource_ModifiedOn)}
              Black
              HotkeyPrefix=None, LineLimit=False, RightToLeft=False, Trimming=None, WordWrap=True, Angle=0, FirstTabOffset=40, DistanceBetweenTabs=20,
              Center
            
          
          {Source.CodesSource_FolderLocation}
          
          GroupHeader0
          
          
        
        
          Transparent
          
          0,5.8,19,1.8
          
            
              Transparent
              True
              0,0,3.2,1.8
              
              Arial,8
              0,0,0,0
              DataText1
              
              
              {Source.CodesSource_Name}
              Black
              HotkeyPrefix=None, LineLimit=False, RightToLeft=False, Trimming=None, WordWrap=True, Angle=0, FirstTabOffset=40, DistanceBetweenTabs=20,
              Center
            
            
              Transparent
              True
              3.2,0,3.2,1.8
              
              Arial,8
              0,0,0,0
              DataText2
              
              
              {Source.CodesSource_CreatedOn}
              Black
              HotkeyPrefix=None, LineLimit=False, RightToLeft=False, Trimming=None, WordWrap=True, Angle=0, FirstTabOffset=40, DistanceBetweenTabs=20,
              Center
            
            
              Transparent
              True
              6.4,0,3.2,1.8
              
              Arial,8
              0,0,0,0
              DataText3
              
              
              {Source.CodesSource_ModifiedOn}
              Black
              HotkeyPrefix=None, LineLimit=False, RightToLeft=False, Trimming=None, WordWrap=True, Angle=0, FirstTabOffset=40, DistanceBetweenTabs=20,
              Center
            
            
              Transparent
              True
              9.6,0,3.2,1.8
              
              Arial,8
              0,0,0,0
              DataText4
              
              
              {Source.CodesSource_FolderLocation}
              Black
              HotkeyPrefix=None, LineLimit=False, RightToLeft=False, Trimming=None, WordWrap=True, Angle=0, FirstTabOffset=40, DistanceBetweenTabs=20,
              Center
            
            
              Transparent
              True
              12.8,0,3.2,1.8
              
              Arial,8
              0,0,0,0
              DataText5
              
              
              {Source.CodesSource_Id}
              Black
              HotkeyPrefix=None, LineLimit=False, RightToLeft=False, Trimming=None, WordWrap=True, Angle=0, FirstTabOffset=40, DistanceBetweenTabs=20,
              Center
            
            
              Transparent
              True
              16,0,3.2,1.8
              
              Arial,8
              0,0,0,0
              DataText6
              
              
              {Source.ReportRecordID}
              Black
              HotkeyPrefix=None, LineLimit=False, RightToLeft=False, Trimming=None, WordWrap=True, Angle=0, FirstTabOffset=40, DistanceBetweenTabs=20,
              Center
            
          
          
          Source
          
          Data
          
          
          
        
        
          Transparent
          0,8.4,19,0.4
          
          
          GroupFooter0
          
          
        
        
          Transparent
          0,9.6,19,0.6
          
          
          Footer
          
          
        
      
      
      9126ca21d36b42c2b9d4480f5f47da76
      1,1,1,1
      Page1
      29.7
      21
      
      
        Arial,100
        [50:0:0:0]
      
    
  
  
  
    System.Dll
    System.Drawing.Dll
    System.Windows.Forms.Dll
    System.Data.Dll
    System.Xml.Dll
    Stimulsoft.Controls.Dll
    Stimulsoft.Base.Dll
    Stimulsoft.Report.Dll
  
  Report
  9/13/2010 12:27:02 PM
  9/13/2010 10:50:11 AM
  C:\Users\dcleyne\Desktop\NullDateReport.mrt
  bb4db9cb5a03439e8f2551abfa343fc2
  Report
  Centimeters
  2010.1.700
  using System;
using System.Drawing;
using System.Windows.Forms;
using System.Data;
using Stimulsoft.Controls;
using Stimulsoft.Base.Drawing;
using Stimulsoft.Report;
using Stimulsoft.Report.Dialogs;
using Stimulsoft.Report.Components;

namespace Reports
{
    
    public class Report : Stimulsoft.Report.StiReport
    {
        
        public Report()
        {
            this.InitializeComponent();
        }
        #region StiReport Designer generated code - do not modify#endregion StiReport Designer generated code - do not modify
    }
}

  CSharp

A sample dataset is: Note the "CreatedOn" and "ModifiedOn" fields are datetime types

Code: Select all

CodesSource_Name, CodesSource_CreatedOn, CodesSource_ModifiedOn, CodesSource_FolderLocation, CodesSource_Id, ReportRecordID
, , , , , 1
Anna, 30/07/2010 15:18:38, 28/10/2007 21:07:07, Internals\Interviews, 6056400f-3dda-46bd-80cc-fe119f12317a, 2
Bernadette, 30/07/2010 15:18:38, 21/08/2007 17:31:16, Internals\Interviews, 0dd90a1f-c165-4352-a9cc-fe119f1e18ce, 3
Child Care, 30/07/2010 15:18:45, 23/08/2007 11:55:50, Internals\Photo Prompts, 3159146c-1e6f-4d71-88cc-fe11a2dd6e18, 4
Community, 30/07/2010 15:18:45, 29/02/2008 20:32:30, Internals\Photo Diaries, bfba85a7-1bcc-46ac-8ccc-fe11a318f123, 5
Cross Cultural Solutions - Dharamasala, 30/07/2010 15:18:41, 21/02/2008 16:22:06, Internals\Interviews, fd30cba0-3511-47d3-b6cc-fe11a0aba2c0, 6
Defining 'volunteer', 30/07/2010 15:18:48, 21/08/2007 17:32:01, Memos, 02abde51-dd3e-4c3e-a8cc-fe11a482c765, 7
Doc1, 30/07/2010 15:18:33, 02/09/2010 10:49:34, Internals, c8e00287-c595-462f-99cc-fe119bc9e006, 8
Doc2, 30/07/2010 15:18:33, 08/07/2010 12:05:17, Internals, b4537b30-3096-4d27-bacc-fe119be67154, 9
Doctor Abroad, 30/07/2010 15:18:45, 23/08/2007 11:56:01, Internals\Photo Prompts, ca9cf290-abeb-4077-89cc-fe11a2e49211, 10
Double standards, 30/07/2010 15:18:32, 21/08/2007 17:32:03, Memos, eb1fbc76-0374-449b-abcc-fe119b84d724, 11
Fredric, 30/07/2010 15:18:39, 21/08/2007 17:31:19, Internals\Interviews, e4b8b905-9a4f-4654-abcc-fe119f253cd6, 12
Grace, 30/07/2010 15:18:39, 21/08/2007 17:31:22, Internals\Interviews, 9f9d6b1f-313b-4084-9dcc-fe119f2ec125, 13
Ken, 30/07/2010 15:18:39, 21/08/2007 17:31:25, Internals\Interviews, 83fbf9ab-cc70-48fc-becc-fe119f442e64, 14
Listening to the Kids, 30/07/2010 15:18:45, 29/02/2008 20:32:34, Internals\Photo Diaries, cfa28ebf-915c-4837-98cc-fe11a324d809, 15
Mary, 30/07/2010 15:18:39, 21/08/2007 17:31:28, Internals\Interviews, afb2ee46-02a2-468d-87cc-fe119f50158e, 16
Nick, 30/07/2010 15:18:39, 21/08/2007 17:31:31, Internals\Interviews, 3cb56cc9-8293-4cfd-97cc-fe119f5bfcce, 17
Non Volunteers, 30/07/2010 15:18:33, 27/10/2007 22:14:25, Internals\Focus Groups, d59282e6-fe57-40e7-98cc-fe119bfbdeea, 18
Non Volunteers - Notes, 30/07/2010 15:18:33, 21/08/2007 17:31:56, Memos, f9ac0c72-71e1-43ed-96cc-fe119c0563e0, 19
Peter, 30/07/2010 15:18:39, 27/10/2007 16:05:58, Internals\Interviews, 45e167be-58fe-46ce-bacc-fe119facec12, 20
Phoebe, 30/07/2010 15:18:39, 21/08/2007 17:31:34, Internals\Interviews, 405b7c83-f0f0-40f0-aecc-fe119f632048, 21
Playing, 30/07/2010 15:18:45, 29/02/2008 20:32:42, Internals\Photo Diaries, 898dc66a-5516-4a3c-8dcc-fe11a330bf0b, 22
Preparing for a match, 30/07/2010 15:18:45, 29/02/2008 20:32:49, Internals\Photo Diaries, 65781b56-a143-4ff1-b4cc-fe11a33ca748, 23
Project Journal, 30/07/2010 15:18:44, 23/06/2008 14:44:34, Internals\Project Notes, b9f581b3-f78b-4a30-b4cc-fe11a250fbe4, 24
Sunil, 30/07/2010 15:18:38, 21/08/2007 17:31:10, Internals\Interviews, 68d10fb6-e1a4-4bd3-b1cc-fe119eff25f3, 25
Teamwork, 30/07/2010 15:18:45, 17/04/2008 12:56:12, Internals\Photo Diaries, 261f65fa-4aae-4b4a-b5cc-fe11a352135f, 26
Video - Non Volunteers, 30/07/2010 15:18:33, 19/02/2008 08:09:28, Internals\Focus Groups, 3aca0d0a-ddab-4ec8-9fcc-fe119c72e446, 27
Volunteers - Clean Up, 30/07/2010 15:18:45, 29/02/2008 20:33:07, Internals\Photo Prompts, cff8a8cb-f157-475e-81cc-fe11a2fc61db, 28
Volunteers Group 1, 30/07/2010 15:18:33, 21/08/2007 17:31:08, Internals\Focus Groups, 8915c966-9a15-4418-bbcc-fe119c114a20, 29
Volunteers Group 2, 30/07/2010 15:18:33, 22/08/2007 21:47:34, Internals\Focus Groups, d4e178ca-8449-45db-a7cc-fe119beff7c4, 30
Wesley Mission - Definitions of 'Volunteering', 30/07/2010 15:18:46, 21/08/2007 17:31:53, Externals, 28b641c8-eed1-4c61-b1cc-fe11a3782a40, 31
Youth Worker, 30/07/2010 15:18:45, 23/08/2007 11:51:28, Internals\Photo Prompts, e0ced84e-c94e-4bd0-9fcc-fe11a2d64a13, 32

Post by **Alex K.** » Mon Sep 13, 2010 3:23 am

Hello,

You can use following expression:

Code: Select all

{CountDistinct(Source["CodesSource_CreatedOn"])}

Thank you.

dcleyne · Post by **dcleyne** » Mon Sep 13, 2010 6:50 pm

Thanks Aleksey!

:biggrin:

Post by **Alex K.** » Tue Sep 14, 2010 12:28 am

Hello,

We are always glad to help you!
Let us know if you need any additional help.

Thank you.