Quote:
Originally Posted by Dököll
Groovy, I am glad you've gone this far. I think you will find some hits here that'll cater to your needs; did a quick search of this forum using search grid in search terms. Give it a go:
http://www.thescripts.com/forum/sear...3&pp=25&page=1
Hi! needed some more help with data reports..I have added dataenvironment to my proj. and added a command to it with the sql query
SELECT A, COUNT(B) AS C, SUM(D) AS E, SUM(F) AS G, SUM(H) AS I
FROM table1
WHERE (K=[?]) and (A=[?])
GROUP BY A;
I have linked a data report to this command. But while passing parameter to the report from a Form I am getting an error "Expected: ="
Private Sub Command1_Click()
DataEnvironment1.Connection1.Open
DataEnvironment1.Command1 (combo1.Text, text1.text)
DataReport7.Show
Unload Me
End Sub
I am able to run reports while passing a single parameter, but not 2.
Thanks,
Nikita
