How to use variables as a Counter?

While inserting data into a target table, I'm trying to populate a primary key ID field sequentially. For each record, the value of the primary key field needs to be incremented by one (a counter).

I've tried to use the RowCount transformation to store the values in a variable. I'm able to successfully do that; however, I don't know how to read or update the variable incrementally.

If someone knows how to perform this task, please let me know. I would greatly appreciate it.

I think this: http://www.sqlis.com/default.aspx?37 should do what you need.

As will this: http://www.sqlis.com/default.aspx?93

They both do the same thing. One uses script, one is a custom component.

-Jamie

|||

I used the script component and it does exactly what I need it to do.

Thanks, Jamie.

How to use Explicit mode ?

I read and tried many times, but I cannot successful build xml
my target xml as:
<Header>
<Body IsUpdate="Y">
<Name IsUpdate="Y">ABC Company</Name>
<Details>
<Line IsUpdate="Y">
<Feature IsUpdate="Y">Feature 1</Feature>
<Feature IsUpdate="N">Feature 2</Feature>
</Line>
</Details>
<Discount IsUpdate="Y">1120</Discount>
</Body>
</Header>
How to use Explicit Mode to build above XML?
From what table(s) is this xml being composed?
Peter DeBetta, MVP - SQL Server
http://sqlblog.com
"ABC" <abc@.abc.com> wrote in message
news:uYc0$stwHHA.3364@.TK2MSFTNGP02.phx.gbl...
>I read and tried many times, but I cannot successful build xml
> my target xml as:
> <Header>
> <Body IsUpdate="Y">
> <Name IsUpdate="Y">ABC Company</Name>
> <Details>
> <Line IsUpdate="Y">
> <Feature IsUpdate="Y">Feature 1</Feature>
> <Feature IsUpdate="N">Feature 2</Feature>
> </Line>
> </Details>
> <Discount IsUpdate="Y">1120</Discount>
> </Body>
> </Header>
> How to use Explicit Mode to build above XML?
>

How to use Explicit mode ?

I read and tried many times, but I cannot successful build xml
my target xml as:
<Header>
<Body IsUpdate="Y">
<Name IsUpdate="Y">ABC Company</Name>
<Details>
<Line IsUpdate="Y">
<Feature IsUpdate="Y">Feature 1</Feature>
<Feature IsUpdate="N">Feature 2</Feature>
</Line>
</Details>
<Discount IsUpdate="Y">1120</Discount>
</Body>
</Header>
How to use Explicit Mode to build above XML?From what table(s) is this xml being composed?
Peter DeBetta, MVP - SQL Server
http://sqlblog.com
--
"ABC" <abc@.abc.com> wrote in message
news:uYc0$stwHHA.3364@.TK2MSFTNGP02.phx.gbl...
>I read and tried many times, but I cannot successful build xml
> my target xml as:
> <Header>
> <Body IsUpdate="Y">
> <Name IsUpdate="Y">ABC Company</Name>
> <Details>
> <Line IsUpdate="Y">
> <Feature IsUpdate="Y">Feature 1</Feature>
> <Feature IsUpdate="N">Feature 2</Feature>
> </Line>
> </Details>
> <Discount IsUpdate="Y">1120</Discount>
> </Body>
> </Header>
> How to use Explicit Mode to build above XML?
>

How to use "TARGET" in "Jump to URL"

Is it possible to include HTML element "Target" in "Jump to URL"?
If it's possible how to do? Can show me any example code?
Cause I want the new report is open on the other frame not a new window.
Thanks for any help!
AngiThis might do what you want:
This is an example of a Jump to URL link I use. This causes Excel to come up
with the data in a separate window:
="javascript:void(window.open('" & Globals!ReportServerUrl &
"?/SomeFolder/SomeReport&ParamName=" & Parameters!ParamName.Value &
"&rs:Format=CSV&rc:Encoding=ASCII','_blank'))"
You have to have SP1 or greater installed.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"angi" <angi@.news.microsoft.com> wrote in message
news:e1oVn0uTGHA.5264@.TK2MSFTNGP10.phx.gbl...
> Is it possible to include HTML element "Target" in "Jump to URL"?
> If it's possible how to do? Can show me any example code?
> Cause I want the new report is open on the other frame not a new window.
> Thanks for any help!
> Angi
>|||Thanks for Bruce!
I knew this function and work well.
But I don't want to open the data in a separate window,
I want it opens in another frame on Homepage.
This is my code:
="javascript:void(window.open('" & Globals!ReportServerUrl &
"?/MOJBIS/MojBisLv2-Bu01Sc','_main'))"
'_main' is the frame's name.
The HTML Code as follow:
<frameset rows="64,*">
<frame name="Horizon" scrolling="no" noresize target="contents"
src="tframe.aspx">
<frameset cols="449,*">
<frame name="contents" target="main" src="http://pics.10026.com/?src=lframe.aspx">
<frame name="main" src="http://pics.10026.com/?src=rframe.aspx">
</frameset>
<noframes>
<body>
</body>
</noframes>
</frameset>
So, I want the report open on "rframe.aspx", and the frame name = "main".
Have any idea?
Thanks for help!
Angi
"Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> ¼¶¼g©ó¶l¥ó·s»D:eHiQ1$1TGHA.3192@.TK2MSFTNGP09.phx.gbl...
> This might do what you want:
> This is an example of a Jump to URL link I use. This causes Excel to come
> up with the data in a separate window:
> ="javascript:void(window.open('" & Globals!ReportServerUrl &
> "?/SomeFolder/SomeReport&ParamName=" & Parameters!ParamName.Value &
> "&rs:Format=CSV&rc:Encoding=ASCII','_blank'))"
> You have to have SP1 or greater installed.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "angi" <angi@.news.microsoft.com> wrote in message
> news:e1oVn0uTGHA.5264@.TK2MSFTNGP10.phx.gbl...
>> Is it possible to include HTML element "Target" in "Jump to URL"?
>> If it's possible how to do? Can show me any example code?
>> Cause I want the new report is open on the other frame not a new window.
>> Thanks for any help!
>> Angi
>|||I haven't done this. My guess would have been to put the frame name instead
of _blank. You tried _main, how about putting the work main with no
underscore?
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"angi" <angi@.news.microsoft.com> wrote in message
news:u8OGJqYUGHA.4864@.TK2MSFTNGP12.phx.gbl...
> Thanks for Bruce!
> I knew this function and work well.
> But I don't want to open the data in a separate window,
> I want it opens in another frame on Homepage.
> This is my code:
> ="javascript:void(window.open('" & Globals!ReportServerUrl &
> "?/MOJBIS/MojBisLv2-Bu01Sc','_main'))"
> '_main' is the frame's name.
> The HTML Code as follow:
> <frameset rows="64,*">
> <frame name="Horizon" scrolling="no" noresize target="contents"
> src="http://pics.10026.com/?src=tframe.aspx">
> <frameset cols="449,*">
> <frame name="contents" target="main" src="http://pics.10026.com/?src=lframe.aspx">
> <frame name="main" src="http://pics.10026.com/?src=rframe.aspx">
> </frameset>
> <noframes>
> <body>
> </body>
> </noframes>
> </frameset>
> So, I want the report open on "rframe.aspx", and the frame name = "main".
> Have any idea?
> Thanks for help!
> Angi
> "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com>
> ¼¶¼g©ó¶l¥ó·s»D:eHiQ1$1TGHA.3192@.TK2MSFTNGP09.phx.gbl...
>> This might do what you want:
>> This is an example of a Jump to URL link I use. This causes Excel to come
>> up with the data in a separate window:
>> ="javascript:void(window.open('" & Globals!ReportServerUrl &
>> "?/SomeFolder/SomeReport&ParamName=" & Parameters!ParamName.Value &
>> "&rs:Format=CSV&rc:Encoding=ASCII','_blank'))"
>> You have to have SP1 or greater installed.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "angi" <angi@.news.microsoft.com> wrote in message
>> news:e1oVn0uTGHA.5264@.TK2MSFTNGP10.phx.gbl...
>> Is it possible to include HTML element "Target" in "Jump to URL"?
>> If it's possible how to do? Can show me any example code?
>> Cause I want the new report is open on the other frame not a new window.
>> Thanks for any help!
>> Angi
>>
>|||Hi, Bruce,
Thank you very much.
I've done this, the code as follow...
="javascript:void(window.open('" & Globals!ReportServerUrl &
"?/MOJBIS/MojBisLv2-Bu01Sc','main'))"
Using underscore will open the new window!
Last, for "window.open" function there is a reference:
http://www.w3schools.com/htmldom/met_win_open.asp
Thanks again!
Angi
"Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> ¼¶¼g©ó¶l¥ó·s»D:%23CSU32aUGHA.776@.TK2MSFTNGP09.phx.gbl...
>I haven't done this. My guess would have been to put the frame name instead
>of _blank. You tried _main, how about putting the work main with no
>underscore?
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
>
> "angi" <angi@.news.microsoft.com> wrote in message
> news:u8OGJqYUGHA.4864@.TK2MSFTNGP12.phx.gbl...
>> Thanks for Bruce!
>> I knew this function and work well.
>> But I don't want to open the data in a separate window,
>> I want it opens in another frame on Homepage.
>> This is my code:
>> ="javascript:void(window.open('" & Globals!ReportServerUrl &
>> "?/MOJBIS/MojBisLv2-Bu01Sc','_main'))"
>> '_main' is the frame's name.
>> The HTML Code as follow:
>> <frameset rows="64,*">
>> <frame name="Horizon" scrolling="no" noresize target="contents"
>> src="http://pics.10026.com/?src=tframe.aspx">
>> <frameset cols="449,*">
>> <frame name="contents" target="main" src="http://pics.10026.com/?src=lframe.aspx">
>> <frame name="main" src="http://pics.10026.com/?src=rframe.aspx">
>> </frameset>
>> <noframes>
>> <body>
>> </body>
>> </noframes>
>> </frameset>
>> So, I want the report open on "rframe.aspx", and the frame name = "main".
>> Have any idea?
>> Thanks for help!
>> Angi
>> "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> ¼¶¼g©ó¶l¥ó·s»D:eHiQ1$1TGHA.3192@.TK2MSFTNGP09.phx.gbl...
>> This might do what you want:
>> This is an example of a Jump to URL link I use. This causes Excel to
>> come up with the data in a separate window:
>> ="javascript:void(window.open('" & Globals!ReportServerUrl &
>> "?/SomeFolder/SomeReport&ParamName=" & Parameters!ParamName.Value &
>> "&rs:Format=CSV&rc:Encoding=ASCII','_blank'))"
>> You have to have SP1 or greater installed.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "angi" <angi@.news.microsoft.com> wrote in message
>> news:e1oVn0uTGHA.5264@.TK2MSFTNGP10.phx.gbl...
>> Is it possible to include HTML element "Target" in "Jump to URL"?
>> If it's possible how to do? Can show me any example code?
>> Cause I want the new report is open on the other frame not a new
>> window.
>> Thanks for any help!
>> Angi
>>
>>
>