I have inherited a report which has been bound at design time using the front end tools/wizards.
A datasource has been bound to a control but there is another control on the report which wants to use a subset of that datasource. Basically it needs to get the number of records where the addedDate field is within the last 6 months.
I thought I would be able to copy the datasource into a datatable and loop through them chacking the date manually but it wont let me cast the datasource as a datatable.
Any ideas how to work around this?
A datasource has been bound to a control but there is another control on the report which wants to use a subset of that datasource. Basically it needs to get the number of records where the addedDate field is within the last 6 months.
I thought I would be able to copy the datasource into a datatable and loop through them chacking the date manually but it wont let me cast the datasource as a datatable.
Any ideas how to work around this?