• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 205
  • Last Modified:

Crystal Reports Parameters

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
TRAB
Asked:
TRAB
  • 3
  • 3
1 Solution
 
RONSLOWCommented:
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
 
TRABAuthor Commented:
Edited text of question.
0
 
RONSLOWCommented:
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
Cloud Class® Course: MCSA MCSE Windows Server 2012

This course teaches how to install and configure Windows Server 2012 R2.  It is the first step on your path to becoming a Microsoft Certified Solutions Expert (MCSE).

 
TRABAuthor Commented:
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
 
RONSLOWCommented:
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
 
TRABAuthor Commented:
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: Ruby Fundamentals

This course will introduce you to Ruby, as well as teach you about classes, methods, variables, data structures, loops, enumerable methods, and finishing touches.

  • 3
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now