Search results for query: *

Hi All, I'm running Crystal 11r2 and was wondering if anyone has a selection criteria formula example of how I can exclude records that were not created between Monday - Friday 9am to 5pm? Thanks

i am being asked for a report to show how long it took to solve 90% of jobs. exampleofdata jobNo Business Days 3 0.38 4 0.5 2 1.58 7 1.7 1 1.71 5 2.3 9 5.9 10 6.1 6 6.7 8 10.3 average= 2.99 I need to...

Hi All, I'm having a few problems returning the correct data in my report. I have used the working hours formula that I found at http://www.kenhamady.com/formula.html My problem is that I need the report to show the whole month and not just the days in which records where created so I created a...

Hi All, I have an issue that has occured after the change from 2010 to 2011. I have a formula that counts values where the month -1 = the previous month i.e: if {@MonthFromDate}-1 = {@MonthofClosure} then 1 else 0 This works well for the year 2010 but when the report was run in jan...

Hi All, I hope you can help me out with an issue I have. I have a cross tab report which currently looks like the below:- weeknumber 45 46 team support %ontarget %ontarget network %ontarget %ontarget I want to display the first monday for week...

Hi All, I'm trying to compare data in two databases for all tables, I found the below code which works OK but does not work for text, ntext columns Below is the code im using set @SQL = 'SELECT ''' + @table1 + ''' AS TableName, ' + @t1ColumnList + ' FROM ' + @Table1 + ' UNION ALL SELECT '''...

Hi All, I have a table that looks like the below:- Dell Inc Optiplex 740 Dell Inc. Optiplex 740 Dell Inc. Optiplex 740 eNHANCED I want to split it into two as per the below :- Col1 Col2 Dell Optiplex 740 Dell Optiplex 740 Dell Optiplex 740 eNHANCED I have run the...

Hi All, Hope you can help - I have a query where i want to count records in a table where a date column's day is in the last 7 days, been trying to do it with datepart but can't seem to get it to function. Can anyone give me an example? Thanks

Hi All, I have created the below trigger but cannot figure out why the delete statment does not work? all other statments work as expected. If i change the variable to the actual value it does work.. Thanks alter TRIGGER [tr_sitelocation] ON dbo.usr_refsitelocation FOR INSERT, UPDATE AS BEGIN...

Hi All, I'm have a column that holds two values separtated by '-' I have selected the right value by using the below SQL; Select substring(EU_Department, (charindex('-',EU_Department)+1), 1000) as Team from dbo.TABLE I'm attempting now to select the left value, I'm using the below but get the...

Hi all, I have a column nvarchar(max) that contains any number of records as below; record1 record2 record3 each of these values originates from another table in the db, does anyone have any code that i could use to split the values and work on them independantly? Thanks

Hi All, I hope you can help, just installed Crystal XI Server and have an issue; In crystal 10 I have a virtual directory with my reports and a custom web page with URL's for each of the reports. They openeded in the Active X viewer by suffixing the URL with ?init=actx Now in Crystal XI this...

Hi All, I have a stored procedure that returns 3 columns of data, is there a way I can move each of these columns into variables?

Hi All, I hope someone can help me with this. I have a strange issue in that if i re-build the index the fragmentation does not change (internal fragmentation) I have both unique clustered indexes and non unique non clustered indexes on each table. Runing; ALTER INDEX ALL ON 'tablename'...

Hi All, I am trying to select everything left of a colon ':' in a varchar field, the ':' is not at the same possition so don't think I can use LEFT() Does anyone have a method I could use Thanks Nathan

Hi All, I am try to convert the below SQL trigger into PLSQL, can anyone help? CREATE TRIGGER copy on table1 for INSERT AS BEGIN IF UPDATE (COLUMN1) UPDATE table1 SET column2 = t.column2 SET column3 = t.column3 SET column4 = t.column4 FROM table1 n, table2 t WHERE t.column1 = n.column1 end

Hello All, I hope someone can advise me what I am doing wrong with this trigger. I have a web application that is hard coded to write a note into a related table. I want to copy this note back into the main table and then delete the origincal record. Table structues below; Main Table (notes) ID...

Hi All, I hope you can help me out with this problem, I have several columns in a table, I want to move the data from column x to column y (I need to move the value from column x to column y for the same row) like the below; I have; Column x column y Value1 <null>...

Hi All, I am having an issue at the moment where I need to generate a random guid (uniqueidentifier) within a table when a row is inserted. I am after some clarity that the quickest way to atchive this would be to drop the column and re-add it using; CREATE TABLE MyUniqueTable (UniqueColumn...

Hi All, I am attempting to replace a statment in a varchar 2048 feild, I am using the below statment; SELECT REPLACE (NOTETEXT,'internalID="CUSTOMER_NAME" attributeID="CUSTOMER_NAME" attributeType="String" attributeName="Client Name"', 'internalID="Name" attributeID="Name"...