DB/Reporting :: Using A Lookup Formula To A Prior Day?
Dec 29, 2008I'm creating a Macro for reporting purposes and trying to create a formula that will look at a prior days report, save it out, and work off of that one.
View 2 RepliesI'm creating a Macro for reporting purposes and trying to create a formula that will look at a prior days report, save it out, and work off of that one.
View 2 RepliesBelow is my formula for a field in my report. All fields are of value type 'Number'. When I try to save the formula it gives me error "The result of selection formula must be a boolean." Why is this? Sometimes it does not catch it as an error, but when I actually run the rwport with real data, it shows the error again. Sigh.
[Code]...
I have a crystal report that fails on a formula field but I cannot see why.
Here is my code:
Code:
Public Function CreateReportPDF(ByVal dsReport As DataSet, ByVal CrystalReportPath As String, _
ByVal reportSize As String, ByVal landScape As Boolean, _
ByVal dsParameters As DataSet, ByVal filePath As String, _
ByVal fileName As String) As Boolean
[Code]...
I want to place two radio buttons in so I can select one of them to use one formula, and then select the other to use another formula. I want to use the I=P(1+r)^n formula and I=P(1-r)^n formula with the radio button text showing Appreciation and Depreciation.
Heres my copy of the original code.
Public Class Form1
Private Sub cmdExit_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles cmdExit.Click
End
End Sub
[CODE].......................
Is it always a good idea to use dispose prior to close? Or only under certain circumstances?
View 10 RepliesIn the members region I declare _Name and assign it the value "NameA" but how do I assign this value conditionally?The idea is that if in some file there's a value set than that should be the default value and not the hard coded one, if non is set the hard coded one should stick.
#Region "Members"
Private _Name As String = "NameA"
#End Region
#Region "Properties"
[code]....
I am currently using the follwoing in my install routine, the idea is to check if the db exists. if the db does exist then leave the mdf name as is and attach it as a temp db then i can run a compare between the 2 db. however if the db does not exist i want to rename the mdf and attach it. however after renaming the mdf i cant attach the file.[code]
View 1 RepliesI want to display an equation prior to solving it. Obviously in MS word etc I can use equation editor to write an equation, but I'm writing my own program.
Is there an easy way to display an equation. Obviously I could use text to write eg as text "a=b^2-3(c-d)/5" and everyone here would have little problem interpretting what I want but I want this to be accessible to 12 year old children.
Alternatively I could try and manipulate lots of text boxes one on top of the other to try and explain what I'm doing
The third alternative I thought of was to write in equation editor export the graphic and then import a graphic.
I'm sure I must be trying to reinvent the wheel - which I believe is the one thing OE programming is supposed to avoid.
I have a stopwatch that begins counting from "00:00:00" upon clicking Button2 (in UserInterfacefrm). When the user
View 6 RepliesI have an application that will require using dates prior to 1/1/1900. (Some historical analysis). What kind of date function can I use for this -- I want to be able to use all the standard features that are available for date, e.g. format, date differences, charting.
View 4 RepliesBeen trying to figure out why my progress bars (one in the status bar when the main window is open and the other in a window by itself before the main window is shown) go up most of the way, then stop till the processing is done.I have refresh in there where the action takes place, and that made it work mostely.Basically I'm loading a file into a string, then while in a loop, I'm processing the file by lines. I have a function that retrieves a line, then it does a:
pbProgress.Value = pbProgress.Maximum - sWork.length
pbProgress.ProgressBar.Refresh()
StatusBar1.Refresh()
[code].....
I am currently trying to publish my project, not to web but to the cd/dvd option, I have done a test and it works all fine. During my project i have code that plays an audio file (wav) in background. This file i have placed manually in my c-drive and and i reference its loaction when i call it via;
[Code]...
I would like to develop a structure to maintain my user's text input somehow on each form to allow user to return to the form and see the prior input for potential editing. My app has four forms which accept user input and form a string for output to printer. In the eventuality that the user notes a mistake in the input after leaving the app, I would like to develop a structure to "save" the user input at the form level and allow for repopulating the text boxes with the prior user input. Make sense? I have no idea how accomplish that functionality. Maybe it's too complex for my purposes. What do the pros think?
View 2 RepliesI have used the following query for my task and it returns the table..
objSQLCon.Open()
Dim da As SqlDataAdapter= New SqlDataAdapter(strSqlQuery, objSQLCon)
da.Fill(dt)
objSQLCon.Close()
[Code]...
But the same query some times not working and I got "Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding" sqlexecption error. I have searched and referred lot of links (cmd.CommandTimeout= 0) and I did not seen any usefull info for my case..
i have a Checkedlistbox in a windows form, and have defined 5 values in it.Also the form holds a datagrid in it. i have manually defined 2 columns in it.Now i would like to populate datagrid with some data according to the check list values selection. When any selection was done in the checkedlistbox, some data need to added to the gird.in case if i am ticking further selection, i need the datagrid to be inserted with additional values with the prior populated data.
being a beginner, i am not able to get any idea to get this worked.
I am getting the following error:
Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding works fine with the other 400+ updates before this one. There are only 5k records right now, and update string works fine from myphpadmin.
mysqlstr2 = "update " & turncolor & piececount & " set status1 = '1' where layoutstring = '" & layoutstring & "' limit 1"
' mysqlstr2 value at error = "update black32 set status1 = '1' where layoutstring = 'rnbqkbnrppppppp................p.....N..........PPPPPPPPRNBQKB.R' limit 1"
Dim command3 As New MySql.Data.MySqlClient.MySqlCommand(mysqlstr2, cn2)
Dim rowsaffected As Integer = 0
rowsaffected = command3.ExecuteNonQuery
I'm reading a file and then closing it with the following code, but my problem is later when I start a batch process it says the file is still in use. Am I doing something wrong in closing it? The process was working fine prior to my adding this code to read the file.
[code]...
This rexx exec is trying to write to the file that I read from in the prior step before creating a PowerPoint presentation, but fails becuase of the lock.I'm at a loss. I should qualify and say the process actually starts, but fails in the rexxexec after it starts, it isn't failing on the process start the rexx exec issues a message that it can't write to the file becuase it is in use.
I have a datagridviewcomboboxcolumn which has its .DataPropertyName set to a int field, its .DisplayMember set to a nvarchar field and its .ValueMember set to a int field on a lookup table. I have captured a dataerror which states that the control is trying to push the .DisplayMember(nvarchar) to the .DataPropertyName(int) field. When I load existing data it works fine. When I try to leave the datagridviewcomboboxcolumn after selecting a different value in it or leave it when I add a new row, I get the error. What am I doing wrong?
View 1 RepliesSimple Code lookup to get Description I have a static list of Street Type Abbreviations and their associated Street Type Descriptions: RD to Road. I have the complete list needed. There are 37 elements in the list - 37 Street Type Abbreviations with their associated Descriptions. The lookup will only happen once. The input lookup field is in a single field: stType.
[Code]...
i am using the LookupEdit control from DevExpress fairly heavily in my projects. It is like a combobox, but it is bound to a datasource and can display multiple columns from the datasource. A single column is identified as the "value" column and a single column is identified as the "Display" column.
I use the LookupEdit control on my forms to give users a pick-list of appropriate values for a particulat database field. Each field has its own table in the database holding said values, commonly referred to as a lookup table, and each lookup table is used as the datasource for each paired LookupEdit control. Of course when a form is being filled-in by the user this works great. And it works good when the user opens a saved record into the form and I set the EditValue of the LookupEdit based on the value stored in the database. Pretty basic stuff right?
Now here is the problem... Let's say a lookup value is no longer an appropriate entry and so it is removed from the lookup table. Say I sell cars and one of the fields in the Cars table is Color. And I have a lookup table called CarColors and the selections are: Black, White, Red, and Silver. Now let's say we sold some Red cars in the past, but now we no longer carry Red as an option and we probably never will. So I remove "Red" from my lookup table, and now when I load an old Order into my form the LookupEdit for Car Color value now shows NULL. What is the best way to handle this situation? ProcessNewValue? Set NullText property? Use a bit field in my lookup table for IsActive, and set to FALSE for Red instead of deleting it?
Obviuosly I want to retain the historical values while maintaining a currently valid lookup list. And I know this question goes deeper as there are probably database design considerations like whether or not to put a constraint on the foreign key relationship between the lookup and child table, etc... I should also mentioin I am using LookupEdit control rather than a ComboBox becasue a lot of my lookups have other information like Description, Sort Order, or are coded and thus require a multiple column display.
I have a datagridview control on a form that is filled programatically (dataadapter, dataset ) from a database table (access).
Some of the columns in this table are foreign keys to other tables. Is it possible to have these
columns as combo box columns so the values can be selected directly from the other tables?
I have an Access 2003/2007 application that pulls computer names from my network along with their last know TCPIP address. This data is created by another application. I am trying to use the IP Adresses to install software via a push application that accepts a list of IP Addresses.My app has a history table of every comuter that has been checked to see if the software is installed. I use the Fully Qualified Domain Name to make this verification. I then populate my text file with the IP address of the computers that have not been installed.This all works well if the last know IP address is still valid for that computer.What I am trying to find is a function that I can pass the FQDN to and have it do a NetBios lookup to return the current IP Address from our DNS Servers so I can be sure that the IP addresses I am populating the text file with match the FQDNs of the computers I am trying to push the software to.I found some info on System.Managment.dll. For some reason Access will not let me add it to my library references.Does anyone know of a standard library function I can use to achive this.[code]
View 2 RepliesI am trying to setup a macro to lookup a value. Its very basic, I am trying setup a sheet to build tariff requests for mobile phone deals. so on sheet i will have lots of macro boxes that simply pubulate a table with a value on sheet 2.
Its basically so a sales person can go onto the excel sheet click click click and it will produce a table of all the product on each mobile number connection.
I have a sql query that looks like this
SELECT SUM(A) AS expr1 FROM TREES WHERE (b = ?) AND (c = ?) and (d = ?)
How do I map the parameters? Since its a sum, I cant select multiple rows.
I am converting a DTS update lookup to an SSIS lookup with an update query. So far it doesn't seem to work.
OLD DTS ACTIVE X CODE:
value = DTSLookups("apple").Execute(DTSSource("ID2"))
SQL Query in DTS:
UPDATE TABLE1 SET STAMP="TEST" WHERE (ID = ?)
In SSIS:
Create a lookup, use same above query, and I get an error if I click on column: "Parameter information cannot be derived from SQL statements. Set parameter information before preparing command"
IS there anyway to accomplish this in SSIS with a lookup? Or is there a better way?
in item Search form i can search the item that i want, if i found the item that i need i will select the entire row and fill this row in DataGridView in frmSWSfromGrid.i been able to achieved this same scenario but it uses textboxes.the ff. COde
frm Dialog code
Public Property DepartmentID() As String
Get
[code].....
I am almost finished building my application. All the data need is being inputted from various locations. I have a form that is suppose to consolidate all this data into a specific format. There are 47 fields that have to be populated and/or calculated based on two fields, the Username and a date range (this part is done). I was trying to set each of the TextBoxes equal to the SQLCommand that would return the proper value, but i am not calling it correctly. Would somebody please take look, is there something i am missing, do i need to write it in a function? I have had to use the Select statement itself in a couple of filters so I'm pretty sure that is correct, but i need help getting it to run the sqlcommand.[code]
View 16 Repliesi am using a third party tool "lookupedit control" which is similar to a combobox. as we type in the address bar of our browser we get the related items in the dropdown of the address bar. eg: if e type go we get all the items starting from go in the drop down of the address bar. I want to implement the same functionality for lookupedit or a combobox.
View 1 RepliesI need some advice I have a bound datagrid and a bound combobox lookup on a form. What i want to do is filter the combo box so it only shows the items left that are not in the datagrid already.
I have managed to achieve this already.But when the program runs, and there are items displayed in the data grid the combo box items are now filtered.The program crashes as it can't display the combobox item as i have filtered them out. The program runs fine if the datagrid is empty (IE combobox items not filtered). But as soon as there is a record in the datagrid when i save the database and refresh the combo box the program falls over is the items it is looking for is not in the combo box items list.
What would a work around be. I have thought of a separate combo box that is hidden and use the datagrid combobox events to show it in the correct position.Just to be tedious the displayed item is not the stored item value
I am trying to setup a lookup combo box in my web page. I was using a linq data source but I then moved my linqtosql code to it's own class library for my DAL dll (took out of app_code folder). So, I am converting the page code to be able to still have lookups driven now by a biz object.Here's what I have done in my biz layer...
Public Class KosherTypes
Public Shared Function GetKosherTypes() As List(Of KosherTypeLookup)
Dim db As New DBDataContext
[code]....
I then setup an object data source and mapped it to this class.I have a few questions as when I was doing internet searches I didn't find anyone that seemed to be doing this and yet I know lookup tables / combo boxes are common...I went with returning a list but I could have returned an IEnumerable or IQueryable. In my reading it seemed IQueryable had more functionality for linq to sql but since I am returning a simple two column list then I only need to return an IEnumerable or List. I went with a List since it's strongly typed.