SQL Reporting - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Programming

SQL Reporting

Author

Topic

sayanti
Starting Member

3 Posts

Posted - 2009-03-17 : 08:26:11

I am using two matrices in the same sql report.Both are using different datasets but both needs to show same columns and for the second matrix I am hiding the column headers.But the alignment is never correct.Is it possible to do it like this? Please help

sakets_2000
Master Smack Fu Yak Hacker

1472 Posts

Posted - 2009-03-17 : 08:31:17

Is this SSRS related ?

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2009-03-17 : 10:30:20

quote:
Originally posted by sayanti

I am using two matrices in the same sql report.Both are using different datasets but both needs to show same columns and for the second matrix I am hiding the column headers.But the alignment is never correct.Is it possible to do it like this? Please help

making alignment of both matrices same is tricky. the matrix column number may vary depending on data you're showing for each matrix (column group). so to make alignment same, you should first make sure you've same values appearing on both dataset for column group field.

sayanti
Starting Member

3 Posts

Posted - 2009-03-18 : 01:39:08

how can we do that?I am using these two queries:
For Dataset1----

select jobtype.code,jobtype.description, count(job.id)as Jobs,job.jobyear from job
inner join jobtype on job.jobtypeid=jobtype.id
where jobtypeid in(select id from jobtype where description in('C1A Licensing Act (A) (Justices & Gaming) Appns', 'Licensing Act (A) (Justices & Gaming) Inspections ' , 'C8 Licensing Acts 2003'))
and job.jobyear >=(year(getdate())-5)
group by code,description,jobyear
order by jobyear

For Dataset2----

select jobtype.code,jobtype.description, count(job.id)as Jobs,job.jobyear from job
inner join jobtype on job.jobtypeid=jobtype.id
where jobtypeid in(select id from jobtype where code in('D'))
and job.jobyear >=(year(getdate())-5)
group by code,description,jobyear
order by jobyear

First query gives me 2005,2006 only for the columns
Second one gives 2005,2006,2007,2008.

Basically I wand to align them as I wand to get the grand total for each year from the two matrices.Is this possible?

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources