I just had this same problem and fixed it by following the link
below... Not sure if that's the same article you already looked at,
but it worked well for me.
http://technicalsupport.businessobjects.com/KanisaSupportSite/search.d
o;jsessionid=E9CC13A9EDD5FFAACF2775EFF7E50B70?
cmd=displayKC&docType=kc&externalId=c2017238&sliceId=&dialogID=360384&
stateId=1%200%20356275
below... Not sure if that's the same article you already looked at,
but it worked well for me.
http://technicalsupport.businessobjects.com/KanisaSupportSite/search.d
o;jsessionid=E9CC13A9EDD5FFAACF2775EFF7E50B70?
cmd=displayKC&docType=kc&externalId=c2017238&sliceId=&dialogID=360384&
stateId=1%200%20356275
--- In vantage@yahoogroups.com, "Brandon Murch" <bmurch@...> wrote:
>
> I stand corrected, and thank you for link - unfortunately now I
don't
> have an excuse to use the feature :)
>
> Brandon Murch
> WindStone Medical Packaging, Inc.
> Supervisor of Information Technology
> (406)259-6387
> bmurch@...
> www.windstonemedical.com
>
>
> -----Original Message-----
> From: talanaky [mailto:talanaky@...]
> Sent: Wednesday, May 09, 2007 7:35 AM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Re: Number of Parameter records Crystal retrieves
>
> I had the same issue, Business Object web site has an article:
>
>
http://technicalsupport.businessobjects.com/KanisaSupportSite/search.d
> o?
>
cmd=displayKC&docType=kc&externalId=c2014948&sliceId=&dialogID=2084000
> 6&stateId=1%200%2020838622
> or search their technical support site for article ID c2014948.
>
> "Symptom:
> When a parameter is initially created, the number of field values
> displayed in the default parameter pick list does not reflect all
of
> the unique field values in the database.
>
>
> How can the number of default values displayed for the parameter
pick
> list be increased?"
>
>
> --- In vantage@yahoogroups.com, "Brandon Murch" <bmurch@> wrote:
> >
> > I believe the limit in Crystal Reports for any "Browse field
data"
> will
> > return only the first 500 records. I don't think there is a way
to
> > increase this.
> >
> > However, you can import a list to the parameter field. Export
all
> part
> > numbers to a text file and then import this text file. That
should
> fix
> > your problem, or at least provide you a workaround.
> >
> > Brandon Murch
> > WindStone Medical Packaging, Inc.
> > Supervisor of Information Technology
> > (406)259-6387
> > bmurch@
> > www.windstonemedical.com
> >
> >
> > -----Original Message-----
> > From: Gerard Wadman [mailto:gwadman@]
> > Sent: Tuesday, May 08, 2007 3:30 PM
> > To: vantage@yahoogroups.com
> > Subject: RE: [Vantage] Number of Parameter records Crystal
retrieves
> >
> > Sorry
> > I tried.
> >
> > Mine work fine so I guess I'm stumped.
> >
> > ________________________________
> >
> > From: vantage@yahoogroups.com on behalf of Scott Litzau
> > Sent: Tue 5/8/2007 5:21 PM
> > To: vantage@yahoogroups.com
> > Subject: RE: [Vantage] Number of Parameter records Crystal
retrieves
> >
> >
> >
> > I do have the parameter set up with Dynamic.
> >
> > Scott
> >
> > -----Original Message-----
> > From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> > [mailto:vantage@yahoogroups.com <mailto:vantage%
> 40yahoogroups.com> ] On
> > Behalf Of
> > Gerard Wadman
> > Sent: Tuesday, May 08, 2007 3:34 PM
> > To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> > Subject: RE: [Vantage] Number of Parameter records Crystal
retrieves
> >
> > Oh OK,
> >
> > Make sure you have "dynamic" selected in the parameter
> > properties "List of Values" field.
> >
> > ________________________________
> >
> > From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> > [mailto:vantage@yahoogroups.com <mailto:vantage%
> 40yahoogroups.com> ] On
> > Behalf
> > Of Scott Litzau
> > Sent: Tuesday, May 08, 2007 4:07 PM
> > To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> > Subject: RE: [Vantage] Number of Parameter records Crystal
retrieves
> >
> > Re-reading my Post I don't think I was explaining myself well.
> >
> > I meant that I create a Parameter, say for Part Number, add it to
> the
> > report
> > for Selection Criteria when running it. I run the report and in
the
> Drop
> > Down box for Part Number when entering Values it only shows X
> number of
> > Part
> > Numbers. It does not give the user all the Part Numbers to choose
> from.
> >
> > Scott
> >
> > -----Original Message-----
> > From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> > <mailto:vantage%40yahoogroups.com>
> > [mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> > <mailto:vantage%40yahoogroups.com> ] On
> > Behalf Of
> > Gerard Wadman
> > Sent: Tuesday, May 08, 2007 2:34 PM
> > To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> > <mailto:vantage%40yahoogroups.com>
> > Subject: RE: [Vantage] Number of Parameter records Crystal
retrieves
> >
> > Scott,
> >
> > It all depends on the method of data retrieval. For instance
> > if you connect directly to the database via ODBC you will see all
> the
> > records but if you have the data passed via XML, it will only see
> the
> > data that meets any filter criteria defined in the XML form.
> >
> > Most vantage forms have selection criteria and queries in the
> underlying
> > code so when an XML datasheet is created it only passes the
filtered
> > result.
> >
> > ________________________________
> >
> > From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> > <mailto:vantage%40yahoogroups.com>
> > [mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> > <mailto:vantage%40yahoogroups.com> ] On
> > Behalf
> > Of Scott Litzau
> > Sent: Tuesday, May 08, 2007 3:15 PM
> > To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> > <mailto:vantage%40yahoogroups.com>
> > Subject: [Vantage] Number of Parameter records Crystal retrieves
> >
> > Anyone know why Crystal only pulls a certain number of records
for
> > Parameter fields when choosing. For example if the Parameter
field
> was
> > Part Number it is only pulling X amount (not sure how many) and
not
> all
> > Part Numbers.
> >
> > [Non-text portions of this message have been removed]
> >
> > Useful links for the Yahoo!Groups Vantage Board are: ( Note: You
> must
> > have
> > already linked your email address to a yahoo id to enable
access. )
> > (1) To access the Files Section of our Yahoo!Group for Report
> Builder
> > and
> > Crystal Reports and other 'goodies', please goto:
> > http://groups.yahoo.com/group/vantage/files/.
> > <http://groups.yahoo.com/group/vantage/files/>
> > <http://groups.yahoo.com/group/vantage/files/
> > <http://groups.yahoo.com/group/vantage/files/> >
> > (2) To search through old msg's goto:
> > http://groups.yahoo.com/group/vantage/messages
> > <http://groups.yahoo.com/group/vantage/messages>
> > <http://groups.yahoo.com/group/vantage/messages
> > <http://groups.yahoo.com/group/vantage/messages> >
> > (3) To view links to Vendors that provide Vantage services goto:
> > http://groups.yahoo.com/group/vantage/links
> > <http://groups.yahoo.com/group/vantage/links>
> > <http://groups.yahoo.com/group/vantage/links
> > <http://groups.yahoo.com/group/vantage/links> >
> > Yahoo! Groups Links
> >
> > [Non-text portions of this message have been removed]
> >
> > Useful links for the Yahoo!Groups Vantage Board are: ( Note: You
> must
> > have
> > already linked your email address to a yahoo id to enable
access. )
> > (1) To access the Files Section of our Yahoo!Group for Report
> Builder
> > and
> > Crystal Reports and other 'goodies', please goto:
> > http://groups.yahoo.com/group/vantage/files/.
> > <http://groups.yahoo.com/group/vantage/files/>
> > (2) To search through old msg's goto:
> > http://groups.yahoo.com/group/vantage/messages
> > <http://groups.yahoo.com/group/vantage/messages>
> > (3) To view links to Vendors that provide Vantage services goto:
> > http://groups.yahoo.com/group/vantage/links
> > <http://groups.yahoo.com/group/vantage/links>
> > Yahoo! Groups Links
> >
> >
> >
> >
> >
> >
> > [Non-text portions of this message have been removed]
> >
> >
> >
> > Useful links for the Yahoo!Groups Vantage Board are: ( Note: You
> must
> > have already linked your email address to a yahoo id to enable
> access. )
> > (1) To access the Files Section of our Yahoo!Group for Report
> Builder
> > and Crystal Reports and other 'goodies', please goto:
> > http://groups.yahoo.com/group/vantage/files/.
> > (2) To search through old msg's goto:
> > http://groups.yahoo.com/group/vantage/messages
> > (3) To view links to Vendors that provide Vantage services goto:
> > http://groups.yahoo.com/group/vantage/links
> > Yahoo! Groups Links
> >
> >
> >
> >
>
**********************************************************************
> *
> > Privileged and/or confidential information may be contained in
> > this message. If you are not the addressee indicated in this
> > message (or are not responsible for delivery of this message to
> that person), you may not copy or deliver this message to
> > anyone. In such case, you should destroy this message and
> > notify the sender by reply e-mail. If you or your employer do
> > not consent to Internet e-mail for messages of this kind,
> > please advise the sender. Windstone Medical Packaging,
> > Inc. does not provide or endorse any opinions, conclusions
> > or other information in this message that do not relate to the
> > official business of the company.
> >
>
**********************************************************************
> *
> >
>
>
>
>
> Useful links for the Yahoo!Groups Vantage Board are: ( Note: You
must
> have already linked your email address to a yahoo id to enable
access. )
> (1) To access the Files Section of our Yahoo!Group for Report
Builder
> and Crystal Reports and other 'goodies', please goto:
> http://groups.yahoo.com/group/vantage/files/.
> (2) To search through old msg's goto:
> http://groups.yahoo.com/group/vantage/messages
> (3) To view links to Vendors that provide Vantage services goto:
> http://groups.yahoo.com/group/vantage/links
> Yahoo! Groups Links
>
>
>
>
**********************************************************************
*
> Privileged and/or confidential information may be contained in
> this message. If you are not the addressee indicated in this
> message (or are not responsible for delivery of this message to
that person), you may not copy or deliver this message to
> anyone. In such case, you should destroy this message and
> notify the sender by reply e-mail. If you or your employer do
> not consent to Internet e-mail for messages of this kind,
> please advise the sender. Windstone Medical Packaging,
> Inc. does not provide or endorse any opinions, conclusions
> or other information in this message that do not relate to the
> official business of the company.
>
**********************************************************************
*
>