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?
|
0 |
|
mcai6in2
7/25/2007 9:59:41 AM
asp.net.crystal-reports
7043 articles. 
0 followers.
3 Replies
1138 Views
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 crystal report wizard Select crystal reports wizard and the type of report you want
6) Under the data menu you need to select project data, then ADO.NET datasets. Assuming you saved your dataset it will now show up in this field and you can make your selection as well as create your crystal report.
7) Go to your Web page where you want to display the Crystal report and Add a Report viewer to that page: Toolbox, Crystal Reports, Report viewer
8) The code behind:
1 Dim dataSet As DataSet 2 Me.Cursor = Cursors.WaitCursor 3 Dim crReportDocument As CrystalReport1 4 Dim Con As SqlConnection 5 Dim Da As SqlDataAdapter 6 Dim conn As String = "Server=Your Server;Database=Your DB; User ID=sa;Password=Your PW" 7 Con = New SqlConnection(conn) 8 Dim sqlString As String = "" 9 Dim cmSQL As SqlClient.SqlCommand 10 cmSQL = New SqlClient.SqlCommand(sqlString, Con) 11 Con.Open() 12 Da = New SqlDataAdapter(sqlString, Con) 13 dataSet = New DataSet() 14 Da.Fill(dataSet, "This is where you put the name of your dataset created in the steps above") 15 crReportDocument = New CrystalReport1() 16 crReportDocument.SetDataSource(dataSet) 17 CView.ReportSource = crReportDocument 18 Con.Close()The way you pass SQL connection in line 6 is NOT recommended, but it is easier for me to show you how to do what you need to this way.Line 17 (CVIEW) is the name of my report viewer. You can name your report viewer what you want and then change CView to that name.Hope this helps.RegardsLawrence
|
|
0 |
|
Lawrence
7/25/2007 11:57:25 AM
Thanks for that!
|
|
0 |
|
mcai6in2
7/27/2007 8:58:48 AM
No Problem,
Let me know if you need more help.
Ps: Don't forget to mark answer if you don't have any more questions.
|
|
0 |
|
Lawrence
7/27/2007 1:11:17 PM
Similar Artilces:
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...
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 ...
VS .net 2005 Crystal reports ok to run on Crystal Reports XI?
I am getting mixed messages from the asp.net website hosting providers - some say they do not support Crystal Reports due to a $25,000 per cpu licensing fee, others say all I need to do is install Crystal Reports XI (about $500) on a dedicated server and it will run fine. Will Reports developed with the embeded Crystal Reports in VS 2005 run in a Crystal Reports XI environment? Thanks....
Cassini, VS.Net and Crystal Reports
Hi,I am working with Win XP home, Cassini and VS.Net.I would like to play with some Crystal Reports.I create the report in VS as CrystalReport1.I put a CrystalReportViewer on my web form. It does not get recognized as a defined object type but there are no build errors.When I run the app I get an error: Type 'CrystalReport1' is not defined.I have googled on this and see several things people have suggested/tried to correct this. Most I have already tried or the suggestions are not very clear to me. Then I came across a msg that instructed me to set up virtual directories for IIS for CrystalR...
Crystal Report.NET and nested sub reports
I have a report where i need to have several nested subreports... A parent may have childs and childs may have other childs and so on... CrystalReport.NET and VS2005 seems to support one level of subreport (a report could have a nested subreport but this nested subreport can't have another nested subreport). I really need to handle multiple levels of nested subreports in order to complete my report. What is the solution ??? Thanks Eviral I'm not positive if this works but its worth a shot. Create the subreports as se...
Reporting (Crystal Reports vs. Custom .NET)
Ok, so I have to confess, I have never tried Crystal Reports. I just recently started working for a marketing company now and reporting is VERY important to them. I am currently migrating a lot of the applications they use from VB5 and VB6 to web based .NET 3.5 apps. The whole company is running off ACCESS databases if you can believe that. They sometimes have up to a few hundred agents taking sales on incoming calls and chat sessions and they are all getting streamed to FLAT file records (completely un-normalized database). I am in the process of developing a c...
Errors with all my reports after upgrade from Bundeled Crystal.NET (VS2003) to Crystal XI Developer for .NET
All my Crystal reports were developed using the bundled Crystal in VS 2003. I just installed the Crystal XI for .NET Developer version that we purchased and now I get an error when running my reports. (I am running them in debug mode on my development machine). I have tested it on several different reports. I did not change the code, this worked fine in the previous version. First I reference my report (AccountList is the AccountList.rpt report that is in my project): Dim myReport As New AccountList Then I start rolling through the report's tables to update the log...
View report from the crystal report server using .NET
Hi,I am first time dealing with crystal report and I having problem with it. I need to use asp.net to link to the crystal report server and view the report, but don't know how? Is there a way to do that? or is there any better way to using .net and view report from the crystal report server?Thanks....
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...
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....
Creating Reports using Crystal Reports for Visual Studio .NET
Hi i am trying to create a crystal report using C# coding but instead of creating a web application under new project i decided to choose create an asp.net website with C#. The problem is i get:- The report you requested requires further information. --------------------------------------------------------------------------------XP\SQLEXPRESS Server name: Database name: User name: Password: All data is present except my password when i enter it, it works fine and the report works too with no problems. How do i ...
Export Crystal Report to Crystal Report format
I looked at some sample code provided by crystaldecisions, and they have the ability to export a web crystal report to a crystal report. I was assuming that this would cause the local instance of Crystal reports on the client machine to be invoked. I tried this in my project, and I get the following error: Error Encountered by Crystal Web Report Server -------------------------------------------------------------------------------- The error message returned is: Connection to Report Server Failed. It creates the file as an .rpt file in the directory it should. Do I need a dif...
ado.net in crystal report
any one know or have source code about using crystal report connecting to ado.net please help me.??? propick2b@hotmail.com Try this web site http://www.codeproject.com/aspnet/crystal_report.asp which uses DataSets We use Crystal with oledb provider but started to move the reports to Data Dynamics report writer Hope it helps > any one know or have source code about using crystal > report connecting to ado.net please help me.??? > propick2b@hotmail.com ...
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...
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 ...
VS .net 2005 Crystal reports ok to run on Crystal Reports XI?
I am getting mixed messages from the asp.net website hosting providers - some say they do not support Crystal Reports due to a $25,000 per cpu licensing fee, others say all I need to do is install Crystal Reports XI (about $500) on a dedicated server and it will run fine. Will Reports developed with the embeded Crystal Reports in VS 2005 run in a Crystal Reports XI environment? Thanks....
Cassini, VS.Net and Crystal Reports
Hi,I am working with Win XP home, Cassini and VS.Net.I would like to play with some Crystal Reports.I create the report in VS as CrystalReport1.I put a CrystalReportViewer on my web form. It does not get recognized as a defined object type but there are no build errors.When I run the app I get an error: Type 'CrystalReport1' is not defined.I have googled on this and see several things people have suggested/tried to correct this. Most I have already tried or the suggestions are not very clear to me. Then I came across a msg that instructed me to set up virtual directories for IIS for CrystalR...
Crystal Report.NET and nested sub reports
I have a report where i need to have several nested subreports... A parent may have childs and childs may have other childs and so on... CrystalReport.NET and VS2005 seems to support one level of subreport (a report could have a nested subreport but this nested subreport can't have another nested subreport). I really need to handle multiple levels of nested subreports in order to complete my report. What is the solution ??? Thanks Eviral I'm not positive if this works but its worth a shot. Create the subreports as se...
Reporting (Crystal Reports vs. Custom .NET)
Ok, so I have to confess, I have never tried Crystal Reports. I just recently started working for a marketing company now and reporting is VERY important to them. I am currently migrating a lot of the applications they use from VB5 and VB6 to web based .NET 3.5 apps. The whole company is running off ACCESS databases if you can believe that. They sometimes have up to a few hundred agents taking sales on incoming calls and chat sessions and they are all getting streamed to FLAT file records (completely un-normalized database). I am in the process of developing a c...
Errors with all my reports after upgrade from Bundeled Crystal.NET (VS2003) to Crystal XI Developer for .NET
All my Crystal reports were developed using the bundled Crystal in VS 2003. I just installed the Crystal XI for .NET Developer version that we purchased and now I get an error when running my reports. (I am running them in debug mode on my development machine). I have tested it on several different reports. I did not change the code, this worked fine in the previous version. First I reference my report (AccountList is the AccountList.rpt report that is in my project): Dim myReport As New AccountList Then I start rolling through the report's tables to update the log...
View report from the crystal report server using .NET
Hi,I am first time dealing with crystal report and I having problem with it. I need to use asp.net to link to the crystal report server and view the report, but don't know how? Is there a way to do that? or is there any better way to using .net and view report from the crystal report server?Thanks....
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...
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....
Creating Reports using Crystal Reports for Visual Studio .NET
Hi i am trying to create a crystal report using C# coding but instead of creating a web application under new project i decided to choose create an asp.net website with C#. The problem is i get:- The report you requested requires further information. --------------------------------------------------------------------------------XP\SQLEXPRESS Server name: Database name: User name: Password: All data is present except my password when i enter it, it works fine and the report works too with no problems. How do i ...
Export Crystal Report to Crystal Report format
I looked at some sample code provided by crystaldecisions, and they have the ability to export a web crystal report to a crystal report. I was assuming that this would cause the local instance of Crystal reports on the client machine to be invoked. I tried this in my project, and I get the following error: Error Encountered by Crystal Web Report Server -------------------------------------------------------------------------------- The error message returned is: Connection to Report Server Failed. It creates the file as an .rpt file in the directory it should. Do I need a dif...
ado.net in crystal report
any one know or have source code about using crystal report connecting to ado.net please help me.??? propick2b@hotmail.com Try this web site http://www.codeproject.com/aspnet/crystal_report.asp which uses DataSets We use Crystal with oledb provider but started to move the reports to Data Dynamics report writer Hope it helps > any one know or have source code about using crystal > report connecting to ado.net please help me.??? > propick2b@hotmail.com ...
Web resources about - Bind crystal reports / sql reports to ADO.NET - asp.net.crystal-reports
Crystal - Wikipedia, the free encyclopediaThis article is about crystalline solids. For the type of glass, see Lead glass . For other uses, see Crystal (disambiguation) . A crystal or ...
Wellington, the town in NSW where crystal meth costs less than beerOne NSW town is so overrun by the drug ice that it is known as "little Antarctica", and police say children as young as 10 are experimenting. ...
Steve McClaren irate after Newcastle United's humiliating loss to Crystal PalaceSteve McClaren will haul his embattled Newcastle squad in for an extra training session on Sunday following their humiliating defeat at Crystal ...
Whoomp! There It Is Crystal Pepsi Is Coming BackPepsiCo has made it official: Crystal Pepsi is coming back, but only for a limited time via a sweepstakes. The marketer hinted at a comeback ...
Crystal Security is a compact cloud-based malware detector... with real-time protection and you’re generally weighing down your system with services, drivers, DLLs, background processes and more. Crystal ...
Former CIA Chief Morell: ‘Crystal Clear’ Obama’s ISIS Strategy Is Not WorkingFormer CIA Chief Morell: 'Crystal Clear' Obama's ISIS Strategy is Not Working
The 18-year-old man accused of killing a kitten with his bare hands had become enraged during an argument with his sister over a bong, a prosecutor ...
CEO: My 'crystal ball' is smoky
Here's what is keeping Corporate America on the sidelines, according to Waste Management CEO David Steiner.
Here's what is keeping Corporate America on the sidelines, according to Waste Management CEO David Steiner.
Return Of Crystal Pepsi Confirmed, But You Can’t Actually Buy ItA few months ago, the word on the street was that Pepsi was bringing back a carbonated ’90s icon, Crystal Pepsi . The clear-caffeine-free beverage ...
Casey Wilson & June Diane Raphael Set Elizabeth Laime Comedy ‘Crystal’ At ABC... duo, USB alums June Diane Raphael and Casey Wilson , have teamed with comedy writer/podcaster and fellow USB-er Elizabeth Laime for Crystal ...
Resources last updated: 12/16/2015 1:55:33 PM