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?

How to find out what rows are not in a table

Hi

I have a problem where I must compair an import table with a local datatable and import rows that are missing and correct the rows that are different.

How to best do this?

I was hoping to avoid cursors

thanks

Walter

hi

what is simple is just refer to the database

and get the rows from current db and insert the sam in target database

use not in clause in source Db so u can take out the duplicates

I hope u ll be geting it right

TechiTawa

|||

walter_verhoeven wrote:

Hi

I have a problem where I must compair an import table with a local datatable and import rows that are missing and correct the rows that are different.

How to best do this?

I was hoping to avoid cursors

thanks

Walter

you need an upsert (update /insert) statement

unfortunately upsert is not a supported keyowrd in sql server right now but

there are work around.

see this links

http://sudheerpalyam.spaces.live.com/Blog/cns!1pKCMhBsSwPMevqFfdi-3JgQ!198.entry

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=58353

How to find missing records from tables involving composite primary keys

Table 1

Code	Quarter
500002	26
500002	27
500002	28
500002	28.5
500002	29

Table 2

Code	Qtr
500002	26
500002	27

I have these two identical tables with the columns CODE & Qtr being COMPOSITE PRIMARY KEYS

Can anybody help me with how to compare the two tables to find the records not present in Table 2

That is i need this result

Code	Quarter
500002	28
500002	28.5
500002	29

I have come up with this solution

select scrip_cd,Qtr,scrip_cd+Qtr from Table1 where
scrip_cd+Qtr not in (select scrip_cd+qtr as 'con' from Table2)

i need to know if there is some other way of doing the same

Thanks in Advance

Jacx

You can use the following query too...

Select
A.Code,
A.Quarter
From
[Table 1] A
Left Outer Join [Table 2] B on A.Code = B.Code And A.Quarter = B.Quarter
Where
B.Code is NULL

|||

Using NOT EXISTS is the fastest way to solve your problem. Use query below:

select t1.scrip_cd, t1.Qtr

from Table1 as t1

where not exists(

select * from Table2 as t2

where t2.scrip_cd = t1.scrip_cd and t2.Qtr = t1.Qtr

)