Recent content by pacificpear

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

I am trying to schedule the report and put in the output folder. I the desitnation caption the check "Set 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...

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

Hi I have to calulate the distinct count. I have the following table. A B C 0801234 010 A343 0801234 010 A344 0801234 010 A344 0801234 011 A345 0801234 011 A346 0801234 011...

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