Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2020 : Report Design
Message Icon Topic: input parameter not showing all available values Post Reply Post New Topic
Author Message
bigdummy76
Newbie
Newbie


Joined: 17 Jun 2011
Location: United States
Online Status: Offline
Posts: 15
Quote bigdummy76 Replybullet Topic: input parameter not showing all available values
    Posted: 21 Jul 2011 at 7:11am
I have a report with a dynamic input parameter based on a field in a table. The parameter allows for multiple values. The table has X distinct values in the field used for the input parameter. The input parameter is not displaying all possible values available.

Field values                     Input parameter available values
1                                         1
2                                         2
3                                         3
4
5

The report was created in 2008. The user is running XI. Could that be an issue.                           
IP IP Logged
lockwelle
Moderator
Moderator


Joined: 21 Dec 2007
Online Status: Offline
Posts: 4372
Quote lockwelle Replybullet Posted: 21 Jul 2011 at 7:36am
are all the values valid for the data?
 
I have seen this before, and it seems that CR will only display values that will return a report.
 
HTH
IP IP Logged
bigdummy76
Newbie
Newbie


Joined: 17 Jun 2011
Location: United States
Online Status: Offline
Posts: 15
Quote bigdummy76 Replybullet Posted: 22 Jul 2011 at 1:52am
There is a default limit of 1000 rows in a dynamic parameter. You can change the value by editing a registry key.

http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=8029
IP IP Logged
roadwarrior01
Newbie
Newbie


Joined: 09 Nov 2011
Location: Canada
Online Status: Offline
Posts: 1
Quote roadwarrior01 Replybullet Posted: 09 Nov 2011 at 4:48am
Running into the same problem.  Using Crystal Reports 2008 (Enterprise), accessing SAP ECC 6.0.  Several attempts on different reports/fields, return maybe a dozen items for drop down.  If I run the report wide open, many other reportable items show up.  any ideas?
IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum



This page was generated in 0.000 seconds.