mibuso.com

Microsoft Business Solutions online community
It is currently Wed Nov 26, 2014 8:59 pm

All times are UTC + 1 hour




Post new topic Reply to topic  [ 7 posts ] 
Author Message
 Post subject: Problem with date display in RDLC Report
PostPosted: Tue Dec 04, 2012 11:08 am 
Offline

Joined: Thu Jun 21, 2012 10:13 am
Posts: 457
Country: France (fr)
Hi everyone,

I am trying to make a report add a layout to a report...
I have a problem with the display of a date field in RTC...
For example, in the Classic form, the report displays 12/04/2012 but in RTC, it displays 12/04/2012 00:00:00...

How can I get my field value displayed just like in the classic report???


Top
 Profile E-mail  
 
 Post subject: Re: Problem with date display in RDLC Report
PostPosted: Tue Dec 04, 2012 11:12 am 
Offline
MVP Microsoft Dynamics NAV
NAV TechDays 2014 attendee

Joined: Tue Sep 02, 2008 7:37 am
Posts: 4615
Location: Hyderabad
Country: India (in)
Use Format(field) in classic sections sourceexpression

_________________
-Mohana
http://mibuso.com/blogs/mohana
http://mohana-dynamicsnav.blogspot.in/
https://www.facebook.com/MohanaDynamicsNav


Top
 Profile  
 
 Post subject: Re: Problem with date display in RDLC Report
PostPosted: Tue Dec 04, 2012 11:29 am 
Offline

Joined: Thu Jun 21, 2012 10:13 am
Posts: 457
Country: France (fr)
mohana_cse06 wrote:
Use Format(field) in classic sections sourceexpression

The problem is that when I created the RDLC layout using Create Layout Suggestion, the field was missing from the created layout so I added it manually using the DataSet...then I got it displayed that way...

How can I correct that???


Top
 Profile E-mail  
 
 Post subject: Re: Problem with date display in RDLC Report
PostPosted: Tue Dec 04, 2012 11:33 am 
Offline
MVP Microsoft Dynamics NAV
NAV TechDays 2014 attendee

Joined: Tue Sep 02, 2008 7:37 am
Posts: 4615
Location: Hyderabad
Country: India (in)
Already gave you the solution.

Set Format(field) in classic sections sourceexpression property..

_________________
-Mohana
http://mibuso.com/blogs/mohana
http://mohana-dynamicsnav.blogspot.in/
https://www.facebook.com/MohanaDynamicsNav


Top
 Profile  
 
 Post subject: Re: Problem with date display in RDLC Report
PostPosted: Tue Dec 04, 2012 11:45 am 
Offline

Joined: Thu Jun 21, 2012 10:13 am
Posts: 457
Country: France (fr)
mohana_cse06 wrote:
Already gave you the solution.

Set Format(field) in classic sections sourceexpression property..


The displayed result is 12/04/12...I want it to be 12/04/2012...
How to do that???


Top
 Profile E-mail  
 
 Post subject: Re: Problem with date display in RDLC Report
PostPosted: Tue Dec 04, 2012 11:56 am 
Offline
MVP Microsoft Dynamics NAV
NAV TechDays 2014 attendee

Joined: Tue Sep 02, 2008 7:37 am
Posts: 4615
Location: Hyderabad
Country: India (in)
Please Search how to use FORMAT function to display dates..

_________________
-Mohana
http://mibuso.com/blogs/mohana
http://mohana-dynamicsnav.blogspot.in/
https://www.facebook.com/MohanaDynamicsNav


Top
 Profile  
 
 Post subject: Re: Problem with date display in RDLC Report
PostPosted: Tue Dec 04, 2012 12:00 pm 
Offline

Joined: Tue Sep 18, 2012 5:19 pm
Posts: 311
Country: United Kingdom (uk)
What stopping you to use VisualStudio date format properties?


Top
 Profile E-mail  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 7 posts ] 

All times are UTC + 1 hour


Who is online

Users browsing this forum: No registered users and 10 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum


Search for:
Jump to: