I need to produce a report for my program. I would have liked to make the report an excel file that gets data through my program. However this program may go out to people who dont have excel on there pc or have different versions to what we are using.So i had an idea that perhaps if i reference excel in my program then it will not matter if a user does not have excel on there PC.
View 1 Replies
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[code]....
View 12 RepliesI am being given excel sheet daily and want to upload them to an existing database with the exact same column names, i wanted to do this in sql server 2005, but then i thought it would be easier to just creat an asp.net program that could do this autmatically, that way the managers could do it them selves. would i use a bulk insert?
[Code]...
There are 50000 thousand records in the data table which is binding to the crystal report. but while generate a PDF or excel report from ASP.net it is giving as time out exception.
how can we resolve this problem and any one can tell me what is the max records limit in the crystal report.
I have increased Session Time and application time by using maxrequestlength and executiontimeout attributes of in the HttpRunTime elemnt tag in web.config then also no we are gettting page cannot be displayed
i have a question concering Reports. I am using Visual Studio 2008. As it currently stands when you try to export a report you have two options, either export to pdf or as an excel file (97-2003). Is it possible to also include an option for saving the file in Excel 2007 format as well?
View 1 RepliesIn the long rung, I'm trying to setup a program to have a local database of files (It's a media player, so think of the library in WMP). I'm just trying to figure out how to do it, so this is a proof of concept thing I'm having a problem with.
Here's the code:
Code:
Dim dsDataset As New Database1DataSet
Dim drRow As Database1DataSet.FilesRow
[code].....
I have this code that I got from somewhere, I forget where, but it adds a checkbox array to my form. Now I have a button on the form that when pressed it will check all the checkboxes but instead I keep getting the error NullReferenceExpection where I put that red arrow. What am I doing wrong?
Public Sub frmAlarm_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
Dim Ypos As Integer 'Need to move the position of the checkboxes down
Dim NumWeek As Integer ' This is the number of checkboxes
[code]....
I have written a program in VB.NET 2008 Express that references a .NET managed dll. I simply added a reference to the dll to the project. I then 'Imports' the dll at the beginning of the program and then can use it. Everything works fine when I am running the program in debug mode (and it uses the dll as intended), but as soon as I go to build the project I get an errors that it "Could not reslove this reference" and "Namespace of type specifier in the Imports 'ModbusTCP' doesn't contain any public member or cannot be found." The dll is located in a different location on my hard drive to the project location, but this was referenced when I 'added reference'.
View 2 RepliesI'm converting a VB6 app (that works fine) to VB.Net app for work using Visual Studio 2008 Express. I have Word 2003 SP3 on my laptop. I need to open an existing Word document; edit it; and save the changes. Now in VB.Net, when I try to do 'Imports Microsoft.Office.Interop.Word', only Microsoft.Office.Core shows up as a choice. I have Microsoft Office 11.0 Object Libary referenced. I've been searching the internet for hours but can't find any thing that helps. Can anyone here point out what I'm doing wrong? How do I get ...Interop.Word to show up as a choice?
View 3 RepliesBasically the code below is supposed to load data from a reader into a datatable, then compare a date to the start date and end date in each row of the table.However, I am getting errors on the if statement indicating Overload resolution failed because no accessible '>=' can be called with these arguments.I can probably do this with just the reader but I am playing around with a data table because I know I will have to learn how to cycle through the records and look at them at some point and this is a simple example I can use to do this.[code]
View 2 RepliesOften I have a list of object A, and I have another object type B that needs to hold a reference to one instance in that list. So, as far as I can imagine, it's three ways to hold such reference:
1. Make B hold the instance variable of type A
2. Make B hold some other key/ID of the A instance
3. Make B hold an integer of the list index of the A instance
I guess 3 is quite limited, and mostly suited for use locally inside a method, in a for-next loop etc. But with the other two I tend to have the feeling that I should use 2) over 1), as I believe I shouldn't "duplicate" the object.. But wonder if that is a mistake. I guess it's only holding a reference to the stack memory, so it doesn't really make any overload compared to holding just an integer key/ID..
Further my thought is that with 1), I don't have to loop through the list to get the correct instance, as it already holds it. However if A changes, it may not be reflected in B.A, if the A has been given a new instance, so then 2) would instead give access to the updated object A. So perhaps if A is a "dynamic" object that may have been reinitialized (if that's a word), I need to use method 2). However if it's a type of object that is only changed when for example the user opens a program settings form, and this setting form only changes value type variables, then perhaps 1) is appropriate?
This is kind of the case I have some times, and I wonder if I should then use 1), as it doesn't require me to loop through the list by key/ID. It makes other object hold the full reference, which is not really necessary, but maybe still more efficient? Although at the same time, maybe I shouldn't really care much about looping through an object list either, if the list is not very big.
I have a collection class, say ITEMS, that inherits a Dictionary (of String, SINGLEITEM). From the SINGLEITEM class, I would like to reference a property in the parent ITEMS class, what is the best way to do this? For example, say the ITEMS class has an IsDirty property and I would like to set that if ANY of the contained SINGLEITEM objects is modified, what's the best way to go about doing this?
I know I could add a reference to the collection class in each SINGLEITEM class (since I override the ADD method, I could make this assignment), but this seems like overkill.
I cant grasp it right now, lol. So here's what Im trying to do: I have two tables, a main table, and an employee table, with a foreign key in the main table pointing to the employee number in the employee table. Im trying to use a databound datagrid to show everything from the main table, and the corresponding name of the employee number referenced in the main table. Is there a way I can do that using DataSet.Table.Column.Expression, or what would be a simple way of doing this? I cant use TableAdapter b/c sometimes the database is offline, so preferably with datasets.
View 1 RepliesBasically, 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 Repliesi am developing an application in vb.net having crystal reportsi have stored all my reports in a folder called report in my applicationbut initally when i executed i got a error msg like the report doesnot exixts in debug folderso i copied all the reports from report folder to debug folder & its workingany changes that i mke in report folder needs to be copied into the debug folder alsois it possible that the reports be executed from reports folder only & not from debug folder as everytime i need to make changes in the debug folderhow can i chnage the path to reports folder
View 1 Repliesthis 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 RepliesHow can we create a report in vb.net without using any crystal reports
View 11 RepliesIs there any way to design and print reports using VB.Net Express 2008 If there is no solution, my backend is Access 2000 - so can I open & print a stored A2000 report from within VB.Net 2008 Express ? How
View 5 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?
Im learning it on my own. I just created my first project which pulls data from a SQL server
displaying it nicely in a form. Id like to take a step further and create reports with the data like
its done in Access. I understand it can be done with crystal reports but the package is not within
my financial reach (over $400, I hear?). Im not looking for a report wizard but a way to draw my own
fields and lines meaning, doing it manually.
I am trying to create reports for a project I am working on. Basically it is a program used by a company to keep track of its sales reps. The income of each sales rep is stored in an array. I need to create a report ranking each sales rep in order of highest sales.I have looked into using crystal reports but I am getting bogged down in the server stuff and dont really know what to do.
View 3 RepliesI am looking for a tutorial for making reports with Visual Studio 2008. I have a VB.Net app using hard coded MySQL statements and variables from different parts of the program, mostly the server as I have the same app with options to connect to different servers with the same back end structure (different data unique). As far as i know I can not use data sets (I think thats the name for them) as that would mean one program for one location.
View 4 RepliesIf 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.
