Can a single report (same layout) have multiple MATRIXES with all referring
to either SAME or SEPARATE tables with different conditions mentioned for
each matrix?
ThanksYes, you can do that. You can drop the matrixes with different datasets
directly on the report body. Matrixes inside a list need to either have the
same dataset as the list; or (if they need to have a different dataset) put
them inside a subreport on the list.
--
Cheers,
'(' Jeff A. Stucker
\
Business Intelligence
www.criadvantage.com
---
"Asim" <Asim@.discussions.microsoft.com> wrote in message
news:70420480-8D78-426F-824B-BCA6F533F01B@.microsoft.com...
> Can a single report (same layout) have multiple MATRIXES with all
> referring
> to either SAME or SEPARATE tables with different conditions mentioned for
> each matrix?
> Thanks
>
Showing posts with label layout. Show all posts
Showing posts with label layout. Show all posts
Monday, March 19, 2012
Wednesday, March 7, 2012
Multiple Column Reports Problem
Have a report containing a single matrix. Have narrowed the matrix to
2.5 inches wide and specified 2 columns in the report layout.
I am aware that previewing the report will only display data in the
first column and that's what it does. However, when I Print Preview or
Export to PDF, I still only see data in the first column.
What am I missing? Thanks.
JeffCorrection: the report contains a table, not a matrix. Any advice
would be greatly appreciated.|||"JeffW" <jwilson@.telnetww.com> wrote in message
news:1112223102.818689.231190@.o13g2000cwo.googlegroups.com...
> Have a report containing a single matrix. Have narrowed the matrix to
> 2.5 inches wide and specified 2 columns in the report layout.
> I am aware that previewing the report will only display data in the
> first column and that's what it does. However, when I Print Preview or
> Export to PDF, I still only see data in the first column.
> What am I missing? Thanks.
> Jeff
Have you added content to the second column? Or is it conditional or
something?
Wrong font color?
Sounds weird.
Kaisa M. Lindahl|||Not sure I follow. It's not a problem displaying a column inside the
table. I want the report itself to display as two columns on the page.|||"JeffW" <jwilson@.telnetww.com> wrote in message
news:1112392187.972596.312270@.z14g2000cwz.googlegroups.com...
> Not sure I follow. It's not a problem displaying a column inside the
> table. I want the report itself to display as two columns on the page.
Not sure if I'm following you either.
Have you deployed your report to Report Manager? Does it show one or two
columns there?
If you know it won't display more than one column during preview, I don't
think it will display any more than what is there if you export the preview
to PDF. The pdf just renders what's in the webpage to the pdf format.
Kaisa|||Largely solved my problem. Must set the following to display 2 columns
on 1 page:
1. Report parameter columns=2 (obviously)
2. Report Body parameter width=3in or so (less obvious). Must set the
body width to correspond to the column. Otherwise, the body fills the
page and only contains one column.
Note that the report preview still displays only one column. Also the
Report Manager still only displays the report with one column.
Exporting to "HTML with Office Web Components" still only displays one
column. However, exporting to PDF or TIFF generates the report I'm
looking for -- 2 columns on a single page.
For what I need, this will do the trick. However, not seeing 2 columns
in the Report Manager is a bit inconvenient, not being WYSIWYG and all.
Any suggestions here?
Thanks.
2.5 inches wide and specified 2 columns in the report layout.
I am aware that previewing the report will only display data in the
first column and that's what it does. However, when I Print Preview or
Export to PDF, I still only see data in the first column.
What am I missing? Thanks.
JeffCorrection: the report contains a table, not a matrix. Any advice
would be greatly appreciated.|||"JeffW" <jwilson@.telnetww.com> wrote in message
news:1112223102.818689.231190@.o13g2000cwo.googlegroups.com...
> Have a report containing a single matrix. Have narrowed the matrix to
> 2.5 inches wide and specified 2 columns in the report layout.
> I am aware that previewing the report will only display data in the
> first column and that's what it does. However, when I Print Preview or
> Export to PDF, I still only see data in the first column.
> What am I missing? Thanks.
> Jeff
Have you added content to the second column? Or is it conditional or
something?
Wrong font color?
Sounds weird.
Kaisa M. Lindahl|||Not sure I follow. It's not a problem displaying a column inside the
table. I want the report itself to display as two columns on the page.|||"JeffW" <jwilson@.telnetww.com> wrote in message
news:1112392187.972596.312270@.z14g2000cwz.googlegroups.com...
> Not sure I follow. It's not a problem displaying a column inside the
> table. I want the report itself to display as two columns on the page.
Not sure if I'm following you either.
Have you deployed your report to Report Manager? Does it show one or two
columns there?
If you know it won't display more than one column during preview, I don't
think it will display any more than what is there if you export the preview
to PDF. The pdf just renders what's in the webpage to the pdf format.
Kaisa|||Largely solved my problem. Must set the following to display 2 columns
on 1 page:
1. Report parameter columns=2 (obviously)
2. Report Body parameter width=3in or so (less obvious). Must set the
body width to correspond to the column. Otherwise, the body fills the
page and only contains one column.
Note that the report preview still displays only one column. Also the
Report Manager still only displays the report with one column.
Exporting to "HTML with Office Web Components" still only displays one
column. However, exporting to PDF or TIFF generates the report I'm
looking for -- 2 columns on a single page.
For what I need, this will do the trick. However, not seeing 2 columns
in the Report Manager is a bit inconvenient, not being WYSIWYG and all.
Any suggestions here?
Thanks.
Subscribe to:
Posts (Atom)