rowcount in header not printing

I have figured out that you really can't place a function like
CountRows directly in a report header. So I tried creating a textbox in
the header that points to a textbox in the body that does the
calculation. There expression for this new textbox looks like the
following:
ReportItems!tbRowCount.value
Since I don't want to display two row counts in a report... I have set
the textbox in the page body to Hidden = True.
Interestingly... the following is what happens:
- In VS.NET preview: header row count renders on the first page, but
none of the others.
- In IE 6: header row count renders on all pages like I was hoping.
Yay!
- When printing from IE 6: header row count renders on the first page,
but none of the others.
What matters the most to me is that the row count shows up in on all
pages in both IE and IE printing. BTW... I tried moving the calculation
into the body and setting its repeat with to the correct dataset. This
resulted in similar behavior: print 1st page... then not again for the
rest.
So has anyone figured this out? BTW I'm using RS 2003 and not the new
version.Hi Scott,
How did you link the TextBox in the header with the one in the body?
Bryan
"scott.d" wrote:
> I have figured out that you really can't place a function like
> CountRows directly in a report header. So I tried creating a textbox in
> the header that points to a textbox in the body that does the
> calculation. There expression for this new textbox looks like the
> following:
> ReportItems!tbRowCount.value
> Since I don't want to display two row counts in a report... I have set
> the textbox in the page body to Hidden = True.
> Interestingly... the following is what happens:
> - In VS.NET preview: header row count renders on the first page, but
> none of the others.
> - In IE 6: header row count renders on all pages like I was hoping.
> Yay!
> - When printing from IE 6: header row count renders on the first page,
> but none of the others.
> What matters the most to me is that the row count shows up in on all
> pages in both IE and IE printing. BTW... I tried moving the calculation
> into the body and setting its repeat with to the correct dataset. This
> resulted in similar behavior: print 1st page... then not again for the
> rest.
> So has anyone figured this out? BTW I'm using RS 2003 and not the new
> version.
>

Row updating error.

Hello. I'm trying to update some 'text' data directly through SQL Server
Management Studio (2005) on a table and have been encountering the following
error popup:
Microsoft SQL Server Management Studio
No row was updated.
The data in row _ was not committed.
Error Source: .Net SqlClient Data Provider.
Error Message: String or binary data would be truncated.
The statement has been terminated.
Correct the errors and retry or press ESC to cancel the change(s).
This is strange in that I can update some records in regards to this 'text'
field but then on many other records I get the above error? Would be much
appreciative if anyone would be able to shed some light on this.
Thanks in advance.
J
It just means that the values you're entering are too long. Right-click
and choose "Modify" in Mgmt Studio. There, you'll see a list of the
maximum allowable lengths for each of your columns. You can't type in
anything longer than what's specified there.
-Dave
J wrote:
> Hello. I'm trying to update some 'text' data directly through SQL Server
> Management Studio (2005) on a table and have been encountering the following
> error popup:
>
> Microsoft SQL Server Management Studio
> No row was updated.
> The data in row _ was not committed.
> Error Source: .Net SqlClient Data Provider.
> Error Message: String or binary data would be truncated.
> The statement has been terminated.
> Correct the errors and retry or press ESC to cancel the change(s).
>
> This is strange in that I can update some records in regards to this 'text'
> field but then on many other records I get the above error? Would be much
> appreciative if anyone would be able to shed some light on this.
> Thanks in advance.
> J
>
-Dave Markle
http://www.markleconsulting.com/blog
|||It was strange because there was existing data in these records under the
'text' column already. In trying to update it to a single character I
noticed I received the error messages for records that had lengthy data in
it (like paragraphs long) versus the records that I was able to update that
only had a few characters which I didn't receive the error message and was
able to update it to a single character. Since we're still in the
development stage I ran an UPDDATE statment to set all of this 'text' column
to null and it seems like that this did the trick.
Thanks for your quick reply and info Dave. Much appreciated.
Take care.
J
"Dave Markle" <"dma[remove_ZZ]ZZrkle"@.gmail.dot.com> wrote in message
news:u5rAbRORHHA.3412@.TK2MSFTNGP05.phx.gbl...
> It just means that the values you're entering are too long. Right-click
> and choose "Modify" in Mgmt Studio. There, you'll see a list of the
> maximum allowable lengths for each of your columns. You can't type in
> anything longer than what's specified there.
> -Dave
> J wrote:
>
> --
> -Dave Markle
> http://www.markleconsulting.com/blog

Row updating error.

Hello. I'm trying to update some 'text' data directly through SQL Server
Management Studio (2005) on a table and have been encountering the following
error popup:
Microsoft SQL Server Management Studio
No row was updated.
The data in row _ was not committed.
Error Source: .Net SqlClient Data Provider.
Error Message: String or binary data would be truncated.
The statement has been terminated.
Correct the errors and retry or press ESC to cancel the change(s).
This is strange in that I can update some records in regards to this 'text'
field but then on many other records I get the above error? Would be much
appreciative if anyone would be able to shed some light on this.
Thanks in advance.
JIt just means that the values you're entering are too long. Right-click
and choose "Modify" in Mgmt Studio. There, you'll see a list of the
maximum allowable lengths for each of your columns. You can't type in
anything longer than what's specified there.
-Dave
J wrote:
> Hello. I'm trying to update some 'text' data directly through SQL Server
> Management Studio (2005) on a table and have been encountering the followi
ng
> error popup:
>
> Microsoft SQL Server Management Studio
> No row was updated.
> The data in row _ was not committed.
> Error Source: .Net SqlClient Data Provider.
> Error Message: String or binary data would be truncated.
> The statement has been terminated.
> Correct the errors and retry or press ESC to cancel the change(s).
>
> This is strange in that I can update some records in regards to this 'text
'
> field but then on many other records I get the above error? Would be much
> appreciative if anyone would be able to shed some light on this.
> Thanks in advance.
> J
>
-Dave Markle
http://www.markleconsulting.com/blog|||It was strange because there was existing data in these records under the
'text' column already. In trying to update it to a single character I
noticed I received the error messages for records that had lengthy data in
it (like paragraphs long) versus the records that I was able to update that
only had a few characters which I didn't receive the error message and was
able to update it to a single character. Since we're still in the
development stage I ran an UPDDATE statment to set all of this 'text' column
to null and it seems like that this did the trick.
Thanks for your quick reply and info Dave. Much appreciated.
Take care.
J
"Dave Markle" <"dma[remove_ZZ]ZZrkle"@.gmail.dot.com> wrote in message
news:u5rAbRORHHA.3412@.TK2MSFTNGP05.phx.gbl...
> It just means that the values you're entering are too long. Right-click
> and choose "Modify" in Mgmt Studio. There, you'll see a list of the
> maximum allowable lengths for each of your columns. You can't type in
> anything longer than what's specified there.
> -Dave
> J wrote:
>
> --
> -Dave Markle
> http://www.markleconsulting.com/blog

Row updating error.

Hello. I'm trying to update some 'text' data directly through SQL Server
Management Studio (2005) on a table and have been encountering the following
error popup:
Microsoft SQL Server Management Studio
No row was updated.
The data in row _ was not committed.
Error Source: .Net SqlClient Data Provider.
Error Message: String or binary data would be truncated.
The statement has been terminated.
Correct the errors and retry or press ESC to cancel the change(s).
This is strange in that I can update some records in regards to this 'text'
field but then on many other records I get the above error? Would be much
appreciative if anyone would be able to shed some light on this.
Thanks in advance.
JIt just means that the values you're entering are too long. Right-click
and choose "Modify" in Mgmt Studio. There, you'll see a list of the
maximum allowable lengths for each of your columns. You can't type in
anything longer than what's specified there.
-Dave
J wrote:
> Hello. I'm trying to update some 'text' data directly through SQL Server
> Management Studio (2005) on a table and have been encountering the following
> error popup:
>
> Microsoft SQL Server Management Studio
> No row was updated.
> The data in row _ was not committed.
> Error Source: .Net SqlClient Data Provider.
> Error Message: String or binary data would be truncated.
> The statement has been terminated.
> Correct the errors and retry or press ESC to cancel the change(s).
>
> This is strange in that I can update some records in regards to this 'text'
> field but then on many other records I get the above error? Would be much
> appreciative if anyone would be able to shed some light on this.
> Thanks in advance.
> J
>
-Dave Markle
http://www.markleconsulting.com/blog|||It was strange because there was existing data in these records under the
'text' column already. In trying to update it to a single character I
noticed I received the error messages for records that had lengthy data in
it (like paragraphs long) versus the records that I was able to update that
only had a few characters which I didn't receive the error message and was
able to update it to a single character. Since we're still in the
development stage I ran an UPDDATE statment to set all of this 'text' column
to null and it seems like that this did the trick.
Thanks for your quick reply and info Dave. Much appreciated.
Take care.
J
"Dave Markle" <"dma[remove_ZZ]ZZrkle"@.gmail.dot.com> wrote in message
news:u5rAbRORHHA.3412@.TK2MSFTNGP05.phx.gbl...
> It just means that the values you're entering are too long. Right-click
> and choose "Modify" in Mgmt Studio. There, you'll see a list of the
> maximum allowable lengths for each of your columns. You can't type in
> anything longer than what's specified there.
> -Dave
> J wrote:
>> Hello. I'm trying to update some 'text' data directly through SQL Server
>> Management Studio (2005) on a table and have been encountering the
>> following error popup:
>>
>> Microsoft SQL Server Management Studio
>> No row was updated.
>> The data in row _ was not committed.
>> Error Source: .Net SqlClient Data Provider.
>> Error Message: String or binary data would be truncated.
>> The statement has been terminated.
>> Correct the errors and retry or press ESC to cancel the change(s).
>>
>> This is strange in that I can update some records in regards to this
>> 'text' field but then on many other records I get the above error? Would
>> be much appreciative if anyone would be able to shed some light on this.
>> Thanks in advance.
>> J
>
> --
> -Dave Markle
> http://www.markleconsulting.com/blog

Row count from another table?

Is it possible to directly get the row count of a different table in a RS2005 report?

I'd like to use this row count number in a calculation in another table...

This would be a lot cleaner than creating a new dataset to provide me with this value.

Thanks!

Alright, figured this out. Just had to use RowNumber("NameOfDataset") to return the number of rows in a table created by a dataset. Also, RowNumber(Nothing) returns the row number of a row in a table.

Routing file to printer

Is there a way to route a file directly to a printer? I have a process that creates PDF file in a known location and I would like to route them directly to the printer after creation.

Did one of your earlier threads not answer this question?

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1259522&SiteID=1|||

I did not see the earlier answer. I have posted an additional question there.

Thanks for the answer.

Routing file to printer

Is there a way to route a file directly to a printer? I have a process that creates PDF file in a known location and I would like to route them directly to the printer after creation.

Did one of your earlier threads not answer this question?

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1259522&SiteID=1|||

I did not see the earlier answer. I have posted an additional question there.

Thanks for the answer.