| T O P I C R E V I E W |
| Z0n3R |
Posted - 02/24/2012 : 10:15:50
Good day,
From another thread I read that ReportPortal doesn't support formatting on numerical values (rounding, etc)...but how is this handled on datetime values?
I don't want to see T-SQL format YYYY-MM-DD 00:00:00.000 -- I just want to see the date MM/DD/YYYY.
Thanks!!
|
| 5 L A T E S T R E P L I E S (Newest First) |
| Z0n3R |
Posted - 02/24/2012 : 14:00:40
quote:
[i]Originally posted by admin[/i]
[br]Please read this Microsoft article that explains how to format dates in the Data Source View.
http://msdn.microsoft.com/en-us/library/ms166578.aspx
That's the trick. Thanks so much. :) |
| admin |
Posted - 02/24/2012 : 13:50:41
Please read this Microsoft article that explains how to format dates in the Data Source View.
http://msdn.microsoft.com/en-us/library/ms166578.aspx |
| Z0n3R |
Posted - 02/24/2012 : 13:42:46
quote:
[i]Originally posted by admin[/i]
[br]OLAP report supports formatting of dates and numbers for measure via calculated measures. OLAP report does not support formatting of dimensional member names. You would have to do this in a data source view like
select CONVERT(varchar, GetDate(), 101) as MyDate
Hmmm, I'm sorry. I'm confused. Are you saying within SSAS I can format date members? Datetime columns are converted to YYYY-MM-DD 00:00:00.000 members when the cube is processed. I'm unaware of any way to change this and have always formatted the date in the report setup when using SSRS. ReportPortal doesn't have this capability? The above example is SQL--which I can do--but are you saying I have to set something new up in SSAS just to format a date member?
Sorry for the confusion. Thank you! |
| admin |
Posted - 02/24/2012 : 12:49:26
OLAP report supports formatting of dates and numbers for measure via calculated measures. OLAP report does not support formatting of dimensional member names. You would have to do this in a data source view like
select CONVERT(varchar, GetDate(), 101) as MyDate
|
| Z0n3R |
Posted - 02/24/2012 : 10:16:58
Just to clarify...this is strictly for OLAP reports.
thx! |
Report Portal
