Showing posts with label linked. Show all posts
Showing posts with label linked. Show all posts

Wednesday, March 28, 2012

How to force linked rpt to open in new window?

This seems like such a simple thing, I must be missing something obvious. I have linked reports to view detail in my humongous main report, and I want them to open in their own windows for the sake of speed of navigation. How do I force a new window in Jump to URL?

Here you go: http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RSPROG/htm/rsp_prog_soapapi_dev_3i49.asp

|||

Thanks, I appreciate your answer, but I'm still left trying to figure out WHERE to put the html code. It would make sense that it should go in the main report's RDL, but the code for this hyperlink looks like this:

<Action>

<Drillthrough>

<ReportName>BusDev_Detail</ReportName>

<Parameters>

<Parameter Name="Who">

<Value>=Fields!tkinit.Value</Value>

</Parameter>

<Parameter Name="Begindate">

<Value>=Parameters!Begindate.Value</Value>

</Parameter>

<Parameter Name="Enddate">

<Value>=Parameters!Enddate.Value</Value>

</Parameter>

</Parameters>

</Drillthrough>

</Action>

So the <LinkTarget=blank> tag doesn't seem to go here. Can you point me in the right direction?

Friday, March 23, 2012

How to find version (build)

How do you find out what version of SQL 2000 you are running?
I need to load build 8.00.534 to solve my problem connecting using
linked servers with a Progress database as this is supposed to fix our
problem.
Thanks,
Tom.Hi,
Execute the below command from Query Analyzer:-
Select @.@.version
8.00.534 is for SP2 , after that install the patch for slammer worm as well.
Check the versions and build number in below site :-
http://www.krell-software.com/mssql-builds.htm
Thanks
Hari
MCDBA
"Thomas Scheiderich" <tfs@.deltanet.com> wrote in message
news:408DF32E.2040205@.deltanet.com...
> How do you find out what version of SQL 2000 you are running?
> I need to load build 8.00.534 to solve my problem connecting using
> linked servers with a Progress database as this is supposed to fix our
> problem.
> Thanks,
> Tom.
>|||SELECT @.@.VERSION ? http://www.aspfaq.com/2160
I strongly, strongly, strongly recommend using this build only for the
required time and only if you are installing it on an isolated machine. If
this build is exposed to the Internet, you are very likely to be complaining
of Slammer very soon...
--
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/
"Thomas Scheiderich" <tfs@.deltanet.com> wrote in message
news:408DF32E.2040205@.deltanet.com...
> How do you find out what version of SQL 2000 you are running?
> I need to load build 8.00.534 to solve my problem connecting using linked
> servers with a Progress database as this is supposed to fix our problem.
> Thanks,
> Tom.
>