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

Problem With Page Borders When Rendering Report In Html

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

Can An Image Be Shown In Matrix Detail?

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

Show Detail Data On A Matrix Rather Than Aggregate Data

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

SQL To Calculate Surrounding Suburbs

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

MS Access Detail Split Into Columns On Report

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

Sort Detail Line In Report Services

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

Report With Constant Number Of Detail Lines

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

Using Multiple Stored Procedure In Master/detail Report

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

Reporting Services :: Add A Detail Line On A Report In Visual Studio

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

Selecting Detail Based On A Sum Of The Detail Lines

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

Adding Columns To A Matrix Report That Don't Belong To The Matrix Columns Groups

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

Gaps In Borders Between Columns...

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

Column Chart Bar Borders

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

Ever See This? No Borders Or Icons On Tasks

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

Reporting Services :: Cannot Seem To Lose Most Double Borders

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

SQL Master/Detail (Master Query Based On Detail Values)

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

Help With The Matrix Report

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

Matrix Report

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

Add A New Row To Matrix Report

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

Help With Matrix Report

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

Help With Matrix Report.

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

MAtrix Report With Drill-through

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

Matrix Report With Totals

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

Sorting Matrix Report

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

Sum Of Fields In Matrix Report

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

Help With Matrix Report And Design

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

Different Totals In A Matrix Report

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

Sum Of Values In Matrix Report

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

Drill Down In A Matrix Report

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

Matrix Report - Need A Clue

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

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 View Related

How Can I Create A New Custom Report Item? The Report Item Is Extends Matrix.

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







Copyrights 2005-15 www.BigResource.com, All rights reserved