<div>
I think you will have to select the data you want through SQL.<br />
<br />
I can't think of &nbsp;a way to get it through the cross tab.<br />
<br />
mlmcc
</div>


I think you will have to select the data you want through SQL.

I can't think of  a way to get it through the cross tab.

mlmcc

<div>
<div class="content wysiwyg-content">
Hello Guys,<br />
I have an issue with the cross tab.<br />
My Data in the DB looks like<br />
<br />
&nbsp; &nbsp; &nbsp; &nbsp;Test &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; result &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; collection_date<br />
&nbsp; &nbsp; &nbsp; &nbsp; test1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 3.5 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 01-03-2011<br />
&nbsp; &nbsp; &nbsp; &nbsp; test1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1.1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 01-14-2011<br />
&nbsp; &nbsp; &nbsp; &nbsp; test2 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;8.0 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 05-08-2011<br />
&nbsp; &nbsp; &nbsp; &nbsp; test2 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;11.9 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;05-13-2011<br />
I am building the cross tab As<br />
&nbsp;Rows=test<br />
&nbsp;Column=Collection_date<br />
data in the crosstab=Result<br />
so my question is- i only need the last value for each month to be printed in the report which is cross tab, How can i make this?
</div>
</div>


Hello Guys,
I have an issue with the cross tab.
My Data in the DB looks like

       Test                           result                     collection_date
        test1                             3.5                         01-03-2011
        test1                            1.1                           01-14-2011
        test2                              8.0                         05-08-2011
        test2                              11.9                        05-13-2011
I am building the cross tab As
 Rows=test
 Column=Collection_date
data in the crosstab=Result
so my question is- i only need the last value for each month to be printed in the report which is cross tab, How can i make this?

getting latest date data in the crystal report cross tab

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.