Solved

Append all database values in Parameter not bringing in all data.

Posted on 2011-03-14
15
1,388 Views
Last Modified: 2012-05-11
Basically I'm creating a parameter in Crystal so the user can select which codes they want to view.. Problem is, whenever I select Actions, Append all database values, It is only giving me the first 3 from the list! I could add them in manually but really don't want to do that..

The field/database I am appending from is complete.. If I go to my field explorer, select the field and hit browse, all my values are there..

Appreciate any help!

Thanks
0
Comment
Question by:SeyerIT
  • 8
  • 6
15 Comments
 
LVL 17

Expert Comment

by:MIKE
ID: 35134939
Try deleting the Parameter and starting over from scratch. i'm testing in CR XI R2, what version are you using?

Also, be very sure your data field is the correct field,...something seems strange here...?

0
 
LVL 2

Author Comment

by:SeyerIT
ID: 35137352
I have Crystal Reports 2008. I have deleted the parameter and recreated it over and over... It's wierd.. Seems like if I browse that field and all my data shows up it should be pulling in.

Even If I try to create a parameter using other data it does the same thing. Such as employee number. It will only pull in the first 15-20.. There are a lot more in the list if I browse the field.
0
 
LVL 100

Expert Comment

by:mlmcc
ID: 35139080
Have you tried running the report and entering a value?

Is this in a COMMAND or regular Crystal parameters?

mlmcc
0
 
LVL 2

Author Comment

by:SeyerIT
ID: 35141914
This is in regular crystal parameters..

I manually created the remainder of the list in the parameter and am able to select any of the entries. All the selected data shows up just fine.. It just won't append the list automatically for some reason..
0
 
LVL 100

Expert Comment

by:mlmcc
ID: 35143523
I have never had that problem or seen it referenced.
The issue usually occurs if you try to add over 1000 values since that is the limit (registry setting)

mlmcc
0
 
LVL 2

Author Comment

by:SeyerIT
ID: 35146724
Well shucks.. At least I can manually import.. Just kind of annoying.. Thanks for looking into it though..  
0
 
LVL 100

Expert Comment

by:mlmcc
ID: 35150143
Since it allows you to add the full set I don't think its is a limit issue.

Have you tried creating a NEW report and adding a parameter.  Don't add anything else to the report.

mlmcc
0
6 Surprising Benefits of Threat Intelligence

All sorts of threat intelligence is available on the web. Intelligence you can learn from, and use to anticipate and prepare for future attacks.

 
LVL 2

Author Comment

by:SeyerIT
ID: 35164772
Sorry, just now getting back to this.. Will get back within a few hours.
0
 
LVL 2

Author Comment

by:SeyerIT
ID: 35165017
Ok.. Ran a new report using data from completely different tables.. This time I've set up a parameter that filters a field that contains substantially more fields.. It is acting similar, only grabbing a chuck of the data from the beginning of the list. (the problem doesn't seem to be that its grabbing a specific number of items, but rather grabbing a percentage depending on the size of the list.. e.g. My previous list was around 20-30 items in length and it only pulled the first 3. This list probably has over 1000 items and it grabbed maybe the first 100 or so..)
0
 
LVL 100

Expert Comment

by:mlmcc
ID: 35165866
Are there that many duplicate values so that if it read the first 1000 you would get only 20-30 values?

mlmcc
0
 
LVL 100

Expert Comment

by:mlmcc
ID: 35165990
I just built a simple table with 1200 records but eh first 1100 had just a few values.  The last 100 had many different values.  When I used that field for a parameter it included all the values.

Is there a simple record selection in place?

mlmcc
0
 
LVL 2

Author Comment

by:SeyerIT
ID: 35258911
No I don't believe so.. Sorry just getting back, was on vacation.
0
 
LVL 100

Expert Comment

by:mlmcc
ID: 35259129
I don't know.

mlmcc
0
 
LVL 2

Accepted Solution

by:
SeyerIT earned 0 total points
ID: 35333001
I am going to close this one out as a lost cause.. :(

Best solution for me has been to extract the data from the table manually and import it into a text document (which wasn't too incredibly difficult, just a pain when I should just be able to append my data from the table in Crystal). Then I can import the text document into Crystal under the Append menu in the parameter..
0
 
LVL 2

Author Closing Comment

by:SeyerIT
ID: 35364671
Couldn't seem to get this resolved.. May be something particularly to my application. I am using Crystal Reports in cunjunction with Epicor Manufacturing Software.. (Current Version 9.05)
0

Featured Post

Threat Intelligence Starter Resources

Integrating threat intelligence can be challenging, and not all companies are ready. These resources can help you build awareness and prepare for defense.

Join & Write a Comment

I hate sub reports and always consider them the last resort in any reporting solution.  The negative effect on performance and maintainability is just not worth the easy ride they give the report writer.  Nine times out of ten reporting requirements…
Hot fix for .Net Crystal Reports 10.2.3600.0 to fix problems with sub reports running on 64 bit operating systems ISSUE: Reports which contain subreports fail with error "Missing Parameter Value" DEPLOYMENT SERVER OS: Windows 2008 with 64 bi…
Get a first impression of how PRTG looks and learn how it works.   This video is a short introduction to PRTG, as an initial overview or as a quick start for new PRTG users.
This tutorial demonstrates a quick way of adding group price to multiple Magento products.

747 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

9 Experts available now in Live!

Get 1:1 Help Now