Search results for query: *

Ok i got..... created three level formula: Put it in the Account group header WhilePrintingRecords; Global NumberVar BalanceForward; BalanceForward := {BalanceForwardField}; In the date group header or footer where you can display the balance WhilePrintingRecords; Global NumberVar...

Yes balance forward is a database field...... ...principal paid is the sum of principal paid during the date that's why I grouped it by date...... I will try what you wrote earlier n let u know......

Actually i am not putting that in the detail section. it is being grouped by date. so the new balance will go the group footer. Thanks

thanks LB, But i am not sure if this will work properly cause for september 2 we need to subtract the principal paid from the new 'new balance' which is begining balance - september 1 principal paid. its just like you are calculating day to day ending balance of your money by subtracting each...

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

The min and the max values are coming from the field - mortgageinterestrate from the table and it changes depending upon the mortgage level. so when you group the report as per mortgage level, the interest changes and so does your range.

Thanks for prompt reply Rtag.But the interest rate min and max can change depending upon other factors. At that time we can't hard code the interest min and max rate but it should be coming from a field within a table. isn't there any other way other than function. Thanks

sorry for the typo, yes it should be 4.01 - 4.25 then 4.26 - 4.50. The database is SQL server 2008. if you have any idea, i would really appreciate your help.

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

Thanks LB

That worked perfectly for me. Thanks..... and one more question, what if we have more then 2 sets of records, will the above formula works then? Thanks again

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

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

was able to fix it myself with following query. CASE WHEN PSMultiStratTags.Tag10 is not null THEN PSMultiStratTags.Tag10 else (case when PSMultiStratTags.Tag9 IS not null then PSMultiStratTags.Tag9 else (case when PSMultiStratTags.Tag8 IS not null then PSMultiStratTags.Tag8 else (case when...

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

Yes, i was trying to get the weighted average of the date. But i couldn't do it with crystal. So i used 'Convert function to change the datetime into number and used that number calculate the weighted average and converted into date again. Convert Function...

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