Search results for query: *

Hi LB, Thanks very much for this it works exactly as I want, but was wondering if you know of a way to pass in the 90 from a parameter field ? it fails with the message that it must be a number. The parameter is set up as a number. I have also tried creating a formula that sets the parameter to...

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

sorry it's crystal 11r2. The data is in the details section as per the above example, i then have the data grouped by type with average days summary in the group footer. Thanks

I have been able to work out the average days for all 10 jobs, i just dont understand how i get the 90% only 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...

Content as per the below //Main formula WhileReadingRecords; Local DateVar Start := date({DATES.DAY}); // place your Starting Date here Local DateVar End := date({DATES.DAY}); // place your Ending Date here Local NumberVar Weeks; Local NumberVar Days; Local Numbervar Hol; DateVar Array...

I can now see where the issue is:- DateTable recordtable workingdaysformula 31/1/2010 31/1/2010 1 31/1/2010 31/1/2010 1 Is there a way to change the working days formula to work inside a group and only count unique working days? Thanks

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...

Thanks I have created the below formulas:- //PrevMonth DateAdd ("m", -1, {?Pm-@par From Date}) //prev month formula if month({@previous month}) = {@Monthofclosure} and year(CurrentDate) = {@Yearofrecord} and not({@exclusionformula}) then 1 else 0

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...

Thanks a lot that was just what i was looking for

hi thanks it should run for the first week containing january the 1st Thanks

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 '''...

thats fantastic Thanks

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...

thanks guys i have used gmmastros's example but have played with all cheers for the quick replies as always Nathan

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

OK rowlocks and pagelocks caused the issues, I unchecked these values on the index and all now works as expected

found that the index was causing the delete to fail?? if I remove the non-unique / non-clustered index the delete statement works fine If present it does not delete, even after a re-build of the index, re-org of the index ??? Nathan