Showing posts with label back. Show all posts
Showing posts with label back. Show all posts

Monday, March 19, 2012

displaying report parameter names and values in a textbox

I'm trying to return the parameters used in a report in the report footer. Where it is no problem getting back the values I would also like to display the actual parameter name. However I haven't found a way to do that yet.
My hunch is this needs to be done with embedded code. If anyone has got the answer to this I'd be very glad if you could share it.
thanks a lot
Axe
From http://www.developmentnow.com/g/115_2004_7_0_21_0/sql-server-reporting-services.ht
Posted via DevelopmentNow.com Group
http://www.developmentnow.comUse Parameters!ParamName.Label
"Axel" wrote:
> I'm trying to return the parameters used in a report in the report footer. Where it is no problem getting back the values I would also like to display the actual parameter name. However I haven't found a way to do that yet.
> My hunch is this needs to be done with embedded code. If anyone has got the answer to this I'd be very glad if you could share it.
> thanks a lot
> Axel
> From http://www.developmentnow.com/g/115_2004_7_0_21_0/sql-server-reporting-services.htm
> Posted via DevelopmentNow.com Groups
> http://www.developmentnow.com
>

Friday, March 9, 2012

Displaying Encoded Characters

some special characters are saved in an encoded form. However reporting
services does not convert it back to the regular form when it retreives it
from the database, instead it would output get wierd characters.the code for keystrokes ALT 250 and others are whats being outputted not the
correct symbol.
"Marvin" wrote:
> some special characters are saved in an encoded form. However reporting
> services does not convert it back to the regular form when it retreives it
> from the database, instead it would output get wierd characters.

Saturday, February 25, 2012

Display User Name

We are looking at deploying SSRS. What I would like to do is display the
user on the home page. Something like:
Welcome Back, Russ Farris!
Is this possible?
Thanks,
RussHi Russ,
You can get the id of the person running the report from the user
collection (ck in books online for syntax). However ... that probably
wouldnt be the users name contained in the user id so you could then use that
to query a table to get the user's full name to display
"Russ Farris" wrote:
> We are looking at deploying SSRS. What I would like to do is display the
> user on the home page. Something like:
> Welcome Back, Russ Farris!
> Is this possible?
> Thanks,
> Russ