Complex Matrix Report - Please Help Me....
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
ADVERTISEMENT
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
Nov 23, 2006
Here is my data
------------------------------
BookName | Price
Book 1 | 75
Book 2 | 100
Book 3 | 45
Book 4 | 10
I want to make a report eg:
Category | Total
>= 75 | 2
25 - 74 | 1
< 25 | 1
View 1 Replies
View Related
Feb 14, 2008
Hi Everyone,
I need to create a grand total field that uses aggregated data from the footer of each group. Any ideas on how I can create the grand total Productivity level in RS 2005? I cannot retrieve the value in the table textbox since it's not in the same group. Thank You
Team Leader: Sam Doe
Days in Dept Productivity Level
------------------------------------------------------------------------------------------------------------------------
Service
Agent 1
Agent 2
Agent 3
Agent 4
Total for Service: 124 1
Parts
Agent 5
Agent 6
Agent 7
Total for Parts: 54 3
------------------------------------------------------------------------------------------------------------------------
Grand Total: 178 (1* 124/178) + (3* 54/178) = 1.63
View 3 Replies
View Related
Jul 20, 2005
Hi AllWondered if you could help.Basically I have 2 tables that contain all the data I want for my report,but I need to put it in a particular way and I need to display it in an ASPpage so my queries got to be manual rather than an MS Excel/Query 'munge'.To be honest, the report itself is very basic, so hopefully my ramble willmake sense. I need to report that shows 6 columns at best, 4 columns ifit's easier. Report looks like the following:Account Code - standard text fieldAccount Name - standard text fieldTurnover (Year to Date) 2002 - standard decimal number (single??) fieldTurnover (Year to Date) 2003 - standard decimal number (single??) field(not vital, but would be nice)Deviation as a straight figure between what the 2003 turnover figure isagainst the 2002 figure - ad hoc calc fieldDeviation as a % between what the 2003 turnover figure is against the 2002figure - ad hoc calc fieldMy table structure is as follows:TABLE 1 - ACCOUNTSThis contains all of the account codes (PK) and names as ACCOUNTID and NAMErespectively. It also contains a field called LEDGER which I would need touse in a Where clause to set this to 1 (1 = sales and 2 = purchases).TABLE 2 - ACCOUNTBUDGETSThis contains the Turnover details and is linked to the ACCOUNTS table by anACCOUNTID (FK??). This table contains a TURNOVER field for the actualturnover amount, a PERIOD field for the months of a year (eg, 1 - 12 - thatbeing Jan to Dec) and a YEAR field for the relevant years.In this ACCOUNTBUDGETS table it basically keeps a line-by-line record ofeach turnover for each period and year for each account code. As youprobably would with any transaction line storing table.An important part of this is that I want to show all of the Account codesand names that relate to LEDGER=1 even if they have no entries in theACCOUNTSBUDGETS table. The reason being is that I want to be able to showthat an account might not have traded for 2002 and therefore their 2003 Yearto date might be really good cos they've sold loads in 2003.So the final part is that I need summarise the Year to date figures next toeach account code and name. To do this I need to take what the month numberis now (eg, Dec = 12) and summarise all the turnover figures for 2002 upto12 and then all the turnover figures for 2003 upto 12. If you can imaginewhen this report is run in March the report would summarize from 1 to 3rather than 1 - 12 in the last examples.The nice bits on the end would be that they would give 2 different calcsagainst what the 2 turnover figures stated.The result should be something like the following:December Turnover YTDDeviationAcc No: Account Name 2003 2002 £%A001 Alpha Motor 9,250 5,398 3,85271%A003 A J V Secure 094 -1,294 -100%A004 Aye Gee 039 -4,239 -100%A007 P H Allin 2,23508 -1,973 -47%Any ideas??RgdsRobbie
View 3 Replies
View Related
Apr 16, 2007
Hi all,
I had developed all my reports using CRXI and stored procedures of MSSQL 2000. Now I am migrating from CRXI to SSRS. But i have a problem because of my report stored procedures. These stored procedures are complex and nested. When i try to use procedures in a report, it gives a error. When i comment out my EXEC line in my procedures, it goes OK.
Please help me to do this ?
View 1 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
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
Jul 11, 2006
I have a matrix report and it doesn't add titles to the different groupings. And when you try and add a text box it spans across all grouping columns. How do you add titles to these columns?
Cheers
Damien
View 3 Replies
View Related
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
Jan 29, 2007
I have a matrix report that has two columns, and one of the colums has the following expression for background color:
=IIF( Fields!Percentile.Value >= .10, "Yellow", "White")
Basically if the percent is greater than 10 highlight the field, for some reason i have some fields that dont show up yellow, see below:
http://duhaas.googlepages.com/percent.Jpg
View 3 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
Aug 17, 2007
In a matrix report with column and row groupings, how to pass the parameters to the drill-through report? The column grouping could open up into multiple columns and the same to the row groupings. I have a navigation link to a drill-through report on a total field in the matrix report and the drill-through report is required three parameters, one from the parameter from the matrix report (this one I can map to easily), second parameter is one of the value from the column grouping field and the third parameter is one of the value from the row grouping field. How to select those values from the column/row grouping.
Thanks
View 8 Replies
View Related
Jun 27, 2007
I have a matrix contained inside a rectangle. When the report is published, a fraction of the last column of matrix is stripped out, about 0.2 cm of it. When I hit Refresh, the report renders properly displaying the last matrix column in its entirety. Any ideas why its doing that?
View 2 Replies
View Related
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
View Related
Dec 15, 2007
Hi everybody,
I'm having trouble creating a seemingly simple Comparison report.
I want to be able to create a Table or Matrix that displays the number of items for the Current Year, the Previous Year, and the Difference. I was able to write a script that gives me the count for each item, for each year, as illustrated below:
Item
WhichYear
Count
Apples
Current Year
2
Apples
Previous Year
2
Mangos
Current Year
214
Mangos
Previous Year
204
Oranges
Current Year
13
Oranges
Previous Year
20
Pears
Current Year
19
Pears
Previous Year
50
Strawberries
Current Year
28
Strawberries
Previous Year
40
Ideally, the report Layout look like this, with a column for each year, and a separate column for the difference:
Item
Current
Previous
Difference
Apples
2
2
0
Mangos
214
204
10
Oranges
13
20
-7
Pears
19
50
-31
Strawberries
28
40
-12
Sounds simple enough to me. But when I put it in a Table, I can't get the counts for the Current and Previous Years on one line per item. They end up broken down into two lines (as illustrated in the first chart). When I try to add a grouping, it somehow holds onto the Current Year numbers and ignores the Previous Year numbers. When I put it in a Matrix, I can't seem to write a simple calculation, like finding the Difference between the two columns. Can I add a non-pivot row or column to the matrix?
I know this is a very general question... Any idea on whether I should go for a Table or a Matrix or another approach, like a summary table?
Thank you very much in advance,
- Trevor
View 2 Replies
View Related
Dec 20, 2007
Hi,
I have a matrix report in which i embedded an image in the page header, i want that image to be alighned at the right most top corner of the page when we view the report, Pls help me What to do to achieve this.
View 1 Replies
View Related
Sep 10, 2007
Hi,
I have a matrxi report with 6 Columns (Col 1, 2, ...6). Based on the parameters I select I wanted to hide 3 of the columns (Col 2, 4 and 6. But the problem is when I hide the columns, it leaves a gap. That means, the matrix report shows Col 1, 3 and 5 with gap in between the Columns.
There is no Column Visibility property in matrix report.
Please help me as I am looking to solve this issue for a long time now.
Thanks,
S Suresh
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
May 15, 2008
I am creating this OLAP matrix report and I tried to speed up the time needed for the OLAP dataset by limiting the number of columns in the dataset. I have two parameters, year and month, for the dataset which are set to multi-select values. Year and month are not assigned to the dataset as for the reason mentioned above (performance). However I do want to show the year and month in the matrix report. Can I use the parameter value when assigning the grouping for the year and month like "Parameters!DateCalendarYear.Value" etc and the same to the text box in the matrix report?
I tried it to the report and it returned with an error saying "The Group expression used in grouping 'matrix_....' returned a data type that is not valid"
Thanks
View 4 Replies
View Related
