Matrix on SQL Reporting

Question

Hi,

I have dataset with the following fields: country, start date, total hours, total billed amt

Can I have 2 matrix on a report

Avg Billed

Country    Jan            Feb          Mar   Apr    May    Jun    Jul    Aug    Sep    Oct    Nov    Dec

--------

A             2000.00     1000.00

 

Avg Hours

Country       Jan          Feb        Mar     Apr      May        Jun         Jul         Aug         Sep           Oct          Nov          Dec

---------

A               3.0           4.0

Answer 1

yes you can. create 2 seperate datasets, 1 each for matrix. map the matrix with the required dataset and you should be able to get your output.

 

Mark as answer if this answers your question.

Answer 2

Hi ngsf5

Yes, u can have two diifrent matrix item in single  report as psyscho said..

But what i suggest u since u r analysis the data on same lines((i.e country on rows and month on columns) in both the report

Y dont  U show Avghours and Avg Billed in one single matrix report

---

Praxy

Answer 3

Yes you can have 2 matrix using the same dataset.

Use Total hours in the data cell section in the first matrix and Avg Hours in the cell section of the second matrix

 

But you should modify your dataset to return the month from your start date instead of using the start date only (or maybe you could write an expression in the column header of the matrix to group by the month of the start date)

---

Cheers,
Jason
P.S. : Please click the 'Mark as Answer' button if a post solves your problem! :)

Answer 4

Hi Jason,

I managed to create the matrix table, however, i have problem setting the Total Billed to the left of the month as shown...

Is it possible to set to the left side instead of below shown?

Current Matrix Table Design

Country   Jan   Feb   Mar    Apr    May   Total Billed

 

 

 

Country   Total Billed   Jan   Feb   Mar   Apr    May (Preferred Design)

 

 

Answer 5

There is no direct way to achieve this however there is a workaround.

For this, you will have to create the first matrix using Country and Total Billed. Create another matrix with Country on rows and all the Months on columns. Make the rows of the second matrix invisible and place both the matrix side by side. For the user it will look like one matrix almost.

---

Cheers,
Jason
P.S. : Please click the 'Mark as Answer' button if a post solves your problem! :)

Answer 6

Hi Jason,

Any idea what could be the reason when I have already set format as ###,###,##0.00 however, when i preview, it is still reflect as 99999.999999

Answer 7

Please raise new questions if it is not related to the topic as it is hard to monitor, and other people would not open the topic if it is answered.

Could you please raise a new question for this?

---

Cheers,
Jason
P.S. : Please click the 'Mark as Answer' button if a post solves your problem! :)