Showing posts with label tool. Show all posts
Showing posts with label tool. Show all posts

Friday, March 30, 2012

I downloaded and installed SQLEXPR_ADV.EXE

This file is 240 Megabytes. What am I supposed to see on the start
menu after this is installed?
Is there a tool in here with which I can create a database?
in florida,
IanODepends on what you want to do. Go back to the download page:
http://msdn.microsoft.com/vstudio/express/sql/download/
and either download the Toolkit if you want the complete set of tools or
management studio Express if you just want to manage the relational database
part.
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
"iano" <IanONet@.gmail.com> wrote in message
news:1151882090.532700.166560@.75g2000cwc.googlegroups.com...
> This file is 240 Megabytes. What am I supposed to see on the start
> menu after this is installed?
> Is there a tool in here with which I can create a database?
> in florida,
> IanO
>

Wednesday, March 28, 2012

I don't see Database Maintenance Planner in my SQL Server Enterorise Manager

Strange..... Anyways, is it possible to add the tool for Database Maintenance Planner to the existing DB installation?

If so, how do I do that? Would someone please help me on this?

Thanks a lot in advance.

Chris.

Hi Chris. If you don't see it, that could mean you aren't logged in as a sysadmin, they are the only logins that are allowed to view/modify maintanence plans.

It should be visible under the Management node in Enterprise manager, then a node called 'Database Maintanence Plans'. You should never see it under a specific database if that's where you are looking, not sure from your post if that may be where you were headed...

As for adding it to an existing installation, that's not really something that ever would need to be done...it's part of all installations, so it should already exist if the installation was successfull to any degree.

HTH,

|||

Having read your kind explanation above, it really make sense!

With confidence backed by your explanation, I will look into the SQL installation (which I did not install myself) and login users on Monday.

Once again, thank you so so so much, Chad. I wish I could buy you a drink!

Chris,

|||No problem Chris, glad to help. Repost if you still continue to have issues finding it...I'd take that drink if I could too!sql

I dont have any backup of my database, but I have the mdf's and ldf's files

Im trying to recover my database using the mdf and ldf files.
I dont have any backup and i have recovered two of the mdf files using
a tool which "discovers" deleted files after hard drive formatting...
It sounds cool, isnt it...:?
Obviously, i get a "suspect" message when the server starts and the log
file says this kind of things:
=B7"Full Path\Name.MDF is not a primary database file." (This is one of
the files repaired using the magic tool.
=B7Error: 823, Severity: 24, State: 6
=B7"I/O error (torn page) detected during read at offset
0000000000000000 in file 'Full Pathi\Name2.mdf'... Name2.mdf is the
second file
=B7Device activation error. The physical file name 'Full Path\Name2.mdf'
may be incorrect.
When i try to execute the command "DBCC CHECKDB ('Database_Name') WITH
PHYSICAL_ONLY" i get the following message :
=B7Could not open FCB for invalid file ID 0 in database 'Logs'.
Do you have any ideas?=20
Thank you very much...:DSeems that the "magic" tool didnt work, database seem to be (physical)
corrupt.
Offset 0000000000000000 failure doent sounds good to me.
Jens Suessmeyer.
"in_the_middle" <mediodia@.gmail.com> schrieb im Newsbeitrag
news:1114002784.429829.178480@.f14g2000cwb.googlegroups.com...
Im trying to recover my database using the mdf and ldf files.
I dont have any backup and i have recovered two of the mdf files using
a tool which "discovers" deleted files after hard drive formatting...
It sounds cool, isnt it...:?
Obviously, i get a "suspect" message when the server starts and the log
file says this kind of things:
"Full Path\Name.MDF is not a primary database file." (This is one of
the files repaired using the magic tool.
Error: 823, Severity: 24, State: 6
"I/O error (torn page) detected during read at offset
0000000000000000 in file 'Full Pathi\Name2.mdf'... Name2.mdf is the
second file
Device activation error. The physical file name 'Full Path\Name2.mdf'
may be incorrect.
When i try to execute the command "DBCC CHECKDB ('Database_Name') WITH
PHYSICAL_ONLY" i get the following message :
Could not open FCB for invalid file ID 0 in database 'Logs'.
Do you have any ideas?
Thank you very much...:D|||I agree with Jens. You could try to open a case with MS support, but I have
little hope that they
can help you as the database files seem to be, at least partially, overwritt
en.
(I've listed one "repair/recovery" tool in my links page on my web site, but
I wouldn't have much
hope for that either...)
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"in_the_middle" <mediodia@.gmail.com> wrote in message
news:1114002784.429829.178480@.f14g2000cwb.googlegroups.com...
Im trying to recover my database using the mdf and ldf files.
I dont have any backup and i have recovered two of the mdf files using
a tool which "discovers" deleted files after hard drive formatting...
It sounds cool, isnt it...:?
Obviously, i get a "suspect" message when the server starts and the log
file says this kind of things:
"Full Path\Name.MDF is not a primary database file." (This is one of
the files repaired using the magic tool.
Error: 823, Severity: 24, State: 6
"I/O error (torn page) detected during read at offset
0000000000000000 in file 'Full Pathi\Name2.mdf'... Name2.mdf is the
second file
Device activation error. The physical file name 'Full Path\Name2.mdf'
may be incorrect.
When i try to execute the command "DBCC CHECKDB ('Database_Name') WITH
PHYSICAL_ONLY" i get the following message :
Could not open FCB for invalid file ID 0 in database 'Logs'.
Do you have any ideas?
Thank you very much...:D|||you mean MSSQLRecovery ... I have tried it... It found 0 corrupt
files...
The content of the tables is important...But it is more important for
me recovering the Schema...(tables, stored procedures, indexes)...Do
you know any other tool which can help me to do this?
Thank you in advanced!|||I'm afraid that MSSQLRecovery is the only tool I know of. Sorry... :-(
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"in_the_middle" <mediodia@.gmail.com> wrote in message
news:1114004870.150171.315500@.f14g2000cwb.googlegroups.com...
> you mean MSSQLRecovery ... I have tried it... It found 0 corrupt
> files...
> The content of the tables is important...But it is more important for
> me recovering the Schema...(tables, stored procedures, indexes)...Do
> you know any other tool which can help me to do this?
> Thank you in advanced!
>|||You've had it I'm afraid - the database is physically corrupt (i.e. the OS
can't read the file from the disk) right at the start. You may be able to
get a data recovery service to salvage raw data from the drive, but that's
your only hope in this kind of hardware failure - there's nothing Product
Support can do to help.
Good luck.
Paul Randal
Dev Lead, Microsoft SQL Server Storage Engine
This posting is provided "AS IS" with no warranties, and confers no rights.
"in_the_middle" <mediodia@.gmail.com> wrote in message
news:1114002784.429829.178480@.f14g2000cwb.googlegroups.com...
Im trying to recover my database using the mdf and ldf files.
I dont have any backup and i have recovered two of the mdf files using
a tool which "discovers" deleted files after hard drive formatting...
It sounds cool, isnt it...:?
Obviously, i get a "suspect" message when the server starts and the log
file says this kind of things:
"Full Path\Name.MDF is not a primary database file." (This is one of
the files repaired using the magic tool.
Error: 823, Severity: 24, State: 6
"I/O error (torn page) detected during read at offset
0000000000000000 in file 'Full Pathi\Name2.mdf'... Name2.mdf is the
second file
Device activation error. The physical file name 'Full Path\Name2.mdf'
may be incorrect.
When i try to execute the command "DBCC CHECKDB ('Database_Name') WITH
PHYSICAL_ONLY" i get the following message :
Could not open FCB for invalid file ID 0 in database 'Logs'.
Do you have any ideas?
Thank you very much...:D|||Thank you very much for all your attentionsql

I dont have any backup of my database, but I have the mdf's and ldf's files

Im trying to recover my database using the mdf and ldf files.
I dont have any backup and i have recovered two of the mdf files using
a tool which "discovers" deleted files after hard drive formatting...
It sounds cool, isnt it...:? :(
Obviously, i get a "suspect" message when the server starts and the log
file says this kind of things:
=B7"Full Path\Name.MDF is not a primary database file." (This is one of
the files repaired using the magic tool.
=B7Error: 823, Severity: 24, State: 6
=B7"I/O error (torn page) detected during read at offset
0000000000000000 in file 'Full Pathi\Name2.mdf'... Name2.mdf is the
second file
=B7Device activation error. The physical file name 'Full Path\Name2.mdf'
may be incorrect.
When i try to execute the command "DBCC CHECKDB ('Database_Name') WITH
PHYSICAL_ONLY" i get the following message :
=B7Could not open FCB for invalid file ID 0 in database 'Logs'.
Do you have any ideas? Thank you very much...:DSeems that the "magic" tool di´dn´t work, database seem to be (physical)
corrupt.
Offset 0000000000000000 failure doen´t sounds good to me.
Jens Suessmeyer.
"in_the_middle" <mediodia@.gmail.com> schrieb im Newsbeitrag
news:1114002784.429829.178480@.f14g2000cwb.googlegroups.com...
Im trying to recover my database using the mdf and ldf files.
I dont have any backup and i have recovered two of the mdf files using
a tool which "discovers" deleted files after hard drive formatting...
It sounds cool, isnt it...:? :(
Obviously, i get a "suspect" message when the server starts and the log
file says this kind of things:
·"Full Path\Name.MDF is not a primary database file." (This is one of
the files repaired using the magic tool.
·Error: 823, Severity: 24, State: 6
·"I/O error (torn page) detected during read at offset
0000000000000000 in file 'Full Pathi\Name2.mdf'... Name2.mdf is the
second file
·Device activation error. The physical file name 'Full Path\Name2.mdf'
may be incorrect.
When i try to execute the command "DBCC CHECKDB ('Database_Name') WITH
PHYSICAL_ONLY" i get the following message :
·Could not open FCB for invalid file ID 0 in database 'Logs'.
Do you have any ideas?
Thank you very much...:D|||I agree with Jens. You could try to open a case with MS support, but I have little hope that they
can help you as the database files seem to be, at least partially, overwritten.
(I've listed one "repair/recovery" tool in my links page on my web site, but I wouldn't have much
hope for that either...)
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"in_the_middle" <mediodia@.gmail.com> wrote in message
news:1114002784.429829.178480@.f14g2000cwb.googlegroups.com...
Im trying to recover my database using the mdf and ldf files.
I dont have any backup and i have recovered two of the mdf files using
a tool which "discovers" deleted files after hard drive formatting...
It sounds cool, isnt it...:? :(
Obviously, i get a "suspect" message when the server starts and the log
file says this kind of things:
·"Full Path\Name.MDF is not a primary database file." (This is one of
the files repaired using the magic tool.
·Error: 823, Severity: 24, State: 6
·"I/O error (torn page) detected during read at offset
0000000000000000 in file 'Full Pathi\Name2.mdf'... Name2.mdf is the
second file
·Device activation error. The physical file name 'Full Path\Name2.mdf'
may be incorrect.
When i try to execute the command "DBCC CHECKDB ('Database_Name') WITH
PHYSICAL_ONLY" i get the following message :
·Could not open FCB for invalid file ID 0 in database 'Logs'.
Do you have any ideas?
Thank you very much...:D|||you mean MSSQLRecovery ... I have tried it... It found 0 corrupt
files...:( :(
The content of the tables is important...But it is more important for
me recovering the Schema...(tables, stored procedures, indexes)...Do
you know any other tool which can help me to do this?
Thank you in advanced!|||I'm afraid that MSSQLRecovery is the only tool I know of. Sorry... :-(
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"in_the_middle" <mediodia@.gmail.com> wrote in message
news:1114004870.150171.315500@.f14g2000cwb.googlegroups.com...
> you mean MSSQLRecovery ... I have tried it... It found 0 corrupt
> files...:( :(
> The content of the tables is important...But it is more important for
> me recovering the Schema...(tables, stored procedures, indexes)...Do
> you know any other tool which can help me to do this?
> Thank you in advanced!
>|||You've had it I'm afraid - the database is physically corrupt (i.e. the OS
can't read the file from the disk) right at the start. You may be able to
get a data recovery service to salvage raw data from the drive, but that's
your only hope in this kind of hardware failure - there's nothing Product
Support can do to help.
Good luck.
--
Paul Randal
Dev Lead, Microsoft SQL Server Storage Engine
This posting is provided "AS IS" with no warranties, and confers no rights.
"in_the_middle" <mediodia@.gmail.com> wrote in message
news:1114002784.429829.178480@.f14g2000cwb.googlegroups.com...
Im trying to recover my database using the mdf and ldf files.
I dont have any backup and i have recovered two of the mdf files using
a tool which "discovers" deleted files after hard drive formatting...
It sounds cool, isnt it...:? :(
Obviously, i get a "suspect" message when the server starts and the log
file says this kind of things:
·"Full Path\Name.MDF is not a primary database file." (This is one of
the files repaired using the magic tool.
·Error: 823, Severity: 24, State: 6
·"I/O error (torn page) detected during read at offset
0000000000000000 in file 'Full Pathi\Name2.mdf'... Name2.mdf is the
second file
·Device activation error. The physical file name 'Full Path\Name2.mdf'
may be incorrect.
When i try to execute the command "DBCC CHECKDB ('Database_Name') WITH
PHYSICAL_ONLY" i get the following message :
·Could not open FCB for invalid file ID 0 in database 'Logs'.
Do you have any ideas?
Thank you very much...:D|||Thank you very much for all your attention

I dont have any backup of my database, but I have the mdf's and ldf's files

Im trying to recover my database using the mdf and ldf files.
I dont have any backup and i have recovered two of the mdf files using
a tool which "discovers" deleted files after hard drive formatting...
It sounds cool, isnt it...:?
Obviously, i get a "suspect" message when the server starts and the log
file says this kind of things:
=B7"Full Path\Name.MDF is not a primary database file." (This is one of
the files repaired using the magic tool.
=B7Error: 823, Severity: 24, State: 6
=B7"I/O error (torn page) detected during read at offset
0000000000000000 in file 'Full Pathi\Name2.mdf'... Name2.mdf is the
second file
=B7Device activation error. The physical file name 'Full Path\Name2.mdf'
may be incorrect.
When i try to execute the command "DBCC CHECKDB ('Database_Name') WITH
PHYSICAL_ONLY" i get the following message :
=B7Could not open FCB for invalid file ID 0 in database 'Logs'.
Do you have any ideas?=20
Thank you very much...:D
Seems that the "magic" tool didnt work, database seem to be (physical)
corrupt.
Offset 0000000000000000 failure doent sounds good to me.
Jens Suessmeyer.
"in_the_middle" <mediodia@.gmail.com> schrieb im Newsbeitrag
news:1114002784.429829.178480@.f14g2000cwb.googlegr oups.com...
Im trying to recover my database using the mdf and ldf files.
I dont have any backup and i have recovered two of the mdf files using
a tool which "discovers" deleted files after hard drive formatting...
It sounds cool, isnt it...:?
Obviously, i get a "suspect" message when the server starts and the log
file says this kind of things:
"Full Path\Name.MDF is not a primary database file." (This is one of
the files repaired using the magic tool.
Error: 823, Severity: 24, State: 6
"I/O error (torn page) detected during read at offset
0000000000000000 in file 'Full Pathi\Name2.mdf'... Name2.mdf is the
second file
Device activation error. The physical file name 'Full Path\Name2.mdf'
may be incorrect.
When i try to execute the command "DBCC CHECKDB ('Database_Name') WITH
PHYSICAL_ONLY" i get the following message :
Could not open FCB for invalid file ID 0 in database 'Logs'.
Do you have any ideas?
Thank you very much...:D
|||I agree with Jens. You could try to open a case with MS support, but I have little hope that they
can help you as the database files seem to be, at least partially, overwritten.
(I've listed one "repair/recovery" tool in my links page on my web site, but I wouldn't have much
hope for that either...)
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"in_the_middle" <mediodia@.gmail.com> wrote in message
news:1114002784.429829.178480@.f14g2000cwb.googlegr oups.com...
Im trying to recover my database using the mdf and ldf files.
I dont have any backup and i have recovered two of the mdf files using
a tool which "discovers" deleted files after hard drive formatting...
It sounds cool, isnt it...:?
Obviously, i get a "suspect" message when the server starts and the log
file says this kind of things:
"Full Path\Name.MDF is not a primary database file." (This is one of
the files repaired using the magic tool.
Error: 823, Severity: 24, State: 6
"I/O error (torn page) detected during read at offset
0000000000000000 in file 'Full Pathi\Name2.mdf'... Name2.mdf is the
second file
Device activation error. The physical file name 'Full Path\Name2.mdf'
may be incorrect.
When i try to execute the command "DBCC CHECKDB ('Database_Name') WITH
PHYSICAL_ONLY" i get the following message :
Could not open FCB for invalid file ID 0 in database 'Logs'.
Do you have any ideas?
Thank you very much...:D
|||you mean MSSQLRecovery ... I have tried it... It found 0 corrupt
files...
The content of the tables is important...But it is more important for
me recovering the Schema...(tables, stored procedures, indexes)...Do
you know any other tool which can help me to do this?
Thank you in advanced!
|||I'm afraid that MSSQLRecovery is the only tool I know of. Sorry... :-(
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"in_the_middle" <mediodia@.gmail.com> wrote in message
news:1114004870.150171.315500@.f14g2000cwb.googlegr oups.com...
> you mean MSSQLRecovery ... I have tried it... It found 0 corrupt
> files...
> The content of the tables is important...But it is more important for
> me recovering the Schema...(tables, stored procedures, indexes)...Do
> you know any other tool which can help me to do this?
> Thank you in advanced!
>
|||You've had it I'm afraid - the database is physically corrupt (i.e. the OS
can't read the file from the disk) right at the start. You may be able to
get a data recovery service to salvage raw data from the drive, but that's
your only hope in this kind of hardware failure - there's nothing Product
Support can do to help.
Good luck.
Paul Randal
Dev Lead, Microsoft SQL Server Storage Engine
This posting is provided "AS IS" with no warranties, and confers no rights.
"in_the_middle" <mediodia@.gmail.com> wrote in message
news:1114002784.429829.178480@.f14g2000cwb.googlegr oups.com...
Im trying to recover my database using the mdf and ldf files.
I dont have any backup and i have recovered two of the mdf files using
a tool which "discovers" deleted files after hard drive formatting...
It sounds cool, isnt it...:?
Obviously, i get a "suspect" message when the server starts and the log
file says this kind of things:
"Full Path\Name.MDF is not a primary database file." (This is one of
the files repaired using the magic tool.
Error: 823, Severity: 24, State: 6
"I/O error (torn page) detected during read at offset
0000000000000000 in file 'Full Pathi\Name2.mdf'... Name2.mdf is the
second file
Device activation error. The physical file name 'Full Path\Name2.mdf'
may be incorrect.
When i try to execute the command "DBCC CHECKDB ('Database_Name') WITH
PHYSICAL_ONLY" i get the following message :
Could not open FCB for invalid file ID 0 in database 'Logs'.
Do you have any ideas?
Thank you very much...:D
|||Thank you very much for all your attention

I dont have any backup of my database, but I have the mdfs and ldfs files

Im trying to recover my database using the mdf and ldf files.

I dont have any backup and i have recovered two of the mdf files using
a tool which "discovers" deleted files after hard drive formatting...
It sounds cool, isnt it...:? :(

Obviously, i get a "suspect" message when the server starts and the log
file says this kind of things:

"Full Path\Name.MDF is not a primary database file." (This is one of
the files repaired using the magic tool.

Error: 823, Severity: 24, State: 6

"I/O error (torn page) detected during read at offset
0000000000000000 in file 'Full Pathi\Name2.mdf'... Name2.mdf is the
second file

Device activation error. The physical file name 'Full Path\Name2.mdf'
may be incorrect.

When i try to execute the command "DBCC CHECKDB ('Database_Name') WITH
PHYSICAL_ONLY" i get the following message :
Could not open FCB for invalid file ID 0 in database 'Logs'.

Do you have any ideas?
Thank you very much...:DIt sounds like the files are probably damaged beyond repair, or at
least beyond the sort of repairs that you can do without help from
Microsoft. If the contents of the database are valuable enough, I would
call MS to see if they can help you to recover the data, otherwise
you'll probably have to recreate everything.

And (obviously) you should plan a backup/restore strategy and a source
control system for your database code, to prevent any similar problems
in the future.

Simon|||Probably, thats what i'll do (call Microsoft asking for help help
help...:D )...

I swear this is the first time i dont plan a backup/restore
strategy... The database was configured a long time ago and I didnt
realize to do it...but i promise ill do the next time...:D

Anyway, I have run the demo tool MSSQLRecovery. This program analyze a
mdf file and recovers corrupt data. It has checked the tables, stored
procedures, indexes, relationships... and says that everything is
OK...but it doesnt generate any report...

Do you know any tool which recovers tables, stored procedures using the
primary mdf file?

Thank you in advanced

Sunday, February 19, 2012

Hyperlink

How can I put a friendly name or tool tip on a hyperlink? This is the
link I use in my graph, but I would like it to display the value when I
hover.
Thanks.
="javascript:void(window.open('http://domain.com/userdatapopup.asp?Initials="
& Fields!soldby.Value & "','popup','width=400,height=200'))"John Geddes wrote:
> How can I put a friendly name or tool tip on a hyperlink? This is the
> link I use in my graph, but I would like it to display the value when I
> hover.
>
> Thanks.
> ="javascript:void(window.open('http://domain.com/userdatapopup.asp?Initials="
> & Fields!soldby.Value & "','popup','width=400,height=200'))"
>
Use the Title="my tool tip" attribute in the a href
EG <a href="http://links.10026.com/?link=#" title="Link to something">Link</a>|||Hi Tony,
Can U please Explain me where I need to put this code'
This can be put directly in the expression for the TextBox'
Thanks in Advance,
Chandra.
"Tony G" wrote:
> <a
> href="http://links.10026.com/?link=javascript:void(window.open('http://domain.com/userdatapopup.asp?Initials=
> & Fields!soldby.Value & "','popup','width=400,height=200'))" title="your
> text">link</a>
>
> John Geddes wrote:
> > I can put TITLE in the function?
> >
> > --
> >
> >
> >
> > John Geddes
> > jgeddes@.email.uophx.edu <mailto:jgeddes@.email.uophx.edu>
> > John.R.Geddes@.gmail.com <mailto:John.R.Geddes@.gmail.com>
> >
> >
> > "Tony G" <b6@.blueyonder.co.yuk> wrote in message news:b6@.blueyonder.co.yuk:
> > > John Geddes wrote:
> > > > How can I put a friendly name or tool tip on a hyperlink? This is the
> > > >
> > > > link I use in my graph, but I would like it to display the value when I
> > > >
> > > > hover.
> > > >
> > > >
> > > > Thanks.
> > > >
> > > >
> > > >
> > ="javascript:void(window.open('http://domain.com/userdatapopup.asp?Initials=
> > > > "
> > > > & Fields!soldby.Value & "','popup','width=400,height=200'))"
> > > >
> > >
> > >
> > > Use the Title="my tool tip" attribute in the a href
> > >
> > > EG <a href="http://links.10026.com/?link=#" title="Link to something">Link</a>
>|||Right mouse click on a textbox (or a field of a table control, etc),
properties, advanced, navigation tab, jump to URL.
(from memory so might be slightly different).
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Chandra" <Chandra@.discussions.microsoft.com> wrote in message
news:7F7942F6-F094-4DB4-B6D9-8F556BCB2460@.microsoft.com...
> Hi Tony,
> Can U please Explain me where I need to put this code'
> This can be put directly in the expression for the TextBox'
> Thanks in Advance,
> Chandra.
> "Tony G" wrote:
>> <a
>> href="http://links.10026.com/?link=javascript:void(window.open('http://domain.com/userdatapopup.asp?Initials=
>> & Fields!soldby.Value & "','popup','width=400,height=200'))" title="your
>> text">link</a>
>>
>> John Geddes wrote:
>> > I can put TITLE in the function?
>> >
>> > --
>> >
>> >
>> >
>> > John Geddes
>> > jgeddes@.email.uophx.edu <mailto:jgeddes@.email.uophx.edu>
>> > John.R.Geddes@.gmail.com <mailto:John.R.Geddes@.gmail.com>
>> >
>> >
>> > "Tony G" <b6@.blueyonder.co.yuk> wrote in message
>> > news:b6@.blueyonder.co.yuk:
>> > > John Geddes wrote:
>> > > > How can I put a friendly name or tool tip on a hyperlink? This is
>> > the
>> > > >
>> > > > link I use in my graph, but I would like it to display the value
>> > when I
>> > > >
>> > > > hover.
>> > > >
>> > > >
>> > > > Thanks.
>> > > >
>> > > >
>> > > >
>> > ="javascript:void(window.open('http://domain.com/userdatapopup.asp?Initials=
>> > > > "
>> > > > & Fields!soldby.Value & "','popup','width=400,height=200'))"
>> > > >
>> > >
>> > >
>> > > Use the Title="my tool tip" attribute in the a href
>> > >
>> > > EG <a href="http://links.10026.com/?link=#" title="Link to something">Link</a>|||I got the javascript to open up a window, however, I cannot pass paramaters
into the string. If the string is hard-coded then it works fine.
-tim
"Bruce L-C [MVP]" wrote:
> Right mouse click on a textbox (or a field of a table control, etc),
> properties, advanced, navigation tab, jump to URL.
> (from memory so might be slightly different).
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
>
> "Chandra" <Chandra@.discussions.microsoft.com> wrote in message
> news:7F7942F6-F094-4DB4-B6D9-8F556BCB2460@.microsoft.com...
> > Hi Tony,
> > Can U please Explain me where I need to put this code'
> > This can be put directly in the expression for the TextBox'
> >
> > Thanks in Advance,
> > Chandra.
> >
> > "Tony G" wrote:
> >
> >> <a
> >> href="http://links.10026.com/?link=javascript:void(window.open('http://domain.com/userdatapopup.asp?Initials=
> >> & Fields!soldby.Value & "','popup','width=400,height=200'))" title="your
> >> text">link</a>
> >>
> >>
> >> John Geddes wrote:
> >> > I can put TITLE in the function?
> >> >
> >> > --
> >> >
> >> >
> >> >
> >> > John Geddes
> >> > jgeddes@.email.uophx.edu <mailto:jgeddes@.email.uophx.edu>
> >> > John.R.Geddes@.gmail.com <mailto:John.R.Geddes@.gmail.com>
> >> >
> >> >
> >> > "Tony G" <b6@.blueyonder.co.yuk> wrote in message
> >> > news:b6@.blueyonder.co.yuk:
> >> > > John Geddes wrote:
> >> > > > How can I put a friendly name or tool tip on a hyperlink? This is
> >> > the
> >> > > >
> >> > > > link I use in my graph, but I would like it to display the value
> >> > when I
> >> > > >
> >> > > > hover.
> >> > > >
> >> > > >
> >> > > > Thanks.
> >> > > >
> >> > > >
> >> > > >
> >> > ="javascript:void(window.open('http://domain.com/userdatapopup.asp?Initials=
> >> > > > "
> >> > > > & Fields!soldby.Value & "','popup','width=400,height=200'))"
> >> > > >
> >> > >
> >> > >
> >> > > Use the Title="my tool tip" attribute in the a href
> >> > >
> >> > > EG <a href="http://links.10026.com/?link=#" title="Link to something">Link</a>
> >>
>
>