How to compile, distribute, and view a Crystal Report
Note: This functionality does not exist in version 8.5 and higher- I want to add crystal reports in application exe file when make installer of windows application on Visual Studio 2005. Like windows forms compile in exe file but crystal reports added in separate folder S~M~E~R But I don't want to add reports in SMER folder separate for security reasons.
- Compiled reports are reports that are compiled into an executable program that can be installed on the end user’s computer. The end user does not need a copy of Crystal Reports to view the report and will be able to view, refresh, and schedule running the report on a desktop.
- Using Visual Studio 2008 and Crystal Reports 2008 here. I have Crystal Report files (.rpt) in my solution. When I try to Debug or Publish my site, VS starts compiling.
Crystal Report Compile Execution
To compile a Crystal Report:- Compile the report from the workstation where the report was created
- With the report open, select Report, Compile Report from the menu bar
- In the Compile Report dialog box, enter the name of the report to compile and a location in which to compile the report
- Click the Yes radio button to create a program item for the report
Creating a program item means that this item is displayed in a program window after the report is compiled. - Click the Yes button to distribute the report after it is compiled
- Click OK
The report in the .EXE format can now be run on workstations which do not have Crystal Reports installed
What is happening is that crystal reports keeps referring to the database path used while compile. Therefore if the report is shown on the computer where it was compiled then it refers to the wrong database. However, if the exe and database is put on another system or we use msi and install the software on another system, only crystal reports.
How to use the Report Distribution Expert:Crystal Report Compile Exemption
- If Yes was selected in step 5 above, the Report Distribution Expert appears
- Make sure that the report and the report database file are saved in the same folder, and that the report has been set for that database
- Use the Browse button to determine the destination of the report to distribute
- Select the folder in which your report and database file are located
This functionality is not supported by Blackbaud. For more information on this functionality, please visit Business Object's website at: http://support.businessobjects.com/.
Crystal Compiled Report Executable
Converting Crystal Reports 9 report to Crystal Reports .NET report
I have a web page that is supposed to display a crystal report. The report is fully written and functional in crystal 9 (non-.Net) . Is there a way to convert my .rpt so that I can just include it in the new web site? why you don't try to compile project with .net and include your report. then if crystal report is power tool will suggests you with conversation tool My blog is here.Please remember to 'Mark as Answer' if this post answered your question! Wow it really was that easy! I just added the old crystal report into my .NET proj...
crystal reports .net -> crystal reports .net 2003
recently converted a project from .net to .net 2003. The 2 crystal reports I had in the project do not load when executing the application. The project itself within 2003 will allow me to multiplat the crystal reports, however when it comes to execution time I get the error: Invalid Data Source. If this isn't the right forum please point me to the right one as this is really the only website I know of with a large reader base. >to multiplat the crystal reports To what the crystal reports? Do you have the same database connections established and verified in your 2003 s...
Reporting. How to pass parameters to the report?
Hi! I try to realize how to use parameters in iReport. For example, i decide to investigate Novell report 'Identity Vault User Report' (http://cdn.novell.com/cached/designer/idmrpt401/Novell-Identity-Manager_IDV_User_Identity_Report.zip). Let's look at the -User- parameter. This one has -java.util.List- parameter class, and -new java.util.ArrayList()- Default value expression. As i understood, user list is passed to User parameter from reporting web page to report definition. The question is what I have to do to add some UI controls to 'edit' page ...
how to make printable reports without Crystal reports and SQL Reporting service
Hi guys I need printable reports in a web app , these reports must be colorful and well formatted ( header and footer ,lines around the page&…) the problem is because of the hosting situation unfortunately I cannot use neither of Crystal reports and SQL Reporting service also we cannot use extra components -that costs money for us- like PDF Creators . I've thought of two possible solutions. 1st I can do that in an HTML format 2nd it is possible to produce Images . Creating Image is extreme...
Bind crystal reports / sql reports to ADO.NET
Hi, I'm a beginner trying to find out if it's possible to directly connect an sql report/crystal report to an ADO.NET data set? It all depends on what version of Visual studio you are using. Here are the steps for VS2005 In VS2005 you need to do the following: 1) Right click on your solution and select add, New Item. 2) Add a dataset and create your queries in the dataset. Make sure you save this dataset or it will not show up later. 3) Add your reportviewer 4) Right click on your solution and select add new Item Again and then add a crystal report 5) In the cr...
Are there other reporting tools other than reporting services and crystal reports
Has anyone had any experience with any reporting tools other than Reporting services and Crystal reports? If so, is there one that you would strongly recommend? Or, are these two the top choice on the market for report generation from .NET? I have heard some moaning and groaning about reporting services. Specifically in regards to the amount of time needed to design a report. Crystal reports seems kind of difficult to me, as I don't have any training with it. Basically I am looking for a reporting tool that is easy to use, and can be used from .NET....
Giving Parameter in SQL Command of Crystal Report. and Passing to Database
If we are using Parameter Fields provided by the crystal report. First it is fetching all the data and then applying the parameter condition. This is very bad case for big tables.In Database expert instead of choosing the tables we have an option called 'Add Command' here we can give directly the sql command. there can we give the sql command with parameters like Select *from employees where employeeid = ?Please let me know any option available to pass parameter to DB from crystal report SQL Command.Please mark as answer if my post is useful and Please correct me if I am wrong anything...
How to passing a report parameter to another report
Hi, I have a sales report and that report have 2 parameters (start date and end date)so If user want to view a sales report from 1 april 2006 to 31 may 2006, he will enter :4/1/2006 in start date text box5/31/2006 in the end date text boxI need to build a report that have a drill down capability, so if user want to see a detailed report - for example he want to see all sales detail for 'chocolate chips' he just need to click on chocolate link and a new report will show up. My problem is : I don't know how to pass 'start date' and 'end date' parameter to another report (detailed report)....
crystal reports or sql reporting services?
Hi, Need to make a decision about which of these to go for. I'm looking to develop a web-based reporting solution which replaces a networked Access Database which displays stacked bar charts and line graphs and tabulated data. All the data will be coming from SQL Server 2000 databases on our intranet. I've got 2 yrs asp.net and sql server but no experience in either CR or SQL RS. Has anyone got experience in both of these technologies to help me out with the best way forward. All responses appreciated. Cheers. Both will do pretty much the same thing--get ...
Crystal Reports Parameters not appearing on the report
Hello everyone, I'm passing parameters to Crystal using C#. Then I'm trying to show the value of the parameters on the report, and it's coming blank. The parameters were previously created on the rpt, here's how i'm passing the values to them:1 relatorio.Load(Server.MapPath(@'RelatoriosTranspEscolarTotalEscola.rpt')); 2 3 relatorio.ParameterFields[0].CurrentValues.AddValue(CodigoSub); 4 5 relatorio.ParameterFields[1].CurrentValues.AddValue(CodigoMunicipio); 6 7 relatorio.ParameterFields[2].CurrentValues.AddValue(Ano); 8 ...
sql reporting services crystal reports
My computer has vs 2008 wish to use sql 2005 standard vista I wish to use sql reporting services , crystal reports, web services, ecommerce, wcf, soa, enterprise development in net, etc What is the best web hosts? I contacted orcsweb, discount asp.net. I wish to use a shared host.....What are my options.... enterprise development for commercial development maybe sharepoint Can I configure sql standard on my computer? I do not wish to use default settings what is the best way to do this? Hello, Maybe i...
SQL Server Reporting and Crystal Reports
Hello Friends,I will be thankful to you if you can throw some light on the following issue:1. Can i use SQL Server Reporting Service with Crystal Report? or they both are different things.2. IF i want to allow the user to choose the header and footer of report and also parameters that need to be displayed in report, can i achieve it with SSRS? In short i want to generate Dynamic Reports. How it can be achieved?3. I know that we can create PDF using SSRS, but is it possible to make it password protected? Awaiting for the response. Regards,NilPlease MARK POST AS AN ANSWER if it helps youM...
integration of Crystal Report with .NET ; crystal report viewer not displaying in Toolbox
Hi I m new to Visual Web Developer 2005 Express Edition. I want to integrate Crystal Report with .NET. In my Toolbox , Crystal Report Viewer is not displaying. How to make it possible? + How to call my report from asp.net 2.0. Need source code plz.*Share Knowledge Every TIME Crystal Reports for .NET does not come with VWD Express. It only comes with VS 2005 Professional (I'm not sure about the Standard edition).If you have Crystal Reports 10 or XI, you can installed the .NET libraries for Crystal and then use them within VWD Express, noting that you have to build your reports ...
about report reports generation and emailing reports
hi i am a bit new to Bugzilla, i am using 2.18rc3version. and i am facing two problems with report generation. 1) the checksetup.pl shows all the perl modules includig optional perl modules to be installed and available including thse required for graphical report generation. but despite this i am able to get tabular reports generated but when i click for line/bar reports of the same tabular report the next page does not show the required pie/bar reports. 2) is there any facility for sending these generated reports to the client via email through Bugzilla? kindly help. regards...
I have a web page that is supposed to display a crystal report. The report is fully written and functional in crystal 9 (non-.Net) . Is there a way to convert my .rpt so that I can just include it in the new web site? why you don't try to compile project with .net and include your report. then if crystal report is power tool will suggests you with conversation tool My blog is here.Please remember to 'Mark as Answer' if this post answered your question! Wow it really was that easy! I just added the old crystal report into my .NET proj...
crystal reports .net -> crystal reports .net 2003
recently converted a project from .net to .net 2003. The 2 crystal reports I had in the project do not load when executing the application. The project itself within 2003 will allow me to multiplat the crystal reports, however when it comes to execution time I get the error: Invalid Data Source. If this isn't the right forum please point me to the right one as this is really the only website I know of with a large reader base. >to multiplat the crystal reports To what the crystal reports? Do you have the same database connections established and verified in your 2003 s...
Reporting. How to pass parameters to the report?
Hi! I try to realize how to use parameters in iReport. For example, i decide to investigate Novell report 'Identity Vault User Report' (http://cdn.novell.com/cached/designer/idmrpt401/Novell-Identity-Manager_IDV_User_Identity_Report.zip). Let's look at the -User- parameter. This one has -java.util.List- parameter class, and -new java.util.ArrayList()- Default value expression. As i understood, user list is passed to User parameter from reporting web page to report definition. The question is what I have to do to add some UI controls to 'edit' page ...
how to make printable reports without Crystal reports and SQL Reporting service
Hi guys I need printable reports in a web app , these reports must be colorful and well formatted ( header and footer ,lines around the page&…) the problem is because of the hosting situation unfortunately I cannot use neither of Crystal reports and SQL Reporting service also we cannot use extra components -that costs money for us- like PDF Creators . I've thought of two possible solutions. 1st I can do that in an HTML format 2nd it is possible to produce Images . Creating Image is extreme...
Bind crystal reports / sql reports to ADO.NET
Hi, I'm a beginner trying to find out if it's possible to directly connect an sql report/crystal report to an ADO.NET data set? It all depends on what version of Visual studio you are using. Here are the steps for VS2005 In VS2005 you need to do the following: 1) Right click on your solution and select add, New Item. 2) Add a dataset and create your queries in the dataset. Make sure you save this dataset or it will not show up later. 3) Add your reportviewer 4) Right click on your solution and select add new Item Again and then add a crystal report 5) In the cr...
Are there other reporting tools other than reporting services and crystal reports
Has anyone had any experience with any reporting tools other than Reporting services and Crystal reports? If so, is there one that you would strongly recommend? Or, are these two the top choice on the market for report generation from .NET? I have heard some moaning and groaning about reporting services. Specifically in regards to the amount of time needed to design a report. Crystal reports seems kind of difficult to me, as I don't have any training with it. Basically I am looking for a reporting tool that is easy to use, and can be used from .NET....
Giving Parameter in SQL Command of Crystal Report. and Passing to Database
If we are using Parameter Fields provided by the crystal report. First it is fetching all the data and then applying the parameter condition. This is very bad case for big tables.In Database expert instead of choosing the tables we have an option called 'Add Command' here we can give directly the sql command. there can we give the sql command with parameters like Select *from employees where employeeid = ?Please let me know any option available to pass parameter to DB from crystal report SQL Command.Please mark as answer if my post is useful and Please correct me if I am wrong anything...
How to passing a report parameter to another report
Hi, I have a sales report and that report have 2 parameters (start date and end date)so If user want to view a sales report from 1 april 2006 to 31 may 2006, he will enter :4/1/2006 in start date text box5/31/2006 in the end date text boxI need to build a report that have a drill down capability, so if user want to see a detailed report - for example he want to see all sales detail for 'chocolate chips' he just need to click on chocolate link and a new report will show up. My problem is : I don't know how to pass 'start date' and 'end date' parameter to another report (detailed report)....
crystal reports or sql reporting services?
Hi, Need to make a decision about which of these to go for. I'm looking to develop a web-based reporting solution which replaces a networked Access Database which displays stacked bar charts and line graphs and tabulated data. All the data will be coming from SQL Server 2000 databases on our intranet. I've got 2 yrs asp.net and sql server but no experience in either CR or SQL RS. Has anyone got experience in both of these technologies to help me out with the best way forward. All responses appreciated. Cheers. Both will do pretty much the same thing--get ...
Crystal Reports Parameters not appearing on the report
Hello everyone, I'm passing parameters to Crystal using C#. Then I'm trying to show the value of the parameters on the report, and it's coming blank. The parameters were previously created on the rpt, here's how i'm passing the values to them:1 relatorio.Load(Server.MapPath(@'RelatoriosTranspEscolarTotalEscola.rpt')); 2 3 relatorio.ParameterFields[0].CurrentValues.AddValue(CodigoSub); 4 5 relatorio.ParameterFields[1].CurrentValues.AddValue(CodigoMunicipio); 6 7 relatorio.ParameterFields[2].CurrentValues.AddValue(Ano); 8 ...
sql reporting services crystal reports
My computer has vs 2008 wish to use sql 2005 standard vista I wish to use sql reporting services , crystal reports, web services, ecommerce, wcf, soa, enterprise development in net, etc What is the best web hosts? I contacted orcsweb, discount asp.net. I wish to use a shared host.....What are my options.... enterprise development for commercial development maybe sharepoint Can I configure sql standard on my computer? I do not wish to use default settings what is the best way to do this? Hello, Maybe i...
SQL Server Reporting and Crystal Reports
Hello Friends,I will be thankful to you if you can throw some light on the following issue:1. Can i use SQL Server Reporting Service with Crystal Report? or they both are different things.2. IF i want to allow the user to choose the header and footer of report and also parameters that need to be displayed in report, can i achieve it with SSRS? In short i want to generate Dynamic Reports. How it can be achieved?3. I know that we can create PDF using SSRS, but is it possible to make it password protected? Awaiting for the response. Regards,NilPlease MARK POST AS AN ANSWER if it helps youM...
integration of Crystal Report with .NET ; crystal report viewer not displaying in Toolbox
Hi I m new to Visual Web Developer 2005 Express Edition. I want to integrate Crystal Report with .NET. In my Toolbox , Crystal Report Viewer is not displaying. How to make it possible? + How to call my report from asp.net 2.0. Need source code plz.*Share Knowledge Every TIME Crystal Reports for .NET does not come with VWD Express. It only comes with VS 2005 Professional (I'm not sure about the Standard edition).If you have Crystal Reports 10 or XI, you can installed the .NET libraries for Crystal and then use them within VWD Express, noting that you have to build your reports ...
about report reports generation and emailing reports
hi i am a bit new to Bugzilla, i am using 2.18rc3version. and i am facing two problems with report generation. 1) the checksetup.pl shows all the perl modules includig optional perl modules to be installed and available including thse required for graphical report generation. but despite this i am able to get tabular reports generated but when i click for line/bar reports of the same tabular report the next page does not show the required pie/bar reports. 2) is there any facility for sending these generated reports to the client via email through Bugzilla? kindly help. regards...