I have two queries that have data that I need in one report.
Query a1:
Select fname, lname,state
from contact
where state = 'TN'
Ouput data:
fname lname state
Kim Smith TN
Jim Jones TN
Sarah Lewis FL
Joe Wills TN
Query a2:
Select fname, lname, state
from...
I have created two queries in Microsoft sql server. I have two select statements that I have joined together and that works. The issue I have is I need the data in description to match shakeweight or armweight.
If description = 'ARM SHANK' then shakeweight
if description = 'ARM SHANK' then...
I have a query that I created in IBM DB2 database that display all report that are within the parameter 202010201 to 20210228 which is the Promise Date. I need to convert this code to Microsoft server.
Here is the IBM DB2 code:
(select a.*
from
(
select...
I have it working now, I add a Sub to Insert.
Code:
Private Sub InsertSql2(ByRef con As ADODB.Connection, ByVal strColumn As String,
ByVal strRelease As String, ByVal rCell As DataGridViewCell)
Dim strInsert, strWhere1, strWhere2 As String
Dim...
I have corrected the code and created a insert Sub:
Private Sub InsertDatabase()
On Error GoTo errH
Dim con As New ADODB.Connection
Dim rs As New ADODB.Recordset
Dim strPath As String
Dim intImportRow As Integer
Dim objType As String
Dim...
How do I add the insert Function to the update? I created a button and add this
Private Sub Button1_Click(sender As Object, e As EventArgs) Handles Button1.Click
Dim strRelease As String
Dim sqlStr, sqlStr1, sqlStr2, sqlStr3, sqlStr4, sqlStr5, sqlStr6, sqlStr7, sqlStr8, sqlStr9...
Here is the update queries I have:
Private Sub UpdateSql(ByRef con As ADODB.Connection, ByVal strColumn As String,
ByVal strRelease As String, ByVal rCell As DataGridViewCell)
Dim strUpdate, strWhere1, strWhere2 As String
Dim strNewSql As String...
I have created a program where the user enters a release number and retrieve the data to a DatagridView connecting to a IBM db2 database. The options the users currently have is: Clear, Retrieve, Validate, and Update. The issue I am having is if the record is not in the database it doesn't...
Thanks pmax9999 I have it working now. Here is what I did:
if {@dateDiff} = 0
then "Week 0" else
" Week "+ totext(Datepart("ww",{@Shipped_day})+ 1- Datepart("ww",({@Shipped_day} - Day({@Shipped_day})+1)),0,"")
It display: week 1, week 2, week 3, week 4
The first week will be the first Monday of the month.
For the First_Monday I only get one 'Y' and its for a shipped_day that is blank. (I put a 'N' where it
If Not OnFirstRecord and
{@Week_Number} <> Previous({@Week_Number}) and
Day({@Shipped_day}) < 8
Then 'Y'
else...
That worked for getting the week number of each row, but how do I get it to give me a week count for each row in the month? I need the first week of every month to be a color and so on. I'm not sure how this needs to be done but this is what I was thinking. I have a shipping date, if I could...
I have a Crystal Report and I need to have the backcolor changed for every week within the month.
Week one Aqua
Week two Orange etc.
I have a formula field that have the date in mm/dd/yyyy format but I'm not sure how to find the week starting at Monday ending at Friday and putting a color to it.
Now I am trying to create two more formula fields: OnTime and Late using the data from the DateDiff formula.
OnTime formula:
if {@dateDiff} > 0 then Count ({@dateDiff})
I get 0.00 for this formula but should get 25 ( I am trying to get all numbers that are greater than 0)
Late formula:
if...
Thanks pmax9999,
you helped me resolved the issue. I had a date of 99999999 in the SHIP_DT and needed to add it to the formula field
If {Command.SHIP_DT} = 0 then date(0000,00,00) else
[highlight #FCE94F]If {Command.SHIP_DT} = 99999999 then date(0000,00,00) else[/highlight]
Date...
I have a report in Crystal report that has a promise date and a shipped day, both data types are number. The data is stored as yyyymmdd in the database (DB2) so I created two formula fields to change the date format to display mm/dd/yyyy. I have two parameter "StartDate and EndDate" and the type...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.