Last post Aug 21, 2012 03:15 AM by Mamba Dai - MSFT
Aug 15, 2012 07:56 PM|bpassy|LINK
i need help on this
i'm trying to use a select query to assign records to both a main report and a subreport with two unlinked tables
this is my code
comm.Connection = conn
comm.CommandText = "Select * from ReceievedStock where month(DateReceived) = '" & dd1 & "' and Year(DateReceived) = '" & dd2 & "'"
da.SelectCommand = comm
comm1.Connection = conn
comm1.CommandText = "Select * from IssuedStock where month(DateIssued) = '" & dd1 & "' and Year(DateIssued) = '" & dd2 & "'"
da.SelectCommand = comm1
But when i display the report, the record comes in double(each set of record get duplicated)
Need help on this.. Thank you
Aug 21, 2012 03:15 AM|Mamba Dai - MSFT|LINK
The source code above appears to be ok. Now I suggest you ask for help from report forum:
You may receive more professional and exact idea from there.