i am in need of a little help. Is there a possibility to create a layout or report without connecting or using a database. Here is what i mean, i am building a very simple app with 2 textbox and a button. Winforms. i want to connect the text i type in the textbox to the template i created and when i click the button it print the template. vs2010 vb.net.
View 2 Repliesi am in the process designing the screen of a report form.I would like to have the Report selection (button, search criteria) on the left hand side and crystal report on the right hand side of the form.My idea is such that:Report Selection take up 30% of the screen and Crystal Report take up 70% of the screen.User are able to view the crystal report immediately after they have filled in all the search criteria and press the OK button.My purpose of doing this is to avoid to have another pop up for crystal report.Is it possible to do so in VB.NET?
View 4 RepliesAnyway, I was just wondering if anyone knows how to do these from a simple text box. i.e. 'TextBox1'.
I'm just learning VB and it's only a simple text editor but I can't find any good sites or posts that help me in understanding how to do it. These are not really covered in any of the 'beginner' books I have acquired either.
I'm just learning VB & ASP.NET and read a lot about making multi language websites. I understand the principes of creating resource file etc...But what with tables in de database that are used to fill f.e. a listbox ?
Example : an employee has a function
In the database I have a table "Functions" with an ID and a description of the function.Should I design my table Functions as this :
ID
Description_en-US
Description_de-DE
Description_nl-BE
...
Is this the best solution ?
how do i change the layout of the web form to Grid Layout so that i can place my control anywhere and not follwing lines or cursor
View 1 RepliesI created a button instead of the print button in crystal report because i need to record the report printed report serial number, date and time to the database. when i click on the button, dialog box appear. if i click on the ok button , system record the printed report details to the database and report printed successfully. but when i click on the cancel button , system again recording the printed report record.
[Code]...
I have been staring at a blank screen for over an hour trying to figure out the best way to build this app. We have a warehouse with consumables. These consumables are stored on racks that are three rows high and 15 columns long. I need to display the contents of these racks with the following; Item nameUnit quantityUnit expiration date
Now while this in itself would be a simple thing, I need to . Take a look at this image, the lower portion of the image shows basically what I want to display as far as the form goes. Instead of the "Row 1-1-1" text, I want to show the item, qty and exp. There are multiple rows. It should also be noted that each location may have more than one item stored in it, and there might not be anything stored in it. So I guess my question is, from a design point, is it better to create a small table for each location and then join those tables to a main "Row" table since there will only be a single row displayed on the form at a time? How would it be possible to keep the data properly ordered from a coding perspective? How can I ensure that each storage location remains static unless the item is moved?
how I can reference a report variable in the Report Properties Code Window of a local report? I have tried Variables!Claimant.Value (for a variable called Claimant) but I get an error "Reference to a non-shared member requires an object reference." I have tried qualifying it with Report. and also with the report name in front of it but I get errors with this also.I have the variable CLaimant defined in the Variables section of the Report Properties.
View 3 Repliesi am new beginner of visual basic, could you give me step by step to generate report using visual studio 2005 and my database is sql 2005.currently i am using a windows aplication..
View 1 RepliesAnyone who give me a reference how to query the sql to SAP crystal report?
View 2 RepliesI have to create a report with crystal reports in my application.my reports is based on a table in my database.As I've seen in the crystal reports designer, I have to add database to the report, and then I can pick the table and fileds that I need in my report.This is a quick and good when I use only one database type (for example Oracle or SQL Server)My questions are:How can I use the same report when my app is on two databases types? (Part of the customers I have use SQL Server, and part of them use Oracle DB)?
View 6 RepliesI have an Access database with a table called Events.I created a new VB.net 2008 project and created a MicrosoftReportViewer control. I also added a "Report" component (which created a .rdlc file).I am easily able to drag things from my Access database I added to the data sources onto the report. However, one part of the report I would like to add data to a Matrix that I calculated with VB (ie it is not in the database). The database has a list of names and a bunch of times associated with each name. and then I calculate some fancy stuff based on those times. I would like the matrix to be a list of names (from the database) on the rows, a list of dates (which I specify in the code) on the columns, and the data of the matrix I also calculate.
View 3 Repliesi am using b.net 2005. i am generating a crystal report. but when i work in a different computer i have to set the location of the database of the report before i generate. is their any dynamic way to set my database location to the report.
View 1 Repliesi am generating a crystal report. but when i work in a different computer i have to set the location of the database of the report before i generate. is their any dynamic way to set my database location to the report.
View 2 Repliesi have done my application that uses crystal report and access database. I try to publish the application but when install on client machine, it wont work. the access database wont load and so the reports. What should i do?
View 9 Repliesi just want to ask if you know any links regarding Crystal Report Tutorial, Or Video Tutorial of it that will teach on how to create a Crystal Report. If someone who can teach me on how to create it then it would really be fine for me.. Im looking for hard coding not just using the connection properties. I want to know on how to connect the crystal report to a database and gets all the data that I need and displays it. Designing the crystal report. Using TSQL if possible.
View 4 RepliesI am having problem with the connection between an access database and crystal report. I created a crystal report by using wizard, all working go, but when I run the program in another computer am getting some error on path..wrong path for the database. So I need to find a way to connect database with the crystal report using a relative path...
View 1 RepliesI am developing a vb.net windows application with crystal report and ms access. My database is stored in bin folder. I cannot bind database to report after deployment. How can I set the database location in report?
View 3 RepliesThis program I am writing is basically a way to record orders. So I got a bunch of possible components required, which got their textfield(1 for product info, 1 for product price). Those are controlled with a checkbox, disabled on default. Enabled when checked.
Something like this:
Label, Checkbox, Product info textbox, Product price textbox.
This for a bunch of products, and at the bottom you got the total costs textbox.
Which updates as entries are made.
1. Would a access database be a good thing to use for this? To save the completed forms to, for later viewing through the program. Or are the better options for this kind of thing.
2. Would crystal reports be a good choice to make the reports after the form has being completed. So you got a decent sheet which shows you the entire order, and give a print ability.
i just want to display data's from mysql database to crystalreport and i need codings
View 1 RepliesI am trying to generate an excel report where the data is coming from access database using VB.
View 2 RepliesI have the following code.
Private Sub genWorkOrderCompForOneCustomer()
If customerNameComboBox.Text = "Please Select a Customer" Then
MessageBox.Show("Please select a customer to create a report for.", "Error",
[Code]....
When I run the the application I am not getting the current information from the sql database until I hit the refresh button and enter the parameter. I would like the information to be up to date when first loading the application.
i am trying to load a filter on load of a report in my database. here is the line of code, i know i am close but i just cant get it right, i know the titles of all the forms, queries and reports are all correct but i am missing something still and cannot figure it out.
Me.Filter = "qryVisa list.[Country] Like " + Chr(34) + [Forms]![frmPassports and Visas]![Combo24].[Value] + Chr(34)
I want to be able to programmatically add or remove database fields in my crystal report.I am familiar with programmatically working to parameters but not with database fields, I just can figure out how to programmatically do what you do in the Database Expert.
View 1 Repliesi want to put my images saved as byte from the database to crystal reports.
View 3 RepliesMy histogram report didn't show the data in the database.
View 2 RepliesWorking with Database, create report and print
View 5 Replieshow can i create report and link it with MS access to display database on this report..
View 1 Replieshow to get the updated database data and print into crystal report using VB.net?
Dim rpt As New CrystalReport1()
Dim myConnection As SqlConnection
Dim MyCommand As New SqlCommand()
[Code].....
dynamically passing image to crystal report from a disk in vb.net 2005
View 1 Replies