Format Dates in Report Studio 8

[rolphdog]

Hi all,

--SQL Server 2000, Report Studio 8--

I'm trying to format a date field as dd/mm/yyyy and use it as a grouped item in a crosstab report and on a chart as a category axis. I can't get rid of the time 00:00 at the end of the field no matter how I play with the format property.

Is the only option to cast as text and work with substrings? (seems a bit ugly)

cheers!

 

[Nuffsaid]

Hi,

I've just recently installed 8 with an Oracle back end and have been "exploring", before we migrate from ReportNet, and have come accross the same issue. Bug? Here's something else I came accross and was told by support that this IS a known bug. I use the Trunc function to chop the time of my date field for use with parameters, like this...

trunc([date_time_field])between ?from? and ?to?

When you do this Report Studio converts the parameters to numeric values....?????.....bizzare.

Got a feeling migration ain't gonna be easy...

Nuffsaid.

 

[Nuffsaid]

I'm back...

Found this in the KB...

Description:

In Report Studio, when creating a chart you may be trying to format a date dimension to only show the months and years of that dimension rather that the entire date. When you change the format, the changes do not show for the chart, it continues to show the entire date. Yet if you make the same format changes for a list report, the formatting changes do appear to take effect.

This is based on Cognos 8.1.52.56

Solution:

Check the Source Type Property and ensure it is set to Data Item Value.

Steps:

1) Click on the "Date" in the Chart
2) Change the "Source Type" to "Data Item Value" (from "Member Caption" in this case)

The formatting should now take effect.


Nuffsaid.

 

[rolphdog]

It works!
Great tip, thanks.