Solved

Crystal Reports Parameters

Posted on 2000-03-28
6
196 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
The Eight Noble Truths of Backup and Recovery

How can IT departments tackle the challenges of a Big Data world? This white paper provides a roadmap to success and helps companies ensure that all their data is safe and secure, no matter if it resides on-premise with physical or virtual machines or in the cloud.

 
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

Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Building cUrl in Windows v7.43.0 4 32
SendMessage fails while PostMessage works 2 114
FMX enumerated colours 2 100
basic hardware to learn oop advanced design patterns 3 95
Article by: SunnyDark
This article's goal is to present you with an easy to use XML wrapper for C++ and also present some interesting techniques that you might use with MS C++. The reason I built this class is to ease the pain of using XML files with C++, since there is…
Basic understanding on "OO- Object Orientation" is needed for designing a logical solution to solve a problem. Basic OOAD is a prerequisite for a coder to ensure that they follow the basic design of OO. This would help developers to understand the b…
The viewer will learn how to pass data into a function in C++. This is one step further in using functions. Instead of only printing text onto the console, the function will be able to perform calculations with argumentents given by the user.
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.

778 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