| Groups | Blog | Home |
sql server reporting services : VS crashes when changing new MDX-report
the report and then close the project and reopen it (save/save all doesn't appear to save the changes?), we can preview the report without a problem. [quoted text, click to view] "Ralph Watermann" wrote:
> Hi, > > we created a little report against the Analysis Services Tutorial cube an > the preview works fine. We save the project. Then change something, for > example the title in the layout, an click preview again -> "Microsoft Visual > Studio has encountered a problem and needs to close". > > Re-open the project again, changing the title in the layout again, but now > close the .rdl window -> "object reference not set to an instance of an > object". > > This occured so far only with reports created with the 2005 report designer. > If we open our "old" reports from some 2005 CTP there is no problem with > little changes so far. But datasets disappear, if we click the Dataset tab > as stated in an earlier newsgroup article. > > Are there major problems with MDX-Queries in VS/Report Designer 2005? > > Regards, > Ralph > >
If we add a new report using the wizard (right click on reports and select
'Add New Report') we have the same issue. If we add a new item and select report, we can modify and review report without a problem. [quoted text, click to view] "GaryV" wrote:
> We are having similar issues when connecting to SSAS. If we make changes to > the report and then close the project and reopen it (save/save all doesn't > appear to save the changes?), we can preview the report without a problem. > > > "Ralph Watermann" wrote: > > > Hi, > > > > we created a little report against the Analysis Services Tutorial cube an > > the preview works fine. We save the project. Then change something, for > > example the title in the layout, an click preview again -> "Microsoft Visual > > Studio has encountered a problem and needs to close". > > > > Re-open the project again, changing the title in the layout again, but now > > close the .rdl window -> "object reference not set to an instance of an > > object". > > > > This occured so far only with reports created with the 2005 report designer. > > If we open our "old" reports from some 2005 CTP there is no problem with > > little changes so far. But datasets disappear, if we click the Dataset tab > > as stated in an earlier newsgroup article. > > > > Are there major problems with MDX-Queries in VS/Report Designer 2005? > > > > Regards, > > Ralph > > > >
Hi,
we created a little report against the Analysis Services Tutorial cube an the preview works fine. We save the project. Then change something, for example the title in the layout, an click preview again -> "Microsoft Visual Studio has encountered a problem and needs to close". Re-open the project again, changing the title in the layout again, but now close the .rdl window -> "object reference not set to an instance of an object". This occured so far only with reports created with the 2005 report designer. If we open our "old" reports from some 2005 CTP there is no problem with little changes so far. But datasets disappear, if we click the Dataset tab as stated in an earlier newsgroup article. Are there major problems with MDX-Queries in VS/Report Designer 2005? Regards, Ralph
I had the same issue, regardless of using the wizard to add a new report or
not. When I first added/created the report, I could design the query in the MDX Query Builder. Once I switched views to Layout or Preview, tabbing back to Data would open an EMPTY Query Builder, overwrite my existing query, and then VS would crash. Also, there is really no way to just directly enter the query and continue editing it in the MDX editor without going through the Query Builder (why??). I have been able to avoid the problem after reprocessing the cube and closing all connections except the report project. However, I am not holding my breath because the release is obviously much less stable than the last CTP. [quoted text, click to view] "GaryV" wrote:
> If we add a new report using the wizard (right click on reports and select > 'Add New Report') we have the same issue. If we add a new item and select > report, we can modify and review report without a problem. > > > "GaryV" wrote: > > > We are having similar issues when connecting to SSAS. If we make changes to > > the report and then close the project and reopen it (save/save all doesn't > > appear to save the changes?), we can preview the report without a problem. > > > > > > "Ralph Watermann" wrote: > > > > > Hi, > > > > > > we created a little report against the Analysis Services Tutorial cube an > > > the preview works fine. We save the project. Then change something, for > > > example the title in the layout, an click preview again -> "Microsoft Visual > > > Studio has encountered a problem and needs to close". > > > > > > Re-open the project again, changing the title in the layout again, but now > > > close the .rdl window -> "object reference not set to an instance of an > > > object". > > > > > > This occured so far only with reports created with the 2005 report designer. > > > If we open our "old" reports from some 2005 CTP there is no problem with > > > little changes so far. But datasets disappear, if we click the Dataset tab > > > as stated in an earlier newsgroup article. > > > > > > Are there major problems with MDX-Queries in VS/Report Designer 2005? > > > > > > Regards, > > > Ralph > > > > > >
WORKAROUND: If you have created your report using the Report Wizard to start
the MDX Query Builder, open the .rdl file as XML. Find the section starting with <rd:MdxQuery> and ending with </rd:MdxQuery> and delete all spaces and newlines between elements (between closing > and opening <) so the whole complex element is inline. You will be able to continue working with the report normally. 1) The problem arises when you use the Report Wizard (as GaryV indicated before me) 2) If you compare the XML generated by the Query Builder when using the Report Wizard and Add existing item... you will see a) the complex element <rd:MdxQuery> from the Wizard path is nicely formatted with spaces and newlines while b) the Query Builder used directly puts the whole long <rd:MdxQuery></rd:MdxQuery> "subdocument" inline c) the proof is in the pudding - if you delete the formatting characters (I ssupect the inlines are key) you can tab to Data and edit the dataset w/o problems [quoted text, click to view] "PeterG" wrote:
> I had the same issue, regardless of using the wizard to add a new report or > not. When I first added/created the report, I could design the query in the > MDX Query Builder. Once I switched views to Layout or Preview, tabbing back > to Data would open an EMPTY Query Builder, overwrite my existing query, and > then VS would crash. > > Also, there is really no way to just directly enter the query and continue > editing it in the MDX editor without going through the Query Builder (why??). > > I have been able to avoid the problem after reprocessing the cube and > closing all connections except the report project. However, I am not holding > my breath because the release is obviously much less stable than the last CTP. > > > "GaryV" wrote: > > > If we add a new report using the wizard (right click on reports and select > > 'Add New Report') we have the same issue. If we add a new item and select > > report, we can modify and review report without a problem. > > > > > > "GaryV" wrote: > > > > > We are having similar issues when connecting to SSAS. If we make changes to > > > the report and then close the project and reopen it (save/save all doesn't > > > appear to save the changes?), we can preview the report without a problem. > > > > > > > > > "Ralph Watermann" wrote: > > > > > > > Hi, > > > > > > > > we created a little report against the Analysis Services Tutorial cube an > > > > the preview works fine. We save the project. Then change something, for > > > > example the title in the layout, an click preview again -> "Microsoft Visual > > > > Studio has encountered a problem and needs to close". > > > > > > > > Re-open the project again, changing the title in the layout again, but now > > > > close the .rdl window -> "object reference not set to an instance of an > > > > object". > > > > > > > > This occured so far only with reports created with the 2005 report designer. > > > > If we open our "old" reports from some 2005 CTP there is no problem with > > > > little changes so far. But datasets disappear, if we click the Dataset tab > > > > as stated in an earlier newsgroup article. > > > > > > > > Are there major problems with MDX-Queries in VS/Report Designer 2005? > > > > > > > > Regards, > > > > Ralph > > > > > > > >
Hi,
We have the same problem and got this workaround from MS: To work around this issue, you have to carefully remove all white spaces and line breaks of the report between the <rd:MdxQuery> and the <QueryDefinition <OtherProperties>> XMLtags. To do this, follow these steps: 1. On the "View" menu, click "Code" to switch to the "Code View". 2. Modify the RDL in the editor to remove the white spaces and line breaks. 3. Save the file and then return to "Data View". After you remove the intervening white spaces and line breaks, the line in question should look similar to this: <rd:MdxQuery><QueryDefinition<OtherProperties>> This is from a draft version of KB-article 909535. Regards, Steen [quoted text, click to view] "GaryV" wrote:
> We are having similar issues when connecting to SSAS. If we make changes to > the report and then close the project and reopen it (save/save all doesn't > appear to save the changes?), we can preview the report without a problem. > > > "Ralph Watermann" wrote: > > > Hi, > > > > we created a little report against the Analysis Services Tutorial cube an > > the preview works fine. We save the project. Then change something, for > > example the title in the layout, an click preview again -> "Microsoft Visual > > Studio has encountered a problem and needs to close". > > > > Re-open the project again, changing the title in the layout again, but now > > close the .rdl window -> "object reference not set to an instance of an > > object". > > > > This occured so far only with reports created with the 2005 report designer. > > If we open our "old" reports from some 2005 CTP there is no problem with > > little changes so far. But datasets disappear, if we click the Dataset tab > > as stated in an earlier newsgroup article. > > > > Are there major problems with MDX-Queries in VS/Report Designer 2005? > > > > Regards, > > Ralph > > > >
Don't see what you're looking for? Try a search.
|
June 2004
July 2004
August 2004
September 2004
October 2004
November 2004
December 2004
January 2005
February 2005
March 2005
April 2005
May 2005
June 2005
July 2005
August 2005
September 2005
October 2005
November 2005
December 2005
January 2006
February 2006
March 2006
April 2006
May 2006
June 2006
July 2006
August 2006
September 2006
October 2006
November 2006
December 2006
January 2007
February 2007
March 2007
April 2007
May 2007
June 2007
July 2007
August 2007
September 2007
October 2007
November 2007
| home · blog · groups | Questions? Comments? Contact the dn |