Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

Why does my dynamic parameter run so slow and then end up with nothing after it checks against the database?

Posted on 2007-03-29
13
Medium Priority
?
276 Views
Last Modified: 2010-08-05
Why is my dynamic parameter report running soooo slow and then after it is done reading the database, nothing populates the page.  What gives?
0
Comment
Question by:VBBRett
  • 5
  • 4
  • 2
  • +2
13 Comments
 
LVL 17

Expert Comment

by:MIKE
ID: 18820871
Are you sure you are using the correct FIELD in your parameter?

What are you using in the record SELECTION FORMULA? Is your parameter there?

Like this:  

{Yourtable.field} = {?YourParameter}

Mike V
0
 
LVL 101

Expert Comment

by:mlmcc
ID: 18821050
What data tyoe is the field?

mlmcc
0
 
LVL 13

Expert Comment

by:crgary_tx
ID: 18821056
How are you publishing the reports?

Gary
0
[Webinar] Database Backup and Recovery

Does your company store data on premises, off site, in the cloud, or a combination of these? If you answered “yes”, you need a data backup recovery plan that fits each and every platform. Watch now as as Percona teaches us how to build agile data backup recovery plan.

 
LVL 17

Expert Comment

by:MIKE
ID: 18821109
If you are using an enterprise edition...then you may need to have it scheduled to REFRESH instead of refreshing on demand..

Are you using Crystal Reports XI Server or Business Objects XI???

Also,
0
 

Author Comment

by:VBBRett
ID: 18821409
I am using Crystal Reports XI report developing tool.  Nothing more.  I was able to make the dynamic parameter by adding another command.  But unfortunately, it doesn't seem to filter like I wanted it to.  Is this because the tables have to be matched up with each other or have joins?  I took the joins out in the Database Command Expert.
0
 
LVL 101

Expert Comment

by:mlmcc
ID: 18821422
The tables need to be joined but you can have a separate command for the parameters that isn't joined to the others

mlmcc
0
 

Author Comment

by:VBBRett
ID: 18821477
Yeah, I have something setup something like this I think when i do the formula

Are you sure you are using the correct FIELD in your parameter?

What are you using in the record SELECTION FORMULA? Is your parameter there?

Like this:  

{Yourtable.field} = {?YourParameter}

0
 
LVL 101

Expert Comment

by:mlmcc
ID: 18822977
What data type is your field?

mlmcc
0
 

Author Comment

by:VBBRett
ID: 18823244
my dynamic parameter field is of string type.  Thanks for asking mlmcc.
0
 

Author Comment

by:VBBRett
ID: 18823853
Now it's crashing that I have them joined.  I have the two command tables joined and when I try to run it for new parameter prompts, it just crashes.  I don't understand what I am doing wrong?
0
 
LVL 101

Expert Comment

by:mlmcc
ID: 18823904
Is one of the tables just for the parameter prompt?  If so don't join it.

Can the strings be lengthy?  If so, then it may be taking quite a while to build the list.

mlmcc
0
 

Author Comment

by:VBBRett
ID: 18824166
I unjoined the tables and I got the following errror message

"Prompting failed with the following errror message:"

Error Source:  Error code: 0x80070057
0
 
LVL 26

Accepted Solution

by:
Kurt Reinhardt earned 2000 total points
ID: 18824310
0

Featured Post

Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

Question has a verified solution.

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

There have always been a lot of questions related to when Crystal Reports evaluates report components (such as formulas, summaries, cross-tabs, charts, to name a few examples). Crystal Reports uses a two-pass reporting process to provide greater …
Hello everyone, Hope you find this as helpful as we did. We have on the company I work for an application built in Delphi V with Crystal Reports 8. We all know that Crystal & Delphi can be temperamental sometimes and the worst thing is, nearly…
This Micro Tutorial will teach you how to add a cinematic look to any film or video out there. There are very few simple steps that you will follow to do so. This will be demonstrated using Adobe Premiere Pro CS6.
When cloud platforms entered the scene, users and companies jumped on board to take advantage of the many benefits, like the ability to work and connect with company information from various locations. What many didn't foresee was the increased risk…
Suggested Courses
Course of the Month12 days, 2 hours left to enroll

564 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