I have added to detail rows to my table and set the canshrink property to
them all to be =True.
I only use one field in each row, and if there is no value in that field you
would think it would shrink the whole row to nothing. It keeps the row
there and takes up the space of the whole row.
Has anyone else seen this or have any idea why CanShrink does not work.?Did you ever find a solution to this? I have the same problem. I have a
matrix control that has the potential to have four rows per group. However,
depending on the group I only want to show some rows and not others. I'm
able to hide the values in the rows, but I can't hide the row.
Thanks!
Ian
Showing posts with label rows. Show all posts
Showing posts with label rows. Show all posts
Monday, March 19, 2012
Thursday, March 8, 2012
cannot update
Hi
we moved from 2000 to 2003 (version 9)
I do Open Table to see all rows
when I try to change a value say 2 to 3 in int field it pops up dialog and
say
like driver error string or binary data will be truncated
but it is an integer field and the values are like 2 and 3!
is it isolation level related perhaps
what setting is it
we just installed it so it must be default
Sincerely
GSLHi
"info@.sites4agents.com" wrote:
> Hi
> we moved from 2000 to 2003 (version 9)
> I do Open Table to see all rows
> when I try to change a value say 2 to 3 in int field it pops up dialog and
> say
> like driver error string or binary data will be truncated
> but it is an integer field and the values are like 2 and 3!
> is it isolation level related perhaps
> what setting is it
> we just installed it so it must be default
> Sincerely
> GSL
This should not be an issue under normal circumstances. Have you service
packed your version of SQL 2005? Are you trying this on a client or the
server itself?
Are there any triggers on the table?
John|||John
Thanks
No SPs as far as I know (how will I know?)
the table does have text column but then in sql2000 it was updatable
manually
No triggers
I do it on the server
also! when I do it in Query like regular update statement it works!
(so maybe it forces good habits nevertheless I am curious why it happens)
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:25EACFD4-9897-4D6E-AEA6-E7936186542A@.microsoft.com...
> Hi
> "info@.sites4agents.com" wrote:
>> Hi
>> we moved from 2000 to 2003 (version 9)
>> I do Open Table to see all rows
>> when I try to change a value say 2 to 3 in int field it pops up dialog
>> and
>> say
>> like driver error string or binary data will be truncated
>> but it is an integer field and the values are like 2 and 3!
>> is it isolation level related perhaps
>> what setting is it
>> we just installed it so it must be default
>> Sincerely
>> GSL
> This should not be an issue under normal circumstances. Have you service
> packed your version of SQL 2005? Are you trying this on a client or the
> server itself?
> Are there any triggers on the table?
> John
>|||Hi
"info@.sites4agents.com" wrote:
> John
> Thanks
> No SPs as far as I know (how will I know?)
Select @.@.VERSION will give you the version number also SELECT
SERVERPROPTERY('ProductLevel ') will tell if a service pack has been applied
or is still at the original release (RTM). See
http://sqlserver2000.databases.aspfaq.com/how-do-i-know-which-version-of-sql-server-i-m-running.html for more.
> the table does have text column but then in sql2000 it was updatable
> manually
> No triggers
> I do it on the server
> also! when I do it in Query like regular update statement it works!
> (so maybe it forces good habits nevertheless I am curious why it happens)
The error message you have seems to be a SQL Server error message, if you
have the error number it would be useful. You could post DDL and example data
http://www.aspfaq.com/etiquette.asp?id=5006 to help others re-create this.
Open table in Enterprise Manager was always quirky therefore it is not
something a lot of people will use in SQL 2005 because of that.
John
we moved from 2000 to 2003 (version 9)
I do Open Table to see all rows
when I try to change a value say 2 to 3 in int field it pops up dialog and
say
like driver error string or binary data will be truncated
but it is an integer field and the values are like 2 and 3!
is it isolation level related perhaps
what setting is it
we just installed it so it must be default
Sincerely
GSLHi
"info@.sites4agents.com" wrote:
> Hi
> we moved from 2000 to 2003 (version 9)
> I do Open Table to see all rows
> when I try to change a value say 2 to 3 in int field it pops up dialog and
> say
> like driver error string or binary data will be truncated
> but it is an integer field and the values are like 2 and 3!
> is it isolation level related perhaps
> what setting is it
> we just installed it so it must be default
> Sincerely
> GSL
This should not be an issue under normal circumstances. Have you service
packed your version of SQL 2005? Are you trying this on a client or the
server itself?
Are there any triggers on the table?
John|||John
Thanks
No SPs as far as I know (how will I know?)
the table does have text column but then in sql2000 it was updatable
manually
No triggers
I do it on the server
also! when I do it in Query like regular update statement it works!
(so maybe it forces good habits nevertheless I am curious why it happens)
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:25EACFD4-9897-4D6E-AEA6-E7936186542A@.microsoft.com...
> Hi
> "info@.sites4agents.com" wrote:
>> Hi
>> we moved from 2000 to 2003 (version 9)
>> I do Open Table to see all rows
>> when I try to change a value say 2 to 3 in int field it pops up dialog
>> and
>> say
>> like driver error string or binary data will be truncated
>> but it is an integer field and the values are like 2 and 3!
>> is it isolation level related perhaps
>> what setting is it
>> we just installed it so it must be default
>> Sincerely
>> GSL
> This should not be an issue under normal circumstances. Have you service
> packed your version of SQL 2005? Are you trying this on a client or the
> server itself?
> Are there any triggers on the table?
> John
>|||Hi
"info@.sites4agents.com" wrote:
> John
> Thanks
> No SPs as far as I know (how will I know?)
Select @.@.VERSION will give you the version number also SELECT
SERVERPROPTERY('ProductLevel ') will tell if a service pack has been applied
or is still at the original release (RTM). See
http://sqlserver2000.databases.aspfaq.com/how-do-i-know-which-version-of-sql-server-i-m-running.html for more.
> the table does have text column but then in sql2000 it was updatable
> manually
> No triggers
> I do it on the server
> also! when I do it in Query like regular update statement it works!
> (so maybe it forces good habits nevertheless I am curious why it happens)
The error message you have seems to be a SQL Server error message, if you
have the error number it would be useful. You could post DDL and example data
http://www.aspfaq.com/etiquette.asp?id=5006 to help others re-create this.
Open table in Enterprise Manager was always quirky therefore it is not
something a lot of people will use in SQL 2005 because of that.
John
Tuesday, February 14, 2012
Cannot see all records in report
Ok..
On the data tab I can see 6 rows of data returned from a sproc
When I input these same parameters onto the report (preview) I can only see
the first or last record depending on the following:
=First(Fields!Year.Value) - gives me first
=(Fields!Year.Value) - also gives me first (I thought this would give me all
values)
=Last(Fields!Year.Value) - gives me last
I just threw the field on the report inside a rectangle which I have set to
put a page break after.
For simplicity, assume I only have to print the year on each page.. how do I
do that? At the moment, I can only print 1.
Tx
LesYou need to put a list control or a table control. What you are doing will
only show one record.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"LesWright" <LesWright@.discussions.microsoft.com> wrote in message
news:E584CC12-08AA-4B5E-8CC8-BEA8291A2D97@.microsoft.com...
> Ok..
> On the data tab I can see 6 rows of data returned from a sproc
> When I input these same parameters onto the report (preview) I can only
> see
> the first or last record depending on the following:
> =First(Fields!Year.Value) - gives me first
> =(Fields!Year.Value) - also gives me first (I thought this would give me
> all
> values)
> =Last(Fields!Year.Value) - gives me last
> I just threw the field on the report inside a rectangle which I have set
> to
> put a page break after.
> For simplicity, assume I only have to print the year on each page.. how do
> I
> do that? At the moment, I can only print 1.
> Tx
> Les|||Thanks Bruce for your reply.
To confirm, you're saying that if I want the information pertaining to one
record to occupy 1 page, I need to add a list or table and design that to
occupy one page, with a page break for the next record?
Tx
Les
"Bruce L-C [MVP]" wrote:
> You need to put a list control or a table control. What you are doing will
> only show one record.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "LesWright" <LesWright@.discussions.microsoft.com> wrote in message
> news:E584CC12-08AA-4B5E-8CC8-BEA8291A2D97@.microsoft.com...
> > Ok..
> > On the data tab I can see 6 rows of data returned from a sproc
> > When I input these same parameters onto the report (preview) I can only
> > see
> > the first or last record depending on the following:
> >
> > =First(Fields!Year.Value) - gives me first
> > =(Fields!Year.Value) - also gives me first (I thought this would give me
> > all
> > values)
> > =Last(Fields!Year.Value) - gives me last
> >
> > I just threw the field on the report inside a rectangle which I have set
> > to
> > put a page break after.
> >
> > For simplicity, assume I only have to print the year on each page.. how do
> > I
> > do that? At the moment, I can only print 1.
> >
> > Tx
> > Les
>
>|||If you want one record per page then you want to have a list, have a group
with a page break to force one record per page.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"LesWright" <LesWright@.discussions.microsoft.com> wrote in message
news:96A788F1-337C-4712-8094-2DA68FC192F7@.microsoft.com...
> Thanks Bruce for your reply.
> To confirm, you're saying that if I want the information pertaining to one
> record to occupy 1 page, I need to add a list or table and design that to
> occupy one page, with a page break for the next record?
> Tx
> Les
> "Bruce L-C [MVP]" wrote:
>> You need to put a list control or a table control. What you are doing
>> will
>> only show one record.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "LesWright" <LesWright@.discussions.microsoft.com> wrote in message
>> news:E584CC12-08AA-4B5E-8CC8-BEA8291A2D97@.microsoft.com...
>> > Ok..
>> > On the data tab I can see 6 rows of data returned from a sproc
>> > When I input these same parameters onto the report (preview) I can only
>> > see
>> > the first or last record depending on the following:
>> >
>> > =First(Fields!Year.Value) - gives me first
>> > =(Fields!Year.Value) - also gives me first (I thought this would give
>> > me
>> > all
>> > values)
>> > =Last(Fields!Year.Value) - gives me last
>> >
>> > I just threw the field on the report inside a rectangle which I have
>> > set
>> > to
>> > put a page break after.
>> >
>> > For simplicity, assume I only have to print the year on each page.. how
>> > do
>> > I
>> > do that? At the moment, I can only print 1.
>> >
>> > Tx
>> > Les
>>|||Thanks Bruce.
Les
"Bruce L-C [MVP]" wrote:
> If you want one record per page then you want to have a list, have a group
> with a page break to force one record per page.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "LesWright" <LesWright@.discussions.microsoft.com> wrote in message
> news:96A788F1-337C-4712-8094-2DA68FC192F7@.microsoft.com...
> > Thanks Bruce for your reply.
> >
> > To confirm, you're saying that if I want the information pertaining to one
> > record to occupy 1 page, I need to add a list or table and design that to
> > occupy one page, with a page break for the next record?
> >
> > Tx
> > Les
> >
> > "Bruce L-C [MVP]" wrote:
> >
> >> You need to put a list control or a table control. What you are doing
> >> will
> >> only show one record.
> >>
> >>
> >> --
> >> Bruce Loehle-Conger
> >> MVP SQL Server Reporting Services
> >>
> >> "LesWright" <LesWright@.discussions.microsoft.com> wrote in message
> >> news:E584CC12-08AA-4B5E-8CC8-BEA8291A2D97@.microsoft.com...
> >> > Ok..
> >> > On the data tab I can see 6 rows of data returned from a sproc
> >> > When I input these same parameters onto the report (preview) I can only
> >> > see
> >> > the first or last record depending on the following:
> >> >
> >> > =First(Fields!Year.Value) - gives me first
> >> > =(Fields!Year.Value) - also gives me first (I thought this would give
> >> > me
> >> > all
> >> > values)
> >> > =Last(Fields!Year.Value) - gives me last
> >> >
> >> > I just threw the field on the report inside a rectangle which I have
> >> > set
> >> > to
> >> > put a page break after.
> >> >
> >> > For simplicity, assume I only have to print the year on each page.. how
> >> > do
> >> > I
> >> > do that? At the moment, I can only print 1.
> >> >
> >> > Tx
> >> > Les
> >>
> >>
> >>
>
>
On the data tab I can see 6 rows of data returned from a sproc
When I input these same parameters onto the report (preview) I can only see
the first or last record depending on the following:
=First(Fields!Year.Value) - gives me first
=(Fields!Year.Value) - also gives me first (I thought this would give me all
values)
=Last(Fields!Year.Value) - gives me last
I just threw the field on the report inside a rectangle which I have set to
put a page break after.
For simplicity, assume I only have to print the year on each page.. how do I
do that? At the moment, I can only print 1.
Tx
LesYou need to put a list control or a table control. What you are doing will
only show one record.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"LesWright" <LesWright@.discussions.microsoft.com> wrote in message
news:E584CC12-08AA-4B5E-8CC8-BEA8291A2D97@.microsoft.com...
> Ok..
> On the data tab I can see 6 rows of data returned from a sproc
> When I input these same parameters onto the report (preview) I can only
> see
> the first or last record depending on the following:
> =First(Fields!Year.Value) - gives me first
> =(Fields!Year.Value) - also gives me first (I thought this would give me
> all
> values)
> =Last(Fields!Year.Value) - gives me last
> I just threw the field on the report inside a rectangle which I have set
> to
> put a page break after.
> For simplicity, assume I only have to print the year on each page.. how do
> I
> do that? At the moment, I can only print 1.
> Tx
> Les|||Thanks Bruce for your reply.
To confirm, you're saying that if I want the information pertaining to one
record to occupy 1 page, I need to add a list or table and design that to
occupy one page, with a page break for the next record?
Tx
Les
"Bruce L-C [MVP]" wrote:
> You need to put a list control or a table control. What you are doing will
> only show one record.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "LesWright" <LesWright@.discussions.microsoft.com> wrote in message
> news:E584CC12-08AA-4B5E-8CC8-BEA8291A2D97@.microsoft.com...
> > Ok..
> > On the data tab I can see 6 rows of data returned from a sproc
> > When I input these same parameters onto the report (preview) I can only
> > see
> > the first or last record depending on the following:
> >
> > =First(Fields!Year.Value) - gives me first
> > =(Fields!Year.Value) - also gives me first (I thought this would give me
> > all
> > values)
> > =Last(Fields!Year.Value) - gives me last
> >
> > I just threw the field on the report inside a rectangle which I have set
> > to
> > put a page break after.
> >
> > For simplicity, assume I only have to print the year on each page.. how do
> > I
> > do that? At the moment, I can only print 1.
> >
> > Tx
> > Les
>
>|||If you want one record per page then you want to have a list, have a group
with a page break to force one record per page.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"LesWright" <LesWright@.discussions.microsoft.com> wrote in message
news:96A788F1-337C-4712-8094-2DA68FC192F7@.microsoft.com...
> Thanks Bruce for your reply.
> To confirm, you're saying that if I want the information pertaining to one
> record to occupy 1 page, I need to add a list or table and design that to
> occupy one page, with a page break for the next record?
> Tx
> Les
> "Bruce L-C [MVP]" wrote:
>> You need to put a list control or a table control. What you are doing
>> will
>> only show one record.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "LesWright" <LesWright@.discussions.microsoft.com> wrote in message
>> news:E584CC12-08AA-4B5E-8CC8-BEA8291A2D97@.microsoft.com...
>> > Ok..
>> > On the data tab I can see 6 rows of data returned from a sproc
>> > When I input these same parameters onto the report (preview) I can only
>> > see
>> > the first or last record depending on the following:
>> >
>> > =First(Fields!Year.Value) - gives me first
>> > =(Fields!Year.Value) - also gives me first (I thought this would give
>> > me
>> > all
>> > values)
>> > =Last(Fields!Year.Value) - gives me last
>> >
>> > I just threw the field on the report inside a rectangle which I have
>> > set
>> > to
>> > put a page break after.
>> >
>> > For simplicity, assume I only have to print the year on each page.. how
>> > do
>> > I
>> > do that? At the moment, I can only print 1.
>> >
>> > Tx
>> > Les
>>|||Thanks Bruce.
Les
"Bruce L-C [MVP]" wrote:
> If you want one record per page then you want to have a list, have a group
> with a page break to force one record per page.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "LesWright" <LesWright@.discussions.microsoft.com> wrote in message
> news:96A788F1-337C-4712-8094-2DA68FC192F7@.microsoft.com...
> > Thanks Bruce for your reply.
> >
> > To confirm, you're saying that if I want the information pertaining to one
> > record to occupy 1 page, I need to add a list or table and design that to
> > occupy one page, with a page break for the next record?
> >
> > Tx
> > Les
> >
> > "Bruce L-C [MVP]" wrote:
> >
> >> You need to put a list control or a table control. What you are doing
> >> will
> >> only show one record.
> >>
> >>
> >> --
> >> Bruce Loehle-Conger
> >> MVP SQL Server Reporting Services
> >>
> >> "LesWright" <LesWright@.discussions.microsoft.com> wrote in message
> >> news:E584CC12-08AA-4B5E-8CC8-BEA8291A2D97@.microsoft.com...
> >> > Ok..
> >> > On the data tab I can see 6 rows of data returned from a sproc
> >> > When I input these same parameters onto the report (preview) I can only
> >> > see
> >> > the first or last record depending on the following:
> >> >
> >> > =First(Fields!Year.Value) - gives me first
> >> > =(Fields!Year.Value) - also gives me first (I thought this would give
> >> > me
> >> > all
> >> > values)
> >> > =Last(Fields!Year.Value) - gives me last
> >> >
> >> > I just threw the field on the report inside a rectangle which I have
> >> > set
> >> > to
> >> > put a page break after.
> >> >
> >> > For simplicity, assume I only have to print the year on each page.. how
> >> > do
> >> > I
> >> > do that? At the moment, I can only print 1.
> >> >
> >> > Tx
> >> > Les
> >>
> >>
> >>
>
>
Subscribe to:
Posts (Atom)