** Problem to SIMPLE format date field

[lorenmario]

I'm doing a relational report, inserted a Crosstab that need to display the date in column.
I have a simple problem, but I can not solve.
A date column appears like this:

25/03/2015 00: 00: 00.000

I applied several types of formatting and nothing works, I need to display the date like this: 25/Mar

I noticed when using a list report formatting functions normally, but when I convert to crosstab formatting does not work.

Any help will be appreciated!
Thank you

[Joker]

I'm doing a relational report, inserted a Crosstab that need to display the date in column.
I have a simple problem, but I can not solve.
A date column appears like this:

25/03/2015 00: 00: 00.000

I applied several types of formatting and nothing works, I need to display the date like this: 25/Mar

I noticed when using a list report formatting functions normally, but when I convert to crosstab formatting does not work.

Any help will be appreciated!
Thank you

Hi,

http://www-01.ibm.com/support/docview.wss?uid=swg21341061

Change Source type from  Member Caption to Data Item Value.

Thanks,

Regards,
Joker

[lorenmario]

Hi Joker thanks for reply.

I had already tried that but it did not work :(
Forgot to mention that the classification has to be applied in the report rows, where I have two fields the first column is the product code, then comes the product name.

I need the names of the products are sorted in ascending order, but as has the code column before, she's not leaving the classification work.

The report is being classified by product code, and not the product name, see the attached image.

Is there any way to make the product name of the column to be sorted correctly?

Thanks for your help!

[MFGF]

Hi Joker thanks for reply.

I had already tried that but it did not work :(
Forgot to mention that the classification has to be applied in the report rows, where I have two fields the first column is the product code, then comes the product name.

I need the names of the products are sorted in ascending order, but as has the code column before, she's not leaving the classification work.

The report is being classified by product code, and not the product name, see the attached image.

Is there any way to make the product name of the column to be sorted correctly?

Thanks for your help!

Hi,

Sorting nested row or column headings in a crosstab will *always* respect the nesting groups. You cannot sort based on a minor heading alone - the sort for these will always be within the major heading.

Cheers!

MF.

[lorenmario]

Hi MF,

So, as there is no other possibility, I have to put the product name field before the code.

Thanks for all the help!

;)