black rectangles appearing in PDF

I have suddenly started getting black rectangles appearing on the right hand
side of PDF output.
There are no rectangles or other objects in this area of the report.
Is this a known bug?By any chance, have you included column 2 as well, and a border, then you
will get this rectangles. check in the properties for column and the border
line for left,right etc... Just to make sure you have not done these things.
Amarnath
"adolf garlic" wrote:
> I have suddenly started getting black rectangles appearing on the right hand
> side of PDF output.
> There are no rectangles or other objects in this area of the report.
> Is this a known bug?|||Just to add, the rectangle is solid black and is the same height as the table
appearing in the report.
I took a copy of the report, deleted the table and the problem went away,
but now I don't have a table...
If I move the table up and down and redeploy, recreate PDF the black
rectangle moves up and down, always in line with the table.
If I move the table left and right, the size of the rectangle changes, when
the table is pushed right up against the right hand side of the body the
rectangle disappears.
The table has dynamically hidden columns based on whether or not there is
data to show. The black rectangle has not previously been a problem.
I'm not sure what you mean by "have you included column 2". The report has
more than 2 columns but there is only one table present. There are no other
hidden or other objects to the right of the table.
"Amarnath" wrote:
> By any chance, have you included column 2 as well, and a border, then you
> will get this rectangles. check in the properties for column and the border
> line for left,right etc... Just to make sure you have not done these things.
> Amarnath
> "adolf garlic" wrote:
> > I have suddenly started getting black rectangles appearing on the right hand
> > side of PDF output.
> >
> > There are no rectangles or other objects in this area of the report.
> >
> > Is this a known bug?|||The size/position of the black rectangle is
top of the rectangle is level with the top of the table
bottom of the rectangle is level with the bottom of the table
right hand side of the rectangle is level with the right hand margin
left hand side starts where the table ends in the designer, where all
columns appear and none are hidden)
e.g.
M M
MTTTTTTTTTTTHHHBBBM
MTTTTTTTTTTTHHHBBBM
MTTTTTTTTTTTHHHBBBM
M M
where M is margin, T is table, H is hidden table, B is bloody annoying black
rectangle
I am using vs2005 sp1
"adolf garlic" wrote:
> Just to add, the rectangle is solid black and is the same height as the table
> appearing in the report.
> I took a copy of the report, deleted the table and the problem went away,
> but now I don't have a table...
> If I move the table up and down and redeploy, recreate PDF the black
> rectangle moves up and down, always in line with the table.
> If I move the table left and right, the size of the rectangle changes, when
> the table is pushed right up against the right hand side of the body the
> rectangle disappears.
> The table has dynamically hidden columns based on whether or not there is
> data to show. The black rectangle has not previously been a problem.
> I'm not sure what you mean by "have you included column 2". The report has
> more than 2 columns but there is only one table present. There are no other
> hidden or other objects to the right of the table.
> "Amarnath" wrote:
> > By any chance, have you included column 2 as well, and a border, then you
> > will get this rectangles. check in the properties for column and the border
> > line for left,right etc... Just to make sure you have not done these things.
> >
> > Amarnath
> >
> > "adolf garlic" wrote:
> >
> > > I have suddenly started getting black rectangles appearing on the right hand
> > > side of PDF output.
> > >
> > > There are no rectangles or other objects in this area of the report.
> > >
> > > Is this a known bug?

Bizarre Stored Procedure Behavior

I have dozens of stored procedures, but one of them is suddenly behaving badly.

Basically, if the sp is run as a query (full text), it runs fine and finishes successfully, but if 'executed' (Exec [sp_name]) it fails, saying that one of the referenced tables doesn't exist. The really weird thing is that the table is created earlier in the same procedure and is recognized enough to allow an index to be created on it. But when it comes to an Update statement, forget it. The sp dies saying the object (table) is unrecognized. I have dropped and recreated it, tried everything I can think of.

Has anyone else experienced this? Any ideas what may be causing it?

I'm stumped.

Thanks!you do have the correct names on your command object of the update statement?