Thursday, March 8, 2012

Can I use the rdls created in Visual Studio in Report builder

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