Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Data Report Grouping

Status
Not open for further replies.

floweriang

Programmer
Joined
May 6, 2002
Messages
4
Location
MY
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?
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top