how to alternate the colours on a column with parent-child dimension

Hi

I have a matrix and one of the column has a parent-child dimension, how can I code to have alternate colours for the column?

Thanks a lot for your help

G

Since this is a matrix, you would need to follow an approach similar to http://blogs.msdn.com/chrishays/archive/2004/08/30/GreenBarMatrix.aspx

-- Robert

|||thanks a lot for your answer!sql

how to add column header in a Matrix

Hi,

is there a way to add column header in a Matrix?

Thanks,

Igor

Igor,

Right Click in your Matrix data row, you can select "add column".

Ham

|||

what I meant was I want find out the way to add a column header to a group in the matrix.
Is it possible?

Thanks,
Igor

|||

Igor,

You can still use the same as a "Header", I create my column, drag the textbox to where I want it display and in my expression I just type the heading that I want.

I hope this helps.

Carl

|||it's a good solution, the only problem is that it doesn't look good when rendered to html. In excel it displayed at the bottom.|||

Igor,

Thanks for the update. I'll take another shot at it and see if I can spuce it up a little.

Ham

How to Add an event to CRI controls

Hi all,

I am trying to develop a CustomReportItem similar to Matrix control. Is it possible to add some "OnClick" sort of events to a section of this CRI (As a drilldown button of matrix control allows to expand the respective column).

Please help me if there can be any solution.

I think it not possible to do that.

Report is web page , is not the application window.

sort the date, you can add a sort report parameters,

different parameters, show different matrix.

|||

Are you asking about design time or runtime?

While the CRI runtime control can generate drillthrough actions based on an image map, currently you cannot fully simulate the matrix group toggle behavior. You would rather need to work around it with report drillthrough actions and encoding the toggle state in parameter values.

-- Robert

|||

Hi Robert,

Thanks for ur response

I am asking it for runtime. How can I encode the toggle state in parameter values and how will it help to solve my problem? Please explain, as I am new to this tool.

|||

For every toggle icon, you could use a boolean report parameter to encode its state (e.g. expanded = true, collapsed = false). Another option is to encode the state of multiple toggles into an integer parameter (by using it as a bitfield) or maybe as string parameter.

For the CRI runtime control you would need to pass the parameter values as custom property values so that you can see the current toggle state (i.e. report parameter values) from within your CRI runtime code. Then you would need to draw the toggle icons as part of the image generated by the CRI runtime control. In addition you need to generate an image map over the toggle icon with a drillthrough action that drills to the same report with a report parameter value that has the opposite value of the currently drawn toggle state.

For example, if there is only one toggle and the toggle icon drawn is shown as expanded (with a report parameter representation as =True), you would add an image map area with a drillthrough action that passes the report parameter with the boolean value =False.

-- Robert

How to Add a rowcount in matrix?

hi, there.
I want to add a rowcount in matrix like as..
Accessory 1. Helmet
Bike 1. Mountain Bike
2. Road Bike
Clothing 1. Bib-Short
2. Cap
3. Gloves
4. Jersey
I'm trying a RowNumber() Function..But It Not work Correctly...-.-
Please let me know that..
have a nice day.This looks like you have 2 dynamic row groupings in the matrix. You actually
want a group count and not a row count.
Lets assume the outer grouping has the name "Category" and the inner group
has the name "Product". You would then use the following function in the
group header to get the "group" count:
=RunningValue(1, Sum, "Category") & ". " & Fields!ProductName.Value
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"KwonHyuckSoo" <hskwon@.rey.co.kr> wrote in message
news:exu0TFYkEHA.1028@.TK2MSFTNGP12.phx.gbl...
> hi, there.
> I want to add a rowcount in matrix like as..
>
> Accessory 1. Helmet
> Bike 1. Mountain Bike
> 2. Road Bike
> Clothing 1. Bib-Short
> 2. Cap
> 3. Gloves
> 4. Jersey
>
> I'm trying a RowNumber() Function..But It Not work Correctly...-.-
> Please let me know that..
> have a nice day.
>

How to add a line chart while building report

This is my first time with Reporting Services. I was using the wizard and it
only had the options of Matrix or tabular.
I want to add a line chart instead. How can I do so ?
ThanksInstead of using the report wizard, create a blank report. Then add a chart
from the toolbox.
Alain Quesnel
alainsansspam@.logiquel.com
www.logiquel.com
"Hassan" <hassan@.test.com> wrote in message
news:OAbD2FjYIHA.6140@.TK2MSFTNGP02.phx.gbl...
> This is my first time with Reporting Services. I was using the wizard and
> it only had the options of Matrix or tabular.
> I want to add a line chart instead. How can I do so ?
> Thanks

How to add a calcualted field in Matrix?

Hello.. I would like to know how this can be done in RS (SQL2000)...

In the dataset I have... sales, company, and year. What I want to display is such...

2005 2006 Growth

companyA $1,000,000 $500,000 100%

companyB $50,000 $100,000 -50%

How do I add a column in a Matrix to calculate the growth based on the sales? Thanks!

-Joseph

you would have to add growth to your dataset as a calculation in of the years. So for MDX you would add a calculated member to the time dimension and calculate growth in that.