DB/Reporting :: Crystal Reports & Entity Framework 4 With Nullable Types
Jul 6, 2011
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?
View 1 Replies
ADVERTISEMENT
Jul 21, 2011
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 Replies
Nov 19, 2008
I'm using a 3rd party tool to generate my model including code classes for the MS Entity framework. What I wanna do is etablish a real layer application. I'm speaking of the layers:
Presentation
Business
Data
If I'm not wrong the generated classes represent the data layer. My question is if I should wrap this classes up for my business layer or not. In some way these generated classes already represents the logic of my application as it was derived from my database. But is this enough?
I definitely wanna use LINQ as well which works pretty good with the generated classes alone.
I'm looking forward to any comments.BTW: It's going to be a ASP.NET web application. I have used the projetc type "class library" for the data layer. The web application will use this DLL.
View 1 Replies
May 17, 2012
I'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 Replies
Feb 21, 2008
I 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 Replies
Oct 10, 2010
how 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 Replies
Dec 21, 2009
Recently, 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 Replies
Mar 2, 2010
I 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 Replies
Mar 19, 2009
We 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??
View 3 Replies
Oct 8, 2008
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 Replies
Jul 27, 2011
I am trying to build a survey engine from an existing database design which is like this.
[Code]...
The line Order By Key.RecordOrder throws a null reference exception and I can understand why. Can someone advise on how to resolve this by just modifying this one query? I am fairly new to LINQ and the necessity to write this project
[Code]...
View 1 Replies
Dec 13, 2008
I 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?
View 3 Replies
Jul 8, 2009
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 Replies
May 13, 2010
c# - Are Microsoft Entity Framework and ADO.NET Entity Framework (.edmx) the same?
View 7 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
Jul 22, 2009
I want to update an entity without loading the entity from the database first. I've accomplished this but only by knowing all of the entities properties and then using the "attachto" method. My issues is i don't want my app to need to remember all of the properties. Example:
[Code]....
View 3 Replies
Dec 14, 2011
Entity Splitting: one class, two or more tables.Here is how it is done in C#, but I need to get it working in vb.net.One more thing: the class name and table columns do not match, so I have to be able to map that out, too.I have to get this to work this way because the place I'm working at right now is a vb.net only shop and the database schema is fubar, but they have so much (millions) of lines of code done directly against the database in both asp classic, vb.net, AND asp.net webforms that changing the schema right now is not realistically possible.
protected override void OnModelCreating(DbModelBuilder modelBuilder)
{
modelBuilder.Entity<Post>()
.Map(m =>
[code]....
View 1 Replies
May 10, 2008
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 Replies
Jan 16, 2011
I am trying to jump from ASP Classic to asp.net. I have followed tutorials to get Entity Framework and LINQ to connect to my test database, but I am having difficulties figuring out ExecuteQuery(). I believe the problem is that I need an "entity class" for my database, but I can't figure out how to do it. Here is my simple code:
Dim db as New TestModel.TestEntity
Dim results AS IEnumerable(OF ???) = db.ExecuteQuery(Of ???)("Select * from Table1")
From the microsoft example site, they use an entity class called Customers, but I don't understand what that means.
View 1 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 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
Aug 27, 2010
I 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 Replies
Jun 27, 2012
Can 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 Replies
Aug 25, 2010
I'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.
View 11 Replies
Feb 15, 2011
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?
View 6 Replies
Nov 15, 2011
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 Replies
Aug 24, 2011
I 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?
View 1 Replies
Jan 17, 2010
It seems like overkill to set the value of a nullable type and implement iNotifyPropertyChanged. Is there a better way of doing this?
[Code]...
View 2 Replies
May 4, 2012
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()
View 1 Replies
Mar 9, 2010
Is there any difference between the 2 methods below for calculating c ... specifically boxing/unboxing issues?
Dim a As Integer? = 10
Dim b As Integer? = Nothing
Dim c As Integer
' Method 1
[code]....
View 3 Replies
