Hi,

I have made a report whereby two tables are connected via their primary key. I wanted to show records where the primary key was equal to 6000030 for example.

I went into the record selection formula area and entered: {transaction.t_id} = '6000030'.

When I preview the report, it works perfectly, however if I load the exact same report through .Net (c#), it's as though the report ignores the selection formula and just goes ahead and shows all records.

I have tried entering the selection formula in the selection formula area, by linking it to a formula field, and also be entering it in code manually (dt.DataDefinition.RecordSelectionFormula = "{transactionlist.t_id} = '6000030'";. None of these are working and the report still shows all records.

I have made sure saving of data is turned off also. Does anyone have any ideas why this would be happening? (this is about my 50th report for this project, but the first where I have tried to use record selection. I use group selection in others and that works fine). Is this a bug in crystal??

C

I rebuilt the app several times, and changed other things in the report to make sure it was running with the correct version. The only thing I can pin it down to, is that when c# loads the report, it is ignoring the recordselectionformula.

Any ideas?