Showing posts with label single. Show all posts
Showing posts with label single. Show all posts

Monday, March 26, 2012

Formatting text within cell

I have multiple words within a single tablecell and need to be able to make one of them bold, not the entired contents of the tablecell, just one word within it. I can't find a way to do it.
Can anyone help me out?
Thanks.
As far as I am aware you can't differentially format text in a cell. Andrew Watt MVP - InfoPath wrote in message news:5fe80da2-bdd1-4e54-987d-31f576f8913c@.discussions.microsoft.com... >I have multiple words within a single tablecell and need to be able to
> make one of them bold, not the entired contents of the tablecell, just
> one word within it. I can't find a way to do it. >
> Can anyone help me out? >
> Thanks.|||I'm interested to see if that is possible, but all signs point to no. (maybe javascript injection or something?)sql

Friday, March 23, 2012

Formatting text in a single table cell

I have a two column report. However, in the footer, i'd like to present a
column similar too:
Total spent: $100
Total left: $1,230
So that the NUMBER values on the right are completely right justified, but
the text on the left is actually LEFT justified. Can this type of
formatting occurr within the same cell?
TIA,
--
Brian Grant
Senior Programmer
SI International
www.si-intl.comJustification is done on a per cell basis. What you can do is use a
rectangle that contains two textboxes for each row. This would allow you to
apply the justification as needed.
--
Bruce Johnson [MSFT]
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"G" <brian.grant@.si-intl-kc.com> wrote in message
news:%23Kh2U%237fEHA.3476@.tk2msftngp13.phx.gbl...
> I have a two column report. However, in the footer, i'd like to present a
> column similar too:
> Total spent: $100
> Total left: $1,230
> So that the NUMBER values on the right are completely right justified, but
> the text on the left is actually LEFT justified. Can this type of
> formatting occurr within the same cell?
> TIA,
> --
> Brian Grant
> Senior Programmer
> SI International
> www.si-intl.com
>

Wednesday, March 21, 2012

formatting issures using tables and mutiple matrixes

Hi. I have a report that pulls all info from a single dataset. However, one
field "type" contains either "a" or "b". I have two matrixes, One for the
description and count of type a and another for type b. I also have data
from the dataset that needs to be both before and after each matrix.
When i layout the tables and matrixes, I measure them EXACTLY next to each
other by adding the position of one item and the width of it to determin the
position of the next. Also put them all in a header of another table with
zero padding. I also make the cangrow and canshrink atrributes to false to
keep all my rows aligned.
No matter what I do, the report always comes out unaligned. I've tried
rectangles already and they didnt work either. sometimes the report will
break on the tables for x number of rows and break for the matrixes at y
number of rows.
Does anyone know how to make matrixes and tables line up side by side,
return the same number of rows per page (this hsould be a no brainer because
its getting its data from the same dataset and there are no forced breaks)
AND make sure all the rows are the same width to ensure what is really four
tables looks like one?
I can provied the rdl if anyone wants to see it.Sorry, forgot to mention. SQL2005, Reporting Services 2005
"cr" wrote:
> Hi. I have a report that pulls all info from a single dataset. However, one
> field "type" contains either "a" or "b". I have two matrixes, One for the
> description and count of type a and another for type b. I also have data
> from the dataset that needs to be both before and after each matrix.
> When i layout the tables and matrixes, I measure them EXACTLY next to each
> other by adding the position of one item and the width of it to determin the
> position of the next. Also put them all in a header of another table with
> zero padding. I also make the cangrow and canshrink atrributes to false to
> keep all my rows aligned.
> No matter what I do, the report always comes out unaligned. I've tried
> rectangles already and they didnt work either. sometimes the report will
> break on the tables for x number of rows and break for the matrixes at y
> number of rows.
> Does anyone know how to make matrixes and tables line up side by side,
> return the same number of rows per page (this hsould be a no brainer because
> its getting its data from the same dataset and there are no forced breaks)
> AND make sure all the rows are the same width to ensure what is really four
> tables looks like one?
> I can provied the rdl if anyone wants to see it.
>

Monday, March 12, 2012

Formatted text in report parameter

I want the user to add his/her own title and some text to the report which can be bold, different color etc. Can this be done via a single report parameter and are there any ways to do it?

Not out of the box. If you use SRS 2005, the ReportViewer controls (part of VS 2005) will allow you to show reports in any ASP.NET or Winforms application. Using the controls, you can hide the report parameters page and replace it with your own prompting logic. See www.gotreportviewer.com for more details.

If you use SRS 2000, you can achieve most of this by putting an iframe to the report server in your web page and include rc:Parameters=False to hide the parameters area. You web page would be responsible for parameters prompting and for feeding the values to the report server iframe. For ex: http://server/reportserver/?PathToTheReport&rc:Parameters=false&Param1=value1&Param2=Value2

Wednesday, March 7, 2012

Format Substring in Textbox

I have a textbox that's several lines in height. I want to put several lines
of text in one textbox to get single spacing. I don't want to use multiple
textboxes, as I have to push multiple textboxes so close together it looks
like a mess.
In the first line below, I actually need the static text "Caller" to be bold
and underlined. I can't even get bold to work using this approach. Any
suggestions on how to get the word "Caller" to be bold and underlined,
leaving the rest as normal text?
=Format("Caller", Style.Bold)
& controlchars.Newline
& Fields!Salutation.Value
& " " & Fields!FirstName.Value
& " " & Fields!LastName.Value & controlchars.Newline
& Fields!EStreetNumber.Value & " " & Fields!EStreet.Value
Thanks,
--
RandyHello Randy,
Thank you for your posting!
Unfortunatly, the format will apply on the whole textbox control. You could
not make the first line have different style with other lines.
One workaround of this issue is to use some third-party RichText control
instead of the textbox control.
Please note Microsoft is providing this information as a convenience to
you. Microsoft cannot make any representations regarding the quality,
safety, or suitability of any software or information found there.
Also, you could send your feedback to the product team.
http://connect.microsoft.com/SQLServer
Hope this information will be helpful and thank you for your understanding!
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications.
Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/subscriptions/support/default.aspx.
==================================================(This posting is provided "AS IS", with no warranties, and confers no
rights.)