Date Display in Crystal Report 2011 from SAP BW

[Former Member]

Hello,

I am using SAP BW MDX Query connection to connect to BEX Query.

The BEX Query has a date field.

I am able to connect and create Crystal Report but the date field data is showing as # in the Crystal Report Output.

How to display BW Date in proper format in Crystal Reports 2011/2013.

Regards,

Surya Kumar

[former_member203168]

Hi Surya,

Did you try copying the generated MDX code from CR and paste it into the MDXTEST transaction in BW? That could help you pinpoint where the difference comes from.

What is your BW version?

Did you import all the transports?

--Praveen G

[Former Member]

Hi,

Please check your BW side data, date field having any null values then #,not assigned values coming from BEX Query.

In crystal formatted the date field many ways.

1. Write click on data field -> format field -> date tab -> by default system date assigned -> you can assign what format you want.

2. Write a formula to display the date field: http://www.c-sharpcorner.com/UploadFile/mahesh/DateFormatInCR06132007092248AM/DateFormatInCR.aspx

Thanks,

DJ