Error with text data type

I have a table with a text data type field, when I paste text less than 1024 in lenght, all is right, but when the size is greater than 1024 nothing is pasted. Some help?
"Paste" where? Have you considered using an INSERT or UPDATE statement in
Query Analyzer?
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/
"Andres Romero" <anonymous@.discussions.microsoft.com> wrote in message
news:BAE4075B-4228-40B3-8ED2-FB23DBF732F1@.microsoft.com...
> I have a table with a text data type field, when I paste text less than
1024 in lenght, all is right, but when the size is greater than 1024 nothing
is pasted. Some help?
|||Hi,
Execute the command Select @.@.textsize to identify the current value.
Increase the value of store using
SET TEXTSIZE <Value in bytes>
Increase to a higher value and try inserting.
Thanks
Hari
MCDBA
"Andres Romero" <anonymous@.discussions.microsoft.com> wrote in message
news:BAE4075B-4228-40B3-8ED2-FB23DBF732F1@.microsoft.com...
> I have a table with a text data type field, when I paste text less than
1024 in lenght, all is right, but when the size is greater than 1024 nothing
is pasted. Some help?

Error with text data type

I have a table with a text data type field, when I paste text less than 1024 in lenght, all is right, but when the size is greater than 1024 nothing is pasted. Some help?"Paste" where? Have you considered using an INSERT or UPDATE statement in
Query Analyzer?
--
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/
"Andres Romero" <anonymous@.discussions.microsoft.com> wrote in message
news:BAE4075B-4228-40B3-8ED2-FB23DBF732F1@.microsoft.com...
> I have a table with a text data type field, when I paste text less than
1024 in lenght, all is right, but when the size is greater than 1024 nothing
is pasted. Some help?|||Hi,
Execute the command Select @.@.textsize to identify the current value.
Increase the value of store using
SET TEXTSIZE <Value in bytes>
Increase to a higher value and try inserting.
Thanks
Hari
MCDBA
"Andres Romero" <anonymous@.discussions.microsoft.com> wrote in message
news:BAE4075B-4228-40B3-8ED2-FB23DBF732F1@.microsoft.com...
> I have a table with a text data type field, when I paste text less than
1024 in lenght, all is right, but when the size is greater than 1024 nothing
is pasted. Some help?

Error with text data type

I have a table with a text data type field, when I paste text less than 1024
in lenght, all is right, but when the size is greater than 1024 nothing is
pasted. Some help?"Paste" where? Have you considered using an INSERT or UPDATE statement in
Query Analyzer?
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/
"Andres Romero" <anonymous@.discussions.microsoft.com> wrote in message
news:BAE4075B-4228-40B3-8ED2-FB23DBF732F1@.microsoft.com...
> I have a table with a text data type field, when I paste text less than
1024 in lenght, all is right, but when the size is greater than 1024 nothing
is pasted. Some help?|||Hi,
Execute the command Select @.@.textsize to identify the current value.
Increase the value of store using
SET TEXTSIZE <Value in bytes>
Increase to a higher value and try inserting.
Thanks
Hari
MCDBA
"Andres Romero" <anonymous@.discussions.microsoft.com> wrote in message
news:BAE4075B-4228-40B3-8ED2-FB23DBF732F1@.microsoft.com...
> I have a table with a text data type field, when I paste text less than
1024 in lenght, all is right, but when the size is greater than 1024 nothing
is pasted. Some help?

Error While Exporting to Excel

Hi Group,
When i tried to export my report to excel it throws me this error
Error: Index was out of range.Must be non-negative and less than the size of
the collection.Parameter name:index.
My Report contains subreport in one column.I Placed my subreport in
rectangle tool
and placed the rectangle in the table cell.
can any only help me how to resolve this error.In excel renderer, subreport and data regions inside table / matrix cells
are not supported.
Anyway, you should be able to render the report with a nice error message in
place of subreport. Could you send us the report, please?
--
Nico Cristache [MSFT]
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Manoj.Pasumarthi" <ManojPasumarthi@.discussions.microsoft.com> wrote in
message news:186AE246-FF9A-4C8D-A86E-D7430F572BD9@.microsoft.com...
> Hi Group,
> When i tried to export my report to excel it throws me this error
> Error: Index was out of range.Must be non-negative and less than the size
of
> the collection.Parameter name:index.
> My Report contains subreport in one column.I Placed my subreport in
> rectangle tool
> and placed the rectangle in the table cell.
> can any only help me how to resolve this error.|||Hi Cristache,
In my Previous Discussion with CHRIS HAYS he Said
Subreports are not currently supported inside tables/matrixes in the Excel
renderer.
You could either convert your table to nested lists (this approach won't
work for matrix) or you could place the contents of your subreport into a
rectangle in the table/matrix cell. Note: This second approach involves
rewriting your query to join the main query data with the subreport query
data.
Now My Problem is I am not able to render the report to xls.But i have
another report with same concept and able to render to xls and values are
displaing in subreport column.But the other report what i was taking is
giving this error
Error: Index was out of range.Must be non-negative and less than the size of
the collection.Parameter name:index. And report is not rendering.
So how do i send the report to you.
"Nico Cristache [MSFT]" wrote:
> In excel renderer, subreport and data regions inside table / matrix cells
> are not supported.
> Anyway, you should be able to render the report with a nice error message in
> place of subreport. Could you send us the report, please?
> --
> Nico Cristache [MSFT]
> Microsoft SQL Server Reporting Services
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "Manoj.Pasumarthi" <ManojPasumarthi@.discussions.microsoft.com> wrote in
> message news:186AE246-FF9A-4C8D-A86E-D7430F572BD9@.microsoft.com...
> > Hi Group,
> >
> > When i tried to export my report to excel it throws me this error
> > Error: Index was out of range.Must be non-negative and less than the size
> of
> > the collection.Parameter name:index.
> >
> > My Report contains subreport in one column.I Placed my subreport in
> > rectangle tool
> > and placed the rectangle in the table cell.
> >
> > can any only help me how to resolve this error.
>
>|||I have the same error message
In my report I use 9 tables
all the rendering goes ok, but when I export it to excell I get the message
"Nico Cristache [MSFT]" wrote:
> In excel renderer, subreport and data regions inside table / matrix cells
> are not supported.
> Anyway, you should be able to render the report with a nice error message in
> place of subreport. Could you send us the report, please?
> --
> Nico Cristache [MSFT]
> Microsoft SQL Server Reporting Services
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "Manoj.Pasumarthi" <ManojPasumarthi@.discussions.microsoft.com> wrote in
> message news:186AE246-FF9A-4C8D-A86E-D7430F572BD9@.microsoft.com...
> > Hi Group,
> >
> > When i tried to export my report to excel it throws me this error
> > Error: Index was out of range.Must be non-negative and less than the size
> of
> > the collection.Parameter name:index.
> >
> > My Report contains subreport in one column.I Placed my subreport in
> > rectangle tool
> > and placed the rectangle in the table cell.
> >
> > can any only help me how to resolve this error.
>
>