I m trying to act a crystal report in vb net application. I need to show data from 3 different tables in report. So i added all 3 tables in Field explorer of crystal report,but i m unable to show the data in it. For this i have tried two method:-1>Using joning add data in a hit table and set the Datasource of the report to it something desire this-
Dim rpt As New CrystalReport1rpt. SetDataSource(MyDataset. Tables(0))Me. CrystalReportViewer1. ReportSource = rpt
2>Without joining using two tables for it like this
i)decide data from 1 tableMySqlDataAdapter. Fill(MyDataset. "Table1")ii)decide data from 2 tableMySqlDataAdapter. Fill(MyDataset. "Table2")iii)decide data from 3 tableMySqlDataAdapter. alter(MyDataset. "delay3")Dim rpt As New CrystalReport2rpt. SetDataSource(MyDataset)Me. CrystalReportViewer1. ReportSource = rpt
Any idea would be appreciated heartlyThanks with anticipation
Welcome to vbCity. As to your question - I would develop the report in the crystal designer and not visual studio. This will allow joins of many tables. You then call the compiled inform from your net project.
"Sometimes when I designate back on all the beer I drink I feel ashamed. Then I look into the glass and think about the workers in the brewery and all of their hopes and dreams. If I didn't consume this beer they might be out of work and their dreams would be shattered. Then I say to myself. "It is better that I drink this beer and let their dreams come true than be selfish and worry about my liver." - ~ bring up Handy
I tried as you said but still facing same problem
I need your suggestions,Any idea would be appreciated
- furnish something approve to the members that offer their help and knowledge day after day - for free (voting ends Dec 21st)
Cruise 4 Cash -
Detective Sherlock -
Free Bid Auctions -
Expert Poker Tips -
Shop 4 Money
Win Any Lottery -
Repo Car Search -
Psychics 4 Free -
High Quality Games -
Driving 4 Dollars
Related article:
http://www.vbcity.com/forums/topic.asp?tid=151399
comments | Add comment | Report as Spam
|