>Hi,
>
>using MM.NET 2.6, C#, ASP.NET, SSRS
>
>I have a Policy Business Object which has a method to calculate the Date the policy has been paid up to (this is done by totalling the number of premium payments that have been received). I need to display this date (as well as another calculated date: the date the next premium is/was due) on a report in SSRS.
>
>How should I approach this? Add Paid To Date and Next Premium Due date fields onto the Policy table? I don't like this way because of the possibility of things getting out of sync, but if there's no other way...

There are a few possibilities.

1. Create a view (or SP or table-valued inline function) that will get your dates.

2. If these dates are used very often, add computed columns to your table.