If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
#Error Message on Report
I am sure that this question has been asked b4; however, i cannot seem to
find the answer. So, if someone does not mind answering again for me i would appreciate it. My problem/question is: In each consultant's report i have the following fldnames client dept program billable days days used remaining billable days remaining days is a calculated field: (billable days - days used)=remaining billable days i used the report wizard to set up my report and in doing so i opted for the summary and detail information. i have a monthbilled header and footer. the monthbilled footer sums the billable days and days used and counts the records. and again i get the #error message. i did place an unbound text box in the detail section with the expr: =IIf(IsNull([fldname]),0,[fldname]) with this i do not get the #error nor a zero. i have tried Nz([fldname])+Nz([fldname]); however, when i enter test information in the monthbilled footer total is double (i.e. 6 billable hrs instead of 3 billable hrs). the grand total is correct, 3 billable hrs. i also get an #error in the summary for count instead of "no data reported" i just want the report to either show zeroes or left blank if there is no data please help |
#2
|
|||
|
|||
#Error Message on Report
I found an expression that seemed to help; however, i still need help...PLEASE.
The expression i found was =IIf([hasdata],[amt],0) and IIf([hasdata],sum([detailamt]),0) I used this expression on my report in my calculated fld, as such: =IIf(HasData],[VBD],0) and IIf([HasData],Sum([VBD]),0) Now this worked when there was no data but when i put in test data in the summaryfooter, count records and the grand total footer i get a negative 1. Please help me what am i doing wrong. "VR" wrote: I am sure that this question has been asked b4; however, i cannot seem to find the answer. So, if someone does not mind answering again for me i would appreciate it. My problem/question is: In each consultant's report i have the following fldnames client dept program billable days days used remaining billable days remaining days is a calculated field: (billable days - days used)=remaining billable days i used the report wizard to set up my report and in doing so i opted for the summary and detail information. i have a monthbilled header and footer. the monthbilled footer sums the billable days and days used and counts the records. and again i get the #error message. i did place an unbound text box in the detail section with the expr: =IIf(IsNull([fldname]),0,[fldname]) with this i do not get the #error nor a zero. i have tried Nz([fldname])+Nz([fldname]); however, when i enter test information in the monthbilled footer total is double (i.e. 6 billable hrs instead of 3 billable hrs). the grand total is correct, 3 billable hrs. i also get an #error in the summary for count instead of "no data reported" i just want the report to either show zeroes or left blank if there is no data please help |
Thread Tools | |
Display Modes | |
|
|