Skip to Content
0
Former Member
Jul 21, 2008 at 08:21 AM

Strange Results

20 Views

Morning all,

I hope everyone had a nice relaxing weekend.

I am having a strange problem with my report today. The following is the layout of the report.

*Report Header* - Report Title and Report comments

*Page Header a* - Start Date, End Date, account number, Records +(Still in lab, Total jobs, Canceled, Credit)+.

*Page Header b* - Headers (Text Objects for the report).

*Details* - Suppress (No details).

*Report Footer* - Total number of days, Total jobs, percentage.

*Page Footer* - Page Number.

Parameters set to:

Start Date:
End Date:
Account number:

Code for Report Record (Record Selection Formula):

{order_header.date_entered} >= {?Start Date} and 
{order_header.date_entered} <= {?End Date} and
(not HasValue({?Account Number}) or {order_header.account_no} = {?Account Number})

What is happening:

When I put objects under the Report Footer (total number of days, total jobs and percentage), the calculations on Page Header a changes. For example

If I have

Total Number of Days - 2
Total Jobs                          -  3
Percentage                         - 3%

My Page Header a will change from "Total Jobs = 23559" to "23571", Canceled will change from "542" to "544", Still in lab will change from "4" to "17" however, the Credit remains the same i.e. "7". This change is bit weird as if I remove all the objects from the Report Footer the results comes out fine.

I suspect it might be because of the report selection formula I have entered however, I am not sure as to why would it effect my report header when report footer has objects in it.

Does "(not HasValue({?Account Number})" puts any value under the parameters? In theory it shouldn't but you never know what CR is doing at the background.

any ideas why is it doing this.

many thanks

Kind Regards

Jehanzeb

Edited by: Jehanzeb Navid on Jul 21, 2008 9:29 AM

Right I have set the account number formula under Record Selection as "Comment" and tried it, and it still showed wrong results. I think it is directly connected to Report Footer and not with Record Selection Formula.