View or Sp As DataSource with Parameters

[jtrapat1]

I'm using CR8.5,VB6,and SQL- Server7.

Here's my problem:
When I use a View as a datasource, and I want to add a parameter,I add the parameter, Set Default Values> and then choose the Table then the field.
After I choose the field,the default values list on the left is populated with the values from my column in the table.
However,when I use a stored procedure as a datasource and I do the same process, after I select the field I want for my default values,the box on the left pane does not get populated.
Is this correct or am I doing something wrong?

Thanks
John

 

[kenhamady]

I just created a report using an SP in the NorthWind sample data that comes with SQL7.

I didn't get any values until I previewed some records into memory. Then it listed those as defaults.

The funny thing was it listed them as strings, sorting them by month first, then day and then year. Ken Hamady, On-site/Phone Crystal Reports Training/Consulting
Quick Reference Guide to using Crystal in VB

http://www.kenhamady.com/