I'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 Replies
I 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 RepliesI currently have a simple crystal reports application which generates a crystal report and in the built in viewer provided by VS2005. There is a drop down where you can select options to change the criteria of the report. I wish to convert this app to a windows executable which will take all those select options and generates pdfs based on the crystal report. the executable will be triggered by windows task scheduler...or maybe command line app?
Obviously this will be somewhat of a re-write. What would be the best way to start this as? a crystal report application or a windows application.
I want to know how i can add reports either crystal or microsoft to a folder called reports in my application and then for them to be displayed in my menu tool bar under reports and then for them to run once clicked. I know it can be done its just how it is done.
View 2 RepliesI have developed a multithread Windows Application that requires to print various Docss/rpt's off. The problem is I get a "Load Report Failed" error message when creating a new instance of my embedded crystal report.
View 3 RepliesI have a project that uses a crystal report and I'm planning of deploying it.The problem is, is there a common setup for the components that was used in my project so I don't need it to manually register on the client pc?
View 2 RepliesI've been asigned to a new project. I have to mantain an application wich was made in Visual Studio 2003 (VB.NET, Framework 1.1) and Crystal Reports wich came included with the IDE. The application is absolutely what we call "legacy code" :).Just to make the test, today I've tried to convert the application in Visual Studio 2010. The converter is offering me download SAP Crystal Reports, with no cost and no registration.The question is: Does anybody has experience with this components?. Is feasible to migrate an application as described to VS 2010?
View 1 Replieshow to create Crystal Reports for Visual Studio 2005 for a Client Server application? The problem I faced is that when I created Crystal Reports for Visual Studio 2005 where the Crystal Report is displayed in the client application it does not get refreshed with data entered. It only displays data that was entered during the time of development. I think this is probably because the database path changes when deployed in a new environment while the Crystal report keeps referring to the database location at development time.
View 1 RepliesI have a stored procedure that takes in 2 parameters and returns an integer value. I would like this value to be the value for a gauge chart on the page. The 2 parameters will change depending on the attributes of the selected item. Is there a simple way to pass the one value from the stored procedure to the chart to display? This will be embedded in an asp.net application (vb) - so depending on the previously selected item, the values for the parameters and result will change.
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 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 RepliesHow can we create a report in vb.net without using any crystal reports
View 11 RepliesI have developed a windows database application in vb.net 2008 express and sql express 2008. Is there a way to create reports in the application?
View 2 RepliesI have just written an application in visual studio 2005, and would like to publish it for use on another computer. When I try to run the publisher, it fails and reports that it is missing an XML file that is located in the bin folder. I have checked the bin folder and the file is there. I am not sure what I am doing wrong? Has anyone else seen this type of error before?
Also, I should point out that while I was creating this app, I would some times copy the project to my desk top, and then change the name of the project folder. For example: myProgramV0 would be come myProgramV1. Then I would copy this back into where I normally keep my VB projects. I do not know if this had an effect on the program or not.
I can articulate my question well enough to get some clear and usable feedback here. I have reports (like paper reports) in my .NET application that have data bound to them. Typically the reports are a combination of many data elements across several busniess entites that may not all relate through an Inheritance hierarcy, etc. This makes it difficult to get all the needed data placed together to bind to the report.
So what I have done before are make 'Report' classes with data elements specific to supporting the reports they are bound to, and on the back end might be tied to specially created Stored Procedures that bring this data back (maybe several joins across many tables to get the right data needed). So if I was to make an analogy to the database world, I am essentially 'denormailizing' the data structure to get all of this data into a single class to make it easy to bind to the report.
However on the hard line OOP concepts and architecture design, one could say that a report is just another 'thing' to bind data to, and its class should not be designed just to suit the needs of data binding. In this thought process, I would actually need to make my class design be able to create the relationships needed to get all of the data together properly to still be bound, but not create any special 'Report' classes. I find this difficult to do sometimes. It is much easier to create these relationships in the back end stored procedures and then just output the resultset to be almost immediately bound to the report.
So what is the right way to solve this? If I create these specialized report classes with really no behavior, am I introducing an anti-pattern like the Anemic Domain Model?I could use some feedback, and please speak up if my question and scenarios did not make sense.
We created a VB.Net application which includes SSRS reports that runs on my development computer. Do you know of a step by step guide that steps us through deploying the reports on our customer's computer? We will be installing SQL Server 2012 Express Advanced on the target computer then configuring the reporting services then installing the application. The last part we need help with is to install the reports themselves on the target computer.
View 1 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
Basically, I am looking for a method on how to preview reports from a datagrid or it can be from the access database which populates the data to the datagrid (then displays this in the datagridview) in vb.net vs 2010.I believe there are two methods using the ReportViewer or using Crystal Reports, but so far, I have no idea how to get them to work. The first idea would be favourable - using the data from a datagridview (which may of already been sorted, filter etc) and be able to produce a report on that.
View 1 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].....
I want to create a Crystal Report for particular engineer installation details. In that report I want to show to no of installation details for particular engineer.Report model looks like this:
totalnoofinstallation assignto c_address c_mobileno package_det frm_date to_date
3 FE01 Ramnagar 232345 xx 25-04-2012 05-04-2012
SQL Server table data look like this:
[code].....
I want to create a report based on some criterias such as dates or names. For example, the user will select the dates from a combo box above and the report to be displayed in some type of container such as a panel for example. Is that possible? My software is like some inventory program, basically just counting no of items in the container and the ones that were delivered. Then at the end of the report, I need to mention the number of items that are still in th container and the ones that were delivered.
View 6 RepliesThe "Details" fields keeps repeating itself for example its showing it 4 times instead of one!this is my code[code...]
View 7 RepliesI am in the process of creating a reporting module. I am stumped on trying to load a report from an existing saved report with an OpenFileDialog. The report that is selected will not load into the CrystalReportViewer. I receive the following error:
Private Sub OpenToolStripMenuItem_Click(ByVal sender As System.Object, _
ByVal e As System.EventArgs) Handles tripMenuItem.Click
' Open an existing report file.
[code]......
