Solved

crystal reports error message

Posted on 2013-05-28
9
360 Views
Last Modified: 2013-05-30
Hi there,

I am using Crystal XI, Developer Edition.  I have a simple access database  that is exported out of the database each time the report is run.  I wanted to create a dynamic parameter so that when new values are added to a specific table, they would upload into the report.  I tried to make the parameter but received the attached error message. Does anyone have any ideas?

Note that this error message pops up when I attempt to create the parameter only - not when I attempt to run the report.

Thanks in advance,
CS
Erorr-Message.JPG
0
Comment
Question by:rporter45
  • 4
  • 3
  • 2
9 Comments
 
LVL 14

Expert Comment

by:LinInDenver
ID: 39204344
You say that the access database is exported out of the database. What do you mean exactly? Does the table containing the parameter values already exist by the time you attempt to create the parameter?
0
 

Author Comment

by:rporter45
ID: 39204413
Sorry - let me explain a little better!  A file is exported out of the database.  It's an access database file.  From there, the report is created using that database file.  The table does exist in the data - I have created a static parameter based on it.  I wanted to create a dynamic parameter so that when the file is exported again out of the main database, it will add any new values to the pick list.

For some reason, I get this error message when I attempt to create a dynamic parameter.  BUT - when I test it on another system, same data file, different crystal install, it works fine so I know it's possible.

Hope that helps to explain better,

Thanks - CS
0
 
LVL 100

Expert Comment

by:mlmcc
ID: 39204439
What is different between the Crystal installs?

Are you changing the database location before the report runs?

Is the table being created when the report is run?

mlmcc
0
Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

 

Author Comment

by:rporter45
ID: 39204975
Hi there,

That's the issue - I'm not sure what the difference is and was hoping that someone could identify what install component may be missing from their system as compared to mine. We are both running the same version and updates.  

Yes - the database location is changed and the table is being created.

Thanks - CS
0
 
LVL 100

Accepted Solution

by:
mlmcc earned 300 total points
ID: 39204990
How did you install the application?

mlmcc
0
 
LVL 100

Expert Comment

by:mlmcc
ID: 39204995
Does the table exist when you create the parameter?

mlmcc
0
 

Author Comment

by:rporter45
ID: 39205333
Hi there,

It's actually someone else who installed it on their system - they said they did a complete install.  Yes, the table exists - I had formerly created a static parameter based on the table.  Then when I went to create a dynamic one on her machine the error message comes up.  My guess is that it is NOT a complete install, but I wasn't sure if there was a specific item during the install that needed to be added?

Thanks - CS
0
 
LVL 14

Assisted Solution

by:LinInDenver
LinInDenver earned 200 total points
ID: 39205399
Any chance her Access DB is preventing the connection? Does the report connect through ODBC or something, that might be missing along the way?

i.e.: I would investigate outside of Crystal Reports - compare data connections and access software versions.
0
 

Author Comment

by:rporter45
ID: 39205409
Hi there,

Good point but the software package that this exports from and the file it creates are standardized.  But believe it or not, this discussion back and forth leads me to believe that she did not install all of the components, that something is missing in the install.  We have basically poked at each element and it all leads back to the Crystal install.

If there are any other ideas at this point, I'll leave this open for a bit but I may have the answer - thanks!

CS
0

Featured Post

Gigs: Get Your Project Delivered by an Expert

Select from freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely and get projects done right.

Question has a verified solution.

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

Crystal Reports: 5 Tests for Top Performance It is complete, your masterpiece report.  Not only does it meet your customer’s expectations, it blows them out the water, all they want is beautifully summarised and displayed in a myriad of ways. …
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…
This Micro Tutorial will teach you how to censor certain areas of your screen. The example in this video will show a little boy's face being blurred. This will be demonstrated using Adobe Premiere Pro CS6.
This Micro Tutorial will give you a basic overview how to record your screen with Microsoft Expression Encoder. This program is still free and open for the public to download. This will be demonstrated using Microsoft Expression Encoder 4.

813 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

12 Experts available now in Live!

Get 1:1 Help Now