Search results for query: *

Good Morning, Can someone please tell me how to convert SSSS (Seconds since midnight) to HH:MI in Universe Designer? For example 55,080 = 3:18 PM This is simple enough in Crystal TimeSerial (0,0,55080) but I cannot for the life of me figure it out in Oracle. I have tried to_timestamp and...

Hello, I know how restrict the specific objects in the universe (through either the Security Access Level or creating object restrictions). However, I need to restrict ALL objects so that the only data elements a user can see are those that pertain to their own Department?? Is this even...

hello, can someone please tell me how to reset a timevar? I have tried (0,0,0)(adding more 0's), ":" I am using Crystal XI R2 my time variable is working fine but I cannot get it to reset (and therefore stop pulling from the previous) whileprintingrecords; shared timevar proc_start_time :=...

Hello, I need to know the Universe Designer syntax for the following 2 Crystal Functions that I created to translate Mumps Date and Mumps Time. Function (StringVar MTIME) TimeSerial(0,0,tonumber(MTIME)) This takes a numeric and translates it to a time...for example "70" gets translated to...

Hello, I have a numeric parameter that I was able to create a display formula for (join function would not work with this parameter) to get all the selected values to show. However, now I would like the translations and not the actual selected values to appear. For example, I currently have...