I have a problem with a report using the function "TotalPages". To show you the problem I attached a small sample with two reports. The first report (without using "TotalPages") is okay and the second one is wrong. The only difference between these two reports is that I use the function "TotalPages" in the second one.
In the output of the repot look at the following data:
Report 1 Report 2
Counter starts at 1 204
Number of pages 9 9
Sum 2225,54 4451,08
Does anybody has an idea what is going wrong here?
I want to inform you that I was able to reproduce the behavior that you described. I have documented this issue and logged it into our QA System so it can be fixed in a future release or service pack. For future reference please use the following case number TD-14983. Thank you for bringing this to our attention.
I highly appreciate your patience and the fact you let us know that this issue is not a problem for you anymore.
Please feel free to contact us anytime. Thank you for bringing this our attention and for pushing us to be better.
the problme still exists in TD 6.0 SP3.
In EMP534747 for TD 6.0 SP2 the error was fixed. But now the error is back again with TD6.0 SP3.
You can find the example code in the very first post. Please try it and give feedback if it is working on your installation!
It's working for us in 6.0 SP3. Here's the feedback from the engineer who tested this issue:
Both reprocases are OK in win32. The provided snapshot about missing value is NOT what I see with SP3 so it seems that testcase is OK with SP3
Please make sure that you have a clean environment (since you've installed previous EMPs and still see this problem, I'd recommend uninstalling everything and starting from scratch).
thank you for the reply! I have also tested it on a clean installation of TD 6.0 SP3. And the problem is still there. The problem is not that there are missing values. The problem is that the values in "Report 2" are wrong.
"Report 1" has 203 rows and the counter in column 1 starts at 1. The sum at the end of the report is 2225,54 €.
"Report2" also has 203 colums but the counter in column 1 starts at 204 (203+1). The sum at the end of the report is 4451,08 € (2225,54 € * 2).
The only difference between the two reports is that I used the function "TotalPages()" in "Report 2". That's all.
So please check again if your reports are both showing excatly the same results.
you should initialize your counter on SAM_ReportFetchInit, because the use of the TotalCount() causes in calling the report twice, the first call calculates the number of pages and the scond one prints. So SAM_Report_Start is called only one time, so every addition is done twice.
Code: Select all
On SAM_ReportFetchInit ! ! Call SqlExecute( hSql ) Set nCounter = 0 Set nSum = 0 !
Who is online
Users browsing this forum: [Ccbot] and 0 guests