subreport with select query‏

Question

0.00/5 (No votes)

See more:

hi,

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

VB

comm.Connection = conn
comm.CommandText = "Select * from ReceievedStock where month(DateReceived) = '" & dd1 & "' and Year(DateReceived) = '" & dd2 & "'"
da.SelectCommand = comm

da.Fill(das, "ReceievedStock")
'da.Dispose()

comm1.Connection = conn
comm1.CommandText = "Select * from IssuedStock where month(DateIssued) = '" & dd1 & "' and Year(DateIssued) = '" & dd2 & "'"
da.SelectCommand = comm1

da.Fill(das, "IssuedStock")

But when i display the report, the record comes in double(each set of record get duplicated)

Need help on this.. Thank you

Posted 15-Aug-12 22:45pm

kwamebounty

Updated 16-Aug-12 0:29am

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ)

v2

Add a Solution

Comments

Adersh Ram 16-Aug-12 9:20am

Hi,
How did u set the report data source ?

kwamebounty 17-Aug-12 5:17am

I set the report datasource this way

rpt.SetDataSource(das)
CrystalReportViewer1.ReportSource = rpt

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

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

Adersh Ram · Answer 1 · 2012-08-18T06:45:00

Hi kwamebounty,

1. First u set the Main report and sub report link(right click the sub reoport and
select Sub Report link , link the master report id and sub report id)
2. Set the report data source
report.setdatasource(das.tables(0))
report.subreports(0).setdatasource(das.tables(1))

Let me know if it is not worked.

Thanks