Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
moonmonkey
Starting Member
4 Posts |
 Posted - 2010-01-21 : 06:38:45
|
I have a report Services Model that I have build using Visual Studio 2005. It has been working fine for months. However, since attempting to add new columns to the model, I have broken a large number of existing reports that people have created using the report builder. Last night, the model was fine.I have been asked to add a column to an entity in my model. To do this, I followed these steps:1 . My model is under source control, so I check out the model files in Visual Studio.2. I edit the data source view. I select the DataTable and choose "Edit Named Query". From here, I am able to select the additional field.3. I then switch to the Report Model, select the entity, and then right click in the attributes column and choose "New Source Field". I specify the Name, Binding, and Data Type properties. I then build & deploy the solution to the Production Enivormnent.What I've noticed is that since doing that, I am unable to produce graphs from the data. I can still retrieve the data from the Enitity in a tabular form, but I can't produce graphs. If I try to make a graph or Matrix, I get this error:Report Execution ErrorThe report might not be valid or the server could not process the data.Semantic query execution failed. Internal SQL Server error.Query execution failed for data set 'dataSet'.An error has occurred during report processing.Naturally, the next step I tried after seeing this error was to undo the checkout of the model, to revert it back to how it was, and then re-deploy that version. Unfortunatly, that doesn't seem to have fixed the problem.Any help you can give me right now would be much appreciated: I am in big trouble !!! |
|
|
|
|
|
|
|
Major Problem with SSRS / Report Builder / Report