Compare Subreport datetime value with main...

[CR85user]

Afternoon folks,

I have been scratching my head about this one for a couple of days now and hope one of you can save me from insanity

Usual stuff to start with:

I am using CR 8.5
odbc database

I have two reports with similar problem on each.

Report 1) returning the same fields datetime value in the main report and a datetime value from a subreport based on a different selection criteria.

Both are displayed in the detail section of the report - I wish to compare the two datetime values and show the difference in time between the two in a way that I can then summarise those values to show the percentile within a certain range.

I assume I need to use a shared datetime var and then a running total based on output to do this, but am unsure how to proceed.

------------------------------------------------------------

Report 2) I have a second report with two subreports built in this time, both displaying in the detail section.

I wish to compare the datetime value of the output on this report so that results are only shown where one date is more recent than the other.


I hope the above makes sense and I apologise for putting two queries in one - But as both are likely to be variations on the shared datetime and subreport theme I figured it made sense to ask them at the same time.

Please let me know if any other iformation is required.

My thanks in advance

 

[CR85user]

Sorry typo above - meant to read, sql database - over odbc

 

[CR85user]

UPDATE - Managed to rectify Report 1 by setting up the table reported on to supply neccesary data.

Report 2 - Still having probs comparing datetime value to find greater value of two subreports placed in main report detail section.