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
261 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 100

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
 
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 100

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
How to improve team productivity

Quip adds documents, spreadsheets, and tasklists to your Slack experience
- Elevate ideas to Quip docs
- Share Quip docs in Slack
- Get notified of changes to your docs
- Available on iOS/Android/Desktop/Web
- Online/Offline

 

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 100

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 100

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 500 total points
ID: 18824310
0

Featured Post

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

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…
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 tutorial demonstrates a quick way of adding group price to multiple Magento products.
You have products, that come in variants and want to set different prices for them? Watch this micro tutorial that describes how to configure prices for Magento super attributes. Assigning simple products to configurable: We assigned simple products…

708 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

13 Experts available now in Live!

Get 1:1 Help Now