Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

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
?
272 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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
New benefit for Premium Members - Upgrade now!

Ready to get started with anonymous questions today? It's easy! Learn more.

 
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

On Demand Webinar: Networking for the Cloud Era

Did you know SD-WANs can improve network connectivity? Check out this webinar to learn how an SD-WAN simplified, one-click tool can help you migrate and manage data in the cloud.

Question has a verified solution.

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

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…
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…
Have you created a query with information for a calendar? ... and then, abra-cadabra, the calendar is done?! I am going to show you how to make that happen. Visualize your data!  ... really see it To use the code to create a calendar from a q…
In response to a need for security and privacy, and to continue fostering an environment members can turn to for support, solutions, and education, Experts Exchange has created anonymous question capabilities. This new feature is available to our Pr…
Suggested Courses

715 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