I have a reportviewer whose sqldatasource is built before it is made visible using options and entries set by the user; the table in the rdlc has no sorting or grouping set. before the report is made viewable, the user has the option of selecting up to 4 'order by' options using dropdownlists else a default 'order by' is used. without using any 'order by' selections in the drop downs, the report runs as expected using the default 'order by' and any combination of the options given (include a specific field, include a specific project in the data scope, get the data scope by project manager or by region). the moment i try to set an 'order by' clause that does not match the default, using the values selected in the dropdownlists, i get the following error:
An unexpected error occurred in Report Processing.
Object reference not set to an instan ...
Go to the complete details ...