I'm running CR XI, and accessing .RPT files through a ReportViewer in my ASP.NET pages.I've already got the following code, which is supposed to set the Report Datasource dynamically.
rptSP = New ReportDocument
Dim rptPath As String = Request.QueryString("report")
rptSP.Load(rptPath.ToString, 0)
[code].....
I have a ReportViewer showing a report that is bound to a dataset. The dataset gets its data from a Access database backend. I have a separate form that allows the user to add/update/delete data. My problem is when the user makes changes to the data using the data entry form, the report does not reflect those changes. I have to close the entire program and reopen it before the changes take effect on my report. This piece is used to bound the report to the dataset
[Code]...
We had our Crystal Reports report sheets in 2008 working and when we moved to 2010, some of them which their datasources were binded to dataset and datatables are not working.
View 2 RepliesI created a program that I am testing for my company. The program works fine except when I try to print the report, I get an error. The Print feature works fine in the debugger on my computer, but when I publish the application and install it on another machine, then they cannot view/print. In fact, it will not even open the Print Form with the Crystal Reports Viewer.
I have an input Form where you add data to the database. When you hit the "Print Button", it is supposed to open another form with the Crystal Reports Viewer where you can view/print the data. I get the error right when I hit the button and the form won't open. Like I said, it works perfect in the debugger on my computer.
Here is the error - Unhandled Exception has occurred in your application. Could not load file or assembly 'CrystalDecsisons.Windows.Forms, VERSION=10.5.3700.0 CULTURE=Neutral PublicKeyToken = 62fbea5521e1304 or one of its dependencies. The system cannot find the file specified.
I recently did an upgrade on my computer.I went from Visual Studio 2008 to Visual Studio 2010.I also have Crystal reports 2008 installed. Everything seemed to be working fine for several weeks until Crystal Reports just stopped working.When I open crystal reports now it locks up.Crystal Reports opens up and goes to the start page but the hour glass never goes away and you cant do anything with the program.The screen just seems to lock up and the only way to exit the program is to end task.
Ive tried repairing the installation which didnt work and then I completely uninstalled crystal reports then did a fresh install which didnt work.You can also create a crystal reports with Visual Studio but before doing so you have to download Crystal Reports for Visual Studio for 2010.Visual Studio 2007 also had a crystal reports builder which I used for a while but I got to the point where I liked Crystal so much that I just went out and bought the whole program Crystal Reports program.After I installed crystal reports I could no longer create reports through visual studio 2007 interface,I had to create my reports indepently with crystal reports.That was fine with me because you had a much richer user interface with the full version.
Info.
Windows 7
Visual Studio 2010 ( recently upgraded from VS 2007)
.net programs on my computer.
.net framework 4 client profile, .net framework 4 extended, as well as 3.5, and 2.0
I have about 15 .RPT files on my .NET 2.0 site, and I recently changed to a new database server.I successfully changed the Datasource on 14 of those .RPT files, but on one, after making the change, I get "Failed to Save Document" when I try to save the updated report. I can change the subreport's Datasource, and save it just fine, but when I try to change the main report's Datasource I get that error message.I'm definitely doing a "Verify Database" at various times throughout the process, but that doesn't seem to help.
View 2 RepliesI am working on VB.NET(Visual studio 2008)..I completed developing my application and i need to deploy the application. I tried it and faced problems in some areas like adding crystal reports to the setup and deployment. I created a setup file to my application and everything is fine except crystal reports...its showing the error like; An error occurred in crystalDecisions.Reports, crystalEngine threw exception.
View 2 Repliestell me wat is the difference between crystal reports created in vb and in vb.net??how to create crystal reports in vb??
View 1 RepliesI am creating reports in Crystal Reports that is integrated within Visual Studio 2008, and I noticed that some of the features are disabled. One is the ability to link tables with a Right Outer Join or Full Outer Join. I also cannot "Show SQL Query" in Crystal Reports. Is this something I can enable or do I have to purchase or upgrade?
View 1 RepliesI want to create Reports using ReportViewer.
I tried and could able to achieve it by adding dataset and data-tables to the form.
But i want to add it using datasets.
I tried myself a little with VS Report Designer and it all went well apart that I'm having trouble to display 2 reports in one Report Viewer (Not two reports in the same time :P).Here a little info on what I'm using I'm using two dataset witch i feel with information through my functions.Until know if i select the report manual on the control properties it works well but only that single one.[code]but i doesn't work for me uuu one think you also should know is that I also use Parameters with i pass to the report, which works great on an single report.
View 2 RepliesHow do I assign datasource to my reportviewer?
Imports System.Data.SqlClient
Public Class frmExamAttendance
Private cnn As New SqlConnection(My.Settings.MyConnectionString)
[Code].....
Is it possible? I just want to reuse ReportViewer control to show a different report one at a time.
Can someone show some code snippet about it?
I am trying create a multiple reports using a single report viewer. can this be done, if yes can u give me a clue on hw to go on about it. i have done everything its just the part of having multiple reports
View 11 RepliesWithin vb.net is there a way I can dynamically create multiple reports using the same rdlc but with different SQL statements.So in essence I want to write a loop that will open the same report multiple times within the viewer which will end up having many pages..
View 1 RepliesI am generating crystal reports using sql statements but now i am looking 4 code to allow me to refresh the crystal report. in other words remove the datra on the report and wait for another query
View 1 RepliesHow can we create a report in vb.net without using any crystal reports
View 11 RepliesI have a form with a single Report Viewer control on it. I wish to use this single form to display ALL of my application's reports. I am looking for a method that will allow me to assign the rdlc file / table adapter and rebind the datasource at runtime. I've tried various methods but cannot get it working. It sounds simple enough but is now driving me crazy!!
View 2 RepliesI have installed on my computer Visual Studio 2010 Premium. I am working in a project, in VBasic.Net where I have to include some reports. Where can I find a good .pdf file training?
View 6 RepliesI am preparing crystal reports using vb.net 2008 with ms sql server 2005.everything is showing fine.. except that i want my report to be multiple column... I cant do this using "format multiple column" option because the data is not shown in details section. Actually i need to group the data in data.
e.g: i am preparing a warehouse report to know how much quantity of which products are left, products with 0 (zero) value are not displayed..
I want my reports to be as follows: item1 item_quantity item2 item_quantity item3 item_quantity
I have an app that has a DataGridView with a few buttons. My intent is to have the DataGridView populate with the data associated with the button clicked. So if you click the States button it'll fill the DataGridView with the DataSet I have created with a link to a SQL table with a list of States.
View 7 RepliesI'm using VS 2008 to develop a solution which will report on data mostly contained in SQL Express databases, across two servers. It will be used by up to about 10 XP clients. I am unfamiliar with the Reports Applications. Will I need to buy extra licenses to use a Crystal Reports application? Why are they both included in VS? What is the basic difference between them?
View 3 RepliesHow can I connect to a Crystal Reports 4.6 report that connects to SQL Server 2005 as a data source, using Visual Basic?I don't want to specify the connection string in the report. I want to pass the connection from VB. Is there any way to do this?
View 1 RepliesI am working on Windows Forms Projects.I am creating a report for customers.The report data is pulled from a "CustomerDetails" table.A field in the table is called "CustPhotoName", this holds a string which relates to an image file.
I Currently have a report set up which runs for a single customer by passing in a customer ID. Then using the passed in ID to populate a Dataset with an ImageRow and then a sub report with the image from the dataset.
I am wanting to set up this report where I can pass in an array of customer IDs and produce the reports (1 page per customer with image (if CustPhotoName has value))
I have created reports using Crystal Reports in my asp.net application(vb). It was fine. But when I run it in another system, the report loading fails. So I modified my code like this.
sub Loadreport()
try
Dim sreport as new ReportDocument
sreport.Load(Server.MapPath("ClientList.rpt"))
[code]....
When the control comes to the line:-
sreport.Load(Server.MapPath("ClientList.rpt"))
it jumps to the catch block showing "Invalid Report path". But initially, the code was not showing any error. I haven't changed the path.
I made a program in VB .net 2008 that has a form in which there is a Crystal Report Viewer object. Here is some code:
[Code]...
1. Some reports show tens and hundreds of thousands or records (they are required to do so, so no work-around is possible), thus the time it takes for the Crystal Report Viewer control to actually show the report is very long. I would like to display like a waiting dialog window WHILE the report is loading its records telling the user to wait for it to load.
2. Another idea would be to show the number of records currently loaded (and continuously updated as the report loads them) from the total number. This is actually shown in my reports when i open them with Crystal Reports 10, but NOT with the Viewer control on the form! How can i make it show this?
Since there doesn't seem to be any way to load old VB6 (ActiveReports) reports in .Net, I need to recreate dozens of reports in .Net. I'd like to do this in the least painful way possible.In VB6, the original authors simply did something like this for every report:
adoConn.ConnectionString = globalConnectionObject.ConnectionString
adoConn.Source = ReportFunctions.GetAllUsers()
GetAllUsers() returns an SQL string which selects a bunch of fields; those fields are then used in the report.Now:How can I do something similar in .Net (either using the built-in Crystal Reports, or the built-in "Microsoft Reporting Technology")?I can't get "Database Expert" to recognize globalConnectionObject (an ADODB.Connection object); and if I fill a dataset and do
report.SetDataSource(dataSet)
It tells me "The report has no tables."How do I populate a Crystal Reports report!? (the connection string/data location is not known at compile time)
I've recently made the switch from the Data Report to Crystal Reports 10. I've rewritten the reports our software uses and they are working fine in a nominal reports location.I have heard that Crystal Reports can be compiled into a single executable file which can be called through vb.net, rather than loading the report from a location.
View 1 RepliesI already installed crystal reports in my vb 2010. (i got it from the sap website) but crystal reports won't appear in the toolbar. i could add a new report, but i can't put it in my design form cause just like what i said, there's no crystal reports in the toolbox. i already checked crystal reports in the customize button of toolbar, but still it won't appear.
View 2 RepliesI am using the following code to output a Crystal Report to an ASP.NET application:
Dim rptDocument As New ReportDocument
Dim rptPath As String = Server.MapPath("Reports/Employees.rpt")
rptDocument.Load(rptPath)
[code].....