Joined: 07 Nov 2013
Location: United States
Online Status: Offline
Posts: 10
Topic: Paramenter Fields limits... Posted: 08 Aug 2016 at 11:46am
When I create a (Item Code)parameter field to lookup values from a table that has about 300 records in it not able to display all the data in the table. It allow for 5 pages of selectable data and then stops. If I need to get the option to select any one of the 300 item codes, how would I change the Parameter filed to allow for this?
or
Do I need to do something else?
Joined: 29 Oct 2009
Online Status: Offline
Posts: 1587
Posted: 09 Aug 2016 at 5:22am
I know that there are limitations for a parameter field. I think Crystal Reports 2011 is up to 1000 entries. It is less with older versions. I have heard that there is a registry entry that can be changed to allow more entries. I do not recall what the name of the entry is.
Joined: 07 Nov 2013
Location: United States
Online Status: Offline
Posts: 10
Posted: 09 Aug 2016 at 8:56am
I am running 2011 version, and when I setup a new parameter field, I select Dynamic, value is Item Code. When it prompts me to Enter Values, the "item code" used to run the report I see that it has 5 pages of item codes, however it does not display all the item codes.
Joined: 29 Oct 2009
Online Status: Offline
Posts: 1587
Posted: 09 Aug 2016 at 12:19pm
I googled "crystal reports 2011 dynamic parameter limit" and several articles came up about the issue. You should be able to see 1000 entries, I do not know why you cannot.
Joined: 07 Nov 2013
Location: United States
Online Status: Offline
Posts: 10
Posted: 09 Aug 2016 at 12:46pm
I see what you are referring to and Wayne is a Sage analyst. I would think he would be correct. I going to keep trying to understand that is my situation...
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
IP Logged
