How To Add Coustom Column In Matrix Report
Nov 15, 2007
Hi,
Can someone tell me,How to create a cusotm column in Matrix report
I have Row Group as State and Column group as Status
I need to have one additional column in Matrix named Resolved Count which basically shows conunts for State which got resolved
State Status1 Status2 Resolved Counts[Custom Col]
NY 12 13 1
TX 1 5 3
I tried creating a different column group but seems like it's not working.I read somewhere that you can do it.Do someone has idea how to achieve it?
-Thanks,
Digant
View 2 Replies
ADVERTISEMENT
Apr 28, 2007
Hi All
I have a matrigx report that groups by months in the columns. The reason for using a matrix style report is due to not knowing which months are going to exist in the database for the current year.
I do however need to have a static column appended to the matrix, using the same row groupings... I did think of placing a table next to the matrix with that column although im worried the row groupings and alignment may be off of each record.
Is it possible to have a static column inside a matrix that is not grouped by any of the columns just the rows.
What would be the best way to achieve this requirement. I also need to provide the options to hide the months columns and display only the static one and vice-versa...
Any help would be appreciated..
Regards,
Neil
View 4 Replies
View Related
Sep 1, 2006
I have a matrix report, which looks like the following:
Header C Header D
Column A Column B Column C Column D
Column A and B are Row Group columns in the matrix. Column C and D are the details columns. How can I add column header to column A and B. Seems I cannot do it in Reporting Services 2005.
Fan
View 8 Replies
View Related
Nov 2, 2007
Hi Everyone,
I am designing a report in SQL Server 2005 Report Designer that uses a Matrix table. The matrix table is grouped by month. How can I add a Year-To-Date total column on the report? This is driving me nuts...I cannot figure this out.
Thank You
-Sam
View 1 Replies
View Related
Jan 24, 2008
Hi
I have a huge matrix with 8 columns and then all the data that's generated when choosing a date span. These 8 columns are Topic, Salesperson, Company and so on and then the right part of the matrix grows with values for each month.
My problem is that there are no column headers for the first 8 columns!! How come?
What I did to resolve this was to put in a table in the top left cell and then write in the corresponding column header. This works €¦ in IE but not in PDF or Excel. And I really need it when I export it to Excel.
Any ideas?
Kind regards.
View 5 Replies
View Related
Apr 1, 2008
I've a matrix report with two row groups. One of the row groups has been used to do alternate coloring in report rows. The issue is that the header text that I've provided for the row group repeats twice. Another interesting point to note here would be this doesn't happen in the report preview but only when the report is displayed through a report viewer in an ASP.Net application. I can guess that it must have got something to do with the invisible row group but can't get my head around on how to avoid it?
The report currently looks something like below:
Month 2007 2008
Month Total Ave % Total Ave %
-----------------------------------------------------------------------
January 12 6 1.5......................etc etc.
I want the text "Month" to come only once. Thanks.
View 1 Replies
View Related
Mar 21, 2007
Hi there...
I have a matrix report within a list so it functions as a report with dynamic columns.
Matrix a:
a b c d e
x 1 2 4 9 12 <NEED SUBTOTAL across Columns for row x>
y 6 2 4 5 9 <<NEED SUBTOTAL across Columns for row y>
TOTAL <need totals going down rows and need a grand total>
Remember the number of rows and columns are dynamic so I have NO CLUE how to add a column and display it if and only all the columns have been displayed ...sort of like a COLUMN and ROW footer for a matrix report.
Any help will be appreciated
thank you
Prashanth Prasanna
View 1 Replies
View Related
Jan 15, 2008
Hi,
Hi All,
I am having some trouble getting a Grand Total column at the end of my matrix report (not row at the bottom), such as you get by default in an Excel pivot table.
I have managed so far to add another column that sums up all values across the data range for a particular product code. My intention was to hide all but the last (I did something similar on rows). However you cannot use an expression on the width property for columns, so this will not work.
My report is very standard:
Year
Month (grouped by year)
Product code | Description [qty]
I want a column that displays the total qty across all dates for each row. Surely this is possible?
Any suggestions would be appreciated! Thanks.
View 6 Replies
View Related
Oct 29, 2015
I am creating a Matrix report using SSRS/Visual Studio 2008 as below:
Jan
Feb
March
April
May
June
July
Aug
Sept
Oct
A & B are customers. The values represent sales for each month.I have got most parts in place except the Month are displayed in random order (1,10,2,3,4,5,6 and so on).I have tried the option to create a calculated column with month numbers and change group properties but that did not work.how to get it to sort display as 1,2,3,4,5,6,7,8,9,10.
View 6 Replies
View Related
Sep 25, 2007
Hi All,
I need to show the Cumulative calculated value only in Total by year/Group. I could not use Visibility expression using
InScope, as it creates *Blank column. Please go thru details below.
Year
Month01 02 03 Total
Salary Salary Salary Salary Cumulative (Calc)
Employee01 20 5 25 25
Employee02 10 10 20 45
.....
Total
How can i achieve this?. Any suggestion on this would be appreciated.
Thanks,
View 1 Replies
View Related
May 15, 2008
Hi,
I am sure there is a simple answer to this, but I cannot find it at the moment???
I have a simple data table in SQL which gives me Division, PL Measure and Value...
SQL Table
Division
PL_Desc
Result
A
Total Labour Costs
10
A
Total Sales (inc Machine Income)
100
B
Total Labour Costs
5
B
Total Sales (inc Machine Income)
100
C
Total Labour Costs
9
C
Total Sales (inc Machine Income)
100
I need to report on this and calculate a ratio, so I have pushed this into a Matrix Report but cannot work out how to get the ratio column to work???...
Matrix Report
???????????
Division
Total Labour Costs
Total Sales (inc Machine Income)
New Column = Labour / Sales
A
10
100
10%
B
5
100
5%
C
9
100
9%
Grand Total
24
300
8%
If anyone can help save me from my own stupidity!
Cheers, Matt
View 6 Replies
View Related
Aug 2, 2007
I have a matrix report with 2 column SaleAmount and ProfitAmounts by Month like
Sale Profit
Dealer 5/1/2007 6/1/2007 7/1/2007 5/1/2007 6/1/2007 7/1/2007
A 100 200 300 20 25 15
B 200 250 50 30 45 19
how can i do following 3 things
1)Add Total column for Sale and Average column for Profit
2)Sort report by lastMonth of Sale (here 7/1/2007) High to low
3)if last month of sale(here 7/1/2007) is less than second last month here (6/1/2007) whole row should be red
thanks
View 1 Replies
View Related
Aug 6, 2015
I got the following code to add a column in a matrix with a variance:
IIF(IsNothing(Previous(Sum(Fields!Amount.Value))) or Fields!year.Value=First(Fields!year.Value,"Category") or Previous(Sum(Fields!Amount.Value))=0,nothing,
(
(Fields!Amount.Value)
/Previous(sum(Fields!Amount.Value))
)
)
This code works fine, except that the first row of the matrix shows an #error
This happens with each matrix where I use this expression. A warning emerges:
rsruntimeerrorinexpression the value expression for the textrun Textbox43.Paragraphs[0].TextRuns[0]' contains an error.
Attempted to divide by zero.
The strange thing is that the part
Fields!year.Value=First(Fields!year.Value,"Category")
should prevent an error and I expect it to show 'nothing'
An screenshot of the table. (each color is a different category. Each row stands for 2013, 2014, 2015)
As you can see, all other 2013 rows show a blank cell, except the first row.
View 3 Replies
View Related
Jan 2, 2007
Can we do this?
Adding more columns in a matrix report that don€™t
belong to the columns drilldown dimensions€¦
That is, for example, having the following report:
Product Family
Product
Country City Number of units sold
Then I
would add some ratios, that is, Units Sold/Months (sold per month) and other that
is the average for Product Family (Units Sold/Number of Product Family), for putting an example€¦ some
columns should be precalculated prior to the report so do not get into it, the
real problem I don€™t see how to solve is adding one or two columns for showing
these calculated column that doesn€™t depend on the column groups but they do
for the rows groups€¦
Any guidance
on that?
The only
way I am seeing by now is to set it as two different reports, and that is not
what my client wants€¦
Many
thanks,
Jose
View 4 Replies
View Related
Mar 2, 2007
Hello All!
I developed a matrix SSRS report for a specific scenario, and the results look something like the example below. The result set is grouped by the date value, so for all records on that date in the first column I have just one value - 2/5/2007. The client would like to see a value for each cell in every row in the date column, so they can sort the results and do other manipulation in Excel. I tried to make it happen but I doesnt seem to work using the matrix. I would really appreciate if anyone has any suggestions on how to make it work. btw, it really has to be a matrix report :)
Thanks, everyone!
2/5/2007
Value 1
3604
Value 2
5250
Value 3
1281
Value 4
1612
Value 5
2861
Value 6
2135
Value 7
850
Value 8
5368
Value 9
1146
Value 10
2928
Value 11
1435
Value 12
195
Value 14
1414
Value 15
776
View 4 Replies
View Related
Jan 30, 2007
hello all,
I have to make matrix report,
my problem is that I have to make report like this picture:
http://img2.tapuz.co.il/forums/1_93196948.jpg
Is there is a way to make it?
do I need a subreport?
Any tips would be appreciated Thanks
View 2 Replies
View Related
Apr 18, 2008
Hi ALL,
I'm trying to create a report using matrix report.
I use a simple query like this.
SELECT Catergory, Month, SUM(TotalApp) AS TotApp
FROM Table1
GROUP BY Catergory, Month
result is like thsi
Approved 2007-03-01 00:00:00.000 60198
Approved 2007-04-01 00:00:00.000 59786
Approved 2007-05-01 00:00:00.000 80608
Decisioned 2007-06-01 00:00:00.000 65981
Decisioned 2007-07-01 00:00:00.000 60217
Decisioned 2007-08-01 00:00:00.000 59040
Decisioned 2007-09-01 00:00:00.000 45180
Now I want to add Approved into one row and decisioned into the next row like that. I can easily do row grouping in the matrix. but then I wont be able to add new rows inbetween those groups. I want to add some rows inbetween those groups to include calculated fields.
I try to use something like this;
=IIf(Fields!Category.Value = "Decisioned" , Fields!TotalApps.Value, " " )
But It gives the same result for every group.( does not matter whether its decisioned , Approved or smthign else)
can any one tell me how to do this?
Thanks
View 6 Replies
View Related
Apr 25, 2008
Hi Everyone,
I am having some trouble creating my employee schedules report. I would like to design a report like this:
Name | 7:00am | ............|..............|................|..30 minutes apart..|................|................| 8:00pm
Frank [ FIRST BRK ] [ LUNCH ] [ PROJ 23 ]
Tony [ FIRST BRK ] [ LUNCH ] [ COACHING ]
The dataset includes the following fields:
EmpID int
EmpName varchar
RowDate date
StartTime datetime
StopTime datetime
SegmentCode char(10)
ColorCode
Can someone please advise me on how I can create this report in SQL Server 2005 Reporting Services. Thank You
View 4 Replies
View Related
May 1, 2007
Hi All,
I have the following matrix report.
Health
1
2
3
4
Std: 1
Health Promotion and Disease Prevention
4
2
4
3
Std: 2
Accessing Health Information, Products, and Services
2
2
Std: 3
Self-Management
2
Std: 4
Influence of Culture, Media, and Technology
2
2
Std: 5
Interpersonal Communication
3
Std: 6
Goal Setting and Decision Making Skills
4
2
Std: 7
Advocating for Health
3
I need a bit of help to do two things.
One is the first row needs to be the average of the matrix columns (1,2,3,4).
Two is for a header row that will span the matrix columns.
So the final output would be;
Average Proficiency Level
Health
1
2
3
4
Overall
2.8
2.3
3
2.5
Std: 1
Health Promotion and Disease Prevention
4
2
4
3
Std: 2
Accessing Health Information, Products, and Services
2
2
Std: 3
Self-Management
2
Std: 4
Influence of Culture, Media, and Technology
2
2
Std: 5
Interpersonal Communication
3
Std: 6
Goal Setting and Decision Making Skills
4
2
Std: 7
Advocating for Health
3
The number of columns can vary from 1 to 4.
Any help would be very much appreciated.
View 2 Replies
View Related
Mar 13, 2007
Hi All,
I have a table which has a country, division, category, product, Valuetype, value
data looks like this:
Country division, category, product, Valuetype, value
---------------------------------------------------------------------
UK Division1 Food Pizza Volume 10000
UK Division1 Food Pizza Revenue 2000
UK Division1 Food Pizza ROI 4.5
UK Division2 Food Pizza Volume 14000
UK Division2 Food Pizza Revenue 2400
UK Division2 Food Pizza ROI 4.1
UK Division2 Drinks Cola Volume 14000
UK Division2 Drinks Cola Revenue 2400
UK Division2 Drinks Cola ROI 4.1
I want to build a drill-through report to be grouped on country, division, category and product.
Can someone help me with some suggestions?
Cheers
Josh
View 1 Replies
View Related
Apr 1, 2007
Hi,
Is there a tutorial on how to do a matrix report with row & column tables? This is easy on by default in Crystal, but I can't figure out how to do it in RS.
Thanks,
John
View 2 Replies
View Related
Jan 23, 2008
I have created a Matrix report with 5 row groups (Company and ProductName, ProductEndDate), one column group (Status) and two data columns(Amount & Count).
The report works fine except that it does not sort properly. I want to sort the data by Company, ProductEndDate, ProductName.
I took the following steps -- I highlighted the matrix and in the properties dialog box, selected the groups tab. In groups I selected each row group, hit the edit button, clicked the sorting tab and Company, ProductEndDate, ProductName.
View 3 Replies
View Related
Aug 24, 2007
I have matrix report to display gender statistics based on hierachical geographic data e.g.
Country 1 | region 1 | subregion 1 | No-of-males | no-of-females
with drill through enabled
I want to have persentage near the number-of-gender as well as total population for a row, like this
Country 1 | region 1 | subregion 1 | No-of-males (%-males) | no-of-females (%-females) | Total in the row
but I cannot find the way to do it.
Expression for data cell is
=sum(Fields!no_of_person.Value)
but if I try something like
=sum(Fields!no_of_person.Value) & " (" & sum(fields!no_of_person.Value) / sum(fields!no_of_person.ParentUniqueName, "column") * 100 & ")"
to get the total for both genders - the reports fails
Thanks in advance
View 4 Replies
View Related
May 3, 2008
I've got this data source that returns member information.. great.
I've got a function that when passed the member number and a month/
year returns days participating in the club.
I need to build a report that will output some of the columns for the
member, but then report other information for 6 months for each member
that all calulated based on days particpating for that month. Which 6
months will be dertimed by a single parameter passed to the report for
starting month/year... basically the next 6 months.
Is a matrix report a good option for this? Or should I just have the
function called 6 times in my data source? Ideally I layout the report
for one month and then *somehow* join in my data source for 6
iterations where month is 1 through 6.
Right now I'm having trouble wrapping my mind around how and where to
join the data? Especially if matrix and I have two data sources. I'm
also not sure I can call my function from cells in the matrix or if I
can even have mulitple data buckets in the matrix. I'm tempted to do
this the only way I know how, but I suspect there is a better way.
I've never built a matrix report in ssrs, any information or help is
appreciated.
Thank you!
View 1 Replies
View Related
Aug 21, 2007
I have a matrix report with 2 column Groups and 2 Row Groups ,I need to calculate the Subtotals at Row Group2
2007
JAN FEB MAR APR MAY JUN JUL AUG SEP OCT NOV DEC TOTAL
Current Period Total 1211 1813 3040 1699
CB 1062 1551 2527 1517
BR 149 262 513 182
Prior Year Total 1528 1894 3238 1676
CB 1276 1540 2521 1400
BR 252 354 717 276
Prior Year Chg% Total <the Total here Should not be a sum of the individual percents but a Calculated percentage>
CB -16.77 0.71
BR -40.87 -25.99
With this Matrix this is what i have in the cell
=iif (InScope("matrix1_Ddat_Prod_Mth_Nm"),
iif(InScope("matrix1_Date_Calculations"),iif(fields!Date_Calculations.Value = "Current Period",
iif(fields!Ddat_Prod_Mth_Nbr.Value > Month(Today),COBJ("-"),
Round(Sum(Fields!RecruitsCount.Value),2)),
iif(fields!Date_Calculations.Value = "Prior Year Chg %",
iif(fields!Ddat_Prod_Mth_Nbr.Value > Month(Today),"-",
iif(fields!Ddat_Prod_Mth_Nbr.Value <= Month(Today) And fields!RecruitsCount.value = -100,
"-", Round(Sum(Fields!RecruitsCount.Value),2))),Round(Sum(Fields!RecruitsCount.Value),2))),
iif(Fields!Date_Calculations.Value= "Current Period",
iif(Fields!RecruitsCount.Value= 0,"-",Sum(Fields!RecruitsCount.value)),
iif(Fields!Date_Calculations.Value= "Prior Year",Sum(Fields!RecruitsCount.value),
iif(Fields!Date_Calculations.Value="Prior Year Chg %",iif(ASC(Fields!RecruitsCount.Value)= ASC("-"),"-",Round(First(Fields!RecruitsCount.Value),2)),0)))),
iif(InScope("matrix1_Date_Calculations"),Round(Sum(Fields!RecruitsCount.Value),2),Round(Sum(Fields!RecruitsCount.Value),2)))
i have to replace the red strip with a calculated function that would return a total percentage for that row .
I am using AS 2005 as datasource for this , the AS2005 has the totals calculated but i am not able to pull them into the reporting services .
here is the MDX for that
WITH MEMBER [Measures].[Avg Monthly] AS 'AVG(Descendants([DimDate].[Fiscal Hierarchy].Currentmember),[Measures].[RecruitsCount])' MEMBER [Measures].[Total Prior Year] AS 'Sum([dimdateCalculations].[Prior Year])'
SELECT { [Measures].[RecruitsCount] } ON COLUMNS,
{ ([dimDate].[Fiscal Hierarchy].[Ddat Prod Mth Nbr].ALLMEMBERS
* [Date Calculations].[Date Calculations].ALLMEMBERS
* [dimWritingNumber].[Dwnb Broker Ind].[Dwnb Broker Ind].ALLMEMBERS ) } DIMENSION PROPERTIES MEMBER_CAPTION, MEMBER_UNIQUE_NAME ON ROWS
FROM ( SELECT ( STRTOSET(@dimDateDdatProdYrNbr, CONSTRAINED) ) ON COLUMNS
FROM ( SELECT ( STRTOSET(@dimProdChainDpchLowestLvlConsolIDNo, CONSTRAINED) ) ON COLUMNS
FROM ( SELECT ( STRTOSET(@dimProdChainDpchLvlConsolIDNo7, CONSTRAINED) ) ON COLUMNS
FROM ( SELECT ( STRTOSET(@dimProdChainDpchLvlConsolIDNo6, CONSTRAINED) ) ON COLUMNS
FROM ( SELECT ( STRTOSET(@dimProdChainDpchLvlConsolIDNo5, CONSTRAINED) ) ON COLUMNS
FROM ( SELECT ( STRTOSET(@dimProdChainDpchLvlConsolIDNo4, CONSTRAINED) ) ON COLUMNS
FROM ( SELECT ( STRTOSET(@dimProdChainDpchLvlConsolIDNo3, CONSTRAINED) ) ON COLUMNS
FROM ( SELECT ( STRTOSET(@dimProdChainDpchLvlConsolIDNo2, CONSTRAINED) ) ON COLUMNS
FROM ( SELECT ( STRTOSET(@dimProdChainDpchLvlConsolIDNo, CONSTRAINED) ) ON COLUMNS
FROM ( SELECT ( STRTOSET(@dimProdChainDpchTdNm, CONSTRAINED) ) ON COLUMNS
FROM ( SELECT ( STRTOSET(@dimProdChainDpchCompanyCd, CONSTRAINED) ) ON COLUMNS
FROM [MRSCUBE])))))))))))
WHERE
( IIF( STRTOSET(@dimProdChainDpchCompanyCd, CONSTRAINED).Count = 1,
STRTOSET(@dimProdChainDpchCompanyCd, CONSTRAINED), [dimProdChain].[Dpch Company Cd].currentmember ),
IIF( STRTOSET(@dimProdChainDpchTdNm, CONSTRAINED).Count = 1,
STRTOSET(@dimProdChainDpchTdNm, CONSTRAINED), [dimProdChain].[Dpch Td Nm].currentmember ),
IIF( STRTOSET(@dimProdChainDpchLvlConsolIDNo, CONSTRAINED).Count = 1,
STRTOSET(@dimProdChainDpchLvlConsolIDNo, CONSTRAINED), [dimProdChain].[Dpch Lvl50 Consol ID No].currentmember ),
IIF( STRTOSET(@dimProdChainDpchLvlConsolIDNo2, CONSTRAINED).Count = 1,
STRTOSET(@dimProdChainDpchLvlConsolIDNo2, CONSTRAINED), [dimProdChain].[Dpch Lvl49 Consol ID No].currentmember ),
IIF( STRTOSET(@dimProdChainDpchLvlConsolIDNo3, CONSTRAINED).Count = 1,
STRTOSET(@dimProdChainDpchLvlConsolIDNo3, CONSTRAINED), [dimProdChain].[Dpch Lvl46 Consol ID No].currentmember ),
IIF( STRTOSET(@dimProdChainDpchLvlConsolIDNo4, CONSTRAINED).Count = 1,
STRTOSET(@dimProdChainDpchLvlConsolIDNo4, CONSTRAINED), [dimProdChain].[Dpch Lvl45 Consol ID No].currentmember ),
IIF( STRTOSET(@dimProdChainDpchLvlConsolIDNo5, CONSTRAINED).Count = 1,
STRTOSET(@dimProdChainDpchLvlConsolIDNo5, CONSTRAINED), [dimProdChain].[Dpch Lvl40 Consol ID No].currentmember ),
IIF( STRTOSET(@dimProdChainDpchLvlConsolIDNo6, CONSTRAINED).Count = 1,
STRTOSET(@dimProdChainDpchLvlConsolIDNo6, CONSTRAINED), [dimProdChain].[Dpch Lvl30 Consol ID No].currentmember ),
IIF( STRTOSET(@dimProdChainDpchLvlConsolIDNo7, CONSTRAINED).Count = 1,
STRTOSET(@dimProdChainDpchLvlConsolIDNo7, CONSTRAINED), [dimProdChain].[Dpch Lvl29 Consol ID No].currentmember ),
IIF( STRTOSET(@dimProdChainDpchLowestLvlConsolIDNo, CONSTRAINED).Count = 1,
STRTOSET(@dimProdChainDpchLowestLvlConsolIDNo, CONSTRAINED), [dimProdChain].[Dpch Lowest Lvl Consol ID No].currentmember ),
IIF( STRTOSET(@dimDateDdatProdYrNbr, CONSTRAINED).Count = 1,
STRTOSET(@dimDateDdatProdYrNbr, CONSTRAINED), [dimDate].[Ddat Prod Yr Nbr].currentmember ) )
CELL PROPERTIES VALUE, BACK_COLOR, FORE_COLOR, FORMATTED_VALUE, FORMAT_STRING, FONT_NAME, FONT_SIZE, FONT_FLAGS
Please help . Thank you
View 2 Replies
View Related
Feb 13, 2008
Hey everybody,
I am somewhat new to SRS. I am creatnig a report containing a Matrix. I did this because there are one or more columns included in the data set. I would like to add totals to both the rows and columns.
Here is data samples of the matrix:
Columns: C1, C2, C3...
Rows: R1, R2, R3, ...
There is a total making up the data section and looks like this (I will just use Valx for the value in the data section):
C1 C2 C3 ....
R1 Val1 Val2 Val3
R2 Val4 Val5 Val6
R3 Val7... ....
.
.
.
I would like to total each column and have a summary at the bottom (for the C1 this would contain Val1+Val4+Val7) and also like to have an extra column containing totals for each row (for the R1 this would contain Val1+Val2+Val3...).
Is there a way to do this? Am I missing something obvious?
Thank you for any help, it is very apprecaited.
Eric
View 3 Replies
View Related
Jan 8, 2007
is it possible to have drill down feature in matrix report?
A B C
x 1 0 1
y 2 2 2
z 4 0 7
What would be nice is if the user clicked on "7" and a report opened showing the detail for that value.
View 1 Replies
View Related
May 11, 2007
My data is like this:
QualifiedDate Total DateTimeQualified
2007-05-11 30 5/11/2007 3:12
2007-05-11 29 5/11/2007 6:28
2007-05-10 22 5/10/2007 1:54
2007-05-10 10 5/10/2007 5:55
Report needs to be like this:
2007-05-11 59
2007-05-10 32
with a drill down option to get it broken down my the datetimequalified
I've seen some examples but they are so overblown I can't figure it out
Can someone give me something simple to start with?
View 1 Replies
View Related
Dec 7, 2007
Hi Everyone,
I'm currently working on a report that is using the matrix tool. But unfortunately I can't create the required report layout as shown below.
Student Name
Additional Information
TERMS
SUBJECT DETAILS
English
Mathematics
History
Term1
Term2
Term3
Quiz
Project
Final Exam
Quiz
Project
Final Exam
Quiz
Project
Final Exam
John Smith
Adviser
Mr. Johnson
Ms. Brown
Mr. Clark
89
79
80
88
80
87
85
89
90
Section
Section 1
Section 2
Section 2
School Year
2007-2008
2007-2008
2007-2008
Michelle Park
Adviser
Ms. Brown
Mr. Clark]
Mr. Johnson
87
78
85
78
85
86
89
90
94
Section
Section 3
Section 2
Section 1
School Year
2007-2008
2007-2008
2007-2008
Based on our analysis, this report seems requires 2 matrices to be joined together. The first one is the TERMS section and the other is SUBJECT DETAILS.
TERMS with dynamic data values such as Term1, Term2 and Term3 contains static row information such as Adviser, Section and School Year that is group by Student Name.
SUBJECT DETAILS with dynamic data values such as English, Math and History contains static columns such as Quiz, Project, Final Exam group by Subjects and Student Name.
How can we join two matrices in one report? Can someone help me on this?
Please bare with my sample matrix layout.
Thank you in advance.
-lia-
View 1 Replies
View Related
Jan 18, 2007
hi everyone
what the matrix's class name ?
where is the matrix's dll?
Can i create a new class extends the matrix?
I want to override the matrix's onpaint method.
Can i do this ?
why the table not have the column group?
View 9 Replies
View Related
Oct 17, 2007
hello there,
how can i add column datas together or merge two columns together.
cheers
zolf
View 3 Replies
View Related
Feb 25, 2008
Hi,
I've a report containing a matrix. I want a column on end of each row in matrix, which shows me sum of that row. Is it possible in matrix? if yes, how can i achieve it?
View 4 Replies
View Related
Jun 24, 2006
hi reporters!
i m using matrix in my project and i want to calculate the
(cell_value/sum_of_column). for data cell values we have to use sum or
another aggregate function for subtotaling, so for the cell value i m
wirting sum(column) / A. how to write A that points to sum of all cells
on the column.
x_column
y_column
z_column
sum(y_column)/A
A?
View 13 Replies
View Related
