Partially Bold text and Justify?

I have put following expression in a textbox.
="My name is " + First(Fields!Brok_Name.Value, "myDataset")
I just want to Bold the Field value and not the word "My name is ".
I also want to justify the text Alignment, how can I ?
I am using Sql Server Reporting Service 2005.
Any idea please ?
Best Regards,
LuqmanLuqman,
I don't think multiple formatting within a single text box is supported. You
might be able to embed an html character in the string like this ...>="My
name is <B>" + First(Fields!Brok_Name.Value, "myDataset") + "</B>" ...never
tried it but maybe it will work?
I have always used 2 text boxes. One for the label "My name is " and another
for the field value. Then I right align the label and left align the field
value. As far as justifying the complete string "My name is " + Field ...not
sure if it is possible with different bold values?
luqman wrote:
>I have put following expression in a textbox.
>="My name is " + First(Fields!Brok_Name.Value, "myDataset")
>I just want to Bold the Field value and not the word "My name is ".
>I also want to justify the text Alignment, how can I ?
>I am using Sql Server Reporting Service 2005.
>Any idea please ?
>Best Regards,
>Luqman
--
Message posted via http://www.sqlmonster.com|||Hi,
The Html character <B> within the text is showing as text.
My expression is :
="My name is <B>" + First(Fields!Brok_Name.Value, "myDataset") + "</B>"
Output is :
My name is <B> luqman </B>
Am I missing something ?
Best Regards,
Luqman
"wnichols via SQLMonster.com" <u3357@.uwe> wrote in message
news:7829016629ac6@.uwe...
> Luqman,
> I don't think multiple formatting within a single text box is supported.
You
> might be able to embed an html character in the string like this ...>="My
> name is <B>" + First(Fields!Brok_Name.Value, "myDataset") + "</B>"
...never
> tried it but maybe it will work?
> I have always used 2 text boxes. One for the label "My name is " and
another
> for the field value. Then I right align the label and left align the
field
> value. As far as justifying the complete string "My name is " + Field
...not
> sure if it is possible with different bold values?
>
> luqman wrote:
> >I have put following expression in a textbox.
> >
> >="My name is " + First(Fields!Brok_Name.Value, "myDataset")
> >
> >I just want to Bold the Field value and not the word "My name is ".
> >
> >I also want to justify the text Alignment, how can I ?
> >
> >I am using Sql Server Reporting Service 2005.
> >
> >Any idea please ?
> >
> >Best Regards,
> >
> >Luqman
> --
> Message posted via http://www.sqlmonster.com
>|||Luqman,
It was just a shot in the dark...guess it did not work. I don't think it is
possible to have multiple formats within the same textbox.
luqman wrote:
>Hi,
>The Html character <B> within the text is showing as text.
>My expression is :
>="My name is <B>" + First(Fields!Brok_Name.Value, "myDataset") + "</B>"
>Output is :
>My name is <B> luqman </B>
>Am I missing something ?
>Best Regards,
>Luqman
>> Luqman,
>[quoted text clipped - 26 lines]
>> --
>> Message posted via http://www.sqlmonster.com
--
Message posted via http://www.sqlmonster.com|||Hi,
In case, the textbox does not support multiple formats, can we display RTF
Text inside a textbox, saved in a database.
Best Regards,
Luqman
"wnichols via SQLMonster.com" <u3357@.uwe> wrote in message
news:7834e5fdfd74f@.uwe...
> Luqman,
> It was just a shot in the dark...guess it did not work. I don't think it
is
> possible to have multiple formats within the same textbox.
>
> luqman wrote:
> >Hi,
> >
> >The Html character <B> within the text is showing as text.
> >
> >My expression is :
> >="My name is <B>" + First(Fields!Brok_Name.Value, "myDataset") + "</B>"
> >
> >Output is :
> >My name is <B> luqman </B>
> >
> >Am I missing something ?
> >
> >Best Regards,
> >
> >Luqman
> >
> >> Luqman,
> >>
> >[quoted text clipped - 26 lines]
> >> --
> >> Message posted via http://www.sqlmonster.com
> --
> Message posted via http://www.sqlmonster.com
>|||Luqman,
That's my extent of the knowledge on the subject...Sorry.
luqman wrote:
>Hi,
>In case, the textbox does not support multiple formats, can we display RTF
>Text inside a textbox, saved in a database.
>Best Regards,
>Luqman
>> Luqman,
>[quoted text clipped - 25 lines]
>> --
>> Message posted via http://www.sqlmonster.com
--
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server-reporting/200709/1|||On Sep 17, 10:55 am, "wnichols via SQLMonster.com" <u3357@.uwe> wrote:
> Luqman,
> That's my extent of the knowledge on the subject...Sorry.
> luqman wrote:
> >Hi,
> >In case, the textbox does not support multiple formats, can we display RTF
> >Text inside a textbox, saved in a database.
> >Best Regards,
> >Luqman
> >> Luqman,
> >[quoted text clipped - 25 lines]
> >> --
> >> Message posted viahttp://www.sqlmonster.com
> --
> Message posted via SQLMonster.comhttp://www.sqlmonster.com/Uwe/Forums.aspx/sql-server-reporting/200709/1
You can't do it in 2005. I saw a video on reporting services 2008,
and it's a new feature microsoft is adding. Below is some links on
it:
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=2122612&SiteID=1
http://sqljunkies.com/WebLog/sqlbi/archive/2007/06/07/35631.aspx

Partial formatting of textbox

Is it possible to format part of an expression in a textbox? I have this
expression which displays the parameter value(s) that are selected by the
user:
="Selected Region(s): " & Join(Parameters!paramRegion.Label,", ")
I wish to put "Selected Region(s): " in bold. I can use a second textbox in
bold "Selected Region(s): " and leave just the expression in the other one,
but I'm trying to do everything in a single textbox.
--
Thank you,
Alain Quesnel
alainsansspam@.logiquel.com
www.logiquel.comYou cannot do this in RS 2005 (rich text in a single textbox)
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Alain Quesnel" <alainsansspam@.logiquel.com> wrote in message
news:ON$sP4yQIHA.748@.TK2MSFTNGP04.phx.gbl...
> Is it possible to format part of an expression in a textbox? I have this
> expression which displays the parameter value(s) that are selected by the
> user:
> ="Selected Region(s): " & Join(Parameters!paramRegion.Label,", ")
> I wish to put "Selected Region(s): " in bold. I can use a second textbox
> in bold "Selected Region(s): " and leave just the expression in the other
> one, but I'm trying to do everything in a single textbox.
> --
> Thank you,
> Alain Quesnel
> alainsansspam@.logiquel.com
> www.logiquel.com
>

Part of textbox content in bold, is it possible ?

We're using reporting services 2000 sp2, i'd like to know if it is possible
to set in bold just part of the text in a textbox. We sometimes want ot
highlight a few words out of a sentence in our reports. We're mostly using
table controls to build the reports.
Thanks!That is not possible, would need to split into two or more textboxes.
Steve MunLeeuw
"/dev/null" <devnull@.discussions.microsoft.com> wrote in message
news:3F445BA7-11B8-40C4-B594-E1798A0351CA@.microsoft.com...
> We're using reporting services 2000 sp2, i'd like to know if it is
> possible
> to set in bold just part of the text in a textbox. We sometimes want ot
> highlight a few words out of a sentence in our reports. We're mostly
> using
> table controls to build the reports.
> Thanks!

parent child package with expressions

Hi there,

sorry if the message seems a bit garbled i cannot see the textbox properly with ie7/ff

anyways. the situation.

childpackage contains a loop-container. in there i use an ole-db-source with a variable

based on an expression. ie. "select * from foo where bar=" + len(@.[bar]) == 0 ? "initial" : @.[bar] + " and etc=1"

where bar is the variable that is set by the loop.

this works great.

however i need to call this package several times, only the expression is a tad different.

so i need a scripttask that sets the expression correctly, then i call the childpackage

and map the current-expression to the expression in childpackage.

how do i do that? or am i doing it wrong?

my script-task looks something like:

dts.Variable("theVar").Expression = " ""select * from foo where bar="" + len(@.[bar]) == 0 ? ""initial"" : @.[bar] + "" and etc=1"" "

in the childpackage i have a package-conf that maps thevar to thequery with target-object expression.nevermind this. i got it working now.

i had to assign it to a variable. that was passed via package-configuration to expression and then it works.

Parametrization of xsd:boolean RDL element

Hi,

I'm trying to parametrize <CanGrow> element of the TextBox. It has xsd:boolean type, so when i assign this element with a simple expression like this:

<CanGrow>=Parameters!CanGrow.Value<CanGrow>

I get the following error:

Deserialization failed: The 'http://schemas.microsoft.com/sqlserver/reporting/2005/01/reportdefinition:CanGrow' element has an invalid value according to its data type. Line 782, position 59.

because resulted XML doesn't satisfy RDL schema.

The same expression in <Hidden> element does'n involve the error, because <Hidden> has xsd:string type.

Is there any way to have xsd:boolean report element parametrized, but not hardcoded?

I've made no progress on this issue.

Could anybody explain me how to parametrize xs:boolean report elements?

Thanks.

|||Any ideas on this issue?|||

Per the RDL specification (http://www.microsoft.com/sql/technologies/reporting/rdlspec.mspx), the CanGrow element is a constant boolean value. Expressions are not supported for CanGrow.

-- Robert

|||Thaks, Robert!

But in this case why not to make all xsd:boolean RDL elements of type

xsd:string? By the way, some RDL element with true/false values already

are of xsd:string type (ex. <VisibilityType><Hidden>).

parameters not showing up in report manager

Hi,
My MAIN report jumps to REPORT1 using the "jump to report:" hyperlink
action of a textbox. REPORT1 has one parameter.
Every thing works fine except I would like to be able to change REPORT1
parameter after I execute it, but it does not display when in Report
Manager.
ie. I jump from MAIN report to REPORT1 passing parameter1="XXX".
REPORT1 displays fine. While in REPORT1, I would like to change
parameter1="ZZZ".
I am unable to do this in the Report Manager because it will not show up in
the parameter header of Report Manager when I jump from MAIN to REPORT1.
It will show up if I execute REPORT1 by itself.
How can I get REPORT1 parameter1 to display after I jump to it from the MAIN
report using the report manager?
I have checked "prompt user" of REPORT1 setup in Report Manager.
Thanks,
___________________________
Daniel J. Zaccarine
Hanford Bay Associates, Ltd.
___________________________You need to use jump to URL instead. (at least that is the only way I found
to do it). Note that you can use some of the global variables with the
expression builder to create this on the fly (so it changes with wherever it
is deployed.
http://servername/Reports/Pages/Report.aspx?ServerUrl=http://servername/ReportServer%3f/directoryname%252fReportName&Parameter1=blahblah&rc:Parameters=True
Bruce L-C
"Dan" <dan_zaccarine@.hanfordbay.com> wrote in message
news:uMzOo%23obEHA.2476@.TK2MSFTNGP09.phx.gbl...
> Hi,
> My MAIN report jumps to REPORT1 using the "jump to report:" hyperlink
> action of a textbox. REPORT1 has one parameter.
> Every thing works fine except I would like to be able to change REPORT1
> parameter after I execute it, but it does not display when in Report
> Manager.
> ie. I jump from MAIN report to REPORT1 passing parameter1="XXX".
> REPORT1 displays fine. While in REPORT1, I would like to change
> parameter1="ZZZ".
> I am unable to do this in the Report Manager because it will not show up
in
> the parameter header of Report Manager when I jump from MAIN to REPORT1.
> It will show up if I execute REPORT1 by itself.
> How can I get REPORT1 parameter1 to display after I jump to it from the
MAIN
> report using the report manager?
> I have checked "prompt user" of REPORT1 setup in Report Manager.
> Thanks,
> ___________________________
> Daniel J. Zaccarine
> Hanford Bay Associates, Ltd.
> ___________________________
>

Parameters in Page Header

I am trying to put my parameters in my page header.It do works fine.I am using a textbox to hold the value of my parameters.I use

= Join(Parameters!resourceParams.Label, ", ")

in my textbox expression.But my problem is,when there are too many values specified(because i am using a dropdown with multi select) the page header,overlaps the body of my report. The page header's text overlap the contents of my report body.What could be the reason or work around for this? Thanks guys

Make your text box the maximum height and width you want it to have and than select can grow = false..

If you keep the text left align.. No one will know that its very big.

Parameters are disabled

I've set three parameters in the reports. However, when it is deployed, the
three parameters (textbox & dropdown list) become disabled? Is there
anything that need to set to make it enable?
Please advise.On Dec 2, 10:12 pm, YeungTakYan
<YeungTak...@.discussions.microsoft.com> wrote:
> I've set three parameters in the reports. However, when it is deployed, the
> three parameters (textbox & dropdown list) become disabled? Is there
> anything that need to set to make it enable?
> Please advise.
Are you using a different datasource for the parameters than you are
for the report itself? If so, make sure that the datasource is
available in the Report Manager on the production server. Also, by
default, the datasource for the report when it is first deployed is
not set. You normally set it by selecting the Properties tab (I
believe it is) and then select Datasources and select the datasource
from the top. Hope this helps.
Regards,
Enrique Martinez
Sr. Software Consultant

Parameters and ReportViewer

I have a report in which I am trying to get a parameter to be displayed in a textbox. I have declared a parameter in my .rdlc called UserName and the expression in the textbox is as follows...

=Parameters!UserName.Value

With that said, I have code in the window containing my ReportViewer to set the parameters and run my report as shown below...

string UserName = "test";

List<ReportParameter> paramList = new List<ReportParameter>();

paramList.Add(new ReportParameter(UserName));

this.baseReportViewer.LocalReport.SetParameters(paramList);

this.baseReportViewer.RefreshReport();

With these things in mind, can anyone here provide me with a reason as to why my report on comes up with a message stating "An error occurred during local processing. One or more parameters required to run the report have not been specified." ?

If I remove the parameter and text box and strip out the code pertaining to the paramter in my window, the report runs without error.

Any ideas?

Answered my own question and it was a total noob mistake.

Assuming I have a parameter in my report named "UserName," the code in my form would need to look like the following...(I've highlighted the change in red)

string UserName = "test";

List<ReportParameter> paramList = new List<ReportParameter>();

paramList.Add(new ReportParameter("UserName", UserName));

this.baseReportViewer.LocalReport.SetParameters(paramList);

this.baseReportViewer.RefreshReport();

Parameters

My query is returning phonenumber,Name and Id.

In layout I have textbox.In Edit Expression,the parmeter is like First(phonenumber)

Why it is showing First(phonenumber).

YOu have to prefix your expression with the eual sign to evaluate expressions, e.g. =First(Phonenumer).

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de