Good Day all
i have done a basic report using telerik Reporting a long time ago , i think its been 3 years if i remember correctly and the report was so basic that it was simple to do. i have a requirement now for a Finance system or Accounting System. I have the Data that comes already calculated via my SP.
My Requirement is as Follows , i want to display the Following format
now each financial year (Mar-08 ) is stored as a record in the db, all this are calculated already i only want to display them, OK my challenge here is that i have a maximum of 4 financial years
i want to generate the financial years based on the data that comes , so there might be 2 or 1 or 3 or 4 so i need to bind this dynamically , how can i achieve this with Telerik report.
Thanks
i have done a basic report using telerik Reporting a long time ago , i think its been 3 years if i remember correctly and the report was so basic that it was simple to do. i have a requirement now for a Finance system or Accounting System. I have the Data that comes already calculated via my SP.
My Requirement is as Follows , i want to display the Following format
Audited | Audited | Audited | Un-audited | |
BALANCE SHEET | Mar-08 | Mar-09 | Mar-10 | Mar-11 |
NET FIXED ASSETS | 23 159 616 | 24 968 321 | 24 352 332 | 23 198 353 |
DEFERRED ASSETS | 0 | 0 | 0 | 0 |
INTANGIBLE ASSETS | 0 | 0 | 0 | 0 |
OTHER ASSETS | 50 000 | 50 000 | 50 000 | 50 000 |
TOTAL NON CURRENT ASSETS | 23 209 616 | 25 018 321 | 24 402 332 | 23 248 353 |
CASH | 36 354 | 80 101 | 148 987 | 521 611 |
ACCOUNTS RECEIVABLE | 11 756 559 | 11 365 227 | 9 223 685 | 7 562 145 |
INVENTORY | 4 708 984 | 4 269 738 | 3 941 538 | 4 613 054 |
OTHER CURRENT ASSETS | 51 478 | 0 | 0 | 0 |
TOTAL CURRENT ASSETS | 16 553 375 | 15 715 066 | 13 314 210 | 12 696 810 |
TOTAL ASSETS | 39 762 991 | 40 733 387 | 37 716 542 | 35 945 163 |
LONG TERM DEFERRED TAXES | 3 054 804 | 4 889 626 | 3 058 807 | 3 017 438 |
LOANS FROM SUBSIDARIES | 0 | 0 | 0 | 0 |
SENIOR LONG TERM DEBT | 106 862 | 132 275 | 64 002 | 23 208 |
LOANS FROM SHAREHOLDERS/DIRECTORS | 0 | 0 | 0 | 0 |
SUBORDINATED DEBT | 0 | 0 | 0 | 0 |
OTHER LONG TERM LIAB | 0 | 0 | 0 | 0 |
PENSION PROVISIONS | 0 | 0 | 0 | 0 |
OTHER PROVISIONS | 0 | 0 | 0 | 0 |
TOTAL NON CURRENT LIABILITIES | 3 161 666 | 5 021 901 | 3 122 809 | 3 040 646 |
SHORT TERM DEBT | 6 490 204 | 3 134 461 | 760 328 | 0 |
ACCOUNTS PAYABLE | 4 916 314 | 5 443 842 | 7 549 264 | 6 847 010 |
TAXES PAYABLE | 0 | 80 553 | 327 398 | 344 951 |
CURR MAT OF LONG TERM DEBT | 115 259 | 111 210 | 72 718 | 35 740 |
OTHER CURRENT LIABS | 102 974 | 488 242 | 0 | 26 436 |
TOTAL CURRENT LIABILITIES | 11 624 751 | 9 258 308 | 8 709 708 | 7 254 137 |
TOTAL LIABILITIES | 14 786 417 | 14 280 209 | 11 832 517 | 10 294 783 |
SHAREHOLDER'S FUNDS | 24 976 574 | 26 453 178 | 25 884 025 | 25 650 380 |
MINORITY INTEREST | 0 | 0 | 0 | 0 |
TOTAL EQUITY | 24 976 574 | 26 453 178 | 25 884 025 | 25 650 380 |
TOTAL LIABS AND EQUITY | 39 762 991 | 40 733 387 | 37 716 542 | 35 945 163 |
BS TEST (S/B 0) | 0 | 0 | 0 | 0 |
now each financial year (Mar-08 ) is stored as a record in the db, all this are calculated already i only want to display them, OK my challenge here is that i have a maximum of 4 financial years
Mar-08 | Mar-09 | Mar-10 | Mar-11 |
i want to generate the financial years based on the data that comes , so there might be 2 or 1 or 3 or 4 so i need to bind this dynamically , how can i achieve this with Telerik report.
Thanks