This is an archive of the Maximo Yahoo Community. The content of this pages may be a sometimes obsolete so please check post dates.
Thanks to the community owner Christopher Wanko for providing the content.
Hi guys: I notice there's not a lot of reporting questions on here - is there another forum for reporting?
My question is: the date formatting is inconsistent between date fields in the same report. I want the dates to only be displayed in short date format, i.e. m/d/y. Some dates are doing that fine - but no matter what I do, other dates are still displaying with the time as well.
Can anyone tell me what's going on?
Shannon
Hi Shannon
Have you made sure the Output Columns Type is set to "Date" on all the
necessary fields rather than "Date Time". Also click on the properties of
the field in question and check what the date format is showing. There is a
drop down list to select from.
Hope that helps. If not send me something off line.
Regards
Peter
From: MAXIMO@yahoogroups.com [mailto:MAXIMO@yahoogroups.com] On Behalf Of
shannonrotz
Sent: Thursday, 8 September 2011 8:12 AM
To: MAXIMO@yahoogroups.com
Subject: [MAXIMO List] BIRT Reporting problems
Hi guys: I notice there's not a lot of reporting questions on here - is
there another forum for reporting?
My question is: the date formatting is inconsistent between date fields in
the same report. I want the dates to only be displayed in short date format,
i.e. m/d/y. Some dates are doing that fine - but no matter what I do, other
dates are still displaying with the time as well.
Can anyone tell me what's going on?
Shannon
Shannon,
If you go into the SQL and perform a To_char() on the date field, specifiing the format "MMDDYYYY" for example, does that change your results?
-Todd
--- In MAXIMO@yahoogroups.com, "shannonrotz" <shannonrotz@...> wrote:
>
> Hi guys: I notice there's not a lot of reporting questions on here - is there another forum for reporting?
>
> My question is: the date formatting is inconsistent between date fields in the same report. I want the dates to only be displayed in short date format, i.e. m/d/y. Some dates are doing that fine - but no matter what I do, other dates are still displaying with the time as well.
>
> Can anyone tell me what's going on?
>
>
> Shannon
>
Hi,
Setting the date format for each field usually works.
But sometimes making a change on the design screen gets out of synch with the XML code. I've had to go in and fix the code on some reports. Usually that happens when I have used a data field and then deleted it later.
Dave Bone
--- In MAXIMO@yahoogroups.com, "shannonrotz" <shannonrotz@...> wrote:
>
> Hi guys: I notice there's not a lot of reporting questions on here - is there another forum for reporting?
>
> My question is: the date formatting is inconsistent between date fields in the same report. I want the dates to only be displayed in short date format, i.e. m/d/y. Some dates are doing that fine - but no matter what I do, other dates are still displaying with the time as well.
>
> Can anyone tell me what's going on?
>
>
> Shannon
>
>
> Hi guys: I notice there's not a lot of reporting questions on here - is there another forum for reporting?
>
I use http://www.birt-exchange.org/org/forum/ for anything BIRT related.
>
> My question is: the date formatting is inconsistent between date fields in the same report. I want the dates to only be displayed in short date format, i.e. m/d/y. Some dates are doing that fine - but no matter what I do, other dates are still displaying with the time as well.
>
> Can anyone tell me what's going on?
>
Are the values stored as a date or date and time in the database?
Select a data field which is displaying date and time. In the Properties tab of the Property Editor, there is an option for Format DateTime. You should be able to set the field to display only the date part from here.