Problem occured to load table in crystal report

Question

4.00/5 (1 vote)

See more:

SQL-Server-2005

In my report i want to display the values from two different tables, how can i set the datasource using coding to report at runtime

For example i give the following but it is not working

it is display all the fields in second table i want to display one table at a time how to do it

VB

Dim rrview As New reportviewer
        Dim ProDset1 As New DataSet
        Dim sqlda As New SqlDataAdapter("select * from PL where fromdate='" & Format(fromdate.Value, "MM-dd-yyyy") & "' and todate='" & Format(todate.Value, "MM-dd-yyyy") & "'", con)
        Dim sqlda1 As New SqlDataAdapter("select * from Expenses where Date>= '" & Format(fromdate.Value, "MM-dd-yyyy") & "' and Date<= '" & Format(todate.Value, "MM-dd-yyyy") & "'", con)
        sqlda.Fill(ProDset1, "T1")
        sqlda1.Fill(ProDset1, "T2")
        Dim RptProstmt As New Crystal10
        RptProstmt.SetDataSource(ProDset1)

        rrview.viewer1.ReportSource = RptProstmt
        rrview.viewer1.DisplayGroupTree = False
        rrview.MdiParent = MyBase.MdiParent
        rrview.Show()

Posted 30-Dec-11 0:41am

devausha

Add a Solution

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)

thatraja · Answer 1 · 2011-12-30T01:04:00

Solution 1

Just assign the Table instead of DataSet.

VB

RptProstmt.SetDataSource(ProDset1.Tables(0))

EDIT

VB.NET Crystal Reports from multiple tables[^]

Posted 30-Dec-11 1:04am

thatraja

Updated 30-Dec-11 1:16am

v2

Comments

devausha 30-Dec-11 7:13am

But it has get the records from first table. it didn't display the records from another table

thatraja 30-Dec-11 7:15am

May be something wrong with data. Check the data in preview time. Check updated answer

bluesathish 31-Dec-11 1:05am

Hi devausha, Instead of assigning dataset to the reportdatasource, just try to do by adding reportdatasource.add() method. Which means, write the for loop as initialize one loop variable to 1 untill the dataset's tables count. And by calling the add() method you can assign the datasource one by one. Hope this will be helpful.

devausha 1-Jan-12 23:46pm

Hai thank you very much for your reply
but i am not clearly for your comment
where i have to give reportdatasource.add() method, i give this line error will occured please explain how to do it

Thank you very much

thatraja 2-Jan-12 4:31am

Did you try that?(RptProstmt.SetDataSource(ProDset1.Tables(0)))

devausha 2-Jan-12 8:16am

Yes, I have already try it but the answer will not come correctly

thatraja 2-Jan-12 8:24am

What about the link in my answer?