Posted by ZRexRider on 10/04/06 20:36

Hi,

I've written reports based on stored procedures that receive parameters
and it usually seems straight forward.

Today I would like to use Crystal Reports parameter interface t prompt
for a "Date Range" and then pass the lower and upper date values to the
@StartDate and @EndDate of my SPROC's range.

Unfortunately when I try to build a report off of a SPROC havng two
dates it insists on prompting for date AND time indivually.

Is there a way to disable the "automatic prompting", use my own Date
Range parameter and then pass the results of the date range to the
stored procedure?

Thanks

• Next in forum: Re: How to find All Permissions in the Current Database for a particular User
• Prev in forum: How to find All Permissions in the Current Database for a particular User
• Thread view: Passing parameters to stored proc from Crystal reports

[Reply to this message]