Print recent date in Cross - tab date column

[visit2me]

Hi all,
My PM wants a cross - tab report that has muitiple dates in a date column to print only recent date instead of multiple dates. I know the cross tab is very picky and I am wondering if someone knows how to get this to work or even it is doable.

Thanks in advance,

 

[lbass]

This isn't at all clear. What IS the recent date? Why would you need a crosstab if you will only be referencing one date in the column?

I think you should identify exactly how the crosstab is set up in the crosstab expert: row fields, column fields, summaries.

-LB

 

[visit2me]

Thank you Ibass for your quick respond,
I also realized after posting that I wasn't clear enough explaining my issue.
When i meant recent date, I meant the latest date in date row. I have customer, Sales order number and sheduled to ship date 3 rows and available to ship date on column and summarizing on quantity.

I have multiple scheduled to ship and I need to display only latest date. Is this doable knowing the fact that cross tab has limited functionality.

Any help will be appreciated..

 

[lbass]

Try creating a SQL expression that returns only the most recent date, something like this:

(
select max(`date`)
from table A
where A.`Customer` = table.`Customer` and
A.`Sales_Order_Number` = table.`Sales_Order_Number`
)

Replace "table" with your table name. This assumes the fields are all in one table--if not, please identify fields and tables they are from using {table.field} format. Also indicate how tables are linked if there are more than one. Identify both your CR version and the type of database you are using.

-LB

 

[crystalkiwibruce]

You can use any summary operation or summary field in a crosstab, so put the date field in the details of the crosstab and set the summary to Maximum.

Bruce Ferguson

http://www.crystalkiwi.com/nlog.htm