Showing posts with label textbox. Show all posts
Showing posts with label textbox. Show all posts

Wednesday, March 28, 2012

I don't understand why is nothing is always evaluated to false

The following in one textbox of my report is always evaluated to false when the field package_pack_value and give an error in the str conversion function that follow saying the 'number' is nothing.


= iif ( Fields!Package_Pack_Value is Nothing, "<Null>", Str ( Fields!Package_Pack_Value.Value ) & " " & Fields!Package_Pack_Unit.Value )

I have read all the forum and search a whole day but nothing...

Maybe is the answer very stupid...

If anyone can help me it would be appreciatedCStr to convert
And try this
ISNULL(Fields!Package_Pack_Value)
|||IsNull is not defined in the Micorsoft.VisualBasic namespace and it give compiling error tryng to use it.

But you give me a part of the answer using CStr :


= iif ( CSTR(Fields!Package_Pack_Value.Value) = "", "<null>", CStr ( Fields!Package_Pack_Value.Value ) & " " & Fields!Package_Pack_Unit.Value )

This give well "<null>" when Fields!Package_Pack_Unit.Value is null.

Thank To you VectorR3|||

You need to use IsNothing(). We convert nulls to empty objects. Does this not work?

=iif ( IsNothing(Fields!Package_Pack_Value.Value), "<null>", CStr ( Fields!Package_Pack_Value.Value ) & " " & Fields!Package_Pack_Unit.Value )

sql

Friday, February 24, 2012

Hyperlink to send an Email

Hello,
I am looking for a way for users to click on a textbox and send an Email. I
got that to work if I set up 'On action' URL to
'mailto:myemail@.mycompany.com'. My problem is this email address is variable.
If a user clicks next to A then Email should go to A@.myemail.com and if they
click next to B email should go to B@.myemail.com so on and so forth. I have A
and B here is value in my field MYFIELD. I tried using
mailto:Fields!MYFIELD.value that won't work.
Any ideas will be appreciated.
Thanks.Hi,
You can use the following expresion in the 'Jump to URL':
="mailto:" & Fields!MYFIELD.value
Use this with the equal sign and spaces. You can add
& "@.mycompany.com" if your field doesn't have the domain included
Jan Pieter Posthuma
"amitj" wrote:
> Hello,
> I am looking for a way for users to click on a textbox and send an Email. I
> got that to work if I set up 'On action' URL to
> 'mailto:myemail@.mycompany.com'. My problem is this email address is variable.
> If a user clicks next to A then Email should go to A@.myemail.com and if they
> click next to B email should go to B@.myemail.com so on and so forth. I have A
> and B here is value in my field MYFIELD. I tried using
> mailto:Fields!MYFIELD.value that won't work.
> Any ideas will be appreciated.
> Thanks.|||Thanks Jan. But that didn't work. It's not recongnising that URL. When I used
mailto:Fields!MYFIELD.value without = sign it recognised that as URL but
didn't add the field name.
"Jan Pieter Posthuma" wrote:
> Hi,
> You can use the following expresion in the 'Jump to URL':
> ="mailto:" & Fields!MYFIELD.value
> Use this with the equal sign and spaces. You can add
> & "@.mycompany.com" if your field doesn't have the domain included
> Jan Pieter Posthuma
>
> "amitj" wrote:
> > Hello,
> >
> > I am looking for a way for users to click on a textbox and send an Email. I
> > got that to work if I set up 'On action' URL to
> > 'mailto:myemail@.mycompany.com'. My problem is this email address is variable.
> > If a user clicks next to A then Email should go to A@.myemail.com and if they
> > click next to B email should go to B@.myemail.com so on and so forth. I have A
> > and B here is value in my field MYFIELD. I tried using
> > mailto:Fields!MYFIELD.value that won't work.
> >
> > Any ideas will be appreciated.
> >
> > Thanks.|||Hi,
You have to add also the qoutes (") and & symbols. You have to use the equal
(=) to let RS to calculate the field. The next part is a string "mailto:"
including the quotes. Then you concatenate by using the &-sign to the value
part: Fields!MYFIELD.value.
Totally will be: <code>="mailto:" & Fields!MYFIELD.value</code>
That will work.
Jan Pieter Posthuma
"amitj" wrote:
> Thanks Jan. But that didn't work. It's not recongnising that URL. When I used
> mailto:Fields!MYFIELD.value without = sign it recognised that as URL but
> didn't add the field name.
> "Jan Pieter Posthuma" wrote:
> > Hi,
> >
> > You can use the following expresion in the 'Jump to URL':
> > ="mailto:" & Fields!MYFIELD.value
> >
> > Use this with the equal sign and spaces. You can add
> > & "@.mycompany.com" if your field doesn't have the domain included
> >
> > Jan Pieter Posthuma
> >
> >
> > "amitj" wrote:
> >
> > > Hello,
> > >
> > > I am looking for a way for users to click on a textbox and send an Email. I
> > > got that to work if I set up 'On action' URL to
> > > 'mailto:myemail@.mycompany.com'. My problem is this email address is variable.
> > > If a user clicks next to A then Email should go to A@.myemail.com and if they
> > > click next to B email should go to B@.myemail.com so on and so forth. I have A
> > > and B here is value in my field MYFIELD. I tried using
> > > mailto:Fields!MYFIELD.value that won't work.
> > >
> > > Any ideas will be appreciated.
> > >
> > > Thanks.

Hyperlink section of TextBox?

Is it possible to hyperlink one word in the middle of a TextBox?
I could put an action on the TextBox, but don't want the hyperlink to cover
the entire paragraph. The output is in PDF, so I can't use an jscript
tricks.
Thanks,
GlenNo, this is not possible. Rich text, including formatting and links within
text, is on the list for a post SQL 2005 release.
--
Brian Welcker
Group Program Manager
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Glen" <glittle@.sunwaptasolutions.RemoveThis.com> wrote in message
news:%23b1MQZRSFHA.3144@.tk2msftngp13.phx.gbl...
> Is it possible to hyperlink one word in the middle of a TextBox?
> I could put an action on the TextBox, but don't want the hyperlink to
> cover the entire paragraph. The output is in PDF, so I can't use an
> jscript tricks.
> Thanks,
> Glen
>

Hyperlink report in new page..Urgent

I am working with two reports. The first reprot has a hyperlink to a textbox which opens a second report. This all works fine, but the when the hyperlink is clicked the second report open on top of the first report. I want the second report to open in a another seperate window, so that i can view two reports at the same time.

Can you please help me .. it's urgent.

Hi

try this I found it on Google

=void(window.open('" & Globals!ReportServerUrl & "?/Directory/ReportName&ParameterName=" & Parameters!ParameterName.Value & "&rs:Format=HTML4.0','_blank','resizable=yes'))"

it worked for me.

(you have to deploy it to test it)

|||

forgot.

use ="java_script: (before void, remove the _ )

="java_script:void(window.open('" & Globals!ReportServerUrl & "?/Directory/ReportName&ParameterName=" & Parameters!ParameterName.Value & "&rs:Format=HTML4.0','_blank','resizable=yes'))"

|||

I use

="java_script:void(window.open('" & "http://server06/ReportServer$Server062005" & "/Pages/ReportViewer.aspx?%2fAccount+Receivable%2fFinishGoodAtyAndNetModelType&Customer="& Fields!Customer.Value & "&Period=" & Fields!Period.Value & "&rs:Format=HTML4.0','_blank','resizable=yes'))"

but when clicking the link:

http://server06/ReportServer$Server062005?%2fAccount+Receivable%2fFinishGoodAtyAndNetModelType&Customer=HUONG+THUY&Period=200602&rs%3aFormat=HTML4.0%27%2c%27_blank%27%2c%27resizable%3dyes%27))

and web page display the error mesaage:

Reporting Services Error

An attempt has been made to use a rendering extension that is not registered for this report server. (rsRenderingExtensionNotFound) Get Online Help|||i tried

="java_script:void(window.open('" & Globals!ReportServerUrl & "?/Directory/ReportName&ParameterName=" & Parameters!ParameterName.Value & "&rs:Format=HTML4.0','_blank','resizable=yes'))"

with removing the "_" from java_script...

but stil it does not work..

i have the sp1 & sp2 intalled with hot fix..

please help

Hyperlink in the report

I want to display a hyperlink in the report. I browsed a little bit and found that the TextBox can be used as a hyperlink.
Under the Navigation tab in the selection "Jump To Url", I wrote http://www.microsoft.com.
It's taking me to microsoft site but its using up the existing window. How to open the site in a
different window.

And Just as an example Iam hardcoding the Url as microsoft.com. Can we also give this value
dynamically as one of the fields in the database.

the control where the report will run can be configured with "Target" so it will go to the window you want to,

The "Jump To Url" can be an expression that you program with data from your report and constants.

|||

I will be opening this report as pdf. So, when I click the link its going to the Url but using up an existing window, instead of opening in a new window.