Showing posts with label reporting. Show all posts
Showing posts with label reporting. Show all posts

Friday, March 30, 2012

Migrating from Developer Edition to Standard Edition

Hello,
I have Reporting Sevices Developer Edition running on a Windows XP Pro
workstation. I want to migrate it to Reporting Services/SQL Server Standard
Edition on a Windows 2003 server. Can this be done? Since the edition of RS
changes, and the edition of SQL Server changes, and the hardware changes, I
need to know if this is feasible, or if it would be better to redeploy the
reports to the new server. BOL isn't very helpful in this area, and I don't
have time to learn C# to use the RS utility.
Thanks in advance.Given that it is so easy to redeploy and the fact that everything is
changing, my advice is to install new and then redeploy.
Bruce L-C
"Cable Guy" <Cable Guy@.discussions.microsoft.com> wrote in message
news:DCD83C56-B311-45EB-90A6-1A5F45B5A87B@.microsoft.com...
> Hello,
> I have Reporting Sevices Developer Edition running on a Windows XP Pro
> workstation. I want to migrate it to Reporting Services/SQL Server
Standard
> Edition on a Windows 2003 server. Can this be done? Since the edition of
RS
> changes, and the edition of SQL Server changes, and the hardware changes,
I
> need to know if this is feasible, or if it would be better to redeploy the
> reports to the new server. BOL isn't very helpful in this area, and I
don't
> have time to learn C# to use the RS utility.
> Thanks in advance.|||Others would need to jump in for your answer. I can't really help you with
that.
Bruce L-C
"Cable Guy" <CableGuy@.discussions.microsoft.com> wrote in message
news:40C1D674-60C1-49AB-B8B6-5483EE8BDE2F@.microsoft.com...
> Hi Bruce,
> Thanks for the reply. That is what I was initially persuaded to do, but
> redeploying introduces the possibility of something being overlooked, and
> that is what we want to avoid. Is it possible to use the RS utility to do
> what we need it to do (i.e. copy the logical contents of the database to a
> new database/server/edition) and have it work properly? Do you know of
> any
> good documentation on the RS utility?
> "Bruce Loehle-Conger" wrote:
>> Given that it is so easy to redeploy and the fact that everything is
>> changing, my advice is to install new and then redeploy.
>> Bruce L-C
>> "Cable Guy" <Cable Guy@.discussions.microsoft.com> wrote in message
>> news:DCD83C56-B311-45EB-90A6-1A5F45B5A87B@.microsoft.com...
>> > Hello,
>> >
>> > I have Reporting Sevices Developer Edition running on a Windows XP Pro
>> > workstation. I want to migrate it to Reporting Services/SQL Server
>> Standard
>> > Edition on a Windows 2003 server. Can this be done? Since the edition
>> > of
>> RS
>> > changes, and the edition of SQL Server changes, and the hardware
>> > changes,
>> I
>> > need to know if this is feasible, or if it would be better to redeploy
>> > the
>> > reports to the new server. BOL isn't very helpful in this area, and I
>> don't
>> > have time to learn C# to use the RS utility.
>> >
>> > Thanks in advance.
>>|||Hi Bruce,
Thanks for the reply. That is what I was initially persuaded to do, but
redeploying introduces the possibility of something being overlooked, and
that is what we want to avoid. Is it possible to use the RS utility to do
what we need it to do (i.e. copy the logical contents of the database to a
new database/server/edition) and have it work properly? Do you know of any
good documentation on the RS utility?
"Bruce Loehle-Conger" wrote:
> Given that it is so easy to redeploy and the fact that everything is
> changing, my advice is to install new and then redeploy.
> Bruce L-C
> "Cable Guy" <Cable Guy@.discussions.microsoft.com> wrote in message
> news:DCD83C56-B311-45EB-90A6-1A5F45B5A87B@.microsoft.com...
> > Hello,
> >
> > I have Reporting Sevices Developer Edition running on a Windows XP Pro
> > workstation. I want to migrate it to Reporting Services/SQL Server
> Standard
> > Edition on a Windows 2003 server. Can this be done? Since the edition of
> RS
> > changes, and the edition of SQL Server changes, and the hardware changes,
> I
> > need to know if this is feasible, or if it would be better to redeploy the
> > reports to the new server. BOL isn't very helpful in this area, and I
> don't
> > have time to learn C# to use the RS utility.
> >
> > Thanks in advance.
>
>sql

Migrating from Crystal Reports Charts using TopN and "Other" to Reporting Services

I am currently migrating several Crystal Reports that have charts. The chart series is set to use the TopN values in a count, and combine the rest of the series into one series titled "Other". I see how to filter the chart using TopN, however I need to still show the rest of the data grouped as "Other". I think the solution I need is to create a group expression that uses some sort of IIF function to create the "Other" group, but I haven't found a function that I can use to get the results I need. Any ideas?

Scott

I found the answer to my question in another forum.

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1055659&SiteID=1

I used option 1.

Migrating from Crystal Reports Charts using TopN and "Other" to Reporting Services

I am currently migrating several Crystal Reports that have charts. The chart series is set to use the TopN values in a count, and combine the rest of the series into one series titled "Other". I see how to filter the chart using TopN, however I need to still show the rest of the data grouped as "Other". I think the solution I need is to create a group expression that uses some sort of IIF function to create the "Other" group, but I haven't found a function that I can use to get the results I need. Any ideas?

Scott

I found the answer to my question in another forum.

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1055659&SiteID=1

I used option 1.

Migrating From CR 9 to VS Reporting Services

Hi,
I'm not that familiar with VS RS and I have to convert reports from Crystal
Report 9 to VS RS.
Is it possible ? If not, is there any equivalent of the "unbound fields"
from CR9 in VS RS ?
Thanks in Advance.
wadjaHello Wadja,
I apologize for contacting you on an unsolicited basis, but I read a
few of your postings on Google's Crystal Developers users group and
hoped that you'd be willing to help me.
I'm a journalist with Application Development Trends magazine (ADT,
http://www.adtmag.com), and I'm working on a story on reporting tools
from a developer's perspective. As you no doubt know, Crystal has
long been pretty much the only game in town in this respect, as the
former Crystal Decisions seeded the market with this tool (it's shipped
with Visual Studio for more than a decade, for example, and it ships
with a host of other applications and tools, too).
Now, however, developers have a choice of which reporting tool to use
when they need to incorporate reporting functionality into their apps.
Microsoft announced its SQL Server 2000 Reporting Services last year,
and there's even an open source alternative called BIRT (that's short
for BI Reporting Tool). I'd like to take a look at the positives and
negatives of each of these solutions -- Crystal still seems hard to
beat for straight-up reporting, but both Reporting Services and BIRT
promise better (that is, cheaper) report lifecycle management
capabilities, which could make them better choices for many BI-related
reporting applications.
Would you mind having a go at a few of the questions I've appended
below? I'd love to hear your thoughts on this issue. If your employer
prohibits you from speaking on the record to journalists, I don't
have a mind abstracting its identity (e.g., "a major pharmaceutical
company based in the Northeast," or "a large financial services
firm based in the American South"). So don't let that stop you.
Thanks very much for your time. I appreciate it, and I apologize, once
again, for contacting you on an unsolicited basis.
Best,
Steve
1. Is your organization invested in Crystal, or have you transitioned
over to Reporting Services? If the former, for what purposes or in
support of which applications do you use Crystal? (I'm trying to get
a sense for whether you use Crystal mostly as a default reporting tool
for app dev purposes, whether it's tied to the use of any specific
application, or whether you're using it mostly as a reporting
front-end for data warehousing and BI.)
2. Did your organization opt for Crystal as a matter of choice -
e.g., you evaluated CR in addition to a host of other tools - or did
it go with Crystal largely because it was bundled with your default
development environment, or core applications that you use?
3. In comparison with Reporting Services and other reporting solutions,
what features about Crystal do you most like? What features about it
would you most like to change? How well do you feel Crystal
addresses/addressed your core use requirements?
4. Re: Reporting Services, are you currently using it? If not, have you
looked into using it? What features, if any, do you most like? What
features, if any, are deal-breakers for you? How do you feel that
Reporting Services compares with Crystal and other established
reporting solutions?
5. Do you have any interest in an open source reporting tool based on
the Eclipse development framework? If so, have you looked at the BIRT
project?|||Hello Steve,
As I said before, I'm new with reporting tools and with my company.
Therefore I can hardly make objective answers to you.
All I can tell is that they (developers before I step in) used Crystal
Report (CR) to test it. Now, we currently use Reporting Services(RS). The
reasons that made us change :
- We don't have to invoice our clients for using CR, it is included in
Microsoft Licences (we have a partnership with this company).
- Several developers complained about the technical support given with CR.
They hardly find professional help they needed.
- I was said designing on RS was much more easier than on CR.
For the moment, we are not interested in other report tools, as RS meets our
satisfaction.
I hope I gave any relevant information for you.
Best,
wadja
"daedalus" <stephen.swoyer@.gmail.com> a écrit dans le message de news:
1117634907.794866.228080@.f14g2000cwb.googlegroups.com...
> Hello Wadja,
> I apologize for contacting you on an unsolicited basis, but I read a
> few of your postings on Google's Crystal Developers users group and
> hoped that you'd be willing to help me.
> I'm a journalist with Application Development Trends magazine (ADT,
> http://www.adtmag.com), and I'm working on a story on reporting tools
> from a developer's perspective. As you no doubt know, Crystal has
> long been pretty much the only game in town in this respect, as the
> former Crystal Decisions seeded the market with this tool (it's shipped
> with Visual Studio for more than a decade, for example, and it ships
> with a host of other applications and tools, too).
> Now, however, developers have a choice of which reporting tool to use
> when they need to incorporate reporting functionality into their apps.
> Microsoft announced its SQL Server 2000 Reporting Services last year,
> and there's even an open source alternative called BIRT (that's short
> for BI Reporting Tool). I'd like to take a look at the positives and
> negatives of each of these solutions -- Crystal still seems hard to
> beat for straight-up reporting, but both Reporting Services and BIRT
> promise better (that is, cheaper) report lifecycle management
> capabilities, which could make them better choices for many BI-related
> reporting applications.
> Would you mind having a go at a few of the questions I've appended
> below? I'd love to hear your thoughts on this issue. If your employer
> prohibits you from speaking on the record to journalists, I don't
> have a mind abstracting its identity (e.g., "a major pharmaceutical
> company based in the Northeast," or "a large financial services
> firm based in the American South"). So don't let that stop you.
> Thanks very much for your time. I appreciate it, and I apologize, once
> again, for contacting you on an unsolicited basis.
> Best,
> Steve
> 1. Is your organization invested in Crystal, or have you transitioned
> over to Reporting Services? If the former, for what purposes or in
> support of which applications do you use Crystal? (I'm trying to get
> a sense for whether you use Crystal mostly as a default reporting tool
> for app dev purposes, whether it's tied to the use of any specific
> application, or whether you're using it mostly as a reporting
> front-end for data warehousing and BI.)
> 2. Did your organization opt for Crystal as a matter of choice -
> e.g., you evaluated CR in addition to a host of other tools - or did
> it go with Crystal largely because it was bundled with your default
> development environment, or core applications that you use?
> 3. In comparison with Reporting Services and other reporting solutions,
> what features about Crystal do you most like? What features about it
> would you most like to change? How well do you feel Crystal
> addresses/addressed your core use requirements?
> 4. Re: Reporting Services, are you currently using it? If not, have you
> looked into using it? What features, if any, do you most like? What
> features, if any, are deal-breakers for you? How do you feel that
> Reporting Services compares with Crystal and other established
> reporting solutions?
> 5. Do you have any interest in an open source reporting tool based on
> the Eclipse development framework? If so, have you looked at the BIRT
> project?
>sql

Monday, March 26, 2012

Migrating all reports to a new server

I'm Managing Reporting Services in a mid-size company, and we are just
beginning to develop reports for different departments...We just set
up a new server and redeployed all of our reports (there were just a
few so far)...
My question is..What happens when we have hundreds of reports and need
to migrate our entire reporting services system to a new server?
Subsequently, In a worst-case situation, how would we recover reports?
I appreciate your help!
-ScottStill looking for a response...This is an important need. Thanks in
advance!

Friday, March 23, 2012

MIGRATE TO REPORTING SERVICE 2005

Good Morning,
I've a server mssql 2000 with reporting service and so also Visual
Studio.NET 2003.
Now I want to migrate to Reporting Service 2005,must I to upgrade also
Mssql to 2005 version and Visual Studio.NET 2005 or can I to upgrade
only Reporting Service?
ThanksYOu can upgrade Reporting Services without going to sql 2005... ( according
to Books On LIne)... Although we put the Reporting Services databases on an
instance of SQL 2005 - I don't think we had to...
--
Wayne Snyder MCDBA, SQL Server MVP
Mariner, Charlotte, NC
I support the Professional Association for SQL Server ( PASS) and it''s
community of SQL Professionals.
"Teo" wrote:
> Good Morning,
> I've a server mssql 2000 with reporting service and so also Visual
> Studio.NET 2003.
> Now I want to migrate to Reporting Service 2005,must I to upgrade also
> Mssql to 2005 version and Visual Studio.NET 2005 or can I to upgrade
> only Reporting Service?
> Thanks
>|||What is your current configuration? Local catalog (all on one server)?
Wayne is correct. You may install Reporting Services 2005 next to Reporting
Services 2000 and then use the 2005 Reporting Services Configuration Manager
to migrate your existing SQL2000 database to SQL2005... BOL is gray in the
fact that it appears that this is only supported in a remote catalog (SQL
and IIS on separate servers) configuration or a web farm/scale-out (multiple
IIS servers sharing a centralized SQL catalog) configuration but since
SQL2000 and SQL2005 can live on the same server it can be done on a local
catalog configuration... having said all that, unless you are needing to
maintain a SQL2000 environment for other reasons I don't see why you would
not want to upgrade you SQL2000 RDBMS to 2005, go for it!
--
Douglas McDowell douglas@.nospam.solidqualitylearning.com
"Wayne Snyder" <wayne.nospam.snyder@.mariner-usa.com> wrote in message
news:3A2A647A-017C-442E-A1B9-D629DA7EEBEF@.microsoft.com...
> YOu can upgrade Reporting Services without going to sql 2005... (
> according
> to Books On LIne)... Although we put the Reporting Services databases on
> an
> instance of SQL 2005 - I don't think we had to...
> --
> Wayne Snyder MCDBA, SQL Server MVP
> Mariner, Charlotte, NC
> I support the Professional Association for SQL Server ( PASS) and it''s
> community of SQL Professionals.
>
> "Teo" wrote:
>> Good Morning,
>> I've a server mssql 2000 with reporting service and so also Visual
>> Studio.NET 2003.
>> Now I want to migrate to Reporting Service 2005,must I to upgrade also
>> Mssql to 2005 version and Visual Studio.NET 2005 or can I to upgrade
>> only Reporting Service?
>> Thanks
>>|||My configuration is SQL Server and IIS on the same box. I upgraded only RS.
My SQL Server is still 2000 (note for all, you do have to have a SQL Server
2005 license if you do this). So, it is incorrect to say that this is only
supported with a remote catalog. That is definitely not true.
All you have to do when upgrading is select only RS 2005 when upgrading and
it all works.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Douglas McDowell" <douglas@.nospam.solidqualitylearning.com> wrote in
message news:e5L7GW7DGHA.2040@.TK2MSFTNGP14.phx.gbl...
> What is your current configuration? Local catalog (all on one server)?
> Wayne is correct. You may install Reporting Services 2005 next to
> Reporting Services 2000 and then use the 2005 Reporting Services
> Configuration Manager to migrate your existing SQL2000 database to
> SQL2005... BOL is gray in the fact that it appears that this is only
> supported in a remote catalog (SQL and IIS on separate servers)
> configuration or a web farm/scale-out (multiple IIS servers sharing a
> centralized SQL catalog) configuration but since SQL2000 and SQL2005 can
> live on the same server it can be done on a local catalog configuration...
> having said all that, unless you are needing to maintain a SQL2000
> environment for other reasons I don't see why you would not want to
> upgrade you SQL2000 RDBMS to 2005, go for it!
> --
> Douglas McDowell douglas@.nospam.solidqualitylearning.com
>
> "Wayne Snyder" <wayne.nospam.snyder@.mariner-usa.com> wrote in message
> news:3A2A647A-017C-442E-A1B9-D629DA7EEBEF@.microsoft.com...
>> YOu can upgrade Reporting Services without going to sql 2005... (
>> according
>> to Books On LIne)... Although we put the Reporting Services databases on
>> an
>> instance of SQL 2005 - I don't think we had to...
>> --
>> Wayne Snyder MCDBA, SQL Server MVP
>> Mariner, Charlotte, NC
>> I support the Professional Association for SQL Server ( PASS) and it''s
>> community of SQL Professionals.
>>
>> "Teo" wrote:
>> Good Morning,
>> I've a server mssql 2000 with reporting service and so also Visual
>> Studio.NET 2003.
>> Now I want to migrate to Reporting Service 2005,must I to upgrade also
>> Mssql to 2005 version and Visual Studio.NET 2005 or can I to upgrade
>> only Reporting Service?
>> Thanks
>>
>|||But RS need Visual Studio.Net so if I want to install RS2005 , I must
to upgrade VS from version 2003 to 2005 ?
it's true?|||RS 2005 comes with a version of VS that is used for the report designer. You
can run side by side (leave your VS 2003 alone). If VS 2005 is installed
then RS 2005 will install the report designer to use that.
So, you do not need to purchase VS 2005.
Note that VS 2005 comes with two new controls for web and winforms. If you
want to use these new controls then you would need to upgrade VS.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Teo" <roninkaiser@.lycos.it> wrote in message
news:1136381218.597528.197920@.g43g2000cwa.googlegroups.com...
> But RS need Visual Studio.Net so if I want to install RS2005 , I must
> to upgrade VS from version 2003 to 2005 ?
> it's true?
>

Wednesday, March 21, 2012

Migrate Reporting Services Databases

I am upgrading the server that houses the SQL Reporting Services
databases (RSwwebservice, IIS and Report Manager are on another box).
The new server will have the same name (fqdn) as the old one.
Any issue with simply backin up the SQL RS dbs and restoring them the
new new server?
Thanks!Make sure to backup & restore the encryption key!
See also:
*
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rsadmin/htm/arp_dbadmin_v1_4915.asp
*
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rsadmin/htm/arp_dbadmin_v1_98xh.asp
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Jim" <emailjeffp@.yahoo.com> wrote in message
news:1106780668.274285.107650@.z14g2000cwz.googlegroups.com...
> I am upgrading the server that houses the SQL Reporting Services
> databases (RSwwebservice, IIS and Report Manager are on another box).
> The new server will have the same name (fqdn) as the old one.
> Any issue with simply backin up the SQL RS dbs and restoring them the
> new new server?
> Thanks!
>|||Thanks.
I am not moving the Reporting Services Front end (i.e IIS, Report
Manager, etc..) do I still need to backup/restore the encryption key?|||If you only move the backend database, but not the RS webservice it is not
required to backup and restore the encryption keys. Nonetheless, you should
always backup the keys right after installation of RS.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Jim" <emailjeffp@.yahoo.com> wrote in message
news:1106840440.083283.232730@.c13g2000cwb.googlegroups.com...
> Thanks.
> I am not moving the Reporting Services Front end (i.e IIS, Report
> Manager, etc..) do I still need to backup/restore the encryption key?
>|||I am having a similar problem - we currently have sql server reporting server
and sql server standard on the same machine. I have loaded the sql reporting
services onto a new machine that also has sql server running. All I want to
do is move the database from the old machine to the new machine - when i do
the backup and restore i see the folders and all my reports but I can not run
any of the reports - i have tried to reactivate using rsactivate and rsconfig
without success. Can I just use DTS to copy the data from the old sql server
database to the new?
"Jim" wrote:
> I am upgrading the server that houses the SQL Reporting Services
> databases (RSwwebservice, IIS and Report Manager are on another box).
> The new server will have the same name (fqdn) as the old one.
> Any issue with simply backin up the SQL RS dbs and restoring them the
> new new server?
> Thanks!
>sql

migrate report history to another server

All,
I'm looking into the ability to move a report and it's history from one
reporting server to another. Moving the reporting is no problem, but I am
not having any luck in finding a way to move the associated historical
reports. I have used RSScripter to move reports, but the history does not
migrate. I was hoping to migrate the report history programmatically, but
I'm not seeing anything that suggests it is possible short of moving the
entire Reporting Services database. Has anyone moved historical reports
between Reporting Service servers?
Thanks,
RobertRMac,
There is a way to do this, I have done it. It involves creating some DTS
Packages though. Here are the steps that I did and it worked great:
First thing you need to do is go into the Catalog Table in the ReportServer
database and find the report that you are working with (the one that has all
of the history). This report will have an 'ItemID'. You will need this
ItemID to use in queries in the DTS packages.
Once you have the ItemID you can run a query against the History Table to
find all of the SnapShotDataID's, like this:
select * from dbo.history
where reportid = '{B22FBC16-5E61-4B40-903E-0E04E689DE60}'
Create a DTS Package, using this query, to export the history items from the
old server to the new one. Your history records will now be in the new
server History table.
Next, create another DTS Package, using a query similar to this one:
select * from dbo.SnapShotData
where snapshotdataid in
(select snapshotdataid from dbo.history
where reportid = '{B22FBC16-5E61-4B40-903E-0E04E689DE60}')
With this DTS package you are going to export out all of the SnapShotData
Table information from the old server to the new one.
Next DTS package will use a query similar to this one:
select * from dbo.ChunkData
where snapshotdataid in
(select snapshotdataid from dbo.history
where reportid = '{B22FBC16-5E61-4B40-903E-0E04E689DE60}')
The ChunkData table is the table that actually contains the image files (or
snapshots) of the reports. Once you have the History table, SnapShotData
table and ChunkData table information moved over. You will need to run an
update query on the new server like this:
update dbo.History
set reportid = '(your new itemid from the new server catalog table)'
where reportid = '(your old itemid from the old server}'
You will need the new itemid for this previous query. Once you have
deployed the report to the new server, just go out to the Catalog table and
find the new item id. Use that in the update query above.
It sounds a lot harder than it really is. But, I have done it and this does
work.
"RMac" wrote:
> All,
> I'm looking into the ability to move a report and it's history from one
> reporting server to another. Moving the reporting is no problem, but I am
> not having any luck in finding a way to move the associated historical
> reports. I have used RSScripter to move reports, but the history does not
> migrate. I was hoping to migrate the report history programmatically, but
> I'm not seeing anything that suggests it is possible short of moving the
> entire Reporting Services database. Has anyone moved historical reports
> between Reporting Service servers?
> Thanks,
> Robert|||SandiB, this works like a champ. Thanks much!
"SandiB" wrote:
> RMac,
> There is a way to do this, I have done it. It involves creating some DTS
> Packages though. Here are the steps that I did and it worked great:
> First thing you need to do is go into the Catalog Table in the ReportServer
> database and find the report that you are working with (the one that has all
> of the history). This report will have an 'ItemID'. You will need this
> ItemID to use in queries in the DTS packages.
> Once you have the ItemID you can run a query against the History Table to
> find all of the SnapShotDataID's, like this:
> select * from dbo.history
> where reportid = '{B22FBC16-5E61-4B40-903E-0E04E689DE60}'
> Create a DTS Package, using this query, to export the history items from the
> old server to the new one. Your history records will now be in the new
> server History table.
> Next, create another DTS Package, using a query similar to this one:
> select * from dbo.SnapShotData
> where snapshotdataid in
> (select snapshotdataid from dbo.history
> where reportid = '{B22FBC16-5E61-4B40-903E-0E04E689DE60}')
> With this DTS package you are going to export out all of the SnapShotData
> Table information from the old server to the new one.
> Next DTS package will use a query similar to this one:
> select * from dbo.ChunkData
> where snapshotdataid in
> (select snapshotdataid from dbo.history
> where reportid = '{B22FBC16-5E61-4B40-903E-0E04E689DE60}')
> The ChunkData table is the table that actually contains the image files (or
> snapshots) of the reports. Once you have the History table, SnapShotData
> table and ChunkData table information moved over. You will need to run an
> update query on the new server like this:
> update dbo.History
> set reportid = '(your new itemid from the new server catalog table)'
> where reportid = '(your old itemid from the old server}'
> You will need the new itemid for this previous query. Once you have
> deployed the report to the new server, just go out to the Catalog table and
> find the new item id. Use that in the update query above.
> It sounds a lot harder than it really is. But, I have done it and this does
> work.
>
> "RMac" wrote:
> > All,
> > I'm looking into the ability to move a report and it's history from one
> > reporting server to another. Moving the reporting is no problem, but I am
> > not having any luck in finding a way to move the associated historical
> > reports. I have used RSScripter to move reports, but the history does not
> > migrate. I was hoping to migrate the report history programmatically, but
> > I'm not seeing anything that suggests it is possible short of moving the
> > entire Reporting Services database. Has anyone moved historical reports
> > between Reporting Service servers?
> > Thanks,
> > Robert

Monday, March 19, 2012

Migrate from sql 2000 to sql 2005

I buckup and restore all databases on the sql server 2005 from sql 2000.
What is the next step ?
I need to implement Reporting Services for sql 2005.
Thanks for help.On Jun 15, 4:11 pm, GGill <G...@.discussions.microsoft.com> wrote:
> I buckup and restore all databases on the sql server 2005 from sql 2000.
> What is the next step ?
> I need to implement Reporting Services for sql 2005.
> Thanks for help.
This article should be of assistance.
http://msdn2.microsoft.com/en-us/library/ms143724(SQL.90).aspx
Regards,
Enrique Martinez
Sr. Software Consultant

Friday, March 9, 2012

Microsoft.ReportingServices.UI ?

does microsoft give away the source for the reporting service ui?
usually installed in
C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
Services\ReportManager\Pages
I would love to see the code for this page
<%@. Register TagPrefix="MSRS" Namespace="Microsoft.ReportingServices.UI"
Assembly="ReportingServicesWebUserInterface" %>
<%@. Page language="c#" Codebehind="DataSource.aspx.cs"
AutoEventWireup="false"
Inherits="Microsoft.ReportingServices.UI.DataSourcePage" %>
If they don't give this code away they should it would be very very helpfull.We all wish. But there is some sample UI code you can download.
--
'(' Jeff A. Stucker
\
Business Intelligence
www.criadvantage.com
---
"letuce dance" <letucedance@.discussions.microsoft.com> wrote in message
news:8A7902B5-5496-458B-B323-013B9724EF53@.microsoft.com...
> does microsoft give away the source for the reporting service ui?
> usually installed in
> C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
> Services\ReportManager\Pages
> I would love to see the code for this page
> <%@. Register TagPrefix="MSRS" Namespace="Microsoft.ReportingServices.UI"
> Assembly="ReportingServicesWebUserInterface" %>
> <%@. Page language="c#" Codebehind="DataSource.aspx.cs"
> AutoEventWireup="false"
> Inherits="Microsoft.ReportingServices.UI.DataSourcePage" %>
> If they don't give this code away they should it would be very very
> helpfull.

Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: There is no data for the

Hi,

I am getting the following errors in my reporting server log. Can anyone help me?

ReportingServicesService!processing!11!8/22/2006-01:04:04:: e ERROR: Throwing Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: There is no data for the field at position 10., ;
Info: Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: There is no data for the field at position 10.
ReportingServicesService!processing!11!8/22/2006-01:04:04:: e ERROR: Throwing Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: There is no data for the field at position 14., ;
Info: Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: There is no data for the field at position 14.
ReportingServicesService!processing!11!8/22/2006-01:04:04:: e ERROR: Throwing Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: There is no data for the field at position 18., ;
Info: Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: There is no data for the field at position 18.
ReportingServicesService!processing!11!8/22/2006-01:04:04:: e ERROR: Throwing Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: There is no data for the field at position 22., ;
Info: Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: There is no data for the field at position 22.

This error message is usually caused by a missing field in the dataset (it is defined in the dataset, but the query does not return it). It is OK if you don't use the field in your report. But if you do, then you'd get a "#error" in the textbox, or the report fails if it's used in a group/sort/filter expression.

Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: There is no data for

Hi,

I am getting the following errors in my reporting server log. Can anyone help me?

ReportingServicesService!processing!11!8/22/2006-01:04:04:: e ERROR: Throwing Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: There is no data for the field at position 10., ;
Info: Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: There is no data for the field at position 10.
ReportingServicesService!processing!11!8/22/2006-01:04:04:: e ERROR: Throwing Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: There is no data for the field at position 14., ;
Info: Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: There is no data for the field at position 14.
ReportingServicesService!processing!11!8/22/2006-01:04:04:: e ERROR: Throwing Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: There is no data for the field at position 18., ;
Info: Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: There is no data for the field at position 18.
ReportingServicesService!processing!11!8/22/2006-01:04:04:: e ERROR: Throwing Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: There is no data for the field at position 22., ;
Info: Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: There is no data for the field at position 22.

This error message is usually caused by a missing field in the dataset (it is defined in the dataset, but the query does not return it). It is OK if you don't use the field in your report. But if you do, then you'd get a "#error" in the textbox, or the report fails if it's used in a group/sort/filter expression.

Wednesday, March 7, 2012

Microsoft Word Delivery Extension & Use of web client

1. Is there a Microsoft Word or RTF delivery extension available for SQL
Reporting Services?
If not, is there any technique of producing the same with XML and XSLT?
2. To solve the security extension problem on a standard edition:
I am thinking of using web client on a filter page on the web server to
connect to the reporting server so that I don't bypass the web server when a
URL access request comes thru.
I mean, the URL for the report viewer won't be reporting server, instead it
will be an aspx (filter) page within the web server. The filter on the web
server will intercept and in turn impersonate a user on the report server and
render a report in the report viewer.
My question: I have not used web clients from web server before. Will it
affect the performance of web server? Is the above theory make sense at all?
I haven't implemented it.
Thanks,
Sri.The XML/XSLT idea is probably your best bet. Years ago I created a custom
RTF generator (to create nice-looking documents from a CASE tool). It's
easy once you do two things:
(1) Hunt down the RTF specification (from Microsoft I think), and learn the
basic syntax.
(2) Create a Word document that looks like what you want and save it to RTF
as a baseline/reference.
Then, you'll be armed and dangerous -- especially if you know how to do
XSLT.
--
Cheers,
'(' Jeff A. Stucker
\
Business Intelligence
www.criadvantage.com
---
"Sri" <Sri@.discussions.microsoft.com> wrote in message
news:8B848583-4F7E-490F-9E77-95CD40C30072@.microsoft.com...
> 1. Is there a Microsoft Word or RTF delivery extension available for SQL
> Reporting Services?
> If not, is there any technique of producing the same with XML and XSLT?
> 2. To solve the security extension problem on a standard edition:
> I am thinking of using web client on a filter page on the web server to
> connect to the reporting server so that I don't bypass the web server when
> a
> URL access request comes thru.
> I mean, the URL for the report viewer won't be reporting server, instead
> it
> will be an aspx (filter) page within the web server. The filter on the web
> server will intercept and in turn impersonate a user on the report server
> and
> render a report in the report viewer.
> My question: I have not used web clients from web server before. Will it
> affect the performance of web server? Is the above theory make sense at
> all?
> I haven't implemented it.
> Thanks,
> Sri.
>|||Thanks Jeff. I will investigate.
"Jeff A. Stucker" wrote:
> The XML/XSLT idea is probably your best bet. Years ago I created a custom
> RTF generator (to create nice-looking documents from a CASE tool). It's
> easy once you do two things:
> (1) Hunt down the RTF specification (from Microsoft I think), and learn the
> basic syntax.
> (2) Create a Word document that looks like what you want and save it to RTF
> as a baseline/reference.
> Then, you'll be armed and dangerous -- especially if you know how to do
> XSLT.
> --
> Cheers,
> '(' Jeff A. Stucker
> \
> Business Intelligence
> www.criadvantage.com
> ---
> "Sri" <Sri@.discussions.microsoft.com> wrote in message
> news:8B848583-4F7E-490F-9E77-95CD40C30072@.microsoft.com...
> > 1. Is there a Microsoft Word or RTF delivery extension available for SQL
> > Reporting Services?
> >
> > If not, is there any technique of producing the same with XML and XSLT?
> >
> > 2. To solve the security extension problem on a standard edition:
> >
> > I am thinking of using web client on a filter page on the web server to
> > connect to the reporting server so that I don't bypass the web server when
> > a
> > URL access request comes thru.
> > I mean, the URL for the report viewer won't be reporting server, instead
> > it
> > will be an aspx (filter) page within the web server. The filter on the web
> > server will intercept and in turn impersonate a user on the report server
> > and
> > render a report in the report viewer.
> >
> > My question: I have not used web clients from web server before. Will it
> > affect the performance of web server? Is the above theory make sense at
> > all?
> > I haven't implemented it.
> >
> > Thanks,
> > Sri.
> >
>
>|||Hi,
You can check http://officewriter.softartisans.com/officewriter-250.aspx
for the first question.
creating a 'filter' will not affect performance
--
Message posted via http://www.sqlmonster.com

Monday, February 20, 2012

Microsoft SQL Server Reporting Services RS2000 datetime picker

Hi everyone!
I got a problem about datetime parameters in RS 2000.
I solved this problem in 2005 because datatime parameter automaticly
got the datetime picker.
However as far as i know, in RS2000 there is no datetime picker
available. Is anybody can achieve to use datetime parameter with
datetime picker control in RS2000?
Thanks in advance,
BeyzaThe only way to have a datetime picker in 2000 is to replace report manager
with your own webpage. RS 2005 will be released early November.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"kleo" <beyzaarpinar@.gmail.com> wrote in message
news:1128435992.724467.223760@.o13g2000cwo.googlegroups.com...
> Hi everyone!
> I got a problem about datetime parameters in RS 2000.
> I solved this problem in 2005 because datatime parameter automaticly
> got the datetime picker.
> However as far as i know, in RS2000 there is no datetime picker
> available. Is anybody can achieve to use datetime parameter with
> datetime picker control in RS2000?
> Thanks in advance,
> Beyza
>

Microsoft SQL Server Reporting Services

Hi all!
I have downloaded the new realese of SQL Server Reporting Services
(the real release, not the Beta 2) and gets the following error
whenever I try to build, deploy or preview a report. I even got it
when I try to shut down the Microsoft .Net IDE. Does anyone have a
clue?
I have used the beta 2 for a while now, without problem and I have
tried both to upgrade the beta 2 to this release and to uninstall the
beta 2 and install the new release from scratch with the same result.
Here is the error message I've got:
"Method not found: Void
Microsoft.DataWarehouse.Interfaces.MenuCommandEx.set_Input(System.Object[])"
Because I didn't find any group dedicated to Reporting Services I post
this message in a couple of more or less closely related groups. I
hope nobody minds.
Regards,
/Mattias TorngrenMat,
Please let me know if you get a resolution to this. I am getting the same er
ror.
Bob
-- Mat wrote: --
Hi all!
I have downloaded the new realese of SQL Server Reporting Services
(the real release, not the Beta 2) and gets the following error
whenever I try to build, deploy or preview a report. I even got it
when I try to shut down the Microsoft .Net IDE. Does anyone have a
clue?
I have used the beta 2 for a while now, without problem and I have
tried both to upgrade the beta 2 to this release and to uninstall the
beta 2 and install the new release from scratch with the same result.
Here is the error message I've got:
"Method not found: Void
Microsoft.DataWarehouse.Interfaces.MenuCommandEx.set_Input(System.Object[])"
Because I didn't find any group dedicated to Reporting Services I post
this message in a couple of more or less closely related groups. I
hope nobody minds.
Regards,
/Mattias Torngren|||The reporting services newsgroup went up early Tues 27 morning. It's
microsoft.public.sqlserver.reportingsvcs. Post there as it is being actively
monitored.
"Mat" <mattias_torngren@.hotmail.com> wrote in message
news:c7333b1a.0401280231.5843bba3@.posting.google.com...
quote:

> Hi all!
> I have downloaded the new realese of SQL Server Reporting Services
> (the real release, not the Beta 2) and gets the following error
> whenever I try to build, deploy or preview a report. I even got it
> when I try to shut down the Microsoft .Net IDE. Does anyone have a
> clue?
> I have used the beta 2 for a while now, without problem and I have
> tried both to upgrade the beta 2 to this release and to uninstall the
> beta 2 and install the new release from scratch with the same result.
> Here is the error message I've got:
> "Method not found: Void
>

Microsoft.DataWarehouse.Interfaces.MenuCommandEx.set_Input(System.Object[])"
quote:

> Because I didn't find any group dedicated to Reporting Services I post
> this message in a couple of more or less closely related groups. I
> hope nobody minds.
> Regards,
> /Mattias Torngren
|||I cannot find this microsoft.public.sqlserver.reportingsvcs newsgroup anywhe
re on the MSDN Newsgroup on the left nav bar for all the MSDN newsgroups
Venky|||Since it's a public newsgroup, it's hosted on the msnews.microsoft.com nntp
server .
I don't think there is a MSDN "managed" newsgroup as of yet.
"Venky" <anonymous@.discussions.microsoft.com> wrote in message
news:4785D4CD-E34F-48C3-BC6B-99FF6E32176A@.microsoft.com...
quote:

> I cannot find this microsoft.public.sqlserver.reportingsvcs newsgroup

anywhere on the MSDN Newsgroup on the left nav bar for all the MSDN
newsgroups
quote:

> Venky
|||You should be able to fix the problem by putting
Microsoft.DataWarehouse.Interfaces.DLL in the gac. (Try the gacutil
command line tool).
HTH,
Scott
http://www.OdeToCode.com
On 28 Jan 2004 02:31:39 -0800, mattias_torngren@.hotmail.com (Mat)
wrote:
quote:

>Hi all!
>I have downloaded the new realese of SQL Server Reporting Services
>(the real release, not the Beta 2) and gets the following error
>whenever I try to build, deploy or preview a report. I even got it
>when I try to shut down the Microsoft .Net IDE. Does anyone have a
>clue?
>I have used the beta 2 for a while now, without problem and I have
>tried both to upgrade the beta 2 to this release and to uninstall the
>beta 2 and install the new release from scratch with the same result.
>Here is the error message I've got:
>"Method not found: Void
>Microsoft.DataWarehouse.Interfaces.MenuCommandEx.set_Input(System.Object[])
"
>Because I didn't find any group dedicated to Reporting Services I post
>this message in a couple of more or less closely related groups. I
>hope nobody minds.
>Regards,
>/Mattias Torngren
|||I cannot find this reporting services newsgroup either !!|||and I don't know if it will become a "managed" newsgroup. I've asked the
microsoft.com site folks to get it listed out on
http://communities2.microsoft.com/c...s/default.aspx,
English/United States/Servers/SQL Server as that apparently got overlooked.
I've also started the conversation with technet and MSDN to see if we can
get it listed out on their sites.
Sincerely,
Stephen Dybing
This posting is provided "AS IS" with no warranties, and confers no rights.
"Keith Hay" <demungkeith.hay@.attglobalperiodnet> wrote in message
news:Oy0uo%23b5DHA.2656@.TK2MSFTNGP11.phx.gbl...
quote:

> Since it's a public newsgroup, it's hosted on the msnews.microsoft.com

nntp
quote:

> server .
> I don't think there is a MSDN "managed" newsgroup as of yet.
>
> "Venky" <anonymous@.discussions.microsoft.com> wrote in message
> news:4785D4CD-E34F-48C3-BC6B-99FF6E32176A@.microsoft.com...
> anywhere on the MSDN Newsgroup on the left nav bar for all the MSDN
> newsgroups
>
|||Scott,
I have this same problem as Mat and the dll was already in the gac.
Bob
-- Scott Allen wrote: --
You should be able to fix the problem by putting
Microsoft.DataWarehouse.Interfaces.DLL in the gac. (Try the gacutil
command line tool).
HTH,
Scott
http://www.OdeToCode.com
On 28 Jan 2004 02:31:39 -0800, mattias_torngren@.hotmail.com (Mat)
wrote:
quote:

>Hi all!
>(the real release, not the Beta 2) and gets the following error
>whenever I try to build, deploy or preview a report. I even got it
>when I try to shut down the Microsoft .Net IDE. Does anyone have a
>clue?
>tried both to upgrade the beta 2 to this release and to uninstall the
>beta 2 and install the new release from scratch with the same result.
>Here is the error message I've got:
>Microsoft.DataWarehouse.Interfaces.MenuCommandEx.set_Input(System.Object[])
"
>this message in a couple of more or less closely related groups. I
>hope nobody minds.
>/Mattias Torngren
|||I've got an answer from another newsgroup that helped me. If you have
a beta installed than it's important to delete everything that has
with the reporting services to do before installing the new release,
otherwise you can get this problem.
The solution is to add an assembly to the gac like this:
"Add the file "C:\Program Files\Microsoft SQL
Server\80\Tools\ReportDesigner\Microsoft
.DataWarehouse.Interfaces.DLL"
to the GAC"
"You can do this from Start>Programs>Administrative Tools>Microsoft
.Net Framework 1.1 Configuration. Click on Assembly Cache and choose
Add an Assembly to the Cache"
You find the whole thread here:
http://www.sql-server-performance.c...p?TOPIC_ID=2963
Thank you again Jasper Smith
/Mattias Torngren
mattias_torngren@.hotmail.com (Mat) wrote in message news:<c7333b1a.0401280231.5843bba3@.posting.goo
gle.com>...
quote:

> Hi all!
> I have downloaded the new realese of SQL Server Reporting Services
> (the real release, not the Beta 2) and gets the following error
> whenever I try to build, deploy or preview a report. I even got it
> when I try to shut down the Microsoft .Net IDE. Does anyone have a
> clue?
> I have used the beta 2 for a while now, without problem and I have
> tried both to upgrade the beta 2 to this release and to uninstall the
> beta 2 and install the new release from scratch with the same result.
> Here is the error message I've got:
> "Method not found: Void
> Microsoft.DataWarehouse.Interfaces.MenuCommandEx.set_Input(System.Object[]
)"
> Because I didn't find any group dedicated to Reporting Services I post
> this message in a couple of more or less closely related groups. I
> hope nobody minds.
> Regards,
> /Mattias Torngren

Microsoft SQL Server Report Designer

Hi, I have installed SQL Server 2000 and Reporting Services 2005 and Visual Studio 2003 all works OK but I need to create a report with the Microsoft SQL Server Report Designer 2005 and it doesn't appear in my VS, someone could help me with this?

Marcos.

Look in [All Programs][Microsoft SQL Server 2005] on the start menu and see if you have SQL Server Business Intelligence Development Studio. If it is not there, go through the following steps Dan Jones supplied in this other thread:

You should make sure that Visual Studio is still installed. If you didn't previously have VS installed, the BI Dev Studio installation will install a VS shell called Visual Studio Premier Partner Edition. Look in Add or Remove Programs for an entry like this. If you don't find any entry for Visual Studio go to the location for SQL Server setup and run .\Tools\Setup\vs_setup.exe. This will install the VS Shell. After this is installed repair the BI Studio installation by running the following from the command line from the .\Tools directory: start /wait setup.exe /qb REINSTALL=SQL_WarehouseDevWorkbench REINSTALLMODE=OMUS

Good luck! Let us know how it turns out.

Larry Smithmier

|||

I install the VS Premier PArtener Ed. but my VS not shows the option to create a new BI project, look the link below.

http://i203.photobucket.com/albums/aa119/mcssnt/My_Screen.jpg

Marcos

|||

You need to install the SQL Server client components to get the Report Project to appear in VS.NET. Alternatively, you can use the Business Intelligence Development Studio which is included in the SQL Server client components.

|||

Thanks, when I try to install the SQL clien components the setup shows: 'An installation package for the product Microsoft SQL Server Native Client cannont be found. Try the installation again using a valid copy of the installation packege 'sqlcli.msi'.' If I install the complete VS 2005 developer ed, this help to fix the issue?

|||

There is a standalone redistributable for SQL Server Native Client. The server portion of the setup installs it as a prerequisite as well.

|||

I have finished to install the Clien Components, I ran the Task Manager and end the process tree of the sqlserver and the explorer.exe and then start again the explorer.exe and ran the setup with this I can install the client components without message error.

Many thanks to all.

Marcos