I added a column to a report. In this column I created the variable “days open” that is the number of days from current date in which a work order was opened. I want to apply a condition on this variable. How do I do this? When I go to the edit data provider, the variable is not listed for me to drag into the condition section.
Any help is greatly appreciated.
Dave
Listserv Archives (BOB member since 2002-06-25)
Dave,
User defined variables are available at the report level only. If you need to use this variable in the query itself, you would have to set it up as a user object or as an object in the universe.
Good Luck!
Shelley
______________________________ Reply Separator _________________________________
Author: CaddellD@PRISMPLUS.COM at ~DISNEY-SMTP
Date: 3/7/2000 6:20 AM
I added a column to a report. In this column I created the variable
“days
open” that is the number of days from current date in which a work order was opened. I want to apply a condition on this variable. How do I do this? When I go to the edit data provider, the variable is not listed for me to drag into the condition section.
Any help is greatly appreciated.
Dave
Listserv Archives (BOB member since 2002-06-25)
How about inserting a filter on the “days open” column in the report?
George Baranowski
QuadraMed
Listserv Archives (BOB member since 2002-06-25)
Dave,
If you have created a variable, or calculation, in the report this will not be available in the query panel. You can still apply a filter in the report, but this will only limit what appears on the report, the actual data is still “behind the scenes” in the report.
If you want to reduce the volume of data being retrieved from the database you must use a condition based upon the objects in your universe or based upon user defined objects (UDOs).
It’s all a matter of when the filtering is done: on the database or in the report.
If you go for UDOs then these are stored on your local PC so swapping reports with other users.
Steve
Listserv Archives (BOB member since 2002-06-25)