Solved

Crystal Reports Parameters

Posted on 2000-03-28
6
195 Views
Last Modified: 2010-05-18
CR7

I get the possible values for a
parameter field out of a database table.
When I add a record to that database table, how can I automatically add this record to the possible values of that parameter? I really don't want to change my report every time I add a record to that table.

Ok RONSLOW,
But how do you dynamically expand the number of parameter values, from code?

Bart
0
Comment
Question by:TRAB
  • 3
  • 3
6 Comments
 
LVL 10

Expert Comment

by:RONSLOW
ID: 2663930
It is usually best to drive Crystal from (say) a vb app, as even the new improved tabbed parameter entry dialog is not really that nice.
0
 
LVL 1

Author Comment

by:TRAB
ID: 2664163
Edited text of question.
0
 
LVL 10

Accepted Solution

by:
RONSLOW earned 200 total points
ID: 2672715
don't think you can .. unless perhaps id you use the ActiveX control .. it is a lot more flexible.

What I was suugesting is write a little app the does the prompting itself (eg. reads the dat arom the database, populates a combo box and displays a dialog).  It would then open the report, set the parameter values accordinhly and start the report.
0
Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

 
LVL 1

Author Comment

by:TRAB
ID: 2672720
OK Ronslow, I've come up with that myself, but you get the points.
(I'm just a bit dissapointed it isn't possible)
0
 
LVL 10

Expert Comment

by:RONSLOW
ID: 2672728
there are lots of disappointing things in the C++ Crystal interface .. the documentation for one :-)

For exmaple, there is a nifty technique for dynamically changing pictures in reports bassed on data in a database (eg the file name).  But this only works for the ActiveX control .. the C++ interface just doesn't have the hooks one needs.
0
 
LVL 1

Author Comment

by:TRAB
ID: 2672739
What I really don't like about Crystal Reports 7 is the graphing functionality. It is so weak. Ever tried to make a diagram with a date-time axis where you want to display minutes?

Thanks again.
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Suggested Solutions

When writing generic code, using template meta-programming techniques, it is sometimes useful to know if a type is convertible to another type. A good example of when this might be is if you are writing diagnostic instrumentation for code to generat…
This article shows you how to optimize memory allocations in C++ using placement new. Applicable especially to usecases dealing with creation of large number of objects. A brief on problem: Lets take example problem for simplicity: - I have a G…
The viewer will learn how to use the return statement in functions in C++. The video will also teach the user how to pass data to a function and have the function return data back for further processing.
The viewer will be introduced to the technique of using vectors in C++. The video will cover how to define a vector, store values in the vector and retrieve data from the values stored in the vector.

863 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

21 Experts available now in Live!

Get 1:1 Help Now