[Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 339
  • Last Modified:

VB6 DataReport - passing Params

VB6 sp3, Win98

I have created a report that is based on a command within a data environment. This is easy if the command has no parameters, but if params are required, how do you pass the param values to the command ?

TIA

John
0
JohnHind
Asked:
JohnHind
  • 2
  • 2
1 Solution
 
MTroutwineCommented:
Here is an article by Microsoft that describes passing a parameter to a Command object.  It comes with explanation and sample code!

http://msdn.microsoft.com/library/devprods/vs6/vbasic/vbcon98/vbcondataenvironmentprogrammingguidelines.htm
0
 
JohnHindAuthor Commented:
I agree that this explains passing params to a data environment, but it does not explain how to do it from a data report.

In the report you select which command to base the report on, but when the report is generated, I cannot see where you would pass the params to the command function....

John
0
 
rovermCommented:
Just invoke the command first:

DataEnvironment1.Command1 parm1, parm2

then invoke the DataReport:

DataReport1.PrintReport

This works!

D'Mzzl!
RoverM
0
 
JohnHindAuthor Commented:
MTroutwine

Yes you were correct but not as clear as roverm. I will send you 25 points if that's possible !

John Hind
0
 
MTroutwineCommented:
John,

Don't worry about the points, glad to see you got a your problem solved. That's what counts!

:>)
0

Featured Post

How to Use the Help Bell

Need to boost the visibility of your question for solutions? Use the Experts Exchange Help Bell to confirm priority levels and contact subject-matter experts for question attention.  Check out this how-to article for more information.

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