Search results for query: *

There is a string I need to parse to create several columns. I am using the following statement to create the employeeID column and the Import Date column: select Substring(rowdata, 1, 9) as 'EmployeeID', substring (rowdata, 11, 8) as 'Import Date' from livereqlog Example of string to be...

I have a table that contains funding sources. It has recently been brought to my attention that there are duplicate entries in the funding source table. EXAMPLE fundName: AAA, fundNumber: 123-456-7890, departmentID: 1 fundName: ZZZ, fundNumber: 123-456-7890, departmentID: 746 As you can...

I need assistance exporting data from an Excel Spreadsheet into an existing SQL table (table A). I used the Import Export Wizard to export the data from Excel into SQL, however that created an additional table (table B). Is it possible to export data from Excel into an existing table using the...

I need to insert a row into table "A". I was instructed to Select scope_identity() to create the ID for the new row in table "A". So I ran the following statement: SELECT SCOPE_IDENTITY() from A This statement returned a NULL value for each row. How do you use scope_identity to create an...

When I execute the following statement: sp_lock The mode colum returns an "IX" and the Resource column is empty. Should I be concerned? Is this indicative of a blocked process? Thanks in advance for your help!

The client does not want to see dates prior to Dec. 31, 1899. I used the Format Editor to suppress the date prior to Dec. 31, 1899: {Reference.beginDate}< 'Dec 31, 1899' This formula works except when the date is April 01, 2011. It suppress the date when the date is April 01, 2011. Why does...

The client does not want to see dates prior to Dec. 31, 1899. I used the Format Editor to suppress the date prior to Dec. 31, 1899: {Reference.beginDate}< 'Dec 31, 1899' This formula works except when the date is April 01, 2011. It suppress the date when the date is April 01, 2011. Why does...

Client "A" is receiving the following crystal report viewer message when she attempts to print a report created in crystal reports 9, "THE PAGE HEADER PLUS PAGE FOOTER IS TOO LARGE FOR THE PAGE". Multiple clients use this report, yet only client "A" receives this message. This leads me to...

I created this report using Crystal Reports 9 several years ago. The description field is a string containing the invoice date and the item description. The client instructions for formatting from the description field were as follows: 1. (First character) Open parenthesis 2. Followed by...

I created this report using Crystal Reports 9 several years ago. The description field is a string containing the invoice date and the item description. The client instructions for formatting from the description field were as follows: 1. (First character) Open parenthesis 2. Followed by...

My more experienced predecessor has created a formula using case logic. Unfortunately our client would like to change the form so that whenever the formula returns the words "data blank" they appear red while the rest of the formula results remain black. Below is a segment of that formula...

I am working with four sub reports, pages 1, 2, 3 & 4 respectively. Each sub report is will contain 18 detail lines. The first sub report will contain detail lines 1-18 and the second will contain 19-36, etc. The sub reports are in sequential report footers of the main report. Each sub report...

The following subquerry generates a message stating: "Server: Msg 8114, Level 16, State 5, Line 1 Error converting data type varchar to numeric." (cast(refNo as nvarchar(200))+' '+cast(orgNo as nvarchar(200))+' '+ (cast((select top 1 modifier from PayrollTable join BudgetTable on...

I want to get 75.000 but I keep getting 0.75000. (replace(modifier,right(table.Numberfield,4),'000')) In an effort to get my desired result I multiplied it by 100. (replace(modifier,right(table.Numberfield,4),'000'))*100 Multiplying it by 100 generates the following message: Server: Msg...

I am working with four sub reports, pages 1, 2, 3 & 4 respectively. Each sub report is will contain 18 detail lines. The first subreport will contain detail lines 1-18 and the second will contain 19-36, etc. The subreports are in sequential report footers of the main report. The subreports...

I am trying to limit the amount of data returned per page. I am working with 4.5W inches x 9H inches section which I have placed in the Page Header of my report. I am using THE SELECTION EXPERT - NEW PAGE BEFORE in order to accomplish my task. This is the formula I am using THE SELECTION...

I am trying to divide the following string: "Departure|Arrival|Time|Expenses" This string will be used to populate the details section of a report. I need to divide the string at the pipe symbols(|) producing the following four individual fields: Departure Arrival Time Expenses Do you...

The fields I am working with are ACCOUNT#, CODE, AMOUNT. I need to sum the AMOUNT field when the ACCOUNT#/CODE are the same, listing the ACCOUNT# and CODE only once. I am currently using the following code: select CodeMaster.code, BCM.Account, Fund.fundID as procureID...

My report can accommodate 5 detail lines per page. The 6th detail line should print on the next page. Under normal circumstances I would do this by applying the following logic in the Section Expert>Common>New Page After: Whileprintingrecords; (RecordNumber mod 5) = 0 The fields I am...

Is there any way to limit the details returned based on the dimensions of the detail area. Here is my dilemma: This form has room for a maximum of 7 detail lines per page. So, I entered (RecordNumber mod 8) = 0 in New Page Before from the Section Expert. However, the first detail record...