Data Report Grouping
Data Report Grouping
(OP)
Hi there,
I have problem in data report grouping.The main screen has two combo boxes to let user select the preferred value.Then user has to click 'View Report' button to view the report. I have specified the grouping option in my Data Environment. On the data report itself, I have retrieved the structure pertaining to the command in my Data Environment.I have written the SQL statement to retrieve the data in cmdReport_Click event.
DataEnvironment1.Commands("Result").CommandText = _
"Select * From QrySectResult " & _
"Where Dept_Desc = '" & Combo1.Text & "' " & _
"And Sect_Desc = '" & Combo2.Text & "'"
rptResult2.Title = Combo2.Text
rptResult2.Show
PROBLEM:I received error msg : "Data field not found" for the fields in Detail Section.
Do u know how to write the correct SQL stmt for grouping in data report?
I have problem in data report grouping.The main screen has two combo boxes to let user select the preferred value.Then user has to click 'View Report' button to view the report. I have specified the grouping option in my Data Environment. On the data report itself, I have retrieved the structure pertaining to the command in my Data Environment.I have written the SQL statement to retrieve the data in cmdReport_Click event.
DataEnvironment1.Commands("Result").CommandText = _
"Select * From QrySectResult " & _
"Where Dept_Desc = '" & Combo1.Text & "' " & _
"And Sect_Desc = '" & Combo2.Text & "'"
rptResult2.Title = Combo2.Text
rptResult2.Show
PROBLEM:I received error msg : "Data field not found" for the fields in Detail Section.
Do u know how to write the correct SQL stmt for grouping in data report?
Talk To Other Members