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

Tuesday, March 20, 2012

Bold within a textbox

I have a textbox on a report that i would like to have one word bolded, how do i do this?

ex: i want this word to be bold

thanks in advanceUnfortunately, this is not supported in the SQL 2000 or SQL 2005 version of Reporting Services. It is something we would like to add in a future release.

Bold inline Textbox

This feels like a question that has been asked 1000 times...I'm just not having much luck finding an answer.

I want to bold a single word in a Textbox on a RS2005 report. Is there a way to do this? The text is always bold. Like this:

By signing this document you accept our Terms and Conditions.

Thanks.
Brian

This feed may help.

http://blogs.msdn.com/bimusings/archive/2005/12/14/503648.aspx

There is no easy way to do this that I know of. Converting RTF to a bitmap is probably the only way. Otherwise you would need to display in a separate text box.

You may also want to take a look at Softartisians OfficeWriter.

cheers,

Andrew

Bold in a textbox ms-access

In my reports of MS-ACCESS I need to combine Bold in a textbox. I do not program in VB

so I would like something like this:

=Format([name],"bold" & " " & [lastname])

and the output shoul be

Mike Andersen

Is it posible to do?

no it isnt, ms-access doesnt support different styles in on textbox (as far as i know)

a little workaround would be to create 2 textboxes next to each other

the first bold, the second normal

sql

Bold in a textbox ms-access

In my reports of MS-ACCESS I need to combine Bold in a textbox. I do not program in VB

so I would like something like this:

=Format([name],"bold" & " " & [lastname])

and the output shoul be

Mike Andersen

Is it posible to do?

no it isnt, ms-access doesnt support different styles in on textbox (as far as i know)

a little workaround would be to create 2 textboxes next to each other

the first bold, the second normal

Friday, February 24, 2012

blank textbox is NOT null ..

This must be a common asp.net / sql server problem.
I only want to filter on the date when the filterdate textbox has a
value. Not sure if this is the best approach, but it does not appear to
be working.. I was hoping blank mean no filtering and all qualifying
rows returning
<asp:TextBox ID="DateFilter" runat="server"></asp:TextBox>
SelectCommand="SELECT * FROM [GEN_RouteInfo_vw] WHERE plancode =
@.plancode and RouteCode=@.RouteCode and CountryId=@.CountryId and
startdate <= IsNull(cast(@.DateFilter as datetime),cast('1/1/2999' as
datetime))and enddate >= IsNull(cast(@.DateFilter as
datetime),cast('1/1/1999' as datetime)) order by StartDate" >
<asp:ControlParameter ControlID="DateFilter" Name="DateFilter"
PropertyName="Text" Type="Datetime" />Hi
If you are going to dynamically create the SQL statement in you ASP then you
can omit the clause completely if no value is entered. If you are going to
use a stored procedure then check out
http://www.sommarskog.se/dyn-search.html and
http://www.sommarskog.se/dynamic_sql.html
John
"jobs" wrote:

> This must be a common asp.net / sql server problem.
> I only want to filter on the date when the filterdate textbox has a
> value. Not sure if this is the best approach, but it does not appear to
> be working.. I was hoping blank mean no filtering and all qualifying
> rows returning
> <asp:TextBox ID="DateFilter" runat="server"></asp:TextBox>
> SelectCommand="SELECT * FROM [GEN_RouteInfo_vw] WHERE plancode =
> @.plancode and RouteCode=@.RouteCode and CountryId=@.CountryId and
> startdate <= IsNull(cast(@.DateFilter as datetime),cast('1/1/2999' as
> datetime))and enddate >= IsNull(cast(@.DateFilter as
> datetime),cast('1/1/1999' as datetime)) order by StartDate" >
> <asp:ControlParameter ControlID="DateFilter" Name="DateFilter"
> PropertyName="Text" Type="Datetime" />
>

blank textbox is NOT null ..

This must be a common asp.net / sql server problem.
I only want to filter on the date when the filterdate textbox has a
value. Not sure if this is the best approach, but it does not appear to
be working.. I was hoping blank mean no filtering and all qualifying
rows returning
<asp:TextBox ID="DateFilter" runat="server"></asp:TextBox>
SelectCommand="SELECT * FROM [GEN_RouteInfo_vw] WHERE plancode =
@.plancode and RouteCode=@.RouteCode and CountryId=@.CountryId and
startdate <= IsNull(cast(@.DateFilter as datetime),cast('1/1/2999' as
datetime))and enddate >= IsNull(cast(@.DateFilter as
datetime),cast('1/1/1999' as datetime)) order by StartDate" >
<asp:ControlParameter ControlID="DateFilter" Name="DateFilter"
PropertyName="Text" Type="Datetime" />
Hi
If you are going to dynamically create the SQL statement in you ASP then you
can omit the clause completely if no value is entered. If you are going to
use a stored procedure then check out
http://www.sommarskog.se/dyn-search.html and
http://www.sommarskog.se/dynamic_sql.html
John
"jobs" wrote:

> This must be a common asp.net / sql server problem.
> I only want to filter on the date when the filterdate textbox has a
> value. Not sure if this is the best approach, but it does not appear to
> be working.. I was hoping blank mean no filtering and all qualifying
> rows returning
> <asp:TextBox ID="DateFilter" runat="server"></asp:TextBox>
> SelectCommand="SELECT * FROM [GEN_RouteInfo_vw] WHERE plancode =
> @.plancode and RouteCode=@.RouteCode and CountryId=@.CountryId and
> startdate <= IsNull(cast(@.DateFilter as datetime),cast('1/1/2999' as
> datetime))and enddate >= IsNull(cast(@.DateFilter as
> datetime),cast('1/1/1999' as datetime)) order by StartDate" >
> <asp:ControlParameter ControlID="DateFilter" Name="DateFilter"
> PropertyName="Text" Type="Datetime" />
>

blank textbox is NOT null ..

This must be a common asp.net / sql server problem.
I only want to filter on the date when the filterdate textbox has a
value. Not sure if this is the best approach, but it does not appear to
be working.. I was hoping blank mean no filtering and all qualifying
rows returning
<asp:TextBox ID="DateFilter" runat="server"></asp:TextBox>
SelectCommand="SELECT * FROM [GEN_RouteInfo_vw] WHERE plancode = @.plancode and RouteCode=@.RouteCode and CountryId=@.CountryId and
startdate <= IsNull(cast(@.DateFilter as datetime),cast('1/1/2999' as
datetime))and enddate >= IsNull(cast(@.DateFilter as
datetime),cast('1/1/1999' as datetime)) order by StartDate" >
<asp:ControlParameter ControlID="DateFilter" Name="DateFilter"
PropertyName="Text" Type="Datetime" />Hi
If you are going to dynamically create the SQL statement in you ASP then you
can omit the clause completely if no value is entered. If you are going to
use a stored procedure then check out
http://www.sommarskog.se/dyn-search.html and
http://www.sommarskog.se/dynamic_sql.html
John
"jobs" wrote:
> This must be a common asp.net / sql server problem.
> I only want to filter on the date when the filterdate textbox has a
> value. Not sure if this is the best approach, but it does not appear to
> be working.. I was hoping blank mean no filtering and all qualifying
> rows returning
> <asp:TextBox ID="DateFilter" runat="server"></asp:TextBox>
> SelectCommand="SELECT * FROM [GEN_RouteInfo_vw] WHERE plancode => @.plancode and RouteCode=@.RouteCode and CountryId=@.CountryId and
> startdate <= IsNull(cast(@.DateFilter as datetime),cast('1/1/2999' as
> datetime))and enddate >= IsNull(cast(@.DateFilter as
> datetime),cast('1/1/1999' as datetime)) order by StartDate" >
> <asp:ControlParameter ControlID="DateFilter" Name="DateFilter"
> PropertyName="Text" Type="Datetime" />
>

Thursday, February 16, 2012

Blank page?

In my report I have 4 lists. In the each list I have textbox (Company Name)
And matrix. Each list shows in separate page. So basically if I view report
I have 4 pages.
The problem is.
For example, If in my report parameter, which is â'Group Nameâ'
(A, B, C and D) I unselect 2 groups then I should have 2 pages but I have
still 4 pages and 2 pages is blank. How can I remove that blank pages?
I used matrix in the list to able to view each matrix in separate pages.
Thank you.On Mar 28, 1:54 pm, JT <J...@.discussions.microsoft.com> wrote:
> In my report I have 4 lists. In the each list I have textbox (Company Name)
> And matrix. Each list shows in separate page. So basically if I view report
> I have 4 pages.
> The problem is.
> For example, If in my report parameter, which is 'Group Name'
> (A, B, C and D) I unselect 2 groups then I should have 2 pages but I have
> still 4 pages and 2 pages is blank. How can I remove that blank pages?
> I used matrix in the list to able to view each matrix in separate pages.
> Thank you.
I don't work with lists often but if I were trying to do here is where
I'd start.
Try conditioning the visibility properties of your lists.
Insert an expression into the Visibility>Hidden property of the
individual lists. For the Group Name A list, try something like:
=IIF(InStr(Parameter!GroupName.Value,"A") > 0, False,True)
You may need to fiddle with the syntax some but what you're trying to
get at is
"If A is found in the Group Name param
then show the List
otherwise hide the List"
If needed, the namespace is Microsoft.VisualBasic.
If lists work like tables and other report items, the non-hidden ones
should move up and fill the white space left by the hidden ones.
HTH
toolman|||I do not have problem to hide my lists. If i unselect 2 groups it will hide
the lists but leaves the 2 blank pages. I need to remove these blank pages.
"toolman" wrote:
> On Mar 28, 1:54 pm, JT <J...@.discussions.microsoft.com> wrote:
> > In my report I have 4 lists. In the each list I have textbox (Company Name)
> > And matrix. Each list shows in separate page. So basically if I view report
> > I have 4 pages.
> > The problem is.
> > For example, If in my report parameter, which is 'Group Name'
> > (A, B, C and D) I unselect 2 groups then I should have 2 pages but I have
> > still 4 pages and 2 pages is blank. How can I remove that blank pages?
> > I used matrix in the list to able to view each matrix in separate pages.
> >
> > Thank you.
> I don't work with lists often but if I were trying to do here is where
> I'd start.
> Try conditioning the visibility properties of your lists.
> Insert an expression into the Visibility>Hidden property of the
> individual lists. For the Group Name A list, try something like:
> =IIF(InStr(Parameter!GroupName.Value,"A") > 0, False,True)
> You may need to fiddle with the syntax some but what you're trying to
> get at is
> "If A is found in the Group Name param
> then show the List
> otherwise hide the List"
> If needed, the namespace is Microsoft.VisualBasic.
> If lists work like tables and other report items, the non-hidden ones
> should move up and fill the white space left by the hidden ones.
> HTH
> toolman
>|||Try to adjust the canvas size in layout to match the report width and height
in Report Properties.
Thanks,
"JT" wrote:
> I do not have problem to hide my lists. If i unselect 2 groups it will hide
> the lists but leaves the 2 blank pages. I need to remove these blank pages.
>
> "toolman" wrote:
> > On Mar 28, 1:54 pm, JT <J...@.discussions.microsoft.com> wrote:
> > > In my report I have 4 lists. In the each list I have textbox (Company Name)
> > > And matrix. Each list shows in separate page. So basically if I view report
> > > I have 4 pages.
> > > The problem is.
> > > For example, If in my report parameter, which is 'Group Name'
> > > (A, B, C and D) I unselect 2 groups then I should have 2 pages but I have
> > > still 4 pages and 2 pages is blank. How can I remove that blank pages?
> > > I used matrix in the list to able to view each matrix in separate pages.
> > >
> > > Thank you.
> >
> > I don't work with lists often but if I were trying to do here is where
> > I'd start.
> >
> > Try conditioning the visibility properties of your lists.
> >
> > Insert an expression into the Visibility>Hidden property of the
> > individual lists. For the Group Name A list, try something like:
> > =IIF(InStr(Parameter!GroupName.Value,"A") > 0, False,True)
> > You may need to fiddle with the syntax some but what you're trying to
> > get at is
> > "If A is found in the Group Name param
> > then show the List
> > otherwise hide the List"
> > If needed, the namespace is Microsoft.VisualBasic.
> >
> > If lists work like tables and other report items, the non-hidden ones
> > should move up and fill the white space left by the hidden ones.
> >
> > HTH
> > toolman
> >|||Each list shows in separate pages but if is one list unselected (For exmp:
group A - from report parameter) then it should not show the 1 page. Instead
of that I do have the blank page. How to remove the blank page?
"naren" wrote:
> Try to adjust the canvas size in layout to match the report width and height
> in Report Properties.
> Thanks,
> "JT" wrote:
> > I do not have problem to hide my lists. If i unselect 2 groups it will hide
> > the lists but leaves the 2 blank pages. I need to remove these blank pages.
> >
> >
> > "toolman" wrote:
> >
> > > On Mar 28, 1:54 pm, JT <J...@.discussions.microsoft.com> wrote:
> > > > In my report I have 4 lists. In the each list I have textbox (Company Name)
> > > > And matrix. Each list shows in separate page. So basically if I view report
> > > > I have 4 pages.
> > > > The problem is.
> > > > For example, If in my report parameter, which is 'Group Name'
> > > > (A, B, C and D) I unselect 2 groups then I should have 2 pages but I have
> > > > still 4 pages and 2 pages is blank. How can I remove that blank pages?
> > > > I used matrix in the list to able to view each matrix in separate pages.
> > > >
> > > > Thank you.
> > >
> > > I don't work with lists often but if I were trying to do here is where
> > > I'd start.
> > >
> > > Try conditioning the visibility properties of your lists.
> > >
> > > Insert an expression into the Visibility>Hidden property of the
> > > individual lists. For the Group Name A list, try something like:
> > > =IIF(InStr(Parameter!GroupName.Value,"A") > 0, False,True)
> > > You may need to fiddle with the syntax some but what you're trying to
> > > get at is
> > > "If A is found in the Group Name param
> > > then show the List
> > > otherwise hide the List"
> > > If needed, the namespace is Microsoft.VisualBasic.
> > >
> > > If lists work like tables and other report items, the non-hidden ones
> > > should move up and fill the white space left by the hidden ones.
> > >
> > > HTH
> > > toolman
> > >