Date/Time filter in Universe

[tamsden]

We are using Business Objects XI Premium with SQL databases... we have universes that I am trying to have the programmer write to use date range filters. He says the only way he can give me a date range is if it uses date/time. We have been told to only display date/time if the time is important to the report.

Can I get a filter in a universe with just date format or do I have to put that parameter in the Crystal report and filter the data after it's returned to the report?

I've searched the pages on Business Objects and the forums here with no luck. Any ideas?

tamsden

 

[blom0344]

This issue was adressed in a post some days earlier.
Basically SQL server date types contain date+time. You can use trunc and floor functions on the date fields.

Anyway, if you use the date as such then just entering the date part will result in a default value for the time part.

The CONVERT function will allow you to extract any format from the date/time format to create objects that need to be displayed within a report (as strings).



Ties Blom

 

[tamsden]

Is there any way to get the universe prompt for the date to only request date and not date/time? We have reports where the time is significant and in this report it is not. We have been asked to not ask for date/time unless it is significant to the report. I can't find a way to specify date only on the universe prompts.

 

[xlbo]

if you enter a date only, a 00:00:00 time will automatically be added to it and the query should not be affected

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question

 

[tamsden]

Yes, and that's what we are getting. However they insist that unless time really is a factor, they don't want it added so I have to have a date only parameter. The only way I've found to make that happen, is to do a date parameter on the report in Crystal - but that slows down the return of records.

 

[blom0344]

Did you look into the convert function and try that out on a new universe object? Alternatively alter the LOV (list of values) by assigning a string representant to the date object..

Ties Blom

 

[skrandel]

It's really a matter of creating a condition object that compares the prompted value to a truncated value in the database.

Steve Krandel
Symantec