Message Boards

Using date/logical field in a report

thumbnail
David Wollin, modified 3 Years ago.

Using date/logical field in a report

Post Date: 9/5/13 (Bronze, 20 Posts) Recent Posts

I am creating a report that is filtered on the Quote Issue Date (=CRM confirm date in the further details tab). There is a check box associated with this date field. I need the report to show me all the quotes in which this box is unchecked. Using the Issue date “Does not exist” doesn’t work as there is actually a date in the field. How do I work with that logical field attached to the date?

thumbnail
Raymond Chin Kwie Joe, modified 12 Years ago.

Re: Using date/logical field in a report

Post Date: 9/8/13 (Rhodium, 825 Posts) Recent Posts
maybe you can select the variable equal to "yes" or "no".
RajKumar Sachdeva, modified 12 Years ago.

Re: Using date/logical field in a report

Post Date: 9/9/13 (Gold, 183 Posts) Recent Posts
Following possibilities exist:
1. As long as toggle box you mentioned in your query is un-checked, the quote_hdr.confirm_date = ? remains true. As soon as someone selects the associated toggle and saves the record, the selected date value gets stored against Quote_hdr.confirm_date field.

2. So after that if someone again un-checks the toggle for the same quote_hdr record (for Quote_hdr.confirm_date field) and re-saves the record, the quote_hdr.confirm_date field value is not wiped out and it stays there.

So what you are looking for is possible only for records listed in scenario 1 above whereby you can query such records using the following Progress code:
/* Non Indexed query*/
for each quote_hdr where confirm_date = ? no-lock:
disp auth quote_id.
end.

For records fulfilling scenario 2, I can’t think of any way of listing such records apart from going into the quote record and manually checking it because of the reasons stated in scenario 2 above.
thumbnail
David Wollin, modified 12 Years ago.

Re: Using date/logical field in a report

Post Date: 9/25/13 (Bronze, 20 Posts) Recent Posts
Using the variable is what I want to do. But, where is that field? What is the name?
RajKumar Sachdeva, modified 12 Years ago.

Re: Using date/logical field in a report

Post Date: 9/30/13 (Gold, 183 Posts) Recent Posts
There is no such field in the database that stores the toggle value you are looking for. Please see my previous response. No direct reporting on that toggle value is possible except for scenarios I stated in my previous response.
thumbnail
David Wollin, modified 12 Years ago.

Re: Using date/logical field in a report

Post Date: 10/1/13 (Bronze, 20 Posts) Recent Posts
OK Thank you.

Message place holder