Matrix Report: Surrounding Borders For Detail
Apr 9, 2008
I have the following report grouped by customer:
month
1
cust1 2008 50
2007 60
cust2 2008 100
cust3 2008 90
2007 80
I'd like to border the last detail row of every group, should look like this:
month
1
cust1 2008 50
2007 60
cust2 2008 100
cust3 2008 90
2007 80
Any suggestions!?
View 10 Replies
ADVERTISEMENT
Dec 28, 2007
Hello,
I created a report with borders in the page header, the page body, and the page footer. When I preview the report in report viewer it is exactly how I want it and it also prints and exports to pdf perfectly. There's only a problem viewing it in report manager. The borders in the page header and footer show up right but the body of the report's borders don't show up at all. The body of the report also is no longer aligned with the page header and footer because it's borders seem to be unrecognized in the report manager view. Has anyone experienced this problem and/or figured out what to do to fix this? Please let me know.
Thanks,
cbal4
View 4 Replies
View Related
Dec 31, 2007
I have a matrix based report running, it shows a pivoted statistical value in the detail cells. Now I'd like 1 of 2 images to show instead, in those cells, based on the value of the statistic. Can this be done in a matrix?
View 1 Replies
View Related
Dec 12, 2007
Hi all experts,
I have a result set like:
Project
Milestone
Info
Project1
M1
Info1
Project1
M1
Info2
Project1
M2
Info3
Project2
M1
Info4
Project2
M2
Info5
Project3
M1
Info6
I need to create a report like:
M1
M2
Project1
Info1
Info2
Info3
Project2
Info4
Info5
Project3
Info6
But while I use matrix to build this report, I got the result like:
M1
M2
Project1
Info1
Info3
Project2
Info4
Info5
Project3
Info6
The report will not show the multiple records on the row group "Project" like item "Info2".
After I referred to the similar problem mentioned on this forums, I tried to use "RowNumber("Matrix1_Project")" to resolve it. But still I got the result like:
M1
M2
Project1
RowNumer
Info1
RowNumer
Info1
RowNumer
Info3
Project2
RowNumer
Info4
RowNumer
Info5
Project3
RowNumer
Info6
It would be much appreciated if anyone could give me some hints to complete the report I need.
Thanks in advance,
Steve Wang 2007/12/12
View 5 Replies
View Related
Nov 15, 2006
Hello all,Does anyone know the SQL statement for calculating surrounding suburbs,or can point me in the right direction?I have a database of Australian postal codes and their centroids inlongitude and latitude, I'd like to pass it either the long/lat orpostal code to calculate from. And preferably return distance as well,in KM..Thanks in advance.
View 6 Replies
View Related
Aug 19, 2004
I would appreciate any help on this project. I have created an Access database that contains one vehicle. I have also included all options on that vehicle, which are in one column. Therefore the main criteria for the vehicle is listed each time for each different option. On my report I am grouping by the vin and placing the main criteria in the group header area of the report. The options are going into the detail section. How do I get the options to print in two columns within the detail section? I am unable to find any help on this subject, so I am asking you for help.
Thank you all! Timpy
View 1 Replies
View Related
Jun 25, 2007
I know this must be an easy fix, but I can't seem to find what I'm after.
I can sort my groups in a report, but I want to sort the detail line as well:
Group: State, City,
Detail: Zip Codes
I want to sort the Zip Codes on the detail line in Ascending order, but can't seem to find an option to handle that.
Where is that located in Reporting Services Visual Studio report designer tool?
Thanks!
View 1 Replies
View Related
Nov 1, 2007
I am developing a report analog of a machine readable form that has to display a static number of detail rows regardless of the number returned from the database - i.e. if a record set has only three detail records, I need to display three blank rows, while if the record set has ten detail records, I need to display six detail records, print the footer, start a new page, repeat the header information, print the remaining 4 detail records and 2 blank rows, print the footer again and move on to the remaining recordset. I am new to report development and I'm having to pick it up on the fly. I can't seem to locate any documentation about how to handle this scenario.
I don't have the time or inclination to re-invent the wheel here, is there anyone who has solved this problem who can point me in the direction of some help?
View 2 Replies
View Related
Aug 19, 2007
Almost new to ssrs, accessing Oracle's stored procedures to feed the reports (no other choice), working on a master/detail report and badly stuck. This report needs to access 3 stored procedures one for master and two for small tables under it. The master's order ID is fed to the two stored procedures that may or may not pull any thing for certain order ID's
I am approaching it by creating 2 datasets and a page-long list, added desired text boxes and a table in the list, grouped the list on order ID and passing it to tables using default values etc. but keep getting the following message.
"The Group expression for the table €˜table1€™ refers to the field €˜ProductName€™. Report item expressions can only refer to fields within the current data set scope or, if inside an aggregate, the specified data set scope".
The list seems to be associated to one dataset only and any item in it cannot refer to anyother dataset, even if I try to access the table's dataset in its properties (The 'current data set scope' implies that).
(Not sure what will happen when I will try to add the second table and dataset with the same parameter name).
How should I approach this issue. I will appreciate help, if explained in steps but won't mind a good tip.
Thanks.
View 8 Replies
View Related
Jun 3, 2015
I want to add a detail line on a report in visual studio. How can I do it?
View 9 Replies
View Related
Sep 14, 2007
I am listing detail transaction lines in a table sorted by account and order number.
the problem is that I only want to see the detail if the sum of a value field is zero for all the transactions in an order otherwise ignore the detail for that order.
I was trying Group by and Having but this doesn't seem to do what I need.
Being relatively new to Reporting services, any nudge in the right direction would be useful.
View 4 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
Jul 20, 2007
I have a row in my report that has 6 columns. I want to outline the row with a border, but not the column lines in between. So, I went into BorderColor, changed the Default to white and my Top and Bottom colors as Black. The problem is that where the "white" column lines are, they are displaying 1pt gaps in my outline. I tried changing the BorderStyle to Zero, but it wouldn't take it.
See sample of the report here.
Any ideas?
Thanks,
James H.
View 6 Replies
View Related
Jul 12, 2007
Can I add borders to my bars in the column chart? My bars don't appear to have any border, and I can't see a place to set one. I am using SSRS Express.
Thanks!
Michael
View 3 Replies
View Related
Oct 3, 2007
I'm setting up a new computer, and opening an SSIS project I've worked on elsewhere. Here's what I'm seeing (see http://tkfiles.storage.live.com/y1pX-TdM6iRI3cSQsl2V4GLd5RAuX2ygIeBbMSb-VM7vTauMSqehrm7pFvpA6N2sFLQFrb4a-1iXnk):
The borders and icons come back if I resize the window by dragging an edge of the window. They disappear again if I maximize the window.
It's very odd, but I'm wondering if it means that something sinister is going on. I didn't set up all of the software on this machine, so I don't fully trust that it was set up correctly.
View 4 Replies
View Related
Aug 19, 2015
We run std 2008 r2.  On my col heading text boxes and data text boxes i'm purposely picking only borders above and left in an attempt to get rid of what looks like a double border between text boxes.Â
The only places I see what appears to be a single thickness is the left of the 1st column hdg and data, and above any col hdg text box I set this way.Â
Also, when I pick .5 instead of 1 pt thickness, ssrs always puts it back to 1 pt.
How can I get the appearance of single thickness borders instead double?
View 5 Replies
View Related
Mar 25, 2008
Hello,
I'm new to SQL and need help with a query. Not sure if this is the right place.
I have 2 tables, one MASTER and one DETAIL.
The MASTER table has a masterID, name and the DETAIL table has a detailID, masterID, and value columns.
I want to return a populated MASTER table with entries based on the DETAIL.value.
SELECT MASTER.*
FROM MASTER
WHERE DETAIL.value > 3
This is a simplified version of my problem. I can't figure out how to set the relationship between MASTER.masterID and DETAIL.masterID. If I do an INNER JOIN, the number of results are based on the number of DETAIL entries. I only want one entry per MASTER entry.
Hope this makes sense.
How can I do this?
GrkEngineer
View 9 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