Matrix title

I have the following report using RS2000

(1) In my page header I have a textbox(title of the report).

(2) In my report body, I have a matrix report that can extend horizontally.

My issue is that I don't know how to make sure that my page header title (1) stretches as far as the last matrix row (2).

Any help? Has anyone ever come across this issue and is there a solution to it?

Thanks,

YADGOR2000

Two options:

1. You can add an outmost status column (or a dynamic column with a constant group expression) in the matrix. Put the title in the column header and set the TextAlign to center.

2. Add a table with two header rows and one column, and drop the matrix inside the second row of the table. Put the title in the first table row, and set the TextAlign to center.

|||

I am not sure I can understand your response. Can you give me step by step break down for either option 1 or 2.

Thank you

yadgor2000

Matrix title

I have the following report using RS2000

(1) In my page header I have a textbox(title of the report).

(2) In my report body, I have a matrix report that can extend horizontally.

My issue is that I don't know how to make sure that my page header title (1) stretches as far as the last matrix row (2).

Any help? Has anyone ever come across this issue and is there a solution to it?

Thanks,

YADGOR2000

Two options:

1. You can add an outmost status column (or a dynamic column with a constant group expression) in the matrix. Put the title in the column header and set the TextAlign to center.

2. Add a table with two header rows and one column, and drop the matrix inside the second row of the table. Put the title in the first table row, and set the TextAlign to center.

|||

I am not sure I can understand your response. Can you give me step by step break down for either option 1 or 2.

Thank you

yadgor2000

Matrix Calculation - New to RS2000

Hello!
Iâ'm hoping somebody out there can help me! I am a new user of SQL Reporting
Services 2000 and have been asked to create a report showing studentsâ'
attendance. After a lot of reading and research I created a matrix report
that looks like this;
=Fields!attendance_type.value Total
=Fields!student_id.value
=Fields!week_no.value =Fields!register_id.Value =count(Fields!attendance_type.value)
It gives me the following results;
PR AA AB Total
0003 7 ACCA2 4 0 0 4
BUSA2 4 0 0 4
LANA2 2 2 0 4
8 ACCA2 2 2 0 4
BUSA2 2 2 0 4
LANA2 2 0 0 2
9 ACCA2 4 0 0 4
BUSA2 2 0 2 4
LANA2 3 0 0 3
10 ACCA2 4 0 0 4
BUSA2 4 0 0 4
LANA2 3 0 0 3
I would now like to add another column next to Total (subtotal of
=Fields!attendance_type.value) to calculate the % Attendance by using
PR/Total*100.
So in the end, I want something like this;
PR AA AB Total % Attendance
0003 7 ACCA2 4 0 0 4 100
BUSA2 4 0 0 4 100
LANA2 2 2 0 4 50
8 ACCA2 2 2 0 4 50
BUSA2 2 2 0 4 50
LANA2 2 0 0 2 100
Your help would be much appreciatedâ?¦
Wilma KhaliqYou can do a second query and append it to this one with "union", like
select blah blah from blah where blah
union
select blah2 blah2 from blah2 where blah2
except in the bottom select you can do your total, making a new type called
'TOTAL'
--
"Everyone knows something you don't know"
"Whee4ever" wrote:
> Hello!
> Iâ'm hoping somebody out there can help me! I am a new user of SQL Reporting
> Services 2000 and have been asked to create a report showing studentsâ'
> attendance. After a lot of reading and research I created a matrix report
> that looks like this;
> =Fields!attendance_type.value Total
> =Fields!student_id.value
> =Fields!week_no.value =Fields!register_id.Value =count(Fields!attendance_type.value)
> It gives me the following results;
> PR AA AB Total
> 0003 7 ACCA2 4 0 0 4
> BUSA2 4 0 0 4
> LANA2 2 2 0 4
> 8 ACCA2 2 2 0 4
> BUSA2 2 2 0 4
> LANA2 2 0 0 2
> 9 ACCA2 4 0 0 4
> BUSA2 2 0 2 4
> LANA2 3 0 0 3
> 10 ACCA2 4 0 0 4
> BUSA2 4 0 0 4
> LANA2 3 0 0 3
> I would now like to add another column next to Total (subtotal of
> =Fields!attendance_type.value) to calculate the % Attendance by using
> PR/Total*100.
> So in the end, I want something like this;
> PR AA AB Total % Attendance
> 0003 7 ACCA2 4 0 0 4 100
> BUSA2 4 0 0 4 100
> LANA2 2 2 0 4 50
> 8 ACCA2 2 2 0 4 50
> BUSA2 2 2 0 4 50
> LANA2 2 0 0 2 100
> Your help would be much appreciatedâ?¦
> Wilma Khaliq