on 09-18-2008 3:16 PM
dear all,
I have created a report which filters records according to statuses. The problem I am having is that two different distinct count fields need to filter by using two different date fields from two different tables. For example
DistinctCount() - this needs to look into Order header date created field
whereas
DistinctCount() - this needs to look into Lab Credit Date created field.
Order header is a table, date created is a date field
LabCredit is a table, date created is a date field
My question is, how can I use both date fields to filter my reporting records.
I have used the following under Report Selection formula but it produces results from only Lab Credit Field and 0s from the FOC field.
{lab_credits.credit_date} in currentdate to currentdate OR
{order_header.date_entered} in currentdate to Currentdate
There is something wrong somewhere and I don't know where.
Any ideas?
Regards
Jehanzeb
sorted
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Please use this formula to compare both the date fields with current date
If you want either of the condition true.
{lab_credits.credit_date} = Currentdate OR
{order_header.date_entered} = Currentdate.
If you want both the conditions true
{lab_credits.credit_date} = Currentdate AND
{order_header.date_entered} = Currentdate.
Regards,
Sastry
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Running now without any date filteration...it is counting all the records, i guess all the records from the year.
Ok it has produced all the records, from both record fields.
However one field has alot of data and other field has only 1s and 2s......the main thing is that it has produced the results in both running totals.
Regards
Jehanzeb
User | Count |
---|---|
83 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.