Matrix Subtotal Format

Have several rows in a Matrix, every row has a different format (percentage,
Currently, Number). The Matrix has 3 groups (all groups not displayed below)
Average Shop1 Shop2 Shop3
Technicians 8.0 7 5 2
Efficiency 70.5% 60.0 75.2 70.1
Hours 1,000 500 2000 1000
I do an average for all columns display the average for that column on the
left side
In my development environment (Visual Studio) the average column formatting
works fine and takes the formatting of other columns in the row. After being
deployed to the reporting server and viewing through the report viewer the
formatting does not seem to work and seems to take the formatting of the
first group.
ThanksAfter hours of digging, the issue seems to be because of SP2.
http://forums.microsoft.com/MSDN/showpost.aspx?postid=2215374&siteid=1
"jeo78" wrote:
> Have several rows in a Matrix, every row has a different format (percentage,
> Currently, Number). The Matrix has 3 groups (all groups not displayed below)
> Average Shop1 Shop2 Shop3
> Technicians 8.0 7 5 2
> Efficiency 70.5% 60.0 75.2 70.1
> Hours 1,000 500 2000 1000
> I do an average for all columns display the average for that column on the
> left side
> In my development environment (Visual Studio) the average column formatting
> works fine and takes the formatting of other columns in the row. After being
> deployed to the reporting server and viewing through the report viewer the
> formatting does not seem to work and seems to take the formatting of the
> first group.
> Thankssql

Matrix Report Columns Grand Total

Hi There i have a Report That Display's data in following format

Areas

Code | Descirption | Emirates | GCC | ASIAN | OTHER ARABS | so on..
1 What ever 3 0 2 1
2 ABC 0 0 1 0
-
Total 3 0 3 1

The Areas are Matric Columns and are dynamically generated .

i dont want sub total of each row , but i want Grand total at the end of the all columns generated by matrix

I have no clue how do to it

Kind Regards

Just Right-click the column header and choose subtotal.

|||No this is what i dont want

this will add total below each row which i dont want i want the grand totals after the last row|||

OK, we seem to be talking cross purposes and your explanation is not clear enough.

If you want an additional column at the end the has the total value for all areas then right-click the column group and choose subtotal.

If you want an additional row at the very bottom that has the total for all the code/description row category, then right-click on the code group i.e. outermost group, and choose subtotal.

|||
let me explain again here is the report's result few row

R






African American Asian Emirates European GCC Not Stated Oceanian(Australia-Newzealand-Fiji Islands) Other Arab Countries TOTAL 1120 Services activities related to extraction of oil and gas, except surveying services ????? ??????? ??????? ???????? ????? ?????? ???????? ????? ????? 20610000 20610000 20610000 1320 Mining of non-ferrous metal ores, except uranium and thorium ores ????? ?????? (?????) ??????? ??? ???????? (???????) (???????? ?????? ?????????? ?????????) 150000 150000 150000 1410 Quarrying for extraction of stones, sands, and clay ??????? ??????? ???????? ??????? ??????? ?????? 0 0

Total Row 0 African Colum total 0 15000 ( asian) rest of totals

the regions name that you see are actually column of matrix report and i want total in last row for each column
i have added total as column but i also want grand total row at the end

means horizontal total of each row
and vertical total of each column

i hope i got it right this time

|||

Fine. Then doing what I said in my previous reply should work for you. Have you tried it?

Just to be totally explicit, right-click the textbox in your matrix that has the "code" and not the one that has the "description" and select the subtotal option.

|||worked thanks a lot

Matrix Help

I need some help, this is my first matrix report. My stored procedure
pulls data in the following format.
Internal_User user_id expense_user_id Amount
category Period month year
Doe, John 99 1234567 385.7900
Airfare May-2007 5 2007
ETC.
I have the matrix set up currently with Row Groups on Internal_user
and Category, and column group on Period. This looks good, what I need
though is a total by internal user for all the categories. Then I
need a category total in the last column. When I try to do a subtotal
on the Internal_User rowgroup it says total, but only spits out the
first category value.
Heres what it looks like
Jan-2007
Feb-2007 Mar-2007 Apr-2007 May-2007
Doe, John
AirFare
385.79
Entertainment 1587.22
556.2 537.39 1996.30
Taxi 100.00
100.00 200.00
Total 1587.22
556.2 537.39 1996.61 358.79
I want the total like for Jan-2007 for example to be 1687.22. I
appreciate any help.Disregard...found the answer.

Matrix Filters

This is a multi-part message in MIME format.
--=_NextPart_000_001F_01C6A504.61E9EAD0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
I have a parameter for displaying information from a particular = department, or from all departments. I can do the filter for a specific = department, but how do I set it up so that if the user selects all, I = basically ignore the deaprtment filter?
Thanks.
Jerry
--=_NextPart_000_001F_01C6A504.61E9EAD0
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
&
I have a parameter for displaying = information from a particular department, or from all departments. I can do the = filter for a specific department, but how do I set it up so that if the user = selects all, I basically ignore the deaprtment filter?

Thanks.

Jerry
--=_NextPart_000_001F_01C6A504.61E9EAD0--Hi
You should use UnionAll to get all the department when u click ALL.
"rlrcstr@.newsgroups.nospam" wrote:
> I have a parameter for displaying information from a particular department, or from all departments. I can do the filter for a specific department, but how do I set it up so that if the user selects all, I basically ignore the deaprtment filter?
> Thanks|||Hi Jerry.
Thank you for your posting and thanks Calvin's suggestion.
If you are using SQL Reporting Services 2005, I think you could use
Multi-Value Parameter to implement this requirement.
For more detailed information, please try to follow this article:
Using Parameters in a Report
http://msdn2.microsoft.com/en-us/library/ms155917.aspx
Single and Multivalued Parameters
You can define a multivalued parameter by selecting the Multivalued option
in the Report Parameters dialog box. If this checkbox is not selected, the
parameter is single-valued. Specifying the Multivalued option adds
checkboxes to the available values in a parameter drop-down list in the
published report. Users can check the values they want; for example, in the
Sales Reason Comparisons sample report, users can select multiple products
to view the combined sales data for those products.
Hope this will be helpful for you!
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.|||The issue isn't in having the user select the requirements, it's in how to
implement the selection in the matrix control's filters.
Thanks.
Jerry
"Wei Lu [MSFT]" <weilu@.online.microsoft.com> wrote in message
news:EgZJkRYpGHA.4612@.TK2MSFTNGXA01.phx.gbl...
> Hi Jerry.
> Thank you for your posting and thanks Calvin's suggestion.
> If you are using SQL Reporting Services 2005, I think you could use
> Multi-Value Parameter to implement this requirement.
> For more detailed information, please try to follow this article:
> Using Parameters in a Report
> http://msdn2.microsoft.com/en-us/library/ms155917.aspx
> Single and Multivalued Parameters
> You can define a multivalued parameter by selecting the Multivalued option
> in the Report Parameters dialog box. If this checkbox is not selected, the
> parameter is single-valued. Specifying the Multivalued option adds
> checkboxes to the available values in a parameter drop-down list in the
> published report. Users can check the values they want; for example, in
> the
> Sales Reason Comparisons sample report, users can select multiple products
> to view the combined sales data for those products.
> Hope this will be helpful for you!
> Sincerely,
> Wei Lu
> Microsoft Online Community Support
> ==================================================> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
> ==================================================> This posting is provided "AS IS" with no warranties, and confers no
> rights.
>|||Can you give me an example of how to implement this in the filters of a
matrix control on the report? Thanks.
Jerry
"calvin" <calvin@.discussions.microsoft.com> wrote in message
news:03B634AB-BA3A-4A7A-AFB4-A08ABE89439B@.microsoft.com...
> Hi
> You should use UnionAll to get all the department when u click ALL.
> "rlrcstr@.newsgroups.nospam" wrote:
>> I have a parameter for displaying information from a particular
>> department, or from all departments. I can do the filter for a specific
>> department, but how do I set it up so that if the user selects all, I
>> basically ignore the deaprtment filter?
>> Thanks|||Hi Jerry,
Thank you for the update.
I would like to know the filter you use in the matrix. Would you please
post it here? Thank you!
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.|||Hello Jerry,
Have you got any progress on this issue? As Wei has mentioned in the last
reply, if you need further help on this, you can post the detailed info
about the filter you used in the matrix so that we can take some further
look into it. As always, if there is anything else we can help, please feel
free to post here.
Sincerely,
Steven Cheng
Microsoft MSDN Online Support Lead
==================================================
This posting is provided "AS IS" with no warranties, and confers no rights.|||I haven't really made much progress here...
I have a data source that is a stored procedure. Let say, for instance,
that I get all records for all employees. In the report, I want to give the
viewer the option to see all employees, active employees, suspended
employees or decommissioned employees.
(The status of an employee is stored in the EmployeeStatus field. 1 =active, 2 = suspended, 4 = decommissioned)
I have no problem creating a filter that will show any of the selected
employee types. The issue is when the user wants to see all employees. How
do I set that up in the filter dialog? Thanks.
Jerry
"Steven Cheng[MSFT]" <stcheng@.online.microsoft.com> wrote in message
news:GOfFXVkqGHA.5392@.TK2MSFTNGXA01.phx.gbl...
> Hello Jerry,
> Have you got any progress on this issue? As Wei has mentioned in the last
> reply, if you need further help on this, you can post the detailed info
> about the filter you used in the matrix so that we can take some further
> look into it. As always, if there is anything else we can help, please
> feel
> free to post here.
> Sincerely,
> Steven Cheng
> Microsoft MSDN Online Support Lead
> ==================================================>
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
>|||Never mind... Figured it out. Thanks.
<rlrcstr@.newsgroups.nospam> wrote in message
news:u63vXVBsGHA.596@.TK2MSFTNGP04.phx.gbl...
>I haven't really made much progress here...
> I have a data source that is a stored procedure. Let say, for instance,
> that I get all records for all employees. In the report, I want to give
> the viewer the option to see all employees, active employees, suspended
> employees or decommissioned employees.
> (The status of an employee is stored in the EmployeeStatus field. 1 => active, 2 = suspended, 4 = decommissioned)
> I have no problem creating a filter that will show any of the selected
> employee types. The issue is when the user wants to see all employees.
> How do I set that up in the filter dialog? Thanks.
> Jerry
>
>
> "Steven Cheng[MSFT]" <stcheng@.online.microsoft.com> wrote in message
> news:GOfFXVkqGHA.5392@.TK2MSFTNGXA01.phx.gbl...
>> Hello Jerry,
>> Have you got any progress on this issue? As Wei has mentioned in the last
>> reply, if you need further help on this, you can post the detailed info
>> about the filter you used in the matrix so that we can take some further
>> look into it. As always, if there is anything else we can help, please
>> feel
>> free to post here.
>> Sincerely,
>> Steven Cheng
>> Microsoft MSDN Online Support Lead
>> ==================================================>>
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>

Matrix export to Excel format difficulty

I made a matrix report with drilldown.

My users like to export it to excel and work with it there.

The + signs don't lie up correctly when it is exported- you have to click the '+' one row up from what you really want to expand it.

Any tips on getting the right data lined up with the right '+' on export? Thanks

How are you exporting it to excel? When I use the standard export method in Report Server, it works fine.|||The user chooses 'excel' format and then clicks export.|||

Try changing your subtotal rows Position property to "Before" instead of "After". You can get to this property by clicking on the green triangle in the corner of the subtotal row, it's in the Layout category.

|||Make sure the toogle item property is set properly.

Matrix Counting and Totals

I have a report in matrix format. The weeks are across the top and the
calculated field is in the rows. I need to be able to count accounts that
have ordered for that week which I was able to do. I also need to count if
this is the first time the customer has ordered "ever" and if they are
re-ordering. A re-order is considered if they have ordered twice. Does
anyone have any suggestions on the best way to do this?Are you getting your data from SQL Server? If possible, I'd do the counting
in the query itself, not the report. It's a lot easier to do counts in SQL
than in a matrix.
If you do want to count in your report, you could use the InScope function,
and check if you are inscope for the account group.
A bit of pseudocode to show what I'm thinking
=IIF(InScope("AccountGroup"), runningvalue(fields!Order.Value), 0)
(Please verify syntax...)
Kaisa M. Lindahl Lervik
"Debbie Nelson" <Debbie Nelson@.discussions.microsoft.com> wrote in message
news:0CC9D925-B21D-4E0D-A59C-C1B9821F59FC@.microsoft.com...
>I have a report in matrix format. The weeks are across the top and the
> calculated field is in the rows. I need to be able to count accounts that
> have ordered for that week which I was able to do. I also need to count
> if
> this is the first time the customer has ordered "ever" and if they are
> re-ordering. A re-order is considered if they have ordered twice. Does
> anyone have any suggestions on the best way to do this?

Matrix - how to let column group stay in separate lines?

I would like to have this matrix format:
JAN-06 FEB-06 ... Total
Sales Dept 100 120 220
Team One 60 70 130
Emp A 30 35 65
Emp B 30 35 65
Team Two 40 50 90
Emp C 20 25 45
Emp D 20 25 45
The default layout is sales dept, team one, and employee are on the same
line, I would like them in separate line to save space.
Thanks in advance.Sorry, I mean row groups in separate lines
"qye2020" <qye2020@.yahoo.com> wrote in message
news:uUKfBjcTGHA.5468@.TK2MSFTNGP14.phx.gbl...
>I would like to have this matrix format:
> JAN-06 FEB-06 ... Total
> Sales Dept 100 120 220
> Team One 60 70 130
> Emp A 30 35 65
> Emp B 30 35 65
> Team Two 40 50 90
> Emp C 20 25 45
> Emp D 20 25 45
> The default layout is sales dept, team one, and employee are on the same
> line, I would like them in separate line to save space.
> Thanks in advance.
>|||I hope someone answers your question...I am trying to do something similar
also.
"qye2020" wrote:
> Sorry, I mean row groups in separate lines
> "qye2020" <qye2020@.yahoo.com> wrote in message
> news:uUKfBjcTGHA.5468@.TK2MSFTNGP14.phx.gbl...
> >I would like to have this matrix format:
> > JAN-06 FEB-06 ... Total
> > Sales Dept 100 120 220
> > Team One 60 70 130
> > Emp A 30 35 65
> > Emp B 30 35 65
> > Team Two 40 50 90
> > Emp C 20 25 45
> > Emp D 20 25 45
> >
> > The default layout is sales dept, team one, and employee are on the same
> > line, I would like them in separate line to save space.
> >
> > Thanks in advance.
> >
>
>

master4IDR ??

This is a multi-part message in MIME format.
--=_NextPart_000_0015_01C51FEB.C5E3BF60
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Does anyone know what the "4IDR" databases are? (Master/Model/MSDB)
MSSQL Log entry: Starting up database 'master4IDR'.
I do see the .mdf & .ldf, but I have no such db on this server.
What are these databases?
Thanx!
--=_NextPart_000_0015_01C51FEB.C5E3BF60
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
&
Does anyone know what = the "4IDR" databases are? (Master/Model/MSDB)

MSSQL Log entry: = Starting up database 'master4IDR'.

I do see the .mdf = & .ldf, but I have no such db on this server.

What are these databases?

Thanx!


--=_NextPart_000_0015_01C51FEB.C5E3BF60--I've never see any such animals. My guess is that some 3rd party tool (like backup sw or similar)
has created these.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
http://www.sqlug.se/
"JLS" <jlshoop@.hotmail.com> wrote in message news:eYXq6WBIFHA.2620@.tk2msftngp13.phx.gbl...
Does anyone know what the "4IDR" databases are? (Master/Model/MSDB)
MSSQL Log entry: Starting up database 'master4IDR'.
I do see the .mdf & .ldf, but I have no such db on this server.
What are these databases?
Thanx!|||I did a google search on 'masteri4dr' and got several, but inconclusive,
hits. Many referred to third party backup software.
Try running the query below to identify the databases associated with these
files.
SELECT *
FROM master..sysaltfiles
WHERE filename LIKE '%4IDR.mdf%'
--
Hope this helps.
Dan Guzman
SQL Server MVP
"JLS" <jlshoop@.hotmail.com> wrote in message
news:eYXq6WBIFHA.2620@.tk2msftngp13.phx.gbl...
Does anyone know what the "4IDR" databases are? (Master/Model/MSDB)
MSSQL Log entry: Starting up database 'master4IDR'.
I do see the .mdf & .ldf, but I have no such db on this server.
What are these databases?
Thanx!|||They are copies of databases made by Veritas, when it does an online backup of SQL. Most of the time it cleans up after itself, but when it does not, you will find these files laying around
From http://www.developmentnow.com/g/118_2005_3_0_0_482621/master4IDR-.ht
Posted via DevelopmentNow.com Group
http://www.developmentnow.com