I'm designing a program using VS.NET 2008 and Crystal Reports 2008, and I want to give the user the option to set how many groups per page is viewed. I know I can do it using the Group Expert, but is it possible to set it programmatically in VS.NET?
View 1 RepliesIs it possible to create crystal reports in vb.net programatically at run time? There will be no typed dataset because I don't know what fields will need to be in it until the user clicks "Print".
View 12 RepliesRecently, I unfortunately installed Windows Vista x64 on my computer! Now, besides all other problems, I realized that Crystal Reports which has been installed with .Net 2005, isn't compatible with Vista x64. I searched internet & realized that I need a redistribution kit named "CRRedist2005_X64.msi" but I can't find the file itself!
View 6 RepliesI am using VS 2008 standard edition to develop my first windows form application and it does not come with crystal components. I nedd to design few reports but I can't find any help on the net. In my vba application I create one form which accepts all parameters and based on parameter I build SQL statement and pass it to report data source. I would like to similar in vb.net, but all I see is cryatal. Can I create reports without Crystal?
View 1 RepliesWe connecting a stored procedure in a crystal report.
In the query analyzer we can call the SP with: execute test 'example'
If we run the crystal report we get the possibillity to fill in the parameter for this SP. The report looks fine but how can we send this parameter in the crystal report script??
I 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 have one working and displaying my data and can change it using my ListView when an item in the list is picked.Now I need to change some of the labels on the report at runtime and cant seem to do it?If i have textbox on th report I can change its text at runtime I just cant seem to do it with the label controls that show in the report as IFieldObjects
Code:
Dim myReport
myReport = New CrystalReport1
[code]....
Can I do this with the label controls or should I try and change all the bound IFieldObjects to TextBox controls?
I have written an application which manages some bookings, and want to use Crystal Reports to provide the reporting engine. I have used it before with datasets with no problems.
I am using EF4, and have a LINQ query and report datasource assignment as below:
Code:
Dim ActiveCustomers = From Customer In FMEntities.Customers
Where Customer.Status = 1
Select Customer
[Code].....
I have read up that I may need to convert the incoming data, but I am confused as to what it needs to be converted to. Should it be a datatable?
I am using vs2005 for developing one project..i have to find Total amount for each page report ( using crystal report and report viewer ..and the report have AMOUNT coloum to display amount) programically..
View 2 RepliesI'm using Visual Studio 2005 and writing in VB.NET.I have a subreport in a Crystal Reports report consisting of a list of log entries. Sometimes the list of log entries is long enough that it would extend onto the next page. What I see happening is that the list appears on the next page, leaving a big blank space at the bottom of the first page.
I've tried unchecking the "Keep Together" boxes in the "Experts" in a number of different places (sections, groups, etc.) but see no change in the output.I'm guessing that this isn't the right way to go, but do you know what is?
I have this code in my form (in load event) wherein there is a crystal report viewer: there is a "A number is required here" error in [Code]. how can I solve this error?
View 3 RepliesI've been working on a report and it has 2 subreports, one of them can outgrow the region destinated for it (on a preprinted paper), and I want to break the subreport on a new page of the main report (with page header and page footer).
View 2 RepliesIs it possible to see the page setup during print preview of crystal reports during run time?
Because there are times that we need to set the top and bottom margin of the report.
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'm creating a report where I want to send a parameter for the number of records to display (I do not want to select the number of records in SQL) I have created a parameter field (?topN) and set the group to use this value which in design mode works well however when I try to set this parameter in vb.net code it does not work. The field which also displays the value shows the parameter correctly though.
View 2 RepliesI'm creating a report where I want to send a parameter for the number of records to display (I do not want to select the number of records in SQL)
View 2 RepliesI am trying to design a report where one filed can be multiple lines and the other related field should be located below (See attached)
address may be 1 one or more lines, city state zip should be located just below.
I already have the field set to can grow, however the spacing is the issue. How do I make the spacing adjust at runtime depending on the number of lines in the field. I can space it to say 3 lines, but if the address filed is only 1 line it leaves a 3 line gap.
this event works ok, but the problem is that I don't know what field was clicked. Should I use objectinfo or something else? VB.net won't recognize for example e.objectinfo.
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 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 RepliesHow can we create a report in vb.net without using any crystal reports
View 11 RepliesFor a race, I am trying to evenly disperse the heats for smaller race groups within those of larger race groups. I do not want the smaller groups to finish too early and I am also trying to minimize groups running back to back heats.
As an example:
Group A has 4 heats
Group B has 2 heats
Group C has 1 heat
The resulting schedule would look something like this:
A1 B1 A2 C1 A3 B2 A4
To complicate things, there could be any number of race groups and each race group can have any number of heats.
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
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 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 Replies