Hi,
I have created a report template in Visual Studio 2005.
To get a consistent look for all batch and ad-hoc reports, I want to provide this template( which has some labels/text fields/todays date in the report header etc) to the users using ad-hoc reporting.
But while opening the rdl file developed using VS 2005 in Report Builder I get an error:
Cannot Open this item
This report cannot be opened using Report Builder
One or more unexpected Report Definition Language (RDL) elements of the following type have been removed: DataSet
Microsoft.ReportingServices.ReportBuilder.ReportModel.Report: System.Web.Services.Protocols.SoapException: The operation you are attempting on item "/Data Sources/Adcenter" is not allowed for this item type. > Microsoft.ReportingServices.Diagnostics.Utilities.WrongItemTypeException: The operation you are attempting on item "/Data Sources/Adcenter" is not allowed for this item type.
at Microsoft.ReportingServices.Library.ModelCatalogItem.ModelStorage.GetModelItemIDAndItemSecurity(ModelCatalogItem model)
at Microsoft.ReportingServices.Library.ModelCatalogItem.ModelStorage.LoadModel(ModelCatalogItem model, Boolean getModelDefinition)
at Microsoft.ReportingServices.Library.ModelCatalogItem.LoadModel(CatalogItemContext modelContext, Nullable`1 requiredOperation, Boolean getModelDefinition)
at Microsoft.ReportingServices.Library.ModelCatalogItem.LoadUserModel(CatalogItemContext modelContext, Nullable`1 requiredOperation, String perspectiveID)
at Microsoft.ReportingServices.Library.GetUserModelAction.PerformActionNow()
at Microsoft.ReportingServices.Library.RSSoapAction.Execute()
at Microsoft.ReportingServices.WebServer.ReportingService2005.GetUserModel(String Model, String Perspective, Byte[]& Definition)
End of inner exception stack trace
at Microsoft.ReportingServices.WebServer.ReportingService2005.GetUserModel(String Model, String Perspective, Byte[]& Definition)
I also tried to work it around by saving a file developed using Report Builder and modifying it using VS 2005.But when I open the modified file in Report Builder ,it throws the error:
Cannot Open this item
This report cannot be opened using Report Builder
Value cannot be null.
Please help me in this.
Thanks in advance,
Heya --
No -- desiging a report in Report Builder which was created/modifed in VS2005 Report Designer is not supported...
Before 2005 released I remember trying to get it to work anyway, and if your Report Designer report was really, really simple, it sometimes did -- again., that was before the product RTM'd...
|||Thanks Russel..
Could you suggest some way I can add images,today's date in a textbox (in the report header) etc in a Report Builder report.The insert option in the Report Builder provides only text boxes,unlike images etc in SQL BI Dev studio 2005.
I tried adding todays date as a calculated field in the report but I have to add it as a column in the table of my tabular report.
Thanks in advance..
|||SP1 will allow you to insert images into reports in Report Builder (yay!) A community tech preview of SP1 was dropped earlier this week. See Brian's blog for more info:
http://blogs.msdn.com/bwelcker/
I've forgotten the current date function you use in R.B. (GetDate()? Now()?) but it should be as easy as adding this function as a forumla in a textbox.
|||I just posted an example of how to do this on my blog:
http://blogs.msdn.com/bobmeyers/archive/2006/03/26/561147.aspx
|||Hi,
I am truying to acheive the same. Please let me know if you found the solution.
Regards,
Prakash
No comments:
Post a Comment