A line in a report

I would like to put a line across my report, for appearance.
How can I make the width of the line to be set to the same as the width of a
matrix or table below it when the report is rendered?
I tried LineWidth "=ReportItems!Matrix1.width", but I got
"Report item expressions can only refer to other report items within the
same grouping scope or a containing grouping scope."
Thanks
BillIn the toolbox collection select line object. Place the line on the report,
then click on the line to 'activate' it. Grab one of the handles at the end
of the line an drag it to the length you want.
NOTE: you can also place the line on the report then use the properties view
to increase/decrease the length and width of the line, as well as the color,
type (solid, dashed, dotted, etc)
X
"bill" wrote:
> I would like to put a line across my report, for appearance.
> How can I make the width of the line to be set to the same as the width of a
> matrix or table below it when the report is rendered?
> I tried LineWidth "=ReportItems!Matrix1.width", but I got
> "Report item expressions can only refer to other report items within the
> same grouping scope or a containing grouping scope."
> Thanks
> Bill
>
>|||Do you know if the width can be set dynamically to the width of a matrix or
table when the report is produced?
Thanks for your help!
-Bill
"Xfonhe" <Xfonhe@.discussions.microsoft.com> wrote in message
news:CF4A40AE-D3C9-49A5-8A11-76E5F96F2EA2@.microsoft.com...
> In the toolbox collection select line object. Place the line on the
report,
> then click on the line to 'activate' it. Grab one of the handles at the
end
> of the line an drag it to the length you want.
> NOTE: you can also place the line on the report then use the properties
view
> to increase/decrease the length and width of the line, as well as the
color,
> type (solid, dashed, dotted, etc)
> X
> "bill" wrote:
> > I would like to put a line across my report, for appearance.
> >
> > How can I make the width of the line to be set to the same as the width
of a
> > matrix or table below it when the report is rendered?
> >
> > I tried LineWidth "=ReportItems!Matrix1.width", but I got
> > "Report item expressions can only refer to other report items within the
> > same grouping scope or a containing grouping scope."
> >
> > Thanks
> > Bill
> >
> >
> >|||Well, you can set the width by expression in the properties view in Report
Designer. I don't know of a built-in function to allow dynamic scaling of an
object in proporation to a second object. You will probably need to write
code to support it, then use the the =CODE() in the expression.
NOTE: to write custom code & embed in the report, eright-click on the blank
section of the layout view, select properties, then the Code tab.
Good luck!
X
"bill" wrote:
> Do you know if the width can be set dynamically to the width of a matrix or
> table when the report is produced?
> Thanks for your help!
> -Bill
> "Xfonhe" <Xfonhe@.discussions.microsoft.com> wrote in message
> news:CF4A40AE-D3C9-49A5-8A11-76E5F96F2EA2@.microsoft.com...
> > In the toolbox collection select line object. Place the line on the
> report,
> > then click on the line to 'activate' it. Grab one of the handles at the
> end
> > of the line an drag it to the length you want.
> >
> > NOTE: you can also place the line on the report then use the properties
> view
> > to increase/decrease the length and width of the line, as well as the
> color,
> > type (solid, dashed, dotted, etc)
> >
> > X
> >
> > "bill" wrote:
> >
> > > I would like to put a line across my report, for appearance.
> > >
> > > How can I make the width of the line to be set to the same as the width
> of a
> > > matrix or table below it when the report is rendered?
> > >
> > > I tried LineWidth "=ReportItems!Matrix1.width", but I got
> > > "Report item expressions can only refer to other report items within the
> > > same grouping scope or a containing grouping scope."
> > >
> > > Thanks
> > > Bill
> > >
> > >
> > >
>
>|||The line itself is not associated with the matrix. So when your matrix grows
or shrinks, the line stays at the same place, and it will look very awkward.
Instead of drawing a line, try use the border control on the rows of the
matrix you want the line to show up. Just like Excel, you can apply just the
top border, or the bottom border, this way the "border" would appear as a
line, and it will move according to your matrix.
"bill" wrote:
> Do you know if the width can be set dynamically to the width of a matrix or
> table when the report is produced?
> Thanks for your help!
> -Bill
> "Xfonhe" <Xfonhe@.discussions.microsoft.com> wrote in message
> news:CF4A40AE-D3C9-49A5-8A11-76E5F96F2EA2@.microsoft.com...
> > In the toolbox collection select line object. Place the line on the
> report,
> > then click on the line to 'activate' it. Grab one of the handles at the
> end
> > of the line an drag it to the length you want.
> >
> > NOTE: you can also place the line on the report then use the properties
> view
> > to increase/decrease the length and width of the line, as well as the
> color,
> > type (solid, dashed, dotted, etc)
> >
> > X
> >
> > "bill" wrote:
> >
> > > I would like to put a line across my report, for appearance.
> > >
> > > How can I make the width of the line to be set to the same as the width
> of a
> > > matrix or table below it when the report is rendered?
> > >
> > > I tried LineWidth "=ReportItems!Matrix1.width", but I got
> > > "Report item expressions can only refer to other report items within the
> > > same grouping scope or a containing grouping scope."
> > >
> > > Thanks
> > > Bill
> > >
> > >
> > >
>
>