Thursday, March 29, 2012
embedded images in the report
report is deployed to the production server, the logo is not displayed in
the Report Manager.
What all steps are required to deploy reports with embedded images?
pls. help.
ThanksHi newmem,
I have had the same problem. I have found out that my IE 6.0 causes the
error in my case. After switching the IE options "check for newer version of
stored html pages" from "automatically" to "every visit to the page"
everything works fine...
your way: IE -> Internet Options > Settings
I identified the IE because every output format displays the company logo
correctly (PDF...) and only the default and html format was wrong...
Regards
Wolfgang Himmelsbach
"newmem" wrote:
> We have company logo stored as an "embedded image" in the rdl file. When the
> report is deployed to the production server, the logo is not displayed in
> the Report Manager.
> What all steps are required to deploy reports with embedded images?
> pls. help.
> Thanks
>
>sql
Wednesday, February 15, 2012
Editing table data in Query Analyzer
I open a table in Query Analyzer by right clicking on it and
selecting 'Open' and when the data is displayed in the view pane I
would like to be able to edit it. It seems however that tables marked
as read only (as shown on the top bar e.g. SQL Query Analyzer - [Open
Table ServerName.DBName.dbo.TableName(read-only)] ) can not be edited
whereas the one that do not have that attribute infront of the name I
can edit. Is there a way I can change the read only attribute of a
table so that I can edit data directly in the view pane?
Please let me know if there is !
Thanks a heap ! :)
Harkirat"harry" <i1073@.tamu.edu> wrote in message
news:1105726082.290783.48450@.f14g2000cwb.googlegro ups.com...
> Hi All !
> I open a table in Query Analyzer by right clicking on it and
> selecting 'Open' and when the data is displayed in the view pane I
> would like to be able to edit it. It seems however that tables marked
> as read only (as shown on the top bar e.g. SQL Query Analyzer - [Open
> Table ServerName.DBName.dbo.TableName(read-only)] ) can not be edited
> whereas the one that do not have that attribute infront of the name I
> can edit. Is there a way I can change the read only attribute of a
> table so that I can edit data directly in the view pane?
> Please let me know if there is !
> Thanks a heap ! :)
> Harkirat
I suspect your table has no primary key (which it normally should have) or
unique index. If there's no way to identify each row in the table then you
can't edit it because there's no way to know which row you're changing. You
can still use an UPDATE statement to modify the table data of course.
Simon|||Yesssssssssss !!! That was it !! Sure wouldn't have guessed that
one...:p
Thanks a heap Simon ! :-)
Harkirat
Simon Hayes wrote:
> "harry" <i1073@.tamu.edu> wrote in message
> news:1105726082.290783.48450@.f14g2000cwb.googlegro ups.com...
> > Hi All !
> > I open a table in Query Analyzer by right clicking on it and
> > selecting 'Open' and when the data is displayed in the view pane I
> > would like to be able to edit it. It seems however that tables
marked
> > as read only (as shown on the top bar e.g. SQL Query Analyzer -
[Open
> > Table ServerName.DBName.dbo.TableName(read-only)] ) can not be
edited
> > whereas the one that do not have that attribute infront of the name
I
> > can edit. Is there a way I can change the read only attribute of a
> > table so that I can edit data directly in the view pane?
> > Please let me know if there is !
> > Thanks a heap ! :)
> > Harkirat
> I suspect your table has no primary key (which it normally should
have) or
> unique index. If there's no way to identify each row in the table
then you
> can't edit it because there's no way to know which row you're
changing. You
> can still use an UPDATE statement to modify the table data of course.
> Simon