Solved

Crystal Reports 8.5 Select Expert

Posted on 2008-10-15
5
423 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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Suggested Solutions

Truncate is a DDL Command where as Delete is a DML Command. Both will delete data from table, but what is the difference between these below statements truncate table <table_name> ?? delete from <table_name> ?? The first command cannot be …
Checking the Alert Log in AWS RDS Oracle can be a pain through their user interface.  I made a script to download the Alert Log, look for errors, and email me the trace files.  In this article I'll describe what I did and share my script.
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.
Video by: Steve
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…

920 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

16 Experts available now in Live!

Get 1:1 Help Now