Generate CR with Two tables in dataset
Printed From: Crystal Reports Book
Category: Crystal Reports for Visual Studio 2005 and Newer
Forum Name: Writing Code
Forum Discription: .NET programming API, report integration
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=6446
Printed Date: 03 May 2024 at 4:38am
Topic: Generate CR with Two tables in dataset
Posted By: arpan209
Subject: Generate CR with Two tables in dataset
Date Posted: 23 May 2009 at 1:15am
Hi frnds..
i m creating a crysatl report with two tables whc dont have any comman field..
1) CreditDetrail
2) DebitDetail
i m generating a day book which show the transection for a perticular day from both of d tables..
my design report look like this
|CreditDate|Receiver Name|Amount| debitDate | On Account OF | Amount |
| | | | | | |
| | | | | | |
| | | | | | |
| | | | | | |
here date will be same coz it will of preticular date..
now i tried few things...but any of that didnt work
i have made a dataset whc have both the table
i first tried to use UNION QUery for both table but it show all d data with sum kind of crossjoin which i dont want..
then i tried JOIn query and apply d data set which dosent show any thing..but when i run this query in database it show the perfect resault..
then i tried two diffent querie and sed report sourse twise for each table like..
l.SetDataSource(ds)
l.Subreports.Item("2").SetDataSource(ds.Tables("creditdetail"))
l.Subreports.Item("1").SetDataSource(ds.Tables("DebitDetail"))
which also dont show any thing..
plz ppl helm me out in this..
if u need any explanation plz write here...
|
|