Why does modifying a Query causes all fields in the dataset to disappear in the Report Data pane
We routinely import reports from Microsoft CRM and amend them in Visual Studio 2008 eg to add column totals, change layouts etc
If the report needs more fields from CRM, I amend the SQL query in the CRM Dataset, adding the new field references (rather than recreate the report in CRM with new fields, import into VS2008 and redo all the formatting etc).
This worked fine until this week.
Whenever I modify the SQL query in the CRM Dataset, all the fields in the Dataset disappear in the Report Data pane.
Even changing a character in a field name which isn't used in the report - which should have absolutely no impact on the report - causes the fields to disappear.
As far as I'm aware, nothing has changed on our systems.
We use SQL 2008 reporting services and Microsoft Visual Studio 2008.
Any suggestions greatly appreciated!
October 22nd, 2010 5:14pm
Hi,
Please execute the modified query individually to make sure it is ok. If possible, post the query before and after modifying here so that we could look into it.
thanks,
Jerry
Free Windows Admin Tool Kit Click here and download it now
October 28th, 2010 10:32pm