Adding Matrix affect the report print preview

I'm sure body+margins=page width, there is no way the report is splited to
multiple page when print preview. The report is a multi-page report. The
matrix is added in the 4th page. Before adding the matrix, everything is
fine. After added the matrix, the first page is splitted to 2 pages or even 3
pages when print previewing depending on the columns the matrix has. And the
matrix itself is within the same page(page width is good enough for it).
Any suggestions? I have run out of ideas. Thanks.Anyone can help?
"Jane" wrote:
> I'm sure body+margins=page width, there is no way the report is splited to
> multiple page when print preview. The report is a multi-page report. The
> matrix is added in the 4th page. Before adding the matrix, everything is
> fine. After added the matrix, the first page is splitted to 2 pages or even 3
> pages when print previewing depending on the columns the matrix has. And the
> matrix itself is within the same page(page width is good enough for it).
> Any suggestions? I have run out of ideas. Thanks.

Adding extra rows to Matrix

Hello, I am creating a report with a matrix in it, and I need to add a couple
extra lines at the end, so the user can print and add in info as needed. Is
there any way to do this? thanks
ChrisOn Jan 18, 9:55 am, Chris <Ch...@.discussions.microsoft.com> wrote:
> Hello, I am creating a report with a matrix in it, and I need to add a couple
> extra lines at the end, so the user can print and add in info as needed. Is
> there any way to do this? thanks
> Chris
The easiest way to do this is to either add a couple textbox controls
below the matrix control -or- add a table control below the matrix
control. Make sure to not overlap the controls and place the matrix
control and textbox controls/etc inside a rectangle. Hope this helps.
Regards,
Enrique Martinez
Sr. Software Consultant|||Thanks Enrique, the problem with that is the matrix is Dynamic, so I don't
know how many columns it is going to be until runtime. If I add textboxes or
a table underneath, the columns will not match up. Any other ideas? Is there
a way to tie the table columns to the columns in the matrix'
"EMartinez" wrote:
> On Jan 18, 9:55 am, Chris <Ch...@.discussions.microsoft.com> wrote:
> > Hello, I am creating a report with a matrix in it, and I need to add a couple
> > extra lines at the end, so the user can print and add in info as needed. Is
> > there any way to do this? thanks
> >
> > Chris
> The easiest way to do this is to either add a couple textbox controls
> below the matrix control -or- add a table control below the matrix
> control. Make sure to not overlap the controls and place the matrix
> control and textbox controls/etc inside a rectangle. Hope this helps.
> Regards,
> Enrique Martinez
> Sr. Software Consultant
>|||On Jan 21, 8:10 am, Chris <Ch...@.discussions.microsoft.com> wrote:
> Thanks Enrique, the problem with that is the matrix is Dynamic, so I don't
> know how many columns it is going to be until runtime. If I add textboxes or
> a table underneath, the columns will not match up. Any other ideas? Is there
> a way to tie the table columns to the columns in the matrix'
> "EMartinez" wrote:
> > On Jan 18, 9:55 am, Chris <Ch...@.discussions.microsoft.com> wrote:
> > > Hello, I am creating a report with a matrix in it, and I need to add a couple
> > > extra lines at the end, so the user can print and add in info as needed. Is
> > > there any way to do this? thanks
> > > Chris
> > The easiest way to do this is to either add a couple textbox controls
> > below the matrix control -or- add a table control below the matrix
> > control. Make sure to not overlap the controls and place the matrix
> > control and textbox controls/etc inside a rectangle. Hope this helps.
> > Regards,
> > Enrique Martinez
> > Sr. Software Consultant
You're welcome. Not unless you use a second matrix control below the
first one that is tied to the same dataset and hide the data. Hope
this helps further.
Regards,
Enrique Martinez
Sr. Software Consultant

Adding Carriage Return and Line Feeds to a text box

Hi All,

I am trying to print 10 values in a single cell in a text box.....

To make it readable I put carriage returns and line feeds into the boxes.

These rendered ok in visual studio but did not render ok in explorer....no carriage return or line feed.

This is what I added...

=Fields!segment_sdesc_00.Value & chr(10) & chr(13)

Can anyone advise me as to what is wrong with this? There must be a way to put a cr/lf or newline into a report in a text box.....

Thanks in Advance

Peter

www.peternolan.com

Try using the + sign over the ampersand.

Code Snippet

=Fields!segment_sdesc_00.Value + chr(10) + chr(13)

This has worked for me in Explorer so far.

|||

If you are working with SRS and need to combine two CRM fields together, but having each on its own line, use the following expression:

=Fields!ShipToName.Value & vbCRLF & Fields!ShipToAddress.Value

vbCRLF is a special system constant that contains the values of carriage return and line feed characters.

- Mitch Milam’s Microsoft Discussions

|||

Hi All,

thanks for the tips...will try both....

Peter

|||

Hi Simone,

some of the fields are numbers and from memory it complained about the plus sign when there was a mixture of numeric and string fields...but I will try again.

Thanks

Peter