Solved

Crystal Reports 8.5 Select Expert

Posted on 2008-10-15
5
424 Views
Last Modified: 2012-05-05
I have created a report in which I will use the Select Expert to filter records. I want to enter 2500 items in the list (using "in list") without having to manually enter each one.  How can i do this?

Thanks.
0
Comment
Question by:missileman72211
5 Comments
 
LVL 100

Accepted Solution

by:
mlmcc earned 100 total points
ID: 22722628
First you will have to make a registry modification since Crystal is limited to 1000 items in a parameter list.

If they values are in the table you can use the table itself as the source of the list
It won't change once deployed.

If you attach a screen shot of the CR8.5 parameter create screen I'll try to figure out what to click

mlmcc
0
 
LVL 1

Expert Comment

by:sjjcat
ID: 22728495
Can you import the list of items into a table in your database?  Then, in Crystal, link between your data table and the table with the list using an innner join.  Your report should then only display data for the records that match in the linked table. Then if you want to increase, or change, from the existing 2500 values you can update the table.  If the criteria list is something that may be maintained by an end user - who would not have access to the database - this may not be the best option.
S
0
 

Author Comment

by:missileman72211
ID: 22730129
I don't have the rights to create tables in the Oracle database.  I only have unique identifiers for all 32,000 records.  My goal is to pull details for 2500 specific records in the group of 32,000. Since I'm not yet an expert using Crystal 8.5, I'm trying to use Select Expert.
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Working with Network Access Control Lists in Oracle 11g (part 1) Part 2: http://www.e-e.com/A_9074.html So, you upgraded to a shiny new 11g database and all of a sudden every program that used UTL_MAIL, UTL_SMTP, UTL_TCP, UTL_HTTP or any oth…
Cursors in Oracle: A cursor is used to process individual rows returned by database system for a query. In oracle every SQL statement executed by the oracle server has a private area. This area contains information about the SQL statement and the…
This video explains at a high level with the mandatory Oracle Memory processes are as well as touching on some of the more common optional ones.
This video shows how to copy a database user from one database to another user DBMS_METADATA.  It also shows how to copy a user's permissions and discusses password hash differences between Oracle 10g and 11g.

816 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

7 Experts available now in Live!

Get 1:1 Help Now