VB 6.0 - How to pass parameters to data report

Asked By nirupama roy on 28-Jun-06 04:49 AM
Hi all
I just want to know how to pass parameteres to data reports?
Asked By Rupali Randhave Kolhe on 28-Jun-06 05:00 AM
1.FIrst add data environment
2.set connection for database
3.Add command by right click on connection
4.Right click on command1.
 on Parameter tab set properties
In VB Code
Let i set 2 parameters month and year
I gave name m1 and y1 in parameter tab then
***************************************
Dim m1 As Integer
Dim y1 As Integer
m1 = month1.text
y1 = year1.Text
Dim ff As New DataEnvironment2
ff.Command1_Grouping m1, y1
DataReport1.Refresh
DataReport1.Show vbModal
--------------------------------

Thanks - Asked By nirupama roy on 28-Jun-06 05:09 AM

:)

from ham - Asked By hany mostafa on 03-Jul-06 03:19 PM

thank