The SQL statements that CRM generates are quite complex – not straight ‘select’ statements.  If you download a report generated by the report wizard to enhance in VS you have to update the Dataset ‘connection string’ – CRM holds ‘Adventure_Works_Cycle_MSCRM’ as the DB.

It is easy enough to change the DSOrganisation and repoint the data source to your actual DB.  However, if you select “DSMAIN” in the selection you get an alert stating that the SQL statements cannot execute and VS deletes all of the Fields associated with the dataset, because it can’t intellisense them from the query (as it is too complex).

The work around is that you then have to hack the SQL to get it to work (or you abandon the report and start again BUT don’t select DSMAIN from the dataset so as to avoid VS trying to execute the SQL query). 

In the Report Wizard if you select a pre-existing view for the filter criteria it corrupts the RDL and will never run.  There is apparently a hotfix in the works for this, but in the meantime construct your own selection criteria.

If you find you are unable to change Column Header properties in a CRM view, or in customisation, unable to actually select the column to change properties - it is an IE feature that is causing your problem.

 

Uninstall the "Internet Security Configuration" from Add Remove Program >> Add Remove Windows Component - afterwards perform an IISRESET.

A tool to assist with the configuration of an Internat facing Deployment has been released.

http://support.microsoft.com/kb/948779

 

There is also a scenarios guide available:

http://www.microsoft.com/downloads/details.aspx?FamilyID=3861e56d-b5ed-4f7f-b2fd-5a53bc71dafc&DisplayLang=en