I am working in migrating my cr application to 10th ver from the existing 8.5 where we have to explicitly make a query in query builder and then attach it. I was using dsn in ms odbc for oracle driver to connect the DB. Now in 10.0 i have removed the query file created using 8.5 query builder and trying to write directly to command editor. the report as stand alone is working fine. but when i try to generate the pdf using my vb application then on .export option it is giving error as "Logon failed.
Details: 01S00:[Microsoft][ODBC driver for Oracle]Invalid connection string attribute". i think the problem might be with cddb_oracle.dll or crdb_oracle.dll file as i am using a evaluation version of crystal report 10. as input to dsn i am providing
1.dsn
2.usid
3.database
4.password
what else is missing . plz help....The next is code I use in VB6 to display in CRViewer10 a CR10 report that read data thru ODBC
Set CRReport = CRApplication.OpenReport("Report.rpt", 1)
For MEnt2 = 1 To CRReport.Database.Tables.Count
Set CRTabla = CRReport.Database.Tables(MEnt2)
Set CRConProp = CRTabla.ConnectionProperties("Provider")
CRConProp.value = "MSDASQL"
Set CRConProp = CRTabla.ConnectionProperties("Data Source")
CRConProp.value = "DSNname"
Set CRConProp = CRTabla.ConnectionProperties("Initial Catalog")
CRConProp.value = "Datapath"
Set CRConProp = CRTabla.ConnectionProperties("User ID")
CRConProp.value = ""
Set CRConProp = CRTabla.ConnectionProperties("Locale Identifier")
CRConProp.value = "2058"
Set CRConProp = CRTabla.ConnectionProperties("OLE DB Services")
CRConProp.value = "-5"
Next MEnt2
frmReport.Show vbModal
Showing posts with label report. Show all posts
Showing posts with label report. Show all posts
Friday, March 30, 2012
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
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
Migrating from ASP
I have a bunch of contracts built in asp and I need them to be
published on report server. Is there any easier way than rebuilding
them in report designer?
There is not migration path from ASP to Reporting Services reports. You can store the asp contracts in reporting services as resources, but they will not be executed as reports.
Wednesday, March 28, 2012
Migrating Crystal Reports from 8x to 11x
Hi All,
I have an application in Crystal Report 8x version which needs to be migrated to 11x. Also assume that the Database is also changing. Maybe from one server to another server or one RDBMS to other RDBMS.
My questions are as follows.
1. How to migrate from version 8.x to 11.x, what are all the steps?
2. How to do database changes in the Crystal Reports?
3. Is there any client version for Crystal Reports? If so, how to view that and what are all the changes in the client version that needs to be done.
4. How do we access the crystal reports externally where we don't install the software? Is there any external components that will be used? If so, what is that?
Kindly clarify me the above questions ASAP.See if you find answer here
www.Businessobjects.com|||Hi,
Can you be more specific about how your reports are currently deployed? I'm moving Crystal 8 reports deployed in ASP using the Web Component Server to ASP using RAS (Report Application Server). The steps are as follows:
Open the version 8 report in 10 and save as a 10 report
Rewrite the ASP to call the report using RAS
Currently I'm running 8 and 10 on the same server and am migrating one report at a time, because the newer versions of Crystal will run side-by-side with previous versions.......of course you want to test that carefully before deploying both versions on a production server!
Changing the database "shouldn't" be a big deal, depending again on what you end up with. I go to set location inside the report designer and handle it there. If you change RDBMS' and your table/field names change, you may as well plan on rewriting the reports.
Hope that helps!
Linda
I have an application in Crystal Report 8x version which needs to be migrated to 11x. Also assume that the Database is also changing. Maybe from one server to another server or one RDBMS to other RDBMS.
My questions are as follows.
1. How to migrate from version 8.x to 11.x, what are all the steps?
2. How to do database changes in the Crystal Reports?
3. Is there any client version for Crystal Reports? If so, how to view that and what are all the changes in the client version that needs to be done.
4. How do we access the crystal reports externally where we don't install the software? Is there any external components that will be used? If so, what is that?
Kindly clarify me the above questions ASAP.See if you find answer here
www.Businessobjects.com|||Hi,
Can you be more specific about how your reports are currently deployed? I'm moving Crystal 8 reports deployed in ASP using the Web Component Server to ASP using RAS (Report Application Server). The steps are as follows:
Open the version 8 report in 10 and save as a 10 report
Rewrite the ASP to call the report using RAS
Currently I'm running 8 and 10 on the same server and am migrating one report at a time, because the newer versions of Crystal will run side-by-side with previous versions.......of course you want to test that carefully before deploying both versions on a production server!
Changing the database "shouldn't" be a big deal, depending again on what you end up with. I go to set location inside the report designer and handle it there. If you change RDBMS' and your table/field names change, you may as well plan on rewriting the reports.
Hope that helps!
Linda
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
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
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
Friday, March 9, 2012
Microsoft: What is next for Report Services?
I know that (typically) software vendors tend to be quiet about new features
and such... but... what is the roadmap for report services? Are they any
new features (or fixes) and what does the timeframe for releases look like?
Thanx!We are working on a roadmap for the next version of Reporting Services
(ships with SQL Server 2005). We have been hesitant to post lots of details
as we were not sure how much we would be able to fit and didn't want to get
people's expectations raised for features we wouldn't have time to finish.
--
Brian Welcker
Group Program Manager
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Kevin B" <kevin@.misnet.info> wrote in message
news:u1b67aXfEHA.4092@.TK2MSFTNGP10.phx.gbl...
>I know that (typically) software vendors tend to be quiet about new
>features
> and such... but... what is the roadmap for report services? Are they
> any
> new features (or fixes) and what does the timeframe for releases look
> like?
> Thanx!
>|||Brian,
would you reveil any information regarding future version of RS. We are
trying to plan what we will use in our software in our next version (written
in .NET) for reporting please. Currently we are in Crystal. Or post a link
where I can find anything about it please. Especially about Report Builder
and printing.
Thanks.
Sincerely,
Victor Kuzmich
"Brian Welcker [MSFT]" wrote:
> We are working on a roadmap for the next version of Reporting Services
> (ships with SQL Server 2005). We have been hesitant to post lots of details
> as we were not sure how much we would be able to fit and didn't want to get
> people's expectations raised for features we wouldn't have time to finish.
> --
> Brian Welcker
> Group Program Manager
> SQL Server Reporting Services
> This posting is provided "AS IS" with no warranties, and confers no rights.
> "Kevin B" <kevin@.misnet.info> wrote in message
> news:u1b67aXfEHA.4092@.TK2MSFTNGP10.phx.gbl...
> >I know that (typically) software vendors tend to be quiet about new
> >features
> > and such... but... what is the roadmap for report services? Are they
> > any
> > new features (or fixes) and what does the timeframe for releases look
> > like?
> >
> > Thanx!
> >
> >
>
>
and such... but... what is the roadmap for report services? Are they any
new features (or fixes) and what does the timeframe for releases look like?
Thanx!We are working on a roadmap for the next version of Reporting Services
(ships with SQL Server 2005). We have been hesitant to post lots of details
as we were not sure how much we would be able to fit and didn't want to get
people's expectations raised for features we wouldn't have time to finish.
--
Brian Welcker
Group Program Manager
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Kevin B" <kevin@.misnet.info> wrote in message
news:u1b67aXfEHA.4092@.TK2MSFTNGP10.phx.gbl...
>I know that (typically) software vendors tend to be quiet about new
>features
> and such... but... what is the roadmap for report services? Are they
> any
> new features (or fixes) and what does the timeframe for releases look
> like?
> Thanx!
>|||Brian,
would you reveil any information regarding future version of RS. We are
trying to plan what we will use in our software in our next version (written
in .NET) for reporting please. Currently we are in Crystal. Or post a link
where I can find anything about it please. Especially about Report Builder
and printing.
Thanks.
Sincerely,
Victor Kuzmich
"Brian Welcker [MSFT]" wrote:
> We are working on a roadmap for the next version of Reporting Services
> (ships with SQL Server 2005). We have been hesitant to post lots of details
> as we were not sure how much we would be able to fit and didn't want to get
> people's expectations raised for features we wouldn't have time to finish.
> --
> Brian Welcker
> Group Program Manager
> SQL Server Reporting Services
> This posting is provided "AS IS" with no warranties, and confers no rights.
> "Kevin B" <kevin@.misnet.info> wrote in message
> news:u1b67aXfEHA.4092@.TK2MSFTNGP10.phx.gbl...
> >I know that (typically) software vendors tend to be quiet about new
> >features
> > and such... but... what is the roadmap for report services? Are they
> > any
> > new features (or fixes) and what does the timeframe for releases look
> > like?
> >
> > Thanx!
> >
> >
>
>
Microsoft.ReportingServices.ReportProcessing.ReportProcessingException
Getting an error "Microsoft.ReportingServices.Report
Processing.ReportProcessingException" when trying to run a report with
a fairly large amount of data. Encountering this error quite often.
I changed the memory limit in the RSReportServer Configuration file to
120, but I am still getting this error.It could as well be a timeout issue.
Try changing the SQLCommandTimeoutSeconds to a higher
value.
>--Original Message--
>Getting an error "Microsoft.ReportingServices.Report
>Processing.ReportProcessingException" when trying to run
a report with
>a fairly large amount of data. Encountering this error
quite often.
>I changed the memory limit in the RSReportServer
Configuration file to
>120, but I am still getting this error.
>.
>
Processing.ReportProcessingException" when trying to run a report with
a fairly large amount of data. Encountering this error quite often.
I changed the memory limit in the RSReportServer Configuration file to
120, but I am still getting this error.It could as well be a timeout issue.
Try changing the SQLCommandTimeoutSeconds to a higher
value.
>--Original Message--
>Getting an error "Microsoft.ReportingServices.Report
>Processing.ReportProcessingException" when trying to run
a report with
>a fairly large amount of data. Encountering this error
quite often.
>I changed the memory limit in the RSReportServer
Configuration file to
>120, but I am still getting this error.
>.
>
Microsoft.Reporting.WebForms.ReportViewer does not support AJAX
If you add a ReportViewer control inside an AJAX UpdatePanel, you get
Javascript errors - and the rendering of the report is not triggered
correctly on partial postbacks.
Does anyone know when we can expect a version of the ReportViewer control
that supports AJAX?Hello Mercatus,
Per my understanding, we do not have such ReportViewer control to support
Ajax directly.
Since VS 2008 just released, you may try to use the new control.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.
Javascript errors - and the rendering of the report is not triggered
correctly on partial postbacks.
Does anyone know when we can expect a version of the ReportViewer control
that supports AJAX?Hello Mercatus,
Per my understanding, we do not have such ReportViewer control to support
Ajax directly.
Since VS 2008 just released, you may try to use the new control.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.
Microsoft.Reporting.WebForms.ReportViewer does not contain a definition for Reset
Hi everyone I developed a web form with a report viewer. I change the report datasource and report path based on user input. Before i do anything on the report i first reset it with this line:
rvWaitTime.Reset();
And then set the parameters, datasources, etc. It works fine on my dev machine: Windows Vista with .NET 2.0 installed (.NET 3.0 is installed as well). When I move the code to the production box: Windows Server 2003 with .NET 2.0 and 3.0 installed i get this error:
'Microsoft.Reporting.WebForms.ReportViewer' does not contain a definition for 'Reset'
and of course it fails on the line of code mentioned above.
Any ideas?
Who would have thought that you needed a seperate installation for a control that comes built in with VS 2005? I finally solved the problem. I needed to install theMicrosoft Report Viewer Redistributable 2005 SP1 (Full Installation) on my server and now everything works like a charm!
microsoft.reporting .rdlc
Hi I am trying to make a scatter chart with the reportviewer and report built into Visual Studio 2005
In my dataset it's basically a date and a value like
3/2/2005 10000
3/4/2005 12000
3/7/2005 9000
So I set the chart to use the Date on the X axis and the number on the Y axis
the report generates but on the X axis all the dates are converted to some integer value and it doesn't display it in date format, how do i get it to show in date format?
I think it takes the date and makes it an integer so it can display all the ticks for it for the dates that are not in my dataset that lie inbetween the dates that are.
Hii, I dont know what chart you are using, but you will have to use the CustomProperty in the charts <CustomProperties>,
For dundas chart the rdl looks like this -
<CustomProperties>
<CustomProperty><Name>Chart.ChartAreas.0.ChartArea.AxisX.ValueType</Name>
<Value>Date</Value>
</CustomProperty>
Microsoft.ReportDesigner.Drawing.Language
I am getting the a big redX when attempting to open a report in VS.NET 2005, "Deserialization failed: The type initializer for "Microsoft.ReportDesigner.Drawing.Language" threw an exception". Has anyone else get this error? Would you please share your solution to me?
Thanks
I am getting the same error and it's driving me crazy...
Anyone willing to help out?
|||I am getting the same error. If I get a solution, I'll post it here.Microsoft.ReportDesigner.Drawing.Language
I am getting the a big redX when attempting to open a report in VS.NET 2005, "Deserialization failed: The type initializer for "Microsoft.ReportDesigner.Drawing.Language" threw an exception". Has anyone else get this error? Would you please share your solution to me?
Thanks
I am getting the same error and it's driving me crazy...
Anyone willing to help out?
|||I am getting the same error. If I get a solution, I'll post it here.Wednesday, March 7, 2012
Microsoft Visual Studio
I am using Microsoft Visual studio and have a question. I need to put
multiple tables on the same report how can I do that? I got this reply to a
previous message but dont understand it
"Depending on your needs, you can either create a dataset that is based
on a query/stored procedure that accesses both tables -or- create 2
separate datasets, each going to a different table and have them
populate different report controls (i.e., table/matrix controls). Hope
this helps."
Can someone please take me through this step by step in detail?On Jul 1, 12:12 am, SQL Server express edition 2005
<SQLServerexpressedition2...@.discussions.microsoft.com> wrote:
> I am using Microsoft Visual studio and have a question. I need to put
> multiple tables on the same report how can I do that? I got this reply to a
> previous message but dont understand it
> "Depending on your needs, you can either create a dataset that is based
> on a query/stored procedure that accesses both tables -or- create 2
> separate datasets, each going to a different table and have them
> populate different report controls (i.e., table/matrix controls). Hope
> this helps."
> Can someone please take me through this step by step in detail?
If you are wanting to combine multiple database tables in a report,
you can write a stored procedure/query including something like this:
select a.*, b.*
from table_a as a
inner join table_b as b on a.x = b.x
Then in the Report in the data view, to the right of Dataset: select
<New Dataset...> and then enter the stored procedure name as the query
string and select Stored Procedure as the command type. Then in the
Layout view, drag-and-drop a table control from the toolbox (Ctrl+Alt
+X). Right click the table control and select Properties. Then on the
General tab, select the dataset you just created below Dataset name:.
Select your header and footer rows via right-clicking the Header/
Footer row and selecting Properties. In the General tab select the
Value (Field from the dataset) you would like to display. If you just
want to display text, instead of right-clicking and selecting
Properties, right-click and select 'Expression...' and enter in
something like: ="Some text here." Do the same for the detail row.
If you want 2 table controls from different database tables, do the
same as above but create your dataset based on a single table or query
of your choice and then repeat for the number of different database
tables or queries you want to use. Just drag-and-dro the number of
different table controls you want to use in the report and repeat the
above steps. I hope this clarifies it a little better for you.
Regards,
Enrique Martinez
Sr. Software Consultant
multiple tables on the same report how can I do that? I got this reply to a
previous message but dont understand it
"Depending on your needs, you can either create a dataset that is based
on a query/stored procedure that accesses both tables -or- create 2
separate datasets, each going to a different table and have them
populate different report controls (i.e., table/matrix controls). Hope
this helps."
Can someone please take me through this step by step in detail?On Jul 1, 12:12 am, SQL Server express edition 2005
<SQLServerexpressedition2...@.discussions.microsoft.com> wrote:
> I am using Microsoft Visual studio and have a question. I need to put
> multiple tables on the same report how can I do that? I got this reply to a
> previous message but dont understand it
> "Depending on your needs, you can either create a dataset that is based
> on a query/stored procedure that accesses both tables -or- create 2
> separate datasets, each going to a different table and have them
> populate different report controls (i.e., table/matrix controls). Hope
> this helps."
> Can someone please take me through this step by step in detail?
If you are wanting to combine multiple database tables in a report,
you can write a stored procedure/query including something like this:
select a.*, b.*
from table_a as a
inner join table_b as b on a.x = b.x
Then in the Report in the data view, to the right of Dataset: select
<New Dataset...> and then enter the stored procedure name as the query
string and select Stored Procedure as the command type. Then in the
Layout view, drag-and-drop a table control from the toolbox (Ctrl+Alt
+X). Right click the table control and select Properties. Then on the
General tab, select the dataset you just created below Dataset name:.
Select your header and footer rows via right-clicking the Header/
Footer row and selecting Properties. In the General tab select the
Value (Field from the dataset) you would like to display. If you just
want to display text, instead of right-clicking and selecting
Properties, right-click and select 'Expression...' and enter in
something like: ="Some text here." Do the same for the detail row.
If you want 2 table controls from different database tables, do the
same as above but create your dataset based on a single table or query
of your choice and then repeat for the number of different database
tables or queries you want to use. Just drag-and-dro the number of
different table controls you want to use in the report and repeat the
above steps. I hope this clarifies it a little better for you.
Regards,
Enrique Martinez
Sr. Software Consultant
Monday, February 20, 2012
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
Subscribe to:
Posts (Atom)