<div>
I tired the other solutions but they did not provide what I needed
</div>


I tired the other solutions but they did not provide what I needed

<div>
<div class="content wysiwyg-content">
I have a database table for my general ledger.<br />
<br />
I want to create a report that will have a group for every day of the year and have a running total of my general ledger every day. &nbsp;<br />
<br />
The general ledger detail has a DataTime Field. &nbsp;<br />
<br />
Some days of the year there are no general ledger transaction but I still want a running total for every day, even if there is no detail.<br />
<br />
I want to see this:<br />
Date &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Ledger Account &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Running Total<br />
03/01/2017 &nbsp; &nbsp; Sales &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 10<br />
03/01/2017 &nbsp; &nbsp; COGS &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;-10<br />
<br />
How can I create a group for every day of the year? How can I do this?
</div>
</div>


I have a database table for my general ledger.

I want to create a report that will have a group for every day of the year and have a running total of my general ledger every day.  

The general ledger detail has a DataTime Field.  

Some days of the year there are no general ledger transaction but I still want a running total for every day, even if there is no detail.

I want to see this:
Date                 Ledger Account                            Running Total
03/01/2017     Sales                                               10
03/01/2017     COGS                                              -10

How can I create a group for every day of the year? How can I do this?

Create a group for Every Day of the Year

Crystal Reports is a business intelligence application from SAP SE. It is used to graphically design data connections and report layouts from a wide range of data sources including Excel spreadsheets, Oracle, SQL Server databases and Access databases, BusinessObjects Enterprise business views, and local file-system information. Report designers can place fields from these sources on the report design surface, and can also deploy them in custom formulas (using either BASIC or Crystal's own syntax), which are then placed on the design surface. Crystal Reports also supports subreports, graphing, and a limited amount of GIS functionality.