Max length of textbox.

I want to display 1 million characters in a SQL Server Report's text box, but it is only showing 32000 charcters....how can I display all 1 million character without any truncation.

Question #1: Why in the world would you want to do that?

Question #2: Did you count all 32000 characters?

Answer to your question: you can't.

|||The count is approximated to 32000
Client is the King! and it is his requirment....
|||Can I use Custom Report Item to achive this?
|||Why don't you put many textboxes side by side with no border?

sql

Matrix width

How do you find out the width of a matrix control, I need this to
enable me to size the width of a Textbox, as the width needs to be the
same size as the Matrix control which keeps growing depending on the
dataThe width of your textbox is changing dynamically? Wow! How did you get it
to do that? The "increase to accomidate contents" checkbox only increases
the height on my version RS. I haven't found out to dynamically change the
width yet. And I believe several other people on this forum are searching
for this same functionality.
BTW, the only place I've seen the size properties (height & width) are in
the properties screen of the individual boxes or the rows or the
tables/matrices/lists. I asked a while back for how to call those properties
in an expression (I know it's similar to "Type!Name.Value" - still don't know
what type to use for properties), but no one answered the question.
Hopefully, someone will help us both out and answer the question here.
Catadmin
"Bryan Avery" wrote:
> How do you find out the width of a matrix control, I need this to
> enable me to size the width of a Textbox, as the width needs to be the
> same size as the Matrix control which keeps growing depending on the
> data
>sql

Matrix title

I have the following report using RS2000

(1) In my page header I have a textbox(title of the report).

(2) In my report body, I have a matrix report that can extend horizontally.

My issue is that I don't know how to make sure that my page header title (1) stretches as far as the last matrix row (2).

Any help? Has anyone ever come across this issue and is there a solution to it?

Thanks,

YADGOR2000

Two options:

1. You can add an outmost status column (or a dynamic column with a constant group expression) in the matrix. Put the title in the column header and set the TextAlign to center.

2. Add a table with two header rows and one column, and drop the matrix inside the second row of the table. Put the title in the first table row, and set the TextAlign to center.

|||

I am not sure I can understand your response. Can you give me step by step break down for either option 1 or 2.

Thank you

yadgor2000

Matrix title

I have the following report using RS2000

(1) In my page header I have a textbox(title of the report).

(2) In my report body, I have a matrix report that can extend horizontally.

My issue is that I don't know how to make sure that my page header title (1) stretches as far as the last matrix row (2).

Any help? Has anyone ever come across this issue and is there a solution to it?

Thanks,

YADGOR2000

Two options:

1. You can add an outmost status column (or a dynamic column with a constant group expression) in the matrix. Put the title in the column header and set the TextAlign to center.

2. Add a table with two header rows and one column, and drop the matrix inside the second row of the table. Put the title in the first table row, and set the TextAlign to center.

|||

I am not sure I can understand your response. Can you give me step by step break down for either option 1 or 2.

Thank you

yadgor2000

Matrix Report Textbox Expression

=IIF( Sum(Fields!Percentile.Value, "RegionalSnaps") >= .10, "Yellow", "White")

I only want the ones above 10% to be yellow, otherwise white.

Any ideas anyone on why the entire range of cells are yellow and not just the one above 10%?

Ive tried both .10 and 10 for the value, and still the same thing

Because you're doing a sum, it's doing it for the entire dataset. If this expression is in a grouping e.g. table, matrix, list etc... then try changing the expresison to

=IIF( Fields!Percentile.Value >= .10, "Yellow", "White")

Effectively evalueated for every row in the group.

|||WOW, I've been searching for an answer for this for a long time, I really appreciate your time.|||You're welcome.

Matrix - Totals

What does the following error mean?
[rsNonAggregateInMatrixCell] The Value expression for the textbox â'textbox2â'
references a field outside an aggregate function. Value expressions in
matrix cells should be aggregates, to allow for subtotaling.
Build complete -- 0 errors, 1 warningsResolved
"Terry" wrote:
> What does the following error mean?
> [rsNonAggregateInMatrixCell] The Value expression for the textbox â'textbox2â'
> references a field outside an aggregate function. Value expressions in
> matrix cells should be aggregates, to allow for subtotaling.
> Build complete -- 0 errors, 1 warnings|||Figured it out. For others knowledge, you need to add the First() around the
value, like this for BorderStyle:
=iif(First(Fields!desc.Value)="Sent","Solid","None")
"Sharon" wrote:
> How was this resolved?
>
> "Terry" wrote:
> > Resolved
> >
> > "Terry" wrote:
> >
> > > What does the following error mean?
> > >
> > > [rsNonAggregateInMatrixCell] The Value expression for the textbox â'textbox2â'
> > > references a field outside an aggregate function. Value expressions in
> > > matrix cells should be aggregates, to allow for subtotaling.
> > > Build complete -- 0 errors, 1 warnings|||How was this resolved?
"Terry" wrote:
> Resolved
> "Terry" wrote:
> > What does the following error mean?
> >
> > [rsNonAggregateInMatrixCell] The Value expression for the textbox â'textbox2â'
> > references a field outside an aggregate function. Value expressions in
> > matrix cells should be aggregates, to allow for subtotaling.
> > Build complete -- 0 errors, 1 warnings