>>>>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...
>>>
>>>Naomi's suggestions are good. You can also add a method to your business object and use ExecSProcScalar or one of the other scalar functions to return a calculated date value.
>>
>>Thanks Linda,
>>
>>see my reply to Naomi, please
>Frank,
>I think you will find it easier to debug if you put your computed column in a view or stored procedure. You can start with a view, let the view builder generate the code and then put that code in a stored procedure.
>Linda
Thanks Linda,
I've got it working this way already, but if I get a chance I'll try out your suggested method.