Search results for query: *

Hi All I am recieving this error messgae when i am trying to preview the report "Unable to retrieve Object. Maximum processing time or maximum records limit reached" How do i overcome this problem PP

Turkbear/rb2005 thnas a lot. It worked PP

...the values to be used at schedule time here": in Destination Directory: "C:/Program Files/Crystal Decisions/Enterprise 10/FileStore/Output/test" * i created the folder "test" under the output. This is the correct way or is something else we have to do for the at specifiying the destination...

Amrita/Vongrunt Thanks a lot both of you. It worked now i will implement it on the real data thanks PP

vongrunt/Amrita Your code fine until teh string has value but when it comes to D or the null value the result also show the value of D or the null instead of E ie 4

when i execute that it give the following result A,B 1 B,C 2 A,B,C 1 A,B,D 1 D,E 0 D,F,H 0 last two reuslts are wrong , 1. as D is null and e has the value 4 in the table x so the result should be 4 2. as D is null and f is null too in the table x so the result should be the value of H ie 6

what is the table Z?

yes it shold return the value of N

evalue corresponding to the first host if it a,b thenn in result the value should the value corresponding to A in table X If B,c then in result the value shul be the value corresponding to b in table X if D,E then in result the value should be the value as e as d is null i hope i am clear on...

Hi All Thanks for the replies Few things to clear 1. The result does not contain the minimum value. It contain the value of the first string for examople for A,c the result should be 1 c,d the result should be 3 d,e,f the result should be 4 as the value of D is null 2. the values given to...

Sql server I have two tables X and Z TABLE X HOST DEPT# A 1 B 2 C 3 D NULL E 4 F NULL G 5 H 6 I NULL Then i have the second table which have the combination of host in...

...A345 0801234 011 A346 0801234 011 A347 0801235 012 A348 0801235 013 A349 * Calucate the dictint count of C Expected Result A B Count 0801234 010 2 0801234 011 3 0801235...

I am using SQL Server I have a view name called " replica" A B C D 000185700681 001 000185701034 001 000185700681 001 000185701034 001 000185700681 001 000185701034 001 000185700681 002...

i have to create two parameter with start date and end date. And all the calculation are done inside that parameter. means: 1. It shows the all the value between those two parameter ie start date and end date. 2. calculte the sum of column Z 3. then it also shows the average of data thanks PP

Crystal Report 10/ SQl/XML All the data in sql server is in string I am having problems in calculating avergages of the given date.Following is the data X Y Z Timestamp 700994 HA-astprod2a 25.30 2005-06-17 08:15:38.000 700994 HA-astprod2b 125.30 2005-06-17...

...recored are missing .. can anyone help customer name amount xyz 100 xyz 200 xyz* 300 abc 400 asd 500 ase 600 asd...

hi Acess/cr10 I have two column probabilitycode(string) and amount(number) I need to mutiply these two columns. How do i convert string to number so that it can be calulated table probabilitycode amount 0 10 0 20 10...

...only select the amount when the parameter is passed expected result code amount MBA0001 155258 MBA0018 10000 these two records of the yaer 2004, when the parameter will be pass of the start date(1/1/2004) to end date(12/31/2004) *dates are originally in datetime pp

access/cr10 need some help with the parameter field my query looks like this code amount startdate enddate MBA0001 93450 2/2/2002 5/17/2004 MBA0001 55250 2/16/2002 4/21/2004 MBA0001 55250 3/15/2004 6/22/2005 MBA0001 155258 3/15/2004 11/22/2004 MBA0001 46762...

hi all, In my report i have to convert the currency amount in the currency of the respective country.Default currency is us$. the report should look like this India Customer name order amount order amount .... in US$ in Rs Honda $1000 Rs 43000...