Writing Code
 Crystal Reports Forum : Crystal Reports for Visual Studio 2005 and Newer : Writing Code
Message Icon Topic: Generate CR with Two tables in dataset Post Reply Post New Topic
Author Message
arpan209
Newbie
Newbie


Joined: 23 May 2009
Location: India
Online Status: Offline
Posts: 1
Quote arpan209 Replybullet Topic: Generate CR with Two tables in dataset
    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...

IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum



This page was generated in 0.016 seconds.