|
| | | Forum Newbie
Group: Forum Members
Last Login: 8/4/2006 8:02:38 AM
Posts: 1, Visits: 10 |
| | I am trying to create a report to track late VOEs. Since each of our VOEs have different followup times (1 day, 3 day, 5 day, etc.) I can not use the Late Document report which uses a single default number of days late. To get around this I am using the Re-Order Date field in the Track VOE screen to determine when the VOEs are due. We have also restricted the number of VOEs to be tracked for each file to 4 so that the single line on the report, for each file, doesn't get to cumbersome. I am using the following code in the condition for the 1st field (File Name) to get only the files I want:ADV IsNull([1 ORDER DATE],'01/01/2006')>#01/01/2006#)AND(IsNull([1 DUE DATE],'01/01/2006')>#01/01/2006#AND[1 DUE DATE]<=TD AND (IsNull([1 REC DATE],'01/01/2006')=#01/01/2006#)OR(IsNull([2 ORDER DATE],'01/01/2006')>#01/01/2006#)AND(IsNull([2 DUE DATE],'01/01/2006')>#01/01/2006#AND[2 DUE DATE]<=TDAND (IsNull([2 REC DATE],'01/01/2006')=#01/01/2006#)OR(IsNull([3 ORDER DATE],'01/01/2006')>#01/01/2006#)AND(IsNull([3 DUE DATE],'01/01/2006')>#01/01/2006#AND[3 DUE DATE]<=TDAND (IsNull([3 REC DATE],'01/01/2006')=#01/01/2006#)OR(IsNull([4 ORDER DATE],'01/01/2006')>#01/01/2006#)AND(IsNull([4 DUE DATE],'01/01/2006')>#01/01/2006#AND[4 DUE DATE]<=TDAND (IsNull([4 REC DATE],'01/01/2006')=#01/01/2006#) My problem is that I only want info for the particular VOE(s) that are past due to show up on the report and not the info for all VOEs for that file - i.e. If the first VOE has already been received but the 2nd VOE is past due I want the fields for the 1st VOE to be blank but the fields for the 2nd VOE to contain their information. I have tried using an Iif statement in the FieldID and/or as a condition and neither works. Does anyone have a suggestion on how I can accomplish this, I would really appreciate it. Thanks Ron |
| |
| | | 
Sepal
Group: Moderators
Last Login: Yesterday @ 4:06:35 PM
Posts: 1,183, Visits: 9,261 |
| Our report engine doesn't have the capability to optionally show data. It is trying to report the state of the file so if you add a field id and leave the show column checked the data for that field will be displayed. I think the best thing you can do is either directly export to excel and create a template to display this report or you can export to XML so that you can take an excel spread sheet and use that XML file as its data source.
Disclaimer: This post carries no explicit or implied warranty. Nor is there any guarantee that the information contained in this post is accurate. It is offered in the hopes of helping others, but you use it at your own risk. The author will not be liable for any damages that occur as a result of using this post.  |
| |
|
|