Settings In Crystal Reports That Modify Sort Order Of Data Sources?
Dec 3, 2009
I'm working with Crystal Reports in VB.NET in Visual Studio 2005.I have a List(Of Stuff) that I've sorted according to one of the object's members.I've verified in the debugger that the list is sorted correctly.When I define my list as the data source, as in
rptDetails.Subreports.Item("rptSubReport").SetDataSource(theListOfStuff)
and view the report, the list is reversed.So, looking for a workaround, I said, "OK, I'll sort the list backwards before binding it."The list still appeared backwards in the report.So something's happening, and I think it's within the report definition, because I don't know where else the sort order could be changed
View 1 Replies
ADVERTISEMENT
Feb 14, 2012
I am using crystal reports in visual studio 2005 to generate invoices. I want to sort different categories of products. I'm using group by on category field. How can i set a specified order in crystal reports for categories.I have for example 3 categories namely 'Recipe', 'Plain Spices', and 'Horeca'....The crystal reports shows them in ascending or descending order but i want Recipe data at top, then Plain Spices and Horeca in the end...!!How can I achieve this in my crystal report that has already been made?
View 2 Replies
Nov 5, 2009
I�m converting some Crystal reporting functions from VB 6.0 to VB .Net 2008, have reports up and running, and I�m not quite sure how to approach one aspect. The issue I have is most of the Crystal reports connect to a database and run a stored procedure. The connection properties are set up in the report usually pointing at the development region. At run time I need to be pointing to either development, user acceptance, or production. I know what environment I�m in from a configuration file but don�t know how to go about telling Crystal what environment and stored procedure to point at. In VB 6.0 it was:
CR1.Connect = "DSN=" & A.ReportServer & ";<<Use Integrated Security>>;DSQ=" & A.ReportManhattanDB
Where A.ReportServer and A.ReportManhattanDB contain the connection poperties. The stored procedure is passed via:
[Code]....
View 3 Replies
Jun 21, 2010
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 Replies
Apr 14, 2009
tell me wat is the difference between crystal reports created in vb and in vb.net??how to create crystal reports in vb??
View 1 Replies
Aug 31, 2009
I am new to crystal reports and i need some help in sending data from form to Crystal report.
View 2 Replies
Sep 27, 2011
Crystal Reports not showing after dynamic data insert.
View 4 Replies
Mar 5, 2012
I am getting data from an SQL Server database and displaying the data on a Windows form.How do I navigate through the data in a Sequential Order or Sort Order using the the REP_ID number? Example: When I use the navigation to move from one data to the other, can I go from; example: 100001 to 100002 and so on?
Finally is there any hint as to why I am getting the time with the dates? I know it is converted to text but not sure how to remove the time and just get the dates.Here is the entire project code:
Imports System.Data
Imports System.Data.SqlClient
Public Class frmBindingData[code]......
View 5 Replies
Aug 26, 2011
I 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 Replies
Jan 8, 2010
I have created a data source connection to an access db by using the wizard in vs2008. I have then used this as a data source for crystal reports. My user would like to put the database on a network and reference it there. Is there a way to set a new path for this data source during runtime?
View 4 Replies
Jul 16, 2009
I plan on designing a Crystal Report, and then calling it through VB.NET code. Will the end-user need a Crystal license in order to use the crystal report part of the program?
View 1 Replies
Dec 1, 2011
How can we create a report in vb.net without using any crystal reports
View 11 Replies
Feb 3, 2011
Working on a Migarition(VB6 to VB.Net(VS 2005)) application, where some of the reports are loaded in the application. The VB application is using the Crystal reports version 8. While migrating the application, we used the Crystal decisions and tried to load the report. Few of the reports are working fine, few are giving error(like boolean is required here, This field name is not known etc..). For few of the issues we have regenerated the report in CR XI it worked fine and few are giving the performance issue, but few reports are giving the same error as "This field name is not known".
To load the report we followed the steps.
1. Based on the user access level, the report connects to different DSNs.
2. Applies the LogonInfo to the report.
3. Sets the datatable as the datasource to the report
4. View the report.
If we run the application to load the report, it's throwing error as "This field Name is not known. Error in file C:Docs~UserLocal~TempSampleReport{EE6CC25A-D216-496C-AA95-E2F0C61718C6}.rpt:Error in Formula '{ViewReport.field} ="AB'"This field Name is not known".For this I have tried changing the setdatabaselocation in database expert.Still getting the error.The reports giving the error are using a View in it's Query. Is it causing the issue?
View 1 Replies
Sep 4, 2011
Im making an application that uses Google Maps Mobile (maps.google.com/m) and it uses a location sensor to give you results. How can i set that up? I would also like to try it with Google Buzz Mobile (m.google.com/app/buzz).
Dustin_K "There are 10 types of people in the world: those who understand binary and those who don't."
View 3 Replies
Jun 22, 2010
we have several applications in Vb.Net using the built in log system (My.Log) to write log information. Until now this system was configured by the application.config file before execution but now we want to let the user to choose some options.
Is there a way that does not requires to parse the XML file and process it? Is there available something like My.Settings that will do the dirty job done?
An example would be to be able to modify the DefaultSwitch value from Verbose to Warning or changing a property of the FileLog like the maxFiles attribute:
<switches>
<add name="DefaultSwitch" value="Verbose" />
</switches>
<sharedListeners>
[Code]....
View 1 Replies
Mar 17, 2010
how to modify local security settings for a remote pc in lan with vb.net?
View 3 Replies
Sep 26, 2011
I 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
View 2 Replies
Mar 23, 2009
keep the listbox sort order
View 3 Replies
Jul 23, 2011
I want to sort from ascending order so i will know where will be the first priority but i dont know what is lacking in my code and whats wrong with it.
Here's my code for sorting i dont know if this is right. It say's IndexoutOfrangeException was unhandled i dont know what's the meaning of that. . . .
Dim p() As Integer = {TextBox1.Text, TextBox2.Text, TextBox3.Text, TextBox4.Text, TextBox5.Text}
Dim a, c, d, f As Integer
[Code]....
View 4 Replies
Dec 22, 2010
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
Jul 26, 2009
How 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 Replies
Jan 28, 2011
I 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))
View 1 Replies
May 14, 2009
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.
View 1 Replies
Mar 29, 2011
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?
View 5 Replies
Jun 30, 2010
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)
View 2 Replies
Jun 5, 2011
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 Replies
Oct 1, 2010
I 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 Replies
Aug 5, 2009
I 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].....
View 3 Replies
Apr 18, 2012
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].....
View 1 Replies
Jan 15, 2012
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 Replies
