Crystal reports
From: Paul (pe_at_nospam.com)
Date: 05/04/04
- Next message: Jacco Schalkwijk: "Re: running multiple scripts"
- Previous message: mark baekdal: "RE: running multiple scripts"
- Next in thread: Anith Sen: "Re: Crystal reports"
- Reply: Anith Sen: "Re: Crystal reports"
- Reply: Dwight: "Re: Crystal reports"
- Messages sorted by: [ date ] [ thread ]
Date: Tue, 4 May 2004 10:42:28 -0400
Hi, maybe off-topic but I've found this group to be full of very smart
people so I'll give it a try!
We currently have a lot of Crystal reports and we are considering changing
our philosophy on how we use it. We are thinking that instead of linking
tables, creating complicated sub-reports etc, we are instead going to use
SQL SERVER stored procedures to get the data, and then use Crystal will do
the formatting.
We've been experimenting and having a problem with date fields. If a date
field is an input parameter to our stored procedure, when crystal displays
the selection criteria box it asks for the date and time and the selection
fields are really hard to use, ideally we want to just select the date using
the date selector Crystal uses, but because SQL SERVER doesn't (YET!) have a
DATE only field Crystal is always asking for the time.
Also, does anybody have any suggestions how we get around the fact that
dropdown in Crystal cannot be database driven only text file driven, right
now we are creating DTS packages to read the database, and write to a text
file, and the DTS package runs every hour, surely an easier way must exist?
Any suggestions?
- Next message: Jacco Schalkwijk: "Re: running multiple scripts"
- Previous message: mark baekdal: "RE: running multiple scripts"
- Next in thread: Anith Sen: "Re: Crystal reports"
- Reply: Anith Sen: "Re: Crystal reports"
- Reply: Dwight: "Re: Crystal reports"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
