Click here to Skip to main content
15,892,059 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
Hello.

I try to display datareport with Group Header and Footer but display an error Report Section do not match data source. Below is the code trying.

VB
Private Sub CmdPreview_Click()
Dim SqlInv As String
'Dim txtCustomerName As TextBox
Dim CustName As String

Public Conn As ADODB.Connection

Public Sub dbConnect()
  Set Conn = New ADODB.Connection
  Conn.ConnectionString = strConn
  Conn.Open
End Sub

Public Function strConn() As String
  strConn = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & App.Path & "\dbdrugInventory.mdb" & ";Persist Security Info=False"
End Function
Posted
Updated 7-Dec-14 9:55am
v3
Comments
Dauda Muhammad 17-Nov-14 8:15am    
Hello
I got the solution but my report showing duplicate value e.g
Date Item ID Qty Item Name Unit Price Amount
11/11/2014 1001 2 Rice 600 1200
11/11/2014 1001 2 Rice 600 1200

thanks.
ZurdoDev 7-Dec-14 20:11pm    
Please post as a solution so that this no longer appears in the Unanswered list.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900