Is there a session variable? Microsoft please help

Is there a way to access a session variable for the url in reporting services? This is hard to explain, but our internal users access our website and view reports via one url, while external users use a different url to view the website and reports. I used the jump to url in some of my reports, but I need the report to read which url they came in on so that it can jump to the correct url that I need it to. Has anyone done anything similar to this?Anyone have any ideas? I use "jump to url" in quite a few of our reports w/ the link that it is jumping to being different information on our website. Our internal users see our website on a different url than our external users, so in my jump to link I need to conditionally set whether they go to the one url or the other, but I have to determine how they came in to begin with to determine which one they jump to.

Is there a session variable?

Is there a way to access a session variable for the url in reporting services? This is hard to explain, but our internal users access our website and view reports via one url, while external users use a different url to view the website and reports. I used the jump to url in some of my reports, but I need the report to read which url they came in on so that it can jump to the correct url that I need it to. Has anyone done anything similar to this?Anyone have any ideas? I use "jump to url" in quite a few of our reports w/ the link that it is jumping to being different information on our website. Our internal users see our website on a different url than our external users, so in my jump to link I need to conditionally set whether they go to the one url or the other, but I have to determine how they came in to begin with to determine which one they jump to.

Is there a self-reference variable so I don't have to refer to a c

Is there a self-reference variable so I don't have to refer to a cell by it's
name? I'd like to do a "iif( self.value = nothing, "Silver","Transparent" )"
so I can do it on the whole table.
--
"Everyone knows something you don't know"On Jun 4, 1:11 pm, David Bienstock <davidleebspam-sq...@.yahoo.com>
wrote:
> Is there a self-reference variable so I don't have to refer to a cell by it's
> name? I'd like to do a "iif( self.value = nothing, "Silver","Transparent" )"
> so I can do it on the whole table.
> --
> "Everyone knows something you don't know"
If the table control cell references a single dataset field (which is
usually the case), you should be able to reference that field outside
the current cell (i.e., =iif(Fields!FieldName.Value = nothing,
"Silver", "Transparent"). That said, as far as I know, there is not a
way to reference the field as 'this.' or 'me.' or any of the like
realistically. Sorry that I could not be of greater assistance.
Regards,
Enrique Martinez
Sr. Software Consultant|||yes you can have
=iif (me.value < Parameters!<paramName>.value, option1, option2)
"David Bienstock" <davidleebspam-sqlrs@.yahoo.com> wrote in message
news:34038AF5-4553-4383-A229-25A86427D44C@.microsoft.com...
> Is there a self-reference variable so I don't have to refer to a cell by
> it's
> name? I'd like to do a "iif( self.value = nothing,
> "Silver","Transparent" )"
> so I can do it on the whole table.
> --
> "Everyone knows something you don't know"sql

Is my object variable empty?

Hallo!

I got an object variable. I used it in a “Recordset destination”.

How can I proof if it is empty?

Isnull(@.[Benutzer::MyVar]) does not work!

One thing you can do is to shred through it and pop up a message with each value.

http://www.sqlis.com/59.aspx

|||

I decided to use a count (Countrow) while populating my recordset. Then I can have access to the variable just like @.[Benutzer::Count] > 0 ? true : false

|||Good idea.|||Remember to mark a post as answered, even if you are the one who answered it...