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...

Thank you so much... I'm not sure if I didn't explain it correctly but the MDATE field keeps a number representing the days that have gone by since 1/1/1841....so won't me adding this number to sysdate give me a future number? or am I supposed to use MDATE (it's a number though) in place of...

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...

This site will be a bit more specific on the error messages you get.. http://ora-03277.ora-code.com/all.html

The subreport (with Parameter link) works... Thank You! g

thanks lbass, but is there anyway to display the "names" in the header? otherwise I could just have dropped the names on the report, thing is they didn't ask for it to be included on the report but I would like them to see what order types they selected. I know it doesn't make a lot of sense...

Sorry about that (First Time) It's Crystal XI and here is the formula that finally allowed all the parameters to display... numbervar counter; stringvar display; for counter := 1 to count({?Order Type}) do ( display := display + totext({?Order Type}[counter],0,"") + ", "); left(display...

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...