Report with multiple columns won't print in portrait

I have a report that has 6 columns and won't print in potrait mode. I have
set the page width to 8.5in and the page height to 5in. If I set the page
height to 11in it prints OK (but I need to limit the height to 5in.
Also, can I use this report as the report source for a subreport control?
Thanks,On Sep 11, 1:59 pm, "Tim Kelley" <tkel...@.company.com> wrote:
> I have a report that has 6 columns and won't print in potrait mode. I have
> set the page width to 8.5in and the page height to 5in. If I set the page
> height to 11in it prints OK (but I need to limit the height to 5in.
> Also, can I use this report as the report source for a subreport control?
> Thanks,
You might try modifying the Report Properties Layout, if you haven't
already: via: Layout view -> Report drop-down -> Report Properties... -
> Layout tab -> Page height:, Top margin:, Bottom margin:. If you are
using columns, reduce the Spacing: property. For the subreport
control, you can use the report; however, it it has report columns,
once it is exported it will remove the columns automatically. This is
evidently a flaw in the export functionality. Hope this helps.
Regards,
Enrique Martinez
Sr. Software Consultant

Report with measures in row

Hi,
I would like to create a report on a cube with Report Server (Query Builder) with one dimension in columns and the "measures" dimension members in rows:

Jan Feb Mar ...
Measure1 10 12 14
Measure2 20 22 24
..

How to create with either Tabular or Matrix report type?

Thanks,
Marcus

You can either:

1. Use the RS 2005 SSAS provider but change the report format to request measures on columns.

2. Bypass the RS 2005 SSAS provider and use the MS OLE DB 9.0 Provider for Analysis Services to request the measures on rows and Time on columns. However, in this case you can't use the matrix region and your table columns will be fixed. So, you have to create 12 columns (assuming 12 months on columns) and hide the ones that are not returned.

|||Thank you very much Teo,
I had to chose alternative 2 and created a report with measures in rows and tabular structure. Now I got stuck in some details. I need cascading parameters following the whitepaper " Integrating Analysis Services with Reporting Services" for SQL 2000. But I'm working with SQL2005. I easily establish a parameter for the highest parameter level (here ProductCategory in Adventure Works)

="WITH MEMBER [Product].[Category].[Prod] AS
'[Product].[Category].[" + Parameters!ProductCategory.Value + "]'

SELECT

{ [Measures].[Internet Sales-Discount Amount],[Measures].[Internet Sales-Extended Amount] } ON ROWS ,

{[Date].[Calendar Time].[Month].[January 2003]} ON COLUMNS

FROM [Adventure Works UDM]
WHERE [Product].[Category].[Prod] "

but a link to this existing parameter in a cascading parameter yields an empty list and the report is not executable ([Product Categories] is a natural hierachy):

= "WITH MEMBER Measures.NullColumn AS 'Null'

SELECT
{Measures.NullColumn} ON COLUMNS,
{DESCENDANTS({" + Parameters!ProductCategory.Value + " },
[Product].[Product Categories].[Subcategory])} ON ROWS
FROM
[Adventure Works UDM]"

Are cascading parameters with OLE DB 9.0 and SQL 2005 possible, can you provide an example?

Thanks a lot,
Marcus

sql

Report with measures in row

Hi,
I would like to create a report on a cube with Report Server (Query Builder) with one dimension in columns and the "measures" dimension members in rows:

Jan Feb Mar ...
Measure1 10 12 14
Measure2 20 22 24
..

How to create with either Tabular or Matrix report type?

Thanks,
Marcus

You can either:

1. Use the RS 2005 SSAS provider but change the report format to request measures on columns.

2. Bypass the RS 2005 SSAS provider and use the MS OLE DB 9.0 Provider for Analysis Services to request the measures on rows and Time on columns. However, in this case you can't use the matrix region and your table columns will be fixed. So, you have to create 12 columns (assuming 12 months on columns) and hide the ones that are not returned.

|||Thank you very much Teo,
I had to chose alternative 2 and created a report with measures in rows and tabular structure. Now I got stuck in some details. I need cascading parameters following the whitepaper " Integrating Analysis Services with Reporting Services" for SQL 2000. But I'm working with SQL2005. I easily establish a parameter for the highest parameter level (here ProductCategory in Adventure Works)

="WITH MEMBER [Product].[Category].[Prod] AS
'[Product].[Category].[" + Parameters!ProductCategory.Value + "]'

SELECT

{ [Measures].[Internet Sales-Discount Amount],[Measures].[Internet Sales-Extended Amount] } ON ROWS ,

{[Date].[Calendar Time].[Month].[January 2003]} ON COLUMNS

FROM [Adventure Works UDM]
WHERE [Product].[Category].[Prod] "

but a link to this existing parameter in a cascading parameter yields an empty list and the report is not executable ([Product Categories] is a natural hierachy):

= "WITH MEMBER Measures.NullColumn AS 'Null'

SELECT
{Measures.NullColumn} ON COLUMNS,
{DESCENDANTS({" + Parameters!ProductCategory.Value + " },
[Product].[Product Categories].[Subcategory])} ON ROWS
FROM
[Adventure Works UDM]"

Are cascading parameters with OLE DB 9.0 and SQL 2005 possible, can you provide an example?

Thanks a lot,
Marcus

Report to have n.. columns

Hi,

I have a table with following structure:

There can be different weeks for different activities. Depending on weeeks on weeks having data should be displayed. i.e. when activity was running.

Activitynumber Line Product Week1 Week2 Week3 .....Week52

100 Volume Product1 23 32

100 Volume Product2 11 46

102 Volume Product3 45 56 67 76

100 Revenue Product1 766 232

100 Revenue Product2 763 146

102 Revenue Product3 890 356 467 576

I want a report which should look like this

For Line=Volume Report:

-

Weeknumber Product1 Product2

Week1 23 11

Week2 32 46

For Line=Revenue Report:

-

Weeknumber Product1 Product2

Week1 766 763

Week2 232 146

Can anyone help me to suggest what should be the wayout?

A matrix will represent that for you. With a matrix, you can set row level grouping and column grouping. For both of your reports i would have the weeks as the row level grouping, and Product as the column grouping, and then either volume or revenue as the detail. The column group means that you will have a dynamic number of columns, one for each product in your dataset.

|||

Hi Sluggy,

Thanks for your answer. The problem here is that the table has got 52 columns for 52 weeks starting from week1, week2...week52.

some activities may be for 3 weeks some for 10 or some for 50. Will this display only the weeks whihc has the data?

regards

Josh

|||

In your report data, just make sure pull back either a week number or a week commencing, then you can row group on that. This means that you will have 52 rows in your matrix. Then if a product doesn't have any volume or revenue for that week you can show a zero (or empty cell) in the detail section. You could even go to the extent of hiding (set the hidden property to true) rows or columns that are only zeros or empty.

Hope that helps.

sluggy

|||

How can I hide rows which dont have any data? I mean which options do I have to select?

thanks

Josh

Report Title Help

How can I make my report title width the same as the table? The table can hide some columns based on the If/Else logic, but Report Title textbox is always static. What happens is that my table can be longer or shorter then my title.

Thanks

Yadgor2000

You can add an outermost table with two header rows to your report. Put the report title textbox in the first row, and the table you currently have into the second row. That way, the title textbox will grow or shrink based on the width of the inner table.