<div>
<div class="content wysiwyg-content">
Hi,<br />
<br />
i have a report where i need to show values based on dates. its a monthly report so report should show dates even when there is no transaction but that date is not coming from database, for example, there are records from 14 June but no records for june 15, so database doesn't give u june 15 and gives u june 16. Now this can happen multiple times within a month.<br />
<br />
so i was hoping if anyone can tell me how to display dates even when there is no records coming out from the database for that particular date and should be able to display multiple times. i would really appreciate any help.<br />
<br />
thanks
</div>
</div>


Hi,

i have a report where i need to show values based on dates. its a monthly report so report should show dates even when there is no transaction but that date is not coming from database, for example, there are records from 14 June but no records for june 15, so database doesn't give u june 15 and gives u june 16. Now this can happen multiple times within a month.

so i was hoping if anyone can tell me how to display dates even when there is no records coming out from the database for that particular date and should be able to display multiple times. i would really appreciate any help.

thanks

Crystal REport Date issue

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.