INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Jobs

Crystal reports XI "Set parameter order" only displays the first 65 parameters there's no

Crystal reports XI "Set parameter order" only displays the first 65 parameters there's no

Crystal reports XI "Set parameter order" only displays the first 65 parameters there's no

(OP)
Hello, is there anyone out there who has experienced this problem or might have a solution?
The report has 110 parameters. The set parameter order screen only displays 65 of the parameters.
It is difficult to sort the bottom 30 because parameters the cursor selection can not be seen once it goes below the 65th parameter.
There is no scroll bar.

Thank you,



RE: Crystal reports XI "Set parameter order" only displays the first 65 parameters there's no

(OP)
This little bug is really bugging me. Have any of you created a crystal report with over 65 parameters?
I can reduce the number of parameters by 20 or so by specifying, 'allow multiple values' within some of the parameters, but I still have over 65 parameters.
With using the - 'Allow multiple parameters', I have to create formulas to display each of the parameter values.
I have documentation, but have not been successful with it yet. Thank you for your feed back it is very appreciated.

RE: Crystal reports XI "Set parameter order" only displays the first 65 parameters there's no

I can't help you with your problem, but I am curious - can you describe your report a little and why it needs 110 parameters? I'm sure there are valid reasons but I'd like to know more. (It's possible that cascading parameters might also help to get that number down a bit).

My #1 rule for report writing is to make one report do the work of many, and that is usually accomplished with parameters. But there's a point at which user pushback at having to enter so many values exceeds the benefit of having a single report. My experience is that number is usually around a dozen or so.

Again, I'm not saying anything is right or wrong, but just wondering about your requirements for my own curiosity.

RE: Crystal reports XI "Set parameter order" only displays the first 65 parameters there's no

(OP)
Hi briangiffin!! I am happy to get your response. To answer your question, it is a long form. It provides data from the data base while providing parameters for information that is different for almost every case. I looked into the option of doing this in Excel, but there seems to be a lot of red tape regarding db permissions/restrictions for the person who will be using it at their workstation. I am open for suggestions.

RE: Crystal reports XI "Set parameter order" only displays the first 65 parameters there's no

It sounds like you are trying to use Crystal Reports as a way to generate a form that the user can then complete.

Instead of expecting the user to respond to so many parameters, consider generating a PDF form directly from the Crystal report.
At least one of the 3rd-party Crystal Reports desktop schedulers listed at: http://kenhamady.com/cru/comparisons/desktop-sched... can do this. You basically use Crystal formulas that act as tag directives for the process to place form fields on the PDF export. These form fields can be free form text edits, drop-downs, checkboxes, etc. And they can be pre-filled with different default values based on database info related to each user or event type, so that each user gets a form that is already partially filled.

view, export, burst, email, and schedule Crystal Reports.
www.MilletSoftware.com

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Resources

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close