I am using Crystal Enterprise 10 to run Adhoc Query to generate reports.My database has data with 4 digits after decimal point. But, the Ad Hoc query report rounds the data to 2 digits and displays that. Is there a way I can change this default behaviour to show the data as it is without rounding it?
View 5 Repliesi'm using the below code to insert data from listview to sql table
but the problem is that i won't data duplicate i try to use trim but not works
can some one help to insert new data only if it's exist
and sure if not will add nothing and i wish some one can help most of time no one reply here i dunno why
i 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 just want to display data's from mysql database to crystalreport and i need codings
View 1 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'm trying to debug an application i'm currently developing but somehow i'm now getting the following exception The type initializer for 'SupervisorProducao.MdlConstantes' threw an exception. the exception occurs when i reach this
[Code]...
how 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].....
i am using Access 2003 and vs2005,i am trying to add data to my crystal report from my access database,ok. So to do this i followed these steps: Now after all these steps,how to add the column names of the table "Table1" in my crystal report?
View 11 RepliesI am trying to set command timeout for enterprise library 4.1 data access. I used below code for get command object from Database.[code]....
View 2 RepliesThis is a Visual Studio forum but can you help me regarding Visual Basic 6.0 Enterprise Edition? I cannot find the CRYSTL32.exe in Visual basic 6.0 Enterpise Edition installation cd. I already some articles and it says that i can find it through this path CommonToolsVBCrysReptCrystl32.exe I alre cd.I saw in my installation cd this path (when I open the cd) Common/Tools... and there is no VBCrysReptCrystl32.exe VBCrysRept so that i can run the Crystl32.exe? I'll be needing it for my programming project which has Official Receipt issuance and somebody told me that i can use crystal report for pie Chart. Is that true that I can use Crystal report for pie Chart? Please also help me to find tutorial regarding crystal report. I am using Visual basic 6.0.
View 1 RepliesIs there any way to retrive data from Database with out writing any sql query . I mean i want to read data into my label fileds with out writing any query in sqlcommand. me how can i do this in c# or vb.netUpdate
protected void Page_Load(object sender, System.EventArgs e)
{
string connectionString = @"Data Source=Data
[code].....
So what i am trying to do is query each database for similar data, but becuase one of the databases is HUGE, it takes to long to go through, and i am only really working with about 1000 files on the other database. So what i need to do is have it only qurey my "Barvisit" database with the same info from the "EPRCensusMT" database. In other words i don't want the second query to go thruogh, say ten million records to just find the 1000 i need to look for.I am think maybe i can put somthing where it reads maxrec but i am not sure.
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
Dim cn As New SqlConnection("Data Source=1;User Id=;Password=)Dim strSQLMTCensus As String = "Select Count(*) as MTCnt from altlivedb.dbo.EPRCensusMT"
[Code]...
I made a query in MS Access using fields from multiple tables. I want to display stuff from it into a listbox on the form and then I need to save stuff back too it also. But I'm obviously doing something wrong cos I keep getting the error: "The Microsoft Jet database engine cannot find the input table or query 'Today'. Make sure it exists and that its name is spelled correctly." [code] Also, I have written further down objDataSet. Tables("Today's Absentees") and "Today's Absentees" is a query not a table, what needs to be written instead?
View 3 RepliesI am working on a VB.Net project and trying to get it to pull data from a database. I have the data base located in my bin folder with in the project but I do not know the exact path how to do it. The code that I am using is noted below
Private Sub btnTotalTravelCost_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnTotalTravelCost.Click
'strsql is a sql statement that selects all the fields from the
'ApprovedTravelRequest table
Dim strSql As String = "SELECT * FROM ApprovedTravelRequests "
'strPath provides the database type and path of the Travel database.
[Code] .....
I want to pull the data from the Bin File. I know the current location shown is incorrect.
I have been using the following code to remove text from strings so far;
String = Replace(String, "TextToChange", "")
However, I now would like to remove two words only when the occur consecutively for example, I would like to remove "Task 1", not all instances of the word "Task" and value "1".
I am having a form in which I should display t datas automatically in a text box once t user enters data in another text box. i.e., if I enter t book name in a text box, I should get display t author name in another text box when it gotfocus..
View 8 RepliesI have to retrieve data in two TextBoxes but the data should belong to tokennum that I am getting from first text box. I have a total of three TextBoxes and one button. In a database called db1 I have a table named Table1 and two fields ser as serial number, tokennum for token number and name for name of employees.
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
Dim con As New OleDb.OleDbConnection
[Code]....
I have store the variable in
Dim Lastname, Surname, Middlename, age As String
and the data are saved in notepad. how can I put them back in their exact label.one of my lable is
lbl_surname.Text
I'm using VB.NET, and I'm trying to write a program for the company I work for, that interacts with a database designed for logging web site email submissions (After a user fills out a form for a item request or comment sheet, the email the form sends gets logged so we can more easily see which site gets spammed more, and we keep a record of the actual spam). My program mainly just makes the data easier to read. However, I want to add a feature so that a user can click a button, then an automatic query will take place so that all the preserved URLs in the database are tested, then a form will appear that states something along the lines of: These Sites Sent This Number of Emails
View 6 RepliesI have a program in which I want to have the user enter two percentages and display the data matching the criteria on a new form. The query would be:
Select *
From Corrosion
Where corrpct1 >= {column in database} OR
corrpct2 >= {column in database}
The way I currently have it written is to display only one row of data. I need to display any number of rows that meet this criteria. My current code is:
Private Sub btnDetails_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnDetails.Click
Dim form As New frmDetails()
Me.Hide()
[code]....
1. How can I do my query to incorporate the user entered criteria (in the where statement)?
2. How can I display ALL of the data instead of just one line?
Im wanting to use a textbox for the entry of Decimal figures (currency). Is there any way I can have it so if a user does not put a decimal figure (ie 15 instead of 15.00) it will put it on.
I tried a masked textbox, but that means i have to set the maximum number of digits before the decimal too which is no good.
We've got a bunch of forms that are using data binding through a binding source control to get text from a textbox into a dataset and then into a database. The problem is that we need to be able to strip trailing spaces before saving the data.
Is there an easy way of doing this without having to go through the dataset manually trimming every string? Ideally everything should update to keep things consistent (e.g. no trailing spaces in the database, dataset or textbox).
I have a basic calendar schedule i want to loop through and then do some checks. My first data reader works fine. But as soon as i put in the second data reader it does not finish.Here is my code
Dim mycommand As New MySqlCommand
Dim mycommand2 As New MySqlCommand
Dim myData As New DataTable[code].....
Basically the above code looks up distinct calendar entries in the database.i then loop through the entries and put the items in a list view.The code above will list about 1600 rows.in the above code if i uncomment the 2 lines the system will break It will on display one line of code. What im trying to do in the second query is to see if there are double bookings in the database.
Dim lvitem As Object
Dim iCount As Integer
Dim iLoop As Integer
[code]....
That is my code. message box show up but the record is not saved in my database?
trying to write a dynamic sql query that fetches data from oracle 10g database. My Where criteria is giving me real problems but i guess it has to do with the oracle data format. The data column is a TIMESTAMP data type storing values like 25-JAN-09 07.06.01.000000000 AM. Am trying to get rows having the columns matching a specific date( ignoring the time values), my where looks like this
WHERE to_date(COMPLY_RUN_DASHBOARD_DATE,'DD-MON-RR')='" & Now.Date & "'"i get the following error :CheckError ORA-01830: date format picture ends before converting entire input string
How do I allow only a decimal point after an input of three digits in a textbox in VB.NET?
Let's say I inputed "123" after that I can only put a decimal else it wont allow any other input. So the result would be "123."
Dim KeyAscii As Integer
KeyAscii = Asc(myE.KeyChar)
Select Case KeyAscii
[Code]....
Is there a format string to format a decimal to 000000000,00. So first 9 digits, right padded with zeros if needed; a comma as fraction separator and two fraction digits.
0 => 00000000,00
12 => 00000012,00
987456,456 => 000987456,46
So something like myDecimal.ToString("D9") together with .ToString("F2").
In the discussion in this thread: [URL] it was reveiled to me that vb.net, using double, could only calculate values up to 18 digits after decimal.... so I started thinking and came up with this class
Public Class LargeNumber
Private pNumber As String
Public Sub New()
[CODE].............
I want to split the string into a series of doubles.... and than combine them into a large number.... The size of each double component should be 18 digits on a 32 bit computer... so that I will have room to add the last carrier...
SQL Server has a Data Type of "Float". Visual Studio has a Data Type of "Decimal". In other words, if I have a variable in a VB.Net app that is defined as a "Decimal" ...can I move that value into a SQL Server Data Table column defined as a "Float"?
View 4 Repliesi hve create combobox & text box and add database source to my project...i know how to binding data or load data to combobox using SELECT query..but can i change SELECT to INSERT query cz i wont when i type data into textbox,data will be in database...second..can i binding without add database to project..i mean mydatabase in debug folder..i hve problem binding data if database is not in myproject..
View 7 Replies