ListBox

is it possible that a matrix inside a listbox1 and the listbox1 inside
another listbox2?
---
|list box2 |
| --
| | listbox1 |
| | --
| | |matrix |
| | | |
| | --
| | |
| --
| |
---
Thanksmayb i should say list instead of listbox...|||Try placing a subreport(s) inside a table. I have used this "layered"
concept before. HTH.
David
"SL" <SL@.discussions.microsoft.com> wrote in message
news:EAD22A3C-7A21-4A8D-BF05-43508BE1FBD9@.microsoft.com...
> is it possible that a matrix inside a listbox1 and the listbox1 inside
> another listbox2?
> ---
> |list box2 |
> | --
> | | listbox1 |
> | | --
> | | |matrix |
> | | | |
> | | --
> | | |
> | --
> | |
> ---
> Thanks|||i have found a way to solve my problem.. thanks anyway.

List Vs Matrix Vs Table performance.

Has anyone performed any analysis comparing the performance of a List vs. a
matrix and a table (inparticular rendering performance).
Other than obvious things like complexity, and groupings (single groups, row
groups and column groups), has anyone documented the reasons to use each
control.
Thanks
JasonA matrix is for pivot tables/cross tab queries. The list control, at least
in part, is used for form type reports with one record per page or for
free-form placement of controls, and a table is used for columns of data
with repeating rows, which is the most common type of report. Obviously
these are basic comparisions and not necessarily set in stone. For instance
you could use a list instead of a table and get the same results but since a
table already has established columns, rows, footers, and headers with I
don't know why you would.
"Jason" <jasonnotebook@.hotmail.com> wrote in message
news:%23KE2Jk7bEHA.3716@.TK2MSFTNGP11.phx.gbl...
> Has anyone performed any analysis comparing the performance of a List vs.
a
> matrix and a table (inparticular rendering performance).
> Other than obvious things like complexity, and groupings (single groups,
row
> groups and column groups), has anyone documented the reasons to use each
> control.
> Thanks
> Jason
>|||Thanks for the response, but what I am looking for is performance
information.
I understand the usages, just would like to know, given you can do of most
what can be done with one control, using the another, if performance over
development time was my priority, what would I pick.
Jason
"Stephen Witter" <switter@.enpathmed.com> wrote in message
news:%23eaT$8%23bEHA.808@.tk2msftngp13.phx.gbl...
> A matrix is for pivot tables/cross tab queries. The list control, at
least
> in part, is used for form type reports with one record per page or for
> free-form placement of controls, and a table is used for columns of data
> with repeating rows, which is the most common type of report. Obviously
> these are basic comparisions and not necessarily set in stone. For
instance
> you could use a list instead of a table and get the same results but since
a
> table already has established columns, rows, footers, and headers with I
> don't know why you would.
> "Jason" <jasonnotebook@.hotmail.com> wrote in message
> news:%23KE2Jk7bEHA.3716@.TK2MSFTNGP11.phx.gbl...
> > Has anyone performed any analysis comparing the performance of a List
vs.
> a
> > matrix and a table (inparticular rendering performance).
> >
> > Other than obvious things like complexity, and groupings (single groups,
> row
> > groups and column groups), has anyone documented the reasons to use each
> > control.
> >
> > Thanks
> >
> > Jason
> >
> >
>|||I was responding to the second part of your question but neglected to state
that. I personally have never done a comparision between the report types.
I also think that all three are for different uses, so comparing them side
by side seems kind of pointless. Having said that, maybe someone else has a
differnet opinion.
"Jason" <jasonnotebook@.hotmail.com> wrote in message
news:%23YEyXrDcEHA.3988@.tk2msftngp13.phx.gbl...
> Thanks for the response, but what I am looking for is performance
> information.
> I understand the usages, just would like to know, given you can do of most
> what can be done with one control, using the another, if performance over
> development time was my priority, what would I pick.
> Jason
>
> "Stephen Witter" <switter@.enpathmed.com> wrote in message
> news:%23eaT$8%23bEHA.808@.tk2msftngp13.phx.gbl...
> > A matrix is for pivot tables/cross tab queries. The list control, at
> least
> > in part, is used for form type reports with one record per page or for
> > free-form placement of controls, and a table is used for columns of data
> > with repeating rows, which is the most common type of report. Obviously
> > these are basic comparisions and not necessarily set in stone. For
> instance
> > you could use a list instead of a table and get the same results but
since
> a
> > table already has established columns, rows, footers, and headers with I
> > don't know why you would.
> >
> > "Jason" <jasonnotebook@.hotmail.com> wrote in message
> > news:%23KE2Jk7bEHA.3716@.TK2MSFTNGP11.phx.gbl...
> > > Has anyone performed any analysis comparing the performance of a List
> vs.
> > a
> > > matrix and a table (inparticular rendering performance).
> > >
> > > Other than obvious things like complexity, and groupings (single
groups,
> > row
> > > groups and column groups), has anyone documented the reasons to use
each
> > > control.
> > >
> > > Thanks
> > >
> > > Jason
> > >
> > >
> >
> >
>

List of color names?

I would like to put the names of the colors into the database to allow users
to configure how they want a matrix report to appear. I don't think they
are standard HTML names are they?
Can someone point me to where can I find this list of names, or any other
advice with this endevour?
cheers,
Paul.On May 10, 8:43 pm, Paul Ritchie <REMOVEpritc...@.xtraREMOVE.co.nz>
wrote:
> I would like to put the names of the colors into the database to allow users
> to configure how they want a matrix report to appear. I don't think they
> are standard HTML names are they?
> Can someone point me to where can I find this list of names, or any other
> advice with this endevour?
> cheers,
> Paul.
The colors are the same ones that are available when building a web
application. To view the available colors, add a textbox control to a
report in Layout view. Select the textbox control. Select 'F4' (or the
'View' drop-down tab -> Properties Window) and select the drop-down
list to the right of BackgroundColor.
Regards,
Enrique Martinez
Sr. Software Consultant

List Box Page Number

Hello,

I have a matrix inside a list box that groups by "question id" to display matrices with summaries for each question. I have checked the box "Insert page break after this list".

I want to be able to place the list box number next to the question, so that I will see something like:

1. Name

2. Category

3. Age

Is there a way to do this? Can I access the current number within the list? If I try the Globals!PageNumber variable, I get an error saying that the variable can only be used in a header or footer.

Thanks,

Michael

Hi,

Are you using any Grouping inside the list? If you are, I believe you can get the number within each list using the following expression:

=RunningValue((<Your List Grouping Field>),CountDistinct,"DataSet1") where "DataSet1" would be the name of your dataset.

If you do not have any grouping for the list, you could try using 'question id' in the expression instead.

Hope it helps.

-Aayush

|||

Aayush,

Thank You! That was exactly what I needed! Worked like a charm!

Michael

list and matrix grouping

hi i would to get some help from you guys. i am doing an item catalog,
basically the page will be full of pic and descriptions. i have done the
horizontal part like 3 pic and their descriptions in a row by using matrix
and list. my problem is, how can i display the header of each catagory just
once for each catagory. Currently my sr display each row has a header. i
would like to have each header display just once before go to second
catagory. Please advice.
Current Result:
---
Battery Battery Battery
<-- Header
---
pic description pic description pic description <-- pic
and description
---
Battery Battery Battery
<-- Header
---
pic description pic description pic description <-- pic
and description
---
Charger Charger Chareger <--
Header
---
pic description pic description pic description <-- pic
and description
Idea Result:
----
Battery
<-- Header
----
pic description pic description pic description <-- pic
and description
pic description pic description pic description <-- pic
and description
pic description pic description pic description <-- pic
and description
----
Charger
<-- Header
----
pic description pic description pic description <-- pic
and description
pic description pic description pic description <-- pic
and description
pic description pic description pic description <-- pic
and description
Thankssorry~ the current and idea result should be like this.
Current Result:
---
Battery Battery Battery <-- Header
---
pic+detail pic+detail pic+detail <-- pic and detail
---
Battery Charger Charger <-- Header
---
pic+detail pic+detail pic+detail <-- pic and detail
---
Headset Carrying Battery <-- Header
---
pic+detail pic+detail pic+detail <-- pic and detail
Idea Result:
---
Battery <-- Header
---
pic+detail pic+detail pic+detail <-- pic and detail
pic+detail pic+detail <-- pic and detail
---
Charger <-- Header
---
pic+detail pic+detail <-- pic and detail
---
Headset <-- Header
---
pic+detail <-- pic and detail
---
Carrying <-- Header
---
pic+detail <-- pic and detail|||actually not the header issue, i just want to group all the item together
under the same catagory and display 3 item in each row.
i tried add two expression into list1_Details_Group expression which do the
category grouping first before 3 row group into one group.
1. =Fields!category.Value
2. =Ceiling(RowNumber(nothing)/3)
however my result become like this.
--
|item 1 - category 1| <- row 1
--
|item 2 - category 1| <- row 1
--
|item 3 - category 1| <- row 1
--
|item 4 - category 1| <- row 2
--
|item 5 - category 2| <- row 3
--
|item 6 - category 2| <- row 3
--
|item 7 - category 2| <- row 4 <-- problem here
--
|item 8 - category 2| <- row 4
--
|item 9 - category 2| <- row 4
--
idea resule:
--
|item 1 - category 1| <- row 1
--
|item 2 - category 1| <- row 1
--
|item 3 - category 1| <- row 1
--
|item 4 - category 1| <- row 2
--
|item 5 - category 2| <- row 3
--
|item 6 - category 2| <- row 3
--
|item 7 - category 2| <- row 3
--
|item 8 - category 2| <- row 4
--
|item 9 - category 2| <- row 4
--

List & Dataset

Hi,
i have two matrix in two different lists with two different dataset. i would
like to know if it is posible to put one of the list into another list?
Please advice.
For example, i have a item table with the item no ,price and sub item, item
is unique, and i have another table which has the subitem no and item
features, each item might have multiple row of feature.
let say:
Table 1
--
item price subitem
A 2.50 AA
B 1.50 AA
C 1.00 BB
D 2.00 AA
E 1.00 CC
Table 2
--
subitem feature
AA a
AA b
AA c
BB t
C y
i would like to display
--
subitem: AA
feature : a
b
c
--
item: A 2.50
B 1.50
D 2.00
--
subitem: BB
feature : t
--
item: C 1.00
--
subitem: CC
feature : y
--
item: E 1.00
--
i tried to link the two table together as one, it will display duplicate
item, like below
item price subitem features
A 2.50 AA a
A 2.50 AA b
A 2.50 AA c
B 1.50 AA a
B 1.50 AA b
B 1.50 AA c
C 1.00 BB t
D 2.00 AA a
D 2.00 AA b
D 2.00 AA c
E 1.00 CC y
and the result will be
--
subitem: AA
feature : a
b
c
--
item: A 2.50
A 2.50
A 2.50
B 1.50
B 1.50
B 1.50
D 2.00
D 2.00
D 2.00
--
subitem: BB
feature : t
--
item: C 1.00
--
subitem: CC
feature : y
--
item: E 1.00
--
or any idea to make the item to be distinct?On May 10, 5:53 pm, SL <S...@.discussions.microsoft.com> wrote:
> Hi,
> i have two matrix in two different lists with two different dataset. i would
> like to know if it is posible to put one of the list into another list?
> Please advice.
> For example, i have a item table with the item no ,price and sub item, item
> is unique, and i have another table which has the subitem no and item
> features, each item might have multiple row of feature.
> let say:
> Table 1
> --
> item price subitem
> A 2.50 AA
> B 1.50 AA
> C 1.00 BB
> D 2.00 AA
> E 1.00 CC
> Table 2
> --
> subitem feature
> AA a
> AA b
> AA c
> BB t
> C y
> i would like to display
> --
> subitem: AA
> feature : a
> b
> c
> --
> item: A 2.50
> B 1.50
> D 2.00
> --
> subitem: BB
> feature : t
> --
> item: C 1.00
> --
> subitem: CC
> feature : y
> --
> item: E 1.00
> --
> i tried to link the two table together as one, it will display duplicate
> item, like below
> item price subitem features
> A 2.50 AA a
> A 2.50 AA b
> A 2.50 AA c
> B 1.50 AA a
> B 1.50 AA b
> B 1.50 AA c
> C 1.00 BB t
> D 2.00 AA a
> D 2.00 AA b
> D 2.00 AA c
> E 1.00 CC y
> and the result will be
> --
> subitem: AA
> feature : a
> b
> c
> --
> item: A 2.50
> A 2.50
> A 2.50
> B 1.50
> B 1.50
> B 1.50
> D 2.00
> D 2.00
> D 2.00
> --
> subitem: BB
> feature : t
> --
> item: C 1.00
> --
> subitem: CC
> feature : y
> --
> item: E 1.00
> --
> or any idea to make the item to be distinct?
I would suggest handling this in the stored procedure/query that is
sourcing the report. You will most likely want to look into your
grouping setup.
Regards,
Enrique Martinez
Sr. Software Consultant|||The result is come from store procedure. As i said in the previous post, i
can either seperate into two dataset or combine two into one dataset which
will cause duplication. The duplication cannot be avoid in store procedure
because i need all the data, just that when i display them, i need to be
distinct. My question is that if it is possible to insert a list with
dataset1 into another list which has diff dataset, dataset2?|||Yes, you want subreports. The second report has a single list on it.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"SL" <SL@.discussions.microsoft.com> wrote in message
news:7CC9ACC7-4073-4DCD-BE1A-3FB7A4A9E29A@.microsoft.com...
> The result is come from store procedure. As i said in the previous post, i
> can either seperate into two dataset or combine two into one dataset which
> will cause duplication. The duplication cannot be avoid in store procedure
> because i need all the data, just that when i display them, i need to be
> distinct. My question is that if it is possible to insert a list with
> dataset1 into another list which has diff dataset, dataset2?
>