set datamember during runtime

Hi guys,

i've been searching other threads but i could not find any answers
about setting the datamember of a data report during runtime.

I have a data report for displaying search results for names. Search results are filtered by firstname, lastname, middle name or any combination of the 3

Instead of creating separate reports. is it possible to just to change the datamember of the data report during runtime

Any comments,suggestion is highly appreciated

TIA

If you mean a way to dealing with same data, but presented in a different way (sorted differently, only that) but keeping the same settings for the report, you might consider to populate your recordset outside of the report and after that assigning the recordset as the DataSource for the report ...


Is this what you have in mind?

hi D12Bit,

thanks for replying, it is not sorted and has different data results depending on the filter options selected by the user

for example the user selected to filter by lastname and firstname
and wants to print it. the data report will be shown with the results.

but if the user selected to filter by lastname only. The same data report will be shown with the results but different datamember

hope that helps you give the idea of the scenario

thanks again