Linking two subreports

[cristle]

Hi,

I'm trying to identify data that has changed bewteen two dates.

I have one Table showing current data and a second table containing data stored at a particular point in time.

I want to report on only the data that has changed since say

1st April (stored in the back-up table)

I'm trying to use Sub-Reports in Crystal Reports XIR2 to achieve this.

Any suggestions are appreciated.

 

[IanWaterman]

Why use subreports, you can use a standard report and join the tables together on relevant field and then report on data only where table1.nonjoinfield1 <> table2.nonjoinfield1

The latter condition is added to the select expert.

Ian

 

[cristle]

Ian,

I did try that but in a different way.
I created a formula to test for the difference and used the formula in the select expert.
I got some strange results, so I opted for a Sub-Report.

i think that it may be a data problem.

Thanks for your suggestion.