Running Total Gives Incorrect Results ?...................
I'm new to this forums and i have a problem with my report.
i have created a report with two groups which will display Employee detail (Epf month wise) and Total will display in each page footer in each page.
next i have two requirements that is
:user will enter the no of records perpage
(eg:if user enter 5 then 5 recors will display in each page)
:i want to put all page totals in report footer in a sub report
that display each page total
01 xxxx xxxx xxx xxx
02 xxxx xxxx xxx xxx
Both of above requirements are done by me.
Following Sections are supressed in my report
Thre are Two Problems
1.i have used Running Totals to get sum page wise
but the problem is totals are wrong .
accourding to my investigation i found following problems.
i have choosen paper 'A4'.
then i have two groups and supressed resluts.
i will explain senario in detail:
let say user enter records per page =3
then my report will display 3 records per page
(let say this is my first page and 3 records perpage)
according my page sum it should be 21500.00
but it differ (21000) the problem is
even it display 3 records in same page (actually because we have supressed GH2,D,GF1,GF2) when i un supressed records
the third record in 2nd page not in first page
so as a result i get first page sum as 21000 not 21500
when i use 'A3' it is give correct result but that depend on
the number of records per page entered by user.
How could i get correct result ,Can any one help me
Other question is i'm using an array to pass page totals to subreport .
using a loop i will get all the array values to a string and display
the problem is if one field change all other string will chane:
1.00 0.00 50.00 34.000 1000.00
2.00 0.00 2000.000 4500.000
like in 2nd line if any large number comes it align to right
so it will diplay like above(not in proper way)
is there a way to do this with out string or is there a way to
format string (like in c++,java,.net)
Or my design is wrong
Thank You ,