Custom Subtotal

Oct 25, 2007

Hi,

I am using a matrix to report, and there is 2 rowgroups and onde column group. It looks like this:


T1 T2 T3 T4
type1 A 9 3 2 4
B 6
type2 A 1 2 3
B 2 4 1 7

But I need to sum only 2 columns of the report (columns T2 and T3):



T1 T2 T3 T4 T2+T3
type1 A 9 3 2 4 5
B 6 6
C
type2 A 1 2 3 2
B 2 4 1 7 5
C 8



And I do not know how to create this sum column, only the default sobtotal column of a matrix.
I tried to do this sum in my datasource, but with no success too.
I also tried to use a table, but the columns must be create automatically from database data and I couldn't do it.

Another issue is: how to make line C appear even with only null or zero numbers?

Any ideas?

I am new with reporting services, so please be clear and detailed.

Thanks a lot!

View 1 Replies


ADVERTISEMENT

Adding Custom Subtotal

Feb 4, 2008



I have a table with a Labor Category Group containing 5 categories (1,2, 3, 4 and 5). I need to add a subtotal for categories 1, 2 and 3. I know how to add the subtotal for all 5 but not for a subset of them. How do I do this?

Thanks
Dean

View 1 Replies View Related

Show Child Subtotal In Parent's Subtotal Row

Apr 1, 2008



My report has two groups, company and error type for each company.
Company1

Functional Error
Data Error
Other Error
My goal is to show the subtotals for each error types when I show Company's subtotal/total; in the group 1 footer area.
Total for Functional Error:
Total for Data Error:
Total for Company1:

Please help me in figuring out how to do that.

Thank you in advance for your help.

View 3 Replies View Related

Displaying Custom Properties For Custom Transformation In Custom UI

Mar 8, 2007

Hi,

I am creating a custom transformation component, and a custom user interface for that component.

In
my custom UI, I want to show the custom properties, and allow users to
edit these properties similar to how the advanced editor shows the
properties.

I know in my UI I need to create a "Property Grid".
In
the properties of this grid, I can select the object I want to display
data for, however, the only objects that appear are the objects that I
have already created within this UI, and not the actual component
object with the custom properties.

How do I go about getting the properties for my transformation component listed in this property grid?

I am writing in C#.

View 5 Replies View Related

Expression Editor On Custom Properties On Custom Data Flow Component

Aug 14, 2007

Hi,

I've created a Custom Data Flow Component and added some Custom Properties.

I want the user to set the contents using an expression. I did some research and come up with the folowing:





Code Snippet
IDTSCustomProperty90 SourceTableProperty = ComponentMetaData.CustomPropertyCollection.New();
SourceTableProperty.ExpressionType = DTSCustomPropertyExpressionType.CPET_NOTIFY;
SourceTableProperty.Name = "SourceTable";






But it doesn't work, if I enter @[System:ackageName] in the field. It comes out "@[System:ackageName]" instead of the actual package name.

I'm also unable to find how I can tell the designer to show the Expression editor. I would like to see the elipses (...) next to my field.

Any help would be greatly appreciated!

Thank you

View 6 Replies View Related

Expression Issue With Custom Data Flow Component And Custom Property

Apr 2, 2007

Hi,



I'm trying to enable Expression for a custom property in my custom data flow component.

Here is the code I wrote to declare the custom property:



public override void ProvideComponentProperties()

{


ComponentMetaData.RuntimeConnectionCollection.RemoveAll();

RemoveAllInputsOutputsAndCustomProperties();



IDTSCustomProperty90 prop = ComponentMetaData.CustomPropertyCollection.New();

prop.Name = "MyProperty";

prop.Description = "My property description";

prop.Value = string.Empty;

prop.ExpressionType = DTSCustomPropertyExpressionType.CPET_NOTIFY;



...

}



In design mode, I can assign an expression to my custom property, but it get evaluated in design mode and not in runtime

Here is my expression (a file name based on a date contained in a user variable):



"DB" + (DT_WSTR, 4)YEAR( @[User::varCurrentDate] ) + RIGHT( "0" + (DT_WSTR, 2)MONTH( @[User::varCurrentDate] ), 2 ) + "\" + (DT_WSTR, 4)YEAR( @[User::varCurrentDate] ) + RIGHT( "0" + (DT_WSTR, 2)MONTH( @[User::varCurrentDate] ), 2 ) + ".VER"



@[User::varCurrentDate] is a DateTime variable and is assign to 0 at design time

So the expression is evaluated as: "DB189912189912.VER".



My package contains 2 data flow.

At runtime,

The first one is responsible to set a valid date in @[User::varCurrentDate] variable. (the date is 2007-01-15)

The second one contains my custom data flow component with my custom property that was set to an expression at design time



When my component get executed, my custom property value is still "DB189912189912.VER" and I expected "DB200701200701.VER"



Any idea ?



View 5 Replies View Related

Adding Custom Property To Custom Component

Aug 17, 2005

What I want to accomplish is that at design time the designer can enter a value for some custom property on my custom task and that this value is accessed at executing time.

View 10 Replies View Related

Custom Task - Custom Property Expression

Aug 16, 2006

I am writing a custom task that has some custom properties. I would like to parameterize these properties i.e. read from a varaible, so I can change these variables from a config file during runtime.

I read the documentation and it says if we set the ExpressionType to CPET_NOTIFY, it should work, but it does not seem to work. Not sure if I am missing anything. Can someone please help me?

This is what I did in the custom task

customProperty.ExpressionType = DTSCustomPropertyExpressionType.CPET_NOTIFY;

In the Editor of my custom task, under custom properties section, I expected a button with 3 dots, to click & pop-up so we can specify the expression or at least so it evaluates the variables if we give @[User::VaraibleName]

Any help on this will be very much appreciated.

Thanks

View 3 Replies View Related

Please Help With Subtotal

Apr 25, 2008

How can something like this be done in reporting services? I'm having trouble to get the totals, because if I do Sum(Fields!Yes.Value) + Sum(Fields!No.Value) it will just give me the overall total (133).

Please help guys. I tried with the matrix but it always breaks or just doesn't want to give me the subtotals.








Description
Yes
No
Subtotal

Studies
50
22
72

Works
28
33
61

€¦
€¦
€¦
€¦

View 1 Replies View Related

SubTotal

Nov 7, 2007

I want to create a subtotal for my results in my table, for example:
=Fields!Animals.Value =Fields!Result.Value
Dogs 3
Cats 4

bird 6

SubTotal 13


If i use =Sum(Fields!Result.Value) i have a error #Error, i don't know how do ir, Someone can help me?

Thank you a lot!

View 12 Replies View Related

How To Hide Subtotal

May 28, 2008

Hello,

I have a matrix with subtotal.

I want to hide or show the subtotal by a parameter.

The header of the subtotal is not a problem since it have the "visibility" property.

The problem is that when I'm clicking on the green rectangle to go to the subtotal area itself - It doesn't have the "visibility" property.

So I don't see the header but I see the subtotal date itself.

Any idea on how to resolve this?



Thanks.

View 7 Replies View Related

Total Of Subtotal

Jun 9, 2006

I need to total filtered values each time the filter criteria changes.
So lets say I change the month to JAN then in addition to the subtotals for each category I need to get a Grand Total.
Thanks much.

SELECT Location, SUM(month_est) AS SubTot_Month_Est, SUM(actual) AS SubTot_Actual, mnth, yr
FROM dbo.meetings
GROUP BY Location, mnth, yr

View 3 Replies View Related

Subtotal In Query

Jul 20, 2005

Hi,WITH SQL SERVER QUETY, I have output likePRJ item qty=================P1 I1 10P1 I1 20P1 I2 10P2 I2 10P2 I3 10================I WANT TO MANIPULATE IT LIKE THISPRJ item qty=================P1 I1 30P1 I2 10---------------P1 * 40---------------P2 I2 10P2 I3 10---------------P2 * 20---------------===============PRJ * 60===============SHOW DATA AND SUBTOTAL AND GRAND TOTAL IN ONE RESULTSETCAN ANYBODY HELPTHANKS IN ADV.T.S.NEGI

View 2 Replies View Related

Subtotal Problem

Jul 17, 2007



hi,



i am using SQL server reporting services 2000. in that i am using a matrix and one column group and a one row group. i want to calculate total of row and column group and i insert a subtotal at for row and column group.



butits calculation wrong total just picking first row and first column in total.














Application
ABC
DEF
123
456
Total

stat
17
15
3
6
17

Config
15
0
12
0
15

CSP - IMS
11
10
0
0
11

Portalm
10
8
8
0
10

Total
17
15
3
6
17



can anyone help me in this regards.



Regards,

Faisal Saleem

View 5 Replies View Related

Condition In Subtotal?

Mar 13, 2007

Hi
I have the following matrix
CA AZ

No surplus 11 5

Surplus 12 10

Zotal 100 50
Totlal 123 65
I want that only (No surplus and Surplus) sum include in total Can I apply This condition on Subtotal.

thanks in advance

View 1 Replies View Related

Matrix Subtotal

Jul 23, 2007

Hi Everyone,



I am trying to get something like this using matrix in reporting services












SE
CP
CG
Total

Qty
Value
Qty
Value
Qty
Value
Qty
Value
GST
Net

7/07/2006
124
233
552
525
141
2544
563
4215
321
4536

8/07/2006
1245
211
11
142
555
1444
1987
1854
124
1978







The problem is, in the total group, the GST value and Net ( Net = Value + GST) can't added into the total group in the matrix.



Can somebody help... Thanks a lot.

View 2 Replies View Related

Subtotal On Every Page

Dec 7, 2007

Is there a way to make the subtotal column appear on every page when the matrix spans multiple pages?

View 1 Replies View Related

Subtotal Formatting

Nov 10, 2005

I'm still new to reporting services so forgive me for the newbie question...

View 9 Replies View Related

Subtotal And Subaverage

Jun 21, 2006

Hello,

I want to have a subtotal column AND a subaverage column (or n total columns) like the one in the following example - but without the extra Avg column in the Data area.

How to do that?










2000



Q. 2


April
Avg

May
Avg

June
Avg

Total


Avg


North

4800
4800

5708
5708

5580
5580

16088


5363


South

3238
3238

3637
3637

3527
3527

10402


3467


West

1699
1699

1687
1687

1614
1614

5000


1667





Thank you!

View 10 Replies View Related

Subtotal Question

Apr 21, 2008



i would like to return total value for each row and column.
can someone send a sample code?

like:


columnA columnB Total
4 5 9
5 1 6
3 2 5
12 8 20

View 3 Replies View Related

Matrix SubTotal

Oct 23, 2007



I have a problem about my subtotal.I cannot change the background color based on my conditions.But what makes me think is that the font of my subtotal changes, the same as when my cell data meets my condition,without changing the subtotal's property.

What could be the reason why my subtotal wont change?I have a condition in my background
=iif(Fields!IsHold.Value = True,"Red","White")

View 2 Replies View Related

Subtotal -not Only One Number

Jan 21, 2008

Hello,

I have created a report - matrix from column month, day, week, partnergroup, number.
With subtotals per each criteria.
Current report:

month week day partnergroup sum
1 1 2008-01-01 loans 10
1 1 2008-01-01 mortgages 20

total day 30
....
1 1 2008-01-02 loans 40
1 1 2008-01-02 mortgages 0
total day 40
...
... total week 200

I need subtotals for week with rows for each partnergroup. It should be like this:

month week day partnergroup sum
1 1 2008-01-01 loans 10
1 1 2008-01-01 mortgages 20

total day 30
....
1 1 2008-01-02 loans 40
1 1 2008-01-02 mortgages 0
total day 40
...
... total week loans 110
mortgages 90

Could anybody help me ?

View 8 Replies View Related

Subtotal Question

Jul 23, 2007

Hopefully this is a simple question. We have a report with several subreports that display certain totals by a group. What we want to do now it to show a running total on the main report. Is there a way to pass data from the subreport (the subtotal) to the main report for a Grand Total?



Thanks for any information.

View 3 Replies View Related

Matrix With 2 Subtotal

Sep 21, 2006

Hi All,

I wish to have a report with 2 subtotal using matrix control given by reporting service.








CD

DVD

Total Price

Total Qty


2.00

5.00





JOHN



5

25.00

5


JOLIN

5



10.00

5





Total Price

10.00

25.00






Total Qty

5

5





I only can came out total price(subtotal) which provided by matrix control.

Does the matrix control able to come out as table above with 2 subtotal?



Thanks

Kendy

View 7 Replies View Related

Subtotal On The Top (before The Data Row)

Apr 16, 2008

Hello everybody,

I would like to put a subtotal at the top of the report, before the data row. Is it possible, and how to do that ?
Thank you in advance for your precious help.

Regards,
Yen

View 4 Replies View Related

How To Display Subtotal For Just 1 Row Only

Jul 4, 2007

i hv finished a report and it looks like the follow:



Status Service A Net in service

Install Disconnect



Completed 100 10 90

Canceled 5 2 3

outstanding 20 5 15







However, actually I just want to display 'Net in service' for 'Completed' status only, like below:



Status Service A Net in service

Install Disconnect



Completed 100 10 90

Canceled 5 2 -

outstanding 20 5 -





Is there anyway to do so? Thank you so much for your help!

View 3 Replies View Related

Using IIF In A Table Subtotal

May 16, 2007

In a group footer in a table, I am trying to calculate a particular field. On the first report I have the following:



=Sum(IIf(Fields!annualAmt.Value = 0,0,Fields!amtYTD.Value/Fields!annualAmt.Value))



I do get a warning, about attempting to divide by zero, which is sometimes the case, but when I deploy this report, it looks fine, it is formatted as a percentage and the divide by zero cases show up as 0%, just as I want it.



However, in a similar, second report, I used the same code as above, and I get the same warning as above, but when I deploy I get the dreaded '#error' for every single case.



I cannot work out what is different between the two and why one would work and the other not work...



Is is something really simple that I have overlooked? Anyone got any ideas?



Thanks in advance!

View 6 Replies View Related

SubTotal In Matrix

Oct 23, 2007

I have a big problem, i need to put my subtotal in right: Tabela aninhada, célula 1Tabela aninhada, célula 2 Tabela unida, célula 3 Column value Column value Row valueDataSubTotal by Row






I want my Matrix showning my SubTotal how this:




Column value


Row value
Data
SubTotal Row


SubTotal Column



My Matriz is how this below: And I don't want it.





Column Value



SubTotal Column

Row Value
SubTotal
Data


Thank you a lot!

View 1 Replies View Related

Subtotal By Page

Jul 4, 2006



Dear guru!

How I can define subtotal by page in the table? Is it possible?

Thanks in advanced.

View 6 Replies View Related

How To SubTotal With Top N Grouping?

Nov 23, 2005

Hi all,

View 10 Replies View Related

Hardcode Subtotal

Jun 3, 2007

Hello,

Can I hardcode matrix subtotal?

For instance, I want to hardcode "100%" in the following Sales report:

2007 Year

Quantity

Phones 21%

Notebooks 30%

Total 100%



Please don't ask me why I need to do that, it's a complex MDX query and the report is much more complex than I depicted.

I just need to statically write 100% in subtotal.

View 4 Replies View Related

To Find Sum Product And Subtotal

Mar 12, 2014

Here I have attached excel sheet. I want to do row wise sum, product and then sub total.

View 4 Replies View Related

Navigation On Matrix Subtotal

Jan 30, 2007

Here's a sample matrix:

Men Women Total

Full Professor 36 12 48

Assoc. Professor 16 9 25

Assistant Professor 11 14 25

Total 63 35 98

Now, it's easy enough to make the values clickable so that somebody can drill down to a report that shows detail about the people. I have also discovered how to turn off clickability on the totals. However, what I really want is for the totals to be clickable so that, for example, if I click on the 63, I see a report that shows all men. Likewise, If I click on the 48, I want to see a report that shows all Full Professors. What currently happens when the totals are clickable is that if I click on the 63, I get all men who are full professors (36 records instead of 63). If I click on the 48, I get all Full Professors who are men. (36 records instead of 48).

Is there any way to send different parameters (or even no parameters) to the secondary report if the subtotals are clicked instead of the regular results?

Thanks in advance!

View 16 Replies View Related







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