Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. pacificpear

    Maximum processing time or maximum records limit reached?

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

    How to schedule report to a specific destination.

    Turkbear/rb2005 thnas a lot. It worked PP
  3. pacificpear

    How to schedule report to a specific destination.

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

    Returning the value from different table

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

    Returning the value from different table

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

    Returning the value from different table

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

    Returning the value from different table

    what is the table Z?
  8. pacificpear

    Returning the value from different table

    yes it shold return the value of N
  9. pacificpear

    Returning the value from different table

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

    Returning the value from different table

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

    Returning the value from different table

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

    Distinct Count problem

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

    Recursion Problem in sql

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

    Calculating average

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

    Calculating average

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

    details And Group section

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

    Mutiplication of number and string?

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

    parameter for different years

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

    parameter for different years

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

    how to convert currencies?

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

Part and Inventory Search

Back
Top