I'm using my data objects in a crystal report. The thing is, when I select my object, it gets added to the field explorer table. My properties are listed except for the Nullable Type properties. Why would this happen. I've had quite a few issues yesterday as this is my first attempt at a crystal report in .Net. I thought I worked around them but now I've hit this snag.
View 11 RepliesI 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 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 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 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?
If it is possible can I please have a few pointers use Crystal Reports XI with .Net 2008 Express?
View 2 RepliesI can create a program or web page that can display crystal reports. I have searched and searched with google but am still none the wiser. I foolishly assumed that there would just be some .NET SDK on the Crystal Reports website, and there isnt... there is a lot of talk about it, but no download link or anything.They are using Crystal 8.5 - does anyone have a clue how I can even get started with this? Will there be an SDK on the Crystal CD or something?
View 4 RepliesI need help in making my Crystal Reports in ASP.NET. I'm using VB.NET. This is my source code
Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
Dim myConnection As New OleDbConnection("Provider = Microsoft.Jet.OleDB.4.0; Data Source = " & Server.MapPath("Sartorius.mdb)"))
Dim MyCommand As New OleDbCommand
[code]...
I'm having errors in making the orpt object. It says that CrystalReport1 is not defined though I already created a CrystalReport1.rpt file on my solution.
A couple of things firstly When I create a new Crystal Reports file (using the built in Crystal Reports in Visual Studio) I create a blank document. I then insert a Text label type text and goto properties and Visual Studio Exits with no rhyme or reason. No error. Anyone experienced this or get any ideas?
Secondly I have a form with a load of text boxes in a column/row arrangement and text labels as column headers. I then want to be able print these in nice view (I have a certain way I have to display the print out.
I have never used Crystal Reports but I thought this would be the way to go about it. Is this right or is there another easy way? If it is can anyone point me to any example (preferablly begginer and basic) that I can read and learn from?
I have a VB.NEt app developed on XP using Visual studio 2008. My crystal reports work fine on XP but if I install the app and try to run the reports on Vista I recieve the following error message - can somebody offer a fix.
[Code]....
I'm buiding an app that loads a crystal report document but it's loading the document from my local drive. I need to embed the crystal report i think because I don't want it reading from the local drive because I'm looking to deploy this to other users when it's done. Are there any other options?
View 1 RepliesIs there a way to make VS2008 work with the old (vs2005 crystal reports) assemblies and not require any updates to be installed in the client machines? We have upgraded a Visual Studio 2005 .net 2.0 solution to Visual Studio 2008. The purpose is to take advantage of the IDE improvements and because it supports multi targeting. The solution still has to be built against .net 2.0. It all works as advertised, we rebuild and run it in a machine with only .net 2.0 installed.
But during testing we get an exception when we try to show a Crystal Report that is included with the application. Then upon review we find out that without telling us, Visual Studio changed the references to the crystal assemblies and pointed our solution to the updated versions that come with vs2008, which requires crystal runtime be updated on client machines. We did try removing the references and adding the old ones but it won't compile.
We always get this error whenever we try to run the form that has the Crystal Reports viewer on the unit to which we deployed our application. Attached is the screenshot of the generated error and the complete error description.
View 2 Repliesdoes anyone knows how to develop dlls for crystal reports 2008?My OS is Windows7 x64 but i would like to develop dlls for x64 and x86, i won't mind to compile them separately.
View 1 RepliesI have: Dim nVar1 As Long?Dim nVar2 As Long?Dim nVarSum As Long?nVar1 = Nothing nVar2 = 5 nVarSum = nVar1 + nVar2 I would prefer the result to end with nVarSum being 5, instead of Nothing. I understand if you add something to an unknown value, you will end up with "somthing + unknown" or x+5 will always equal "x+5" not "5" because you are still carrying around that unknown "x". However, how can I effectively treat an unknown or Nothing as a zero for the purposes of addition in this case?(What is basically happening is that the end user is sending us a data file, this code parses that file and then sums together about 15 fields. If the user leaves those fields blank instead of assigning a zero to them, I need to treat it as if it was a zero for this one addition operation, but all the rest of the code needs to continue seeing it as a Nothing value since the user did not ACTUALLY submit zero... they submitted blank or nothing)
View 3 RepliesCan Nullable Types be used in VB.NET? If so, is it possible to have a Nullable Integer that I can use with a field that accepts NULL in SQL Server?
View 4 RepliesI'm converting an Access VBA app to VB.NET. It has dates defined as variants or objects to handle null values. I thought this would be a great chance to use the Nullable type. But I can't get it to work. Either it is inappropriate for what I am trying to use it for, or I am doing it wrong. Anyone know how to use it? Reader is a SqlDataReader.
[Code]...
I was hoping I didn't have to put a lot of If .. Null statements throughtout the code, but that is my only option unless someone has any other idea.
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 RepliesI have added the references but I go to add ew item Crystal Reports still doesn't show.
View 8 RepliesI have upgraded an existing project to be developed on Visual Studio 2008 but I still need to target the .NET framework 2.0My project had the prerequisite Crystal Reports for .NET Framework 2.0 but Visual Studio 2008 reports that that "could not be found for bootstrapping"Now my users get the error:Could not load file or assembly 'CrystalDecisions.CrystalReports.Engine, Version=10.5.3700.0, ...' or one of its dependencies. The system cannot find the file specified.
View 3 RepliesI recently upgraded to Crystal Reports 2008 for the barcoding functionality. When we use the barcode in the report designer, it renders as expected, so we installed the Crystal Reports 2008 redistributable package on our dev server to test deployment, but we receive the error message listed below. I cannot locate any information about this issue on the business objects site, or azaleas site, or any info regarding deployment of barcoding functionality.
[Code]....
I have been trying to connect a Crystal Report app. to a database. I have had a hard time with this. It is working on my dev box, but it will not work on any other boxes. I have read some posts about adding logon info and connection info. I have followed these posts, but I am still unable to connect. Here is what I have thus far:
[Code]...
C#'s 'as' keyword will let you do this: int? input = value as int? Here's what I would assume the vb.net equivalent would be: Dim input As Integer? = TryCast(value, Integer?) There's an intellisense error in the TryCast stating the operand must be a reference type but Integer? is a value type.
Intellisense on Nullable(Of Integer) says 'Represents an object whose underlying type is a value type that can also be assigned null like a reference type.' It seems C#'s 'as' handles this like a reference type where TryCast doesn't have this built in. In VB10 I was able to take advantage of the new CTypeDynamic function to do the casting. Conversion.CTypeDynamic Method
Dim input As Integer? = CTypeDynamic(Of Integer?)(value)
Or:
Dim input As Integer? = CTypeDynamic(Value, GetType(Integer?))
There's a cost here as CTypeDynamic examines the type at runtime.
My question is what is the elegant way to handle this without CTypeDynamic?
Dim input As Integer? = TryCast(value, Integer?)There's an intellisense error in the TryCast stating the operand must be a reference type but Integer? is a value type.Intellisense on Nullable(Of Integer) says 'Represents an object whose underlying type is a value type that can also be assigned null like a reference type.'It seems C#'s 'as' handles this like a reference type where TryCast doesn't have this built in.
View 1 RepliesHow do I go about importing existing Crystal Reports to a new VS2008 project?
View 1 Replieshow to create a setup in vb.net that comes with a ms access database and the .net framework if it is not existing in the system.. and also a crystal report... and also i want my database go automatically to C:
View 9 RepliesI have recently been working on a number of sections of code that deal with the insertion of Nullable types into a database. As I'm sure anyone who has dealt with similar code will be aware of the annoyance of constantly writing conditional logic to deal with the insertion of nulls into a database. I.e.:
MyValue.HasValue ? MyValue.Value : DBNull.Value;
If(MyValue.HasValue, MyValue.Value, DBNull.Value)
Basically I am just wondering why DBNull.Value exists and why Null simply couldn't be used?
It seems like overkill to set the value of a nullable type and implement iNotifyPropertyChanged. Is there a better way of doing this?
[Code]...
I am trying to query for records where that column IS NULL:
Dim UnassignedSubSvc =
From c In CurrentContext.SubService
Where c.Product.ProductSubServiceId **is null**
Select c).ToList()