• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1568
  • Last Modified:

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

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
Jarred Meyer
Asked:
Jarred Meyer
  • 8
  • 6
1 Solution
 
MIKESoftware Solutions ConsultantCommented:
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
 
Jarred MeyerProduction ManagerAuthor Commented:
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
 
mlmccCommented:
Have you tried running the report and entering a value?

Is this in a COMMAND or regular Crystal parameters?

mlmcc
0
Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

 
Jarred MeyerProduction ManagerAuthor Commented:
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
 
mlmccCommented:
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
 
Jarred MeyerProduction ManagerAuthor Commented:
Well shucks.. At least I can manually import.. Just kind of annoying.. Thanks for looking into it though..  
0
 
mlmccCommented:
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
 
Jarred MeyerProduction ManagerAuthor Commented:
Sorry, just now getting back to this.. Will get back within a few hours.
0
 
Jarred MeyerProduction ManagerAuthor Commented:
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
 
mlmccCommented:
Are there that many duplicate values so that if it read the first 1000 you would get only 20-30 values?

mlmcc
0
 
mlmccCommented:
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
 
Jarred MeyerProduction ManagerAuthor Commented:
No I don't believe so.. Sorry just getting back, was on vacation.
0
 
mlmccCommented:
I don't know.

mlmcc
0
 
Jarred MeyerProduction ManagerAuthor Commented:
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
 
Jarred MeyerProduction ManagerAuthor Commented:
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

  • 8
  • 6
Tackle projects and never again get stuck behind a technical roadblock.
Join Now