Few weeks ago I have wrote on how to hack Crystal Reports 2008 ASP.Net Viewer control to suppress time part in the parameter calendar control. With release of Service Pack 1 for Crystal Reports 2008, suggested solution no longer works since structure of the files has been changed. So I went Read more…
We have created our perfect reporting solution using Crystal Reports 2008 viewer control, tested everything, and deployed it into production environment… and it is working… until Friday night… 🙁 Information below is provided for both IIS 6 and IIS 7 along with 32 and 64 bit Windows environment. Make sure Read more…
One would think that this should be a no-brainer : ability to specify an edit format for date/time parameter in Crystal Reports. Not so fast…
Problem is as following:
ASP.Net Web client with Crystal Reports Viewer control is used.
When our report is based of some stored procedure which uses datetime parameter, it will inherit it as is and when report parameter entry form is displayed we would be asked to enter both date and time portion.
While, in general, it is OK, some reports are really interested only in date part being entered and time should be always set to 00:00:00. So we are forced to type time every time because if it is not provided calendar control would try to set time part initially to current time.
After some research off the Internet, visiting SAP forums, it is appear to be engine limitation. But we would want to overcome it somehow.
DISCLAIMER: solution below could only be used as a last resort and only if your business logic requires using date only params. And while it is only applies to calendar control, it is not per se a generic solution. This is a first “rough” attempt of achieving desired result and may lack some features otherwise expected.
It has been reported that solution above only works for current month. Since we are now using Crystal Reports 2008 with SP1, I would address this issue in my new post below.
IMPORTANT! With release of Service Pack 1 for Crystal Reports 2008, method blow is no longer applicable since structure of the files has changed. Please refer to this new post for more information.
Otherwise, Where there is a will, there is a way…
Fortunately we have access to internals behind the parameter handlers in Crystal Report Viewer web control.
Navigate to one of following locations:
- C:\Program Files\Business Objects\Common\4.0\crystalreportviewers12\
and locate the file called allInOne.js – this is our victim. This file contains all JS code behind for CRV control which would be used by your web-site.
IMPORTANT: always create a backup copy before making any modifications.
From part 1 of this article, you got list of steps in order to deploy Crystal Reports 2008 project created in Visual Studio 2008.
Next step is to choose deployment strategy, prepare installation script and then install it on IIS server.
There is enough written about deployment process from within Visual Studio so let’s give some people credit for their work – for example, please check this article – I am going to use it as a base.
All things considered there is still a variation to that process specific to Crystal Reports.
Note: Make sure you have latest runtime available for you – visit SAP download page – as of 10/19/2009 runtime version available is 12.2 .
Crystal Reports Deployment strategy This is a first part of the discussion about what it takes to deploy Crystal Reports 2008 based project created in Visual Studio. Dependencies When you develop something which involves Crystal Reports you need to deploy CR 2008 run-time along with your project. As you know Read more…
One of my projects is to maintain application which creates export files off the Crystal Reports reports. There is a little post about my experience migrating to CR 2008. Just a little background I am using Crystal Reports since 1997. As you can see it has been a long time. Read more…