sql server reporting services:
Hello, I am having two tables ... SendMails (SendMailID,sender,subject) Data is 1, 'Sender1','Subject1' 2, 'Sender2','Subject2' 3, 'Sender3','Subject3' RecMails(RecMailId,Recieved,Subject) Data is 4, 'Rec1','Subject4' 5, 'Rec2','Subject5' 6, 'Rec3','Subject6' I want in the Report as 1, 'Sender1','Subject1' 2, 'Sender2','Subject2' 3, 'Sender3','Subject3' 4, 'Rec1','Subject4' 5, 'Rec2','Subject5' 6, 'Rec3','Subject6' I am unable to get this from a single Query... so I decided to have two tables in the body with one dataset each ...but it leaves a big blank space in between .. Is there some way possible for this requirement.. I also tried putting two tables in one group each within a third table but the blank space remains... any Idea will be highly appreciated.. Cheers,
Are you using a database that does not support a UNION in the query? Otherwise, UNION them and have them in the same dataset. -- Douglas McDowell douglas@nospam.solidqualitylearning.com [quoted text, click to view] "siaj" <siaj@discussions.microsoft.com> wrote in message
news:E449AE49-ECE2-4B23-979D-D877C5BE3BC4@microsoft.com...
> Hello,
>
> I am having two tables ...
>
> SendMails (SendMailID,sender,subject)
> Data is
> 1, 'Sender1','Subject1'
> 2, 'Sender2','Subject2'
> 3, 'Sender3','Subject3'
>
>
> RecMails(RecMailId,Recieved,Subject)
> Data is
> 4, 'Rec1','Subject4'
> 5, 'Rec2','Subject5'
> 6, 'Rec3','Subject6'
>
> I want in the Report as
>
> 1, 'Sender1','Subject1'
> 2, 'Sender2','Subject2'
> 3, 'Sender3','Subject3'
> 4, 'Rec1','Subject4'
> 5, 'Rec2','Subject5'
> 6, 'Rec3','Subject6'
>
>
> I am unable to get this from a single Query...
>
> so I decided to have two tables in the body with one dataset each ...but
> it
> leaves a big blank space in between .. Is there some way possible for this
> requirement..
> I also tried putting two tables in one group each within a third table but
> the blank space remains...
> any Idea will be highly appreciated..
>
> Cheers,
> siaj
Thanks Douglas... I am using SQL Server 2000...and I can very well use Union Operator.. It had never clicked me.. Cheers, siaj [quoted text, click to view] "Douglas McDowell" wrote:
> Are you using a database that does not support a UNION in the query?
> Otherwise, UNION them and have them in the same dataset.
> --
> Douglas McDowell douglas@nospam.solidqualitylearning.com
>
>
> "siaj" <siaj@discussions.microsoft.com> wrote in message
> news:E449AE49-ECE2-4B23-979D-D877C5BE3BC4@microsoft.com...
> > Hello,
> >
> > I am having two tables ...
> >
> > SendMails (SendMailID,sender,subject)
> > Data is
> > 1, 'Sender1','Subject1'
> > 2, 'Sender2','Subject2'
> > 3, 'Sender3','Subject3'
> >
> >
> > RecMails(RecMailId,Recieved,Subject)
> > Data is
> > 4, 'Rec1','Subject4'
> > 5, 'Rec2','Subject5'
> > 6, 'Rec3','Subject6'
> >
> > I want in the Report as
> >
> > 1, 'Sender1','Subject1'
> > 2, 'Sender2','Subject2'
> > 3, 'Sender3','Subject3'
> > 4, 'Rec1','Subject4'
> > 5, 'Rec2','Subject5'
> > 6, 'Rec3','Subject6'
> >
> >
> > I am unable to get this from a single Query...
> >
> > so I decided to have two tables in the body with one dataset each ...but
> > it
> > leaves a big blank space in between .. Is there some way possible for this
> > requirement..
> > I also tried putting two tables in one group each within a third table but
> > the blank space remains...
> > any Idea will be highly appreciated..
> >
> > Cheers,
> > siaj
>
>
Don't see what you're looking for? Try a search.
|
