Matrix Width

Is there a way to ensure a matrix layout does not expand horizontally
past a certain point (i.e. page)? There appears to be an option to try
and fit the matrix on one page but that doesn't stop it going over
multiple pages in the horizontal direction.
ThanksOn Apr 16, 5:57 pm, "gommo" <colin.gou...@.gmail.com> wrote:
> Is there a way to ensure a matrix layout does not expand horizontally
> past a certain point (i.e. page)? There appears to be an option to try
> and fit the matrix on one page but that doesn't stop it going over
> multiple pages in the horizontal direction.
> Thanks
Outside of the option you mentioned, as far as I know, there is
nothing else available. Sorry I could not be of further assistance.
Regards,
Enrique Martinez
Sr. Software Consultant|||On Apr 16, 5:57 pm, "gommo" <colin.gou...@.gmail.com> wrote:
> Is there a way to ensure a matrix layout does not expand horizontally
> past a certain point (i.e. page)? There appears to be an option to try
> and fit the matrix on one page but that doesn't stop it going over
> multiple pages in the horizontal direction.
> Thanks
It will cut off additional data, but you could filter the outermost
column group on {group expression} by "Top N" ={max columns}, i.e for
at most 5 columns grouped on myID you would have a group filter for
myID by 'Top N' with value of '=5'.
Hope this helps ~ K

Matrix Report: Need some suggestions please

I have to create a report that will list the room bookings for a certain
hotel in a certain time frame.
Sound easy enough right...
This is what the report should look like, first lets accept that I pass in
parameters for the following:
1. Start Date
2. End Date
3. The hotel I want the the bookings for
Then the report should look like the following:
Static Column
Twin Room 1
Twin Room 2
Single 1
1 Jan 2004
Party Name
Guest Names
Agency
Jones x2
R. Jones
T. Jones
AAA Travel
2 Jan 2004
Party Name
Guest Names
Agency
Twin Room 1
Twin Room 2
Twin Room 3
Single 1
3 Jan 2004
Party Name
Guest Names
Agency
Gates x1
B. Gates
MS
As you can see from above the amount of rooms changes on certain dates
depending on seasons etc. so the columns should be able to change
dynamicaly.
The rooms don't have a unique number - The hotel has listing of room types,
and how many rooms there are ie.
Hotel1,Twin,2
Hotel1,Single,1
Do i need to use some form of cubed data?
Have tables/matrix within tables/matrix?
Use lists, with tables in them?
How would I want my data returned to achieve the desired result?
Some suggestions, ideas would be appreciated.
Thanks in advance.Ok so Outlook Express don't like tables that much here is the table layout
Static Column Twin Room 1 Twin
Room 2 Single 1
1 Jan 2004 Party Name Jones x2
Guest Names R. Jones
T. Jones
Agency AAA Travel
2 Jan 2004 <empty row>
Twin Room 1
Twin Room 2 Twin Room 3 Single 1
3 Jan 2004 MS Party x2
Oracle x1
B. Gates
L. Jones
S. Balmer
MS Travel
Oracle Travel
Hope this is clearer now.
"Reg" <reg@.dsl.za.org> wrote in message
news:uaYE%23ugpEHA.2340@.TK2MSFTNGP11.phx.gbl...
> I have to create a report that will list the room bookings for a certain
> hotel in a certain time frame.
> Sound easy enough right...
> This is what the report should look like, first lets accept that I pass in
> parameters for the following:
> 1. Start Date
> 2. End Date
> 3. The hotel I want the the bookings for
> Then the report should look like the following:
>
> Static Column
> Twin Room 1
> Twin Room 2
> Single 1
> 1 Jan 2004
> Party Name
> Guest Names
>
> Agency
>
>
> Jones x2
> R. Jones
> T. Jones
> AAA Travel
>
>
>
>
>
>
>
>
>
>
>
>
>
>
> 2 Jan 2004
> Party Name
> Guest Names
>
> Agency
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
> Twin Room 1
> Twin Room 2
> Twin Room 3
> Single 1
> 3 Jan 2004
> Party Name
> Guest Names
>
> Agency
>
>
> Gates x1
> B. Gates
>
> MS
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
> As you can see from above the amount of rooms changes on certain dates
> depending on seasons etc. so the columns should be able to change
> dynamicaly.
> The rooms don't have a unique number - The hotel has listing of room
types,
> and how many rooms there are ie.
> Hotel1,Twin,2
> Hotel1,Single,1
> Do i need to use some form of cubed data?
> Have tables/matrix within tables/matrix?
> Use lists, with tables in them?
> How would I want my data returned to achieve the desired result?
> Some suggestions, ideas would be appreciated.
> Thanks in advance.
>

Matrix

I've produce a report using a matrix.

Within that matrix I want to navigate to a subreport, however this only applies to certain columns in the matrix and within only when a cell contains a certain value.

Can anybody tell me how to reference individual matrix columns and whether the above is possible?

It sounds like you want a "drillthrough" to another report rather than a subreport.

You can use an expression to dynamically determine the drillthrough target report name, e.g. based on a value in the matrix cell or based on a certain grouping scope. For instance, add a drillthrough navigation action on a matrix cell with an expression-based drillthrough report name: =iif(InScope("Matrix_ColumnGroupName"), "DrillthroughReportName", Nothing)

If the expression for the report name evaluates to Nothing, no drillthrough link will be shown.

-- Robert