Print Page | Close Window

Not able to create timewise report Printed From: Crystal Reports Book Category: Crystal Reports for Visual Studio 2005 and Newer Forum Name: Data Connectivity Forum Discription: How to connect to data sources and export reports URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=5571 Printed Date: 08 May 2024 at 7:39pm Topic: Not able to create timewise report Posted By: rahul.badole Subject: Not able to create timewise report Date Posted: 20 Feb 2009 at 11:25pm Hi I am storing some data with date+time thr' VB in MS access table in format like 13/02/2009 7:15:00 AM and using Crystal report 8.5 to generate report. When I browse the .MDB data from a date field , it shows only date and not showing time. Now I am able to create a date wise report correctly. But I want a date+time wise report i.e. Shift wise report (7.00 AM - 3.00 PM & 3.00 PM - 11.00 PM etc). Can anyone help me in How to set the datetime format in crystal report. i.e. " dd/mm/yyyy h:mm:ss AM/PM " in formula editor ? How to pass the date+time parameters from VB to crystal reports as a filter to create date+time wise report? Thanks in advance... Rahul B. ------------- Rahul B.

Print Page | Close Window