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

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

Cr10/access I have a detailed report which include name of all the customers(repitions are there). so i made the group so that i get distinct record.and sum the amount but when i am making group some of the recored are missing .. can anyone help customer name amount xyz...

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

hi it should 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...

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