But presumably you can change the code which builds the dataset on the fly.
Base your reportsource on a datatable.
Use sql to alias the field names if they can change.
Build your string up on the fly.
something like:
Select
variablefieldname1 as v1,
variablefieldname2 as v2
from whatevertable
Your report sees variables v1 and v2.
You can specify the datatable name in design or change the property using the code I posted a couple of days ago.
Your report must end up being presented a datasource with the same datatable name and same field names and types as the dataset you build against.
You can generate the dataset using the usual dataset designer in vs2005 or build a view even. Either way you do of course need a database at design time.
BTW
I say datatable rather than dataset because they use less resource.
Edited by andyoneill - 18 Jun 2007 at 4:25am
IP Logged