Home > Archive > Visual Basic Crystal Reports > May 2005 > Crystal Reports Parameter Dialog Only Displays Subset of Selectable Values
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Crystal Reports Parameter Dialog Only Displays Subset of Selectable Values
|
|
| jandras 2005-05-27, 8:59 pm |
| I am working with a database that has a table called "Matters" with a
numeric key field called URI (unique
record ID). As shown by the following dialog box when I right-click
the field in CR's Field Explorer and
select Browse Data, there are 5,186 records in the Matters table:
http://www.teamandras.com/personal/5186.jpg
In my main report, I set Matters.URI as a parameter field using the
Parameter Expert:
http://www.teamandras.com/personal/Matter Expert.jpg
In the Web App that I built with VS .NET, I pass the URI to Crystal
Reports and everything works fine.
However, when working directly inside of CR to further develop the
report, if I press F5 (same as Report- Refresh Report Data), I
am only shown a small subset of the records, 1,038 to be exact:
http://www.teamandras.com/personal/1038.jpg
So, I cannot select the matter with URI of, say, 2000. Anybody know
why I don't see all of them?
Thanks in advance.
Joe.
| |
| Briscobar 2005-05-27, 8:59 pm |
| In news:1117226926.363304.163620@g49g2000cwa.googlegroups.com,
jandras <register@teamandras.com> rambled:
> I am working with a database that has a table called "Matters" with a
> numeric key field called URI (unique
> record ID). As shown by the following dialog box when I right-click
> the field in CR's Field Explorer and
> select Browse Data, there are 5,186 records in the Matters table:
>
> http://www.teamandras.com/personal/5186.jpg
Well, firstly, I see gaps in the data, there. Just because the last one is
number 5186, does that mean that there are exactly 5186 in your table? This
will depend on your data and its application.
> In my main report, I set Matters.URI as a parameter field using the
> Parameter Expert:
>
> http://www.teamandras.com/personal/Matter Expert.jpg
>
> In the Web App that I built with VS .NET, I pass the URI to Crystal
> Reports and everything works fine.
>
> However, when working directly inside of CR to further develop the
> report, if I press F5 (same as Report- Refresh Report Data), I
> am only shown a small subset of the records, 1,038 to be exact:
>
> http://www.teamandras.com/personal/1038.jpg
Are there 1,038 records there, or is it just that the last one listed is
number 1,038? By default, CR (at least version 8; i'm not sure about newer
releases) shows only the first 500 records in "Browse Field Data." You can
almost work around this by going to the report options and checking off
"Select Distinct Data for Browsing". This will return the first 500 distinct
records (which may or may not increase the number shown; again, it depends
on your data).
> So, I cannot select the matter with URI of, say, 2000. Anybody know
> why I don't see all of them?
If this is a parameter field, you can create a text file that contains all
the possible selections. For formatting this text file, check out the help
of your version of CR.
HTH.
--
KB - MCNGP "silent thug" #26
Briscobar AT gmail DOT com
Please to be www.mcngp.com visits!
|
|
|
|
|