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

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

can I use report builder with SS2000 and RS2000

We're using SS2000 SP4, RS2000, VS2003.NET.
As I understand it, report builder will be installed when I install SS2005.
Would it be possible to use report builder from SS2005 with RS2000 and SS2000
or will I need to use SS2005 and RS2005?
Thanks,
--
Dan D.Report Builder requires RS 2005. RS 2005 can use either SQL Server 2000 or
2005 as its object/metadata store. Whether the database stays at 2000 or not
does not change licensing. Any box with RS 2005 requires a SQL Server 2005
license.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Dan D." <DanD@.discussions.microsoft.com> wrote in message
news:FE8E3692-DE9F-48CF-9EA2-125B576EFFD4@.microsoft.com...
> We're using SS2000 SP4, RS2000, VS2003.NET.
> As I understand it, report builder will be installed when I install
> SS2005.
> Would it be possible to use report builder from SS2005 with RS2000 and
> SS2000
> or will I need to use SS2005 and RS2005?
> Thanks,
> --
> Dan D.|||We already have some reports designed in VS2003 in SS2000 using RS2000. If I
install RS2005 to the same SS2000 server will it overwrite what is now in the
ReportServer and ReportServerTempDB databases? I don't know much about RS yet
but the developer used rds files instead of storing that information in the
db. I don't know how much difference that will make.
Thanks,
--
Dan D.
"Bruce L-C [MVP]" wrote:
> Report Builder requires RS 2005. RS 2005 can use either SQL Server 2000 or
> 2005 as its object/metadata store. Whether the database stays at 2000 or not
> does not change licensing. Any box with RS 2005 requires a SQL Server 2005
> license.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Dan D." <DanD@.discussions.microsoft.com> wrote in message
> news:FE8E3692-DE9F-48CF-9EA2-125B576EFFD4@.microsoft.com...
> > We're using SS2000 SP4, RS2000, VS2003.NET.
> >
> > As I understand it, report builder will be installed when I install
> > SS2005.
> > Would it be possible to use report builder from SS2005 with RS2000 and
> > SS2000
> > or will I need to use SS2005 and RS2005?
> >
> > Thanks,
> > --
> > Dan D.
>
>|||Is report builder part of SS2005 or RS2005?
--
Dan D.
"Bruce L-C [MVP]" wrote:
> Report Builder requires RS 2005. RS 2005 can use either SQL Server 2000 or
> 2005 as its object/metadata store. Whether the database stays at 2000 or not
> does not change licensing. Any box with RS 2005 requires a SQL Server 2005
> license.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Dan D." <DanD@.discussions.microsoft.com> wrote in message
> news:FE8E3692-DE9F-48CF-9EA2-125B576EFFD4@.microsoft.com...
> > We're using SS2000 SP4, RS2000, VS2003.NET.
> >
> > As I understand it, report builder will be installed when I install
> > SS2005.
> > Would it be possible to use report builder from SS2005 with RS2000 and
> > SS2000
> > or will I need to use SS2005 and RS2005?
> >
> > Thanks,
> > --
> > Dan D.
>
>|||Report Builder is part of RS 2005 which is part of SQL 2005.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Dan D." <DanD@.discussions.microsoft.com> wrote in message
news:227A9350-BE33-4CAC-A65C-AA30CEE8FA27@.microsoft.com...
> Is report builder part of SS2005 or RS2005?
> --
> Dan D.
>
> "Bruce L-C [MVP]" wrote:
>> Report Builder requires RS 2005. RS 2005 can use either SQL Server 2000
>> or
>> 2005 as its object/metadata store. Whether the database stays at 2000 or
>> not
>> does not change licensing. Any box with RS 2005 requires a SQL Server
>> 2005
>> license.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "Dan D." <DanD@.discussions.microsoft.com> wrote in message
>> news:FE8E3692-DE9F-48CF-9EA2-125B576EFFD4@.microsoft.com...
>> > We're using SS2000 SP4, RS2000, VS2003.NET.
>> >
>> > As I understand it, report builder will be installed when I install
>> > SS2005.
>> > Would it be possible to use report builder from SS2005 with RS2000 and
>> > SS2000
>> > or will I need to use SS2005 and RS2005?
>> >
>> > Thanks,
>> > --
>> > Dan D.
>>|||RDS files always exist. They are what is used in the development
environment. When deployed RS stores them in the database. No rds files are
found on the server.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Dan D." <DanD@.discussions.microsoft.com> wrote in message
news:FEED4410-60AF-43DB-9DA2-1F8E212B7CD2@.microsoft.com...
> We already have some reports designed in VS2003 in SS2000 using RS2000. If
> I
> install RS2005 to the same SS2000 server will it overwrite what is now in
> the
> ReportServer and ReportServerTempDB databases? I don't know much about RS
> yet
> but the developer used rds files instead of storing that information in
> the
> db. I don't know how much difference that will make.
> Thanks,
> --
> Dan D.
>
> "Bruce L-C [MVP]" wrote:
>> Report Builder requires RS 2005. RS 2005 can use either SQL Server 2000
>> or
>> 2005 as its object/metadata store. Whether the database stays at 2000 or
>> not
>> does not change licensing. Any box with RS 2005 requires a SQL Server
>> 2005
>> license.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "Dan D." <DanD@.discussions.microsoft.com> wrote in message
>> news:FE8E3692-DE9F-48CF-9EA2-125B576EFFD4@.microsoft.com...
>> > We're using SS2000 SP4, RS2000, VS2003.NET.
>> >
>> > As I understand it, report builder will be installed when I install
>> > SS2005.
>> > Would it be possible to use report builder from SS2005 with RS2000 and
>> > SS2000
>> > or will I need to use SS2005 and RS2005?
>> >
>> > Thanks,
>> > --
>> > Dan D.
>>|||Sorry. What I meant was if the developer didn't use rds files for a report,
but he stored the info in the database, will it get overwritten when I
install RS2005?
--
Dan D.
"Bruce L-C [MVP]" wrote:
> RDS files always exist. They are what is used in the development
> environment. When deployed RS stores them in the database. No rds files are
> found on the server.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Dan D." <DanD@.discussions.microsoft.com> wrote in message
> news:FEED4410-60AF-43DB-9DA2-1F8E212B7CD2@.microsoft.com...
> > We already have some reports designed in VS2003 in SS2000 using RS2000. If
> > I
> > install RS2005 to the same SS2000 server will it overwrite what is now in
> > the
> > ReportServer and ReportServerTempDB databases? I don't know much about RS
> > yet
> > but the developer used rds files instead of storing that information in
> > the
> > db. I don't know how much difference that will make.
> >
> > Thanks,
> > --
> > Dan D.
> >
> >
> > "Bruce L-C [MVP]" wrote:
> >
> >> Report Builder requires RS 2005. RS 2005 can use either SQL Server 2000
> >> or
> >> 2005 as its object/metadata store. Whether the database stays at 2000 or
> >> not
> >> does not change licensing. Any box with RS 2005 requires a SQL Server
> >> 2005
> >> license.
> >>
> >>
> >> --
> >> Bruce Loehle-Conger
> >> MVP SQL Server Reporting Services
> >>
> >> "Dan D." <DanD@.discussions.microsoft.com> wrote in message
> >> news:FE8E3692-DE9F-48CF-9EA2-125B576EFFD4@.microsoft.com...
> >> > We're using SS2000 SP4, RS2000, VS2003.NET.
> >> >
> >> > As I understand it, report builder will be installed when I install
> >> > SS2005.
> >> > Would it be possible to use report builder from SS2005 with RS2000 and
> >> > SS2000
> >> > or will I need to use SS2005 and RS2005?
> >> >
> >> > Thanks,
> >> > --
> >> > Dan D.
> >>
> >>
> >>
>
>|||I installed SS2005 Standard but I didn't see reporting services. Is RS2005
only on the Enterprise Edition disk perhaps?
Can I download RS2005 from msdn?
--
Dan D.
"Bruce L-C [MVP]" wrote:
> Report Builder is part of RS 2005 which is part of SQL 2005.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Dan D." <DanD@.discussions.microsoft.com> wrote in message
> news:227A9350-BE33-4CAC-A65C-AA30CEE8FA27@.microsoft.com...
> > Is report builder part of SS2005 or RS2005?
> > --
> > Dan D.
> >
> >
> > "Bruce L-C [MVP]" wrote:
> >
> >> Report Builder requires RS 2005. RS 2005 can use either SQL Server 2000
> >> or
> >> 2005 as its object/metadata store. Whether the database stays at 2000 or
> >> not
> >> does not change licensing. Any box with RS 2005 requires a SQL Server
> >> 2005
> >> license.
> >>
> >>
> >> --
> >> Bruce Loehle-Conger
> >> MVP SQL Server Reporting Services
> >>
> >> "Dan D." <DanD@.discussions.microsoft.com> wrote in message
> >> news:FE8E3692-DE9F-48CF-9EA2-125B576EFFD4@.microsoft.com...
> >> > We're using SS2000 SP4, RS2000, VS2003.NET.
> >> >
> >> > As I understand it, report builder will be installed when I install
> >> > SS2005.
> >> > Would it be possible to use report builder from SS2005 with RS2000 and
> >> > SS2000
> >> > or will I need to use SS2005 and RS2005?
> >> >
> >> > Thanks,
> >> > --
> >> > Dan D.
> >>
> >>
> >>
>
>|||Reporting Services Designer is part of the BI tools and is available with
Standard. I don't know about Report Builder or not. My guess is you did not
install the BI development tools.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Dan D." <DanD@.discussions.microsoft.com> wrote in message
news:DC949A01-F153-496E-A227-B0ECBEEDF452@.microsoft.com...
>I installed SS2005 Standard but I didn't see reporting services. Is RS2005
> only on the Enterprise Edition disk perhaps?
> Can I download RS2005 from msdn?
> --
> Dan D.
>
> "Bruce L-C [MVP]" wrote:
>> Report Builder is part of RS 2005 which is part of SQL 2005.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "Dan D." <DanD@.discussions.microsoft.com> wrote in message
>> news:227A9350-BE33-4CAC-A65C-AA30CEE8FA27@.microsoft.com...
>> > Is report builder part of SS2005 or RS2005?
>> > --
>> > Dan D.
>> >
>> >
>> > "Bruce L-C [MVP]" wrote:
>> >
>> >> Report Builder requires RS 2005. RS 2005 can use either SQL Server
>> >> 2000
>> >> or
>> >> 2005 as its object/metadata store. Whether the database stays at 2000
>> >> or
>> >> not
>> >> does not change licensing. Any box with RS 2005 requires a SQL Server
>> >> 2005
>> >> license.
>> >>
>> >>
>> >> --
>> >> Bruce Loehle-Conger
>> >> MVP SQL Server Reporting Services
>> >>
>> >> "Dan D." <DanD@.discussions.microsoft.com> wrote in message
>> >> news:FE8E3692-DE9F-48CF-9EA2-125B576EFFD4@.microsoft.com...
>> >> > We're using SS2000 SP4, RS2000, VS2003.NET.
>> >> >
>> >> > As I understand it, report builder will be installed when I install
>> >> > SS2005.
>> >> > Would it be possible to use report builder from SS2005 with RS2000
>> >> > and
>> >> > SS2000
>> >> > or will I need to use SS2005 and RS2005?
>> >> >
>> >> > Thanks,
>> >> > --
>> >> > Dan D.
>> >>
>> >>
>> >>
>>|||If he used the report designer that came with RS 2000 then there has to be
RDS files. They are with his project. If not, then I strongly suggest
getting them from the server (go to the properties of the report in report
manager to get the rds file and store it locally).
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Dan D." <DanD@.discussions.microsoft.com> wrote in message
news:2D38B1D3-D1C3-4055-A483-67628A145C00@.microsoft.com...
> Sorry. What I meant was if the developer didn't use rds files for a
> report,
> but he stored the info in the database, will it get overwritten when I
> install RS2005?
> --
> Dan D.
>
> "Bruce L-C [MVP]" wrote:
>> RDS files always exist. They are what is used in the development
>> environment. When deployed RS stores them in the database. No rds files
>> are
>> found on the server.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "Dan D." <DanD@.discussions.microsoft.com> wrote in message
>> news:FEED4410-60AF-43DB-9DA2-1F8E212B7CD2@.microsoft.com...
>> > We already have some reports designed in VS2003 in SS2000 using RS2000.
>> > If
>> > I
>> > install RS2005 to the same SS2000 server will it overwrite what is now
>> > in
>> > the
>> > ReportServer and ReportServerTempDB databases? I don't know much about
>> > RS
>> > yet
>> > but the developer used rds files instead of storing that information in
>> > the
>> > db. I don't know how much difference that will make.
>> >
>> > Thanks,
>> > --
>> > Dan D.
>> >
>> >
>> > "Bruce L-C [MVP]" wrote:
>> >
>> >> Report Builder requires RS 2005. RS 2005 can use either SQL Server
>> >> 2000
>> >> or
>> >> 2005 as its object/metadata store. Whether the database stays at 2000
>> >> or
>> >> not
>> >> does not change licensing. Any box with RS 2005 requires a SQL Server
>> >> 2005
>> >> license.
>> >>
>> >>
>> >> --
>> >> Bruce Loehle-Conger
>> >> MVP SQL Server Reporting Services
>> >>
>> >> "Dan D." <DanD@.discussions.microsoft.com> wrote in message
>> >> news:FE8E3692-DE9F-48CF-9EA2-125B576EFFD4@.microsoft.com...
>> >> > We're using SS2000 SP4, RS2000, VS2003.NET.
>> >> >
>> >> > As I understand it, report builder will be installed when I install
>> >> > SS2005.
>> >> > Would it be possible to use report builder from SS2005 with RS2000
>> >> > and
>> >> > SS2000
>> >> > or will I need to use SS2005 and RS2005?
>> >> >
>> >> > Thanks,
>> >> > --
>> >> > Dan D.
>> >>
>> >>
>> >>
>>|||I see a SS Business Intelligence Studio on the menu. There are no
ReportServices databases when I open management studio. When I open Reporting
Services configuration under configuration tools on the menu it says no
report servers were found. I'll look on the CD again and see if I can install
RS2005.
Thanks,
--
Dan D.
"Bruce L-C [MVP]" wrote:
> Reporting Services Designer is part of the BI tools and is available with
> Standard. I don't know about Report Builder or not. My guess is you did not
> install the BI development tools.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Dan D." <DanD@.discussions.microsoft.com> wrote in message
> news:DC949A01-F153-496E-A227-B0ECBEEDF452@.microsoft.com...
> >I installed SS2005 Standard but I didn't see reporting services. Is RS2005
> > only on the Enterprise Edition disk perhaps?
> >
> > Can I download RS2005 from msdn?
> > --
> > Dan D.
> >
> >
> > "Bruce L-C [MVP]" wrote:
> >
> >> Report Builder is part of RS 2005 which is part of SQL 2005.
> >>
> >>
> >> --
> >> Bruce Loehle-Conger
> >> MVP SQL Server Reporting Services
> >>
> >> "Dan D." <DanD@.discussions.microsoft.com> wrote in message
> >> news:227A9350-BE33-4CAC-A65C-AA30CEE8FA27@.microsoft.com...
> >> > Is report builder part of SS2005 or RS2005?
> >> > --
> >> > Dan D.
> >> >
> >> >
> >> > "Bruce L-C [MVP]" wrote:
> >> >
> >> >> Report Builder requires RS 2005. RS 2005 can use either SQL Server
> >> >> 2000
> >> >> or
> >> >> 2005 as its object/metadata store. Whether the database stays at 2000
> >> >> or
> >> >> not
> >> >> does not change licensing. Any box with RS 2005 requires a SQL Server
> >> >> 2005
> >> >> license.
> >> >>
> >> >>
> >> >> --
> >> >> Bruce Loehle-Conger
> >> >> MVP SQL Server Reporting Services
> >> >>
> >> >> "Dan D." <DanD@.discussions.microsoft.com> wrote in message
> >> >> news:FE8E3692-DE9F-48CF-9EA2-125B576EFFD4@.microsoft.com...
> >> >> > We're using SS2000 SP4, RS2000, VS2003.NET.
> >> >> >
> >> >> > As I understand it, report builder will be installed when I install
> >> >> > SS2005.
> >> >> > Would it be possible to use report builder from SS2005 with RS2000
> >> >> > and
> >> >> > SS2000
> >> >> > or will I need to use SS2005 and RS2005?
> >> >> >
> >> >> > Thanks,
> >> >> > --
> >> >> > Dan D.
> >> >>
> >> >>
> >> >>
> >>
> >>
> >>
>
>