Parameter Defaults missing

[piercey]

I have a report that based around a SQL stored procedure. The default values for one of my parameters are drawn from a field on the stored procedure.

The problem is that when I look at the values that the stored procedure produces in SQL it is different to the list of values I see when I select the values for the default value.

In other words it looks like the default value selection screen is somehow filtering out some of the rows of the stored procedure. There is no selection on the report, so I have no idea why it's no showing the full list of values.

Anyone have any suggestions?

I'm using Crystal Reports 9.

 

[synapsevampire]

Parameters aren't dynamic in CR 9.

What you saved at design time is what is displayed.

As for the SP filtering, whatever is in the joins, permissions for that user, and the where clause dictate what is returned and displayed by Crystal. Crystal doesn't elect to drop some unless you exceed the amount that is designated in the registry (I can't recall, 100 or 500, but this can be changed).

-k

 

[piercey]

There is a single Stored Procedure with no links or filtering of any kind. I also doubt that security is an issue although all these things were worth checking.

If a parameter value exceeds the limit, whether it be 100 or 500, does it truncate the text or drop the value completely?

Thanks for your help.

 

[synapsevampire]

It drops the values.

Here's a whitepaper of interest:

http://support.businessobjects.com/library/kbase/articles/c2012684.asp

-k