Re: Crystal reports
From: Dwight (news_at_tsystemscorp.com)
Date: 05/05/04
- Next message: vishal subramaniam: "RE: Windows NT Security"
- Previous message: Andrew J. Kelly: "Re: Transaction Log Filling Up - SQL 2000"
- In reply to: Paul: "Crystal reports"
- Messages sorted by: [ date ] [ thread ]
Date: Tue, 04 May 2004 23:10:19 -0500
Paul wrote:
> 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.
I don't worry about the time and let the procedure handle getting the
correct time.
Usually by using a convert or setting dates to be 00:00:00 to 23:59:59.
> 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?
>
Only way I know of is to use crystal enterprise.
>
>
>
- Next message: vishal subramaniam: "RE: Windows NT Security"
- Previous message: Andrew J. Kelly: "Re: Transaction Log Filling Up - SQL 2000"
- In reply to: Paul: "Crystal reports"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
