any solution for this ? Date parameter
Printed From: Crystal Reports Book
Category: Crystal Reports for Visual Studio 2005 and Newer
Forum Name: Writing Code
Forum Discription: .NET programming API, report integration
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=8473
Printed Date: 15 Apr 2024 at 7:08pm
Topic: any solution for this ? Date parameter
Posted By: zakal1983
Subject: any solution for this ? Date parameter
Date Posted: 24 Nov 2009 at 9:07pm
For simplicity, I will just list the basic settings.
- Oracle 10 DB
- Crystal Reports XI
- Visual Studio 2008 C#
The Crystal Reports, rpt file has
- cross tab
- two 'date' parameters
- selection using 'date' parameters (formula is like
table.datevalue <= start_date and table.datevalue <= end_date)
The implementation is :
- C# DLL Class library that converts rpt to pdf file.
- take two parameters from users and send it to rpt file
- rpt file is supposed to generate a report using two 'date' parameters. (the data consists of falls between start and end date) (used Export())
- to send parameter values to rpt file, used
Convert.ToDateTime(string value)
Problem is :
- I can successfully convert a rpt file to pdf file if I just send two date values and print them on the report. However, when I try to generate a report that consists of data that falls in two different dates (start and end), it gives me the database load error.
Is that because of the type (Date and DateTime) difference?
I am pretty sure that it is not about the connection problem as I can get the pdf file with the default values on start and end date.
Thank you
|
|