Hi ,
I am Sejal. I am using vb6. and i want to build Data Report in Vb6 with Data Environment and with passing parameter. now My query is , i need to group data on one field. and i have written the Code like:
dim str1 as string
jugname=cmbname .text ( Variable I want to pass)
str1="select Judge,Client_Na me,Case_No,Stag e,Remarks from Client_Detail where Judge='"& jugname "&' Group by Judge"
Dataenvironment 1.rscommand1.so urct=str1
dataenvironment 1.rscommand1.op en str1,dataenviro nment1.connecti on1
dataenvironment 1.rscommand1.re query
loda datareport1
datareport1.sho w
i have written this code. I need to group on Judge . but it doesn't work
can u help me pl.
I am Sejal. I am using vb6. and i want to build Data Report in Vb6 with Data Environment and with passing parameter. now My query is , i need to group data on one field. and i have written the Code like:
dim str1 as string
jugname=cmbname .text ( Variable I want to pass)
str1="select Judge,Client_Na me,Case_No,Stag e,Remarks from Client_Detail where Judge='"& jugname "&' Group by Judge"
Dataenvironment 1.rscommand1.so urct=str1
dataenvironment 1.rscommand1.op en str1,dataenviro nment1.connecti on1
dataenvironment 1.rscommand1.re query
loda datareport1
datareport1.sho w
i have written this code. I need to group on Judge . but it doesn't work
can u help me pl.