Writing Code
 Crystal Reports Forum : Crystal Reports for Visual Studio 2005 and Newer : Writing Code
Message Icon Topic: any solution for this ? Date parameter Post Reply Post New Topic
Author Message
zakal1983
Newbie
Newbie


Joined: 24 Nov 2009
Online Status: Offline
Posts: 8
Quote zakal1983 Replybullet Topic: any solution for this ? Date parameter
    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
IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum



This page was generated in 0.047 seconds.