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 derfloh 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: *

  • Users: Palpa
  • Content: Threads
  • Order by date
  1. Palpa

    Roll up Calculation

    Hi there, I need to calculate some field based on the date. For Ex; Balance Forward 8,792,038,358.57 Principal Paid New balance 1-Sep-10 21,224,226.52 8,770,814,132.05 2-Sep-10 12,838,569.65 8,757,975,562.40 Here we have balance forward which is...
  2. Palpa

    Range Grouping

    hi all, Need to create a range depending upon the min and max of the record. Let say, the field interest rate has min value 0f 2.56 and max value of 5.12. Now we need to group interest rate based on following condition: Minimum quartile will always be .01, .26 .51, .76 Maximum quartile will...
  3. Palpa

    Crystal Report Max record formula

    Hi there, I need to display record based on the max of another record. For example, a mortgage number 1234 and 5678 have two sets of principal but in the report i need to display that mortgage number which has the highest principal. I am displaying the mortgage number in the report footer...
  4. Palpa

    getting query engine error

    I am getting following error while running the crystal report: "Query Engine Error: Error Code; 0x Failed to open a rowset Error in the file: file name Query Engine Error" Can anyone please let me know why i am getting this error and how can i fix it? And i am using SQL server 2005 and using...
  5. Palpa

    Pulling records through SQL quries

    Hi there, I am trying to creat a CASE WHEN Statement where it will pull the field which is not null from the list of given fields. Let say we have 10 fields with name Tag1, tag2, tag3 ..... tag10. Now what we need here is if the tag10 field is null then go to tag9 and if tag 9 is also null then...
  6. Palpa

    calculating weighted average of datetime field

    Hi there, i am trying to convert datetime field into numeric filed so that i can generate weighted average but every time to try to do that i am getting 'the string is non-numeric' error. What i am doing is converting datetime to string and then to number and then get the weighted average and...

Part and Inventory Search

Back
Top