| |
ActiveReports 2.0 (Visual Basic 6.0) Support
Started by snmdody at 06-03-2009 1:49 AM. Topic has 4 replies.
  
|
|
Sort Posts:
|
|
|
|
 06-03-2009, 1:49 AM
|
snmdody
Joined on 04-11-2008
Posts 5
|
|
|
Hi,
can anyone fix Fetchdata problem?
Please See Attch.
|
|
|
|
|
Report
|
|
|
|
|
06-03-2009, 1:15 PM
|
PrantikS
Joined on 12-11-2008
Posts 759
|
|
|
|
Hello,
Please find the attached sample which gives proper display at my testing.
Regards,
Prantik
|
|
|
|
|
Report
|
|
|
|
|
06-04-2009, 2:42 AM
|
snmdody
Joined on 04-11-2008
Posts 5
|
|
|
|
Thank you...
(cnt = cnt + 1)
But I want the value Taken from report field, can you help please?
---------------------------------------------
Like :
SQL = "SELECT Count(CarID)From TblTrans" & " Where CarID = " & Val(Me.CarID.DataValue) & "And Check = " & True
Not Like:
SQL = "SELECT Count(CarID)From TblTrans" & " Where CarID = " & cnt & "And Check = " & True
---------------------------------------------
Best regards,
|
|
|
|
|
Report
|
|
|
|
|
06-04-2009, 1:50 PM
|
PrantikS
Joined on 12-11-2008
Posts 759
|
|
|
|
Hello,
You could change the SQL statement to the following to get the desired output
SQL = "SELECT Count (CarID) From TblTrans" &” Where CarID = " & Me. Fields ("CarID").Value & "And Check = “& True
Please take a look at the attached sample.
Regards,
Prantik
|
|
|
|
|
Report
|
|
|
|
|
06-06-2009, 3:48 AM
|
snmdody
Joined on 04-11-2008
Posts 5
|
|
|
|
Thank you,
That is exactly what I want
|
|
|
|
|
Report
|
|
|
|
|
GrapeCity » Product Support » ActiveReports 2... » FetchData problem
|
|
|
|
|