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
Quote from: lorenmario on 26 Mar 2015 08:47:04 AM
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
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!
Quote from: lorenmario on 27 Mar 2015 07:29:02 AM
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.
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!
;)