I am trying to add a column to the Sales Pipeline Detail report. I have successfully downloaded it and opened it in Visual Studio. I have the correct connection string but as soon as I refresh the DsPipeDetails dataset, Visual Studio no longer sees all of the fields.  This happens even before I make any change to the sql script to add the new column.

I assume it has something to do with the hidden parameters that Visual Studio can not access, (ie @CRM_FilteredOpportunity), so I tried to ignore the problem and made the changes to the dataset, saved it and tried to upload it to CRM (4.0) but it keeps bombing out.

 Any help would be GREATLY appreciated. Thanks!