ReportBuilder 11 and later include what is known as Group Search support or Having clause support in DADE. In order to understand how this feature can be used, we must first discuss what exactly the Having clause is. The Having clause is very similar to the Where clause in a SQL statement in that it  Full Article…

TECH TIP: Date Format When DADE Search Criteria Values Are Saved in a Template Question: I create a dataview with a criteria value as a date. Why does the template not save the date value as my local regional settings for date format? Answer:   DADE saves the TdaCriteria value as a string in the report template.  Full Article…

DADE handles date formatting in two phases: User entry This occurs when the user specifies a date using the Query tools or the AutoSearch dialog. DADE converts the date string entered by the user into a Delphi TDateTime value. The string entered by the user is converted using Delphi’s StrToDateTime. By default Delphi’s StrToDateTime relies  Full Article…