Formatting Issues

Is there a way to create a report where the data appears vertically in
multiple "columns" with lines around each column and multiple fields in each
column of differing data lengths.
I can do this in Crystal Reports but can't seem to find a way to do it in SQL.
The problem is that the data in one column affects the data in another
column as far as the formatting columns. I get extra white space.
I can't concantenate all of the data together because I need to bold the
labels.
Here is what I want:
ColumnHeader1 ColumnHeader2
some data Label 1:
vs. This data will go past
other data one line
Label 2:
This data can also be
multiple lines
Here is what I get:
ColumnHeader1 ColumnHeader2
some data Label 1:
vs. This data will go past
one line
other data
Label 2:
This data can also be
multiple lines
Because the 2nd row in ColumnHeader2 is 2 lines it pushes the data in the
2nd row in ColumnHeader1 down 2 lines as well.
I have tried using tables, list boxes, and subreports. None of them work .
. . especially with trying to add lines around each column. The top line
will appear only on the first page and the bottom line only on the last page.
The left and right border lines also get messed up.On Dec 7, 5:14 pm, Orne <polysilly...@.yahoo.com> wrote:
> On Dec 7, 2:57 pm, Anonymous <Anonym...@.discussions.microsoft.com>
> wrote:
>
> > Is there a way to create a report where the data appears vertically in
> > multiple "columns" with lines around each column and multiple fields in each
> > column of differing data lengths.
> > I can do this in Crystal Reports but can't seem to find a way to do it in SQL.
> > The problem is that the data in one column affects the data in another
> > column as far as the formatting columns. I get extra white space.
> > I can't concantenate all of the data together because I need to bold the
> > labels.
> > Here is what I want:
> > ColumnHeader1 ColumnHeader2
> > some data Label 1:
> > vs. This data will go past
> > other data one line
> > Label 2:
> > This data can also be
> > multiple lines
> > Here is what I get:
> > ColumnHeader1 ColumnHeader2
> > some data Label 1:
> > vs. This data will go past
> > one line
> > other data
> > Label 2:
> > This data can also be
> > multiple lines
> > Because the 2nd row in ColumnHeader2 is 2 lines it pushes the data in the
> > 2nd row in ColumnHeader1 down 2 lines as well.
> > I have tried using tables, list boxes, and subreports. None of them work .
> > . . especially with trying to add lines around each column. The top line
> > will appear only on the first page and the bottom line only on the last page.
> > The left and right border lines also get messed up.
> Create two Rectangle objects side-by-side, then drag all of your
> Column 1 data into the left Rectangle, and drag all of the Column 2
> data into the right rectangle. Make sure that the two are Top
> aligned, and the right of the first rectangle is against the left of
> the second rectangle.
> Rectangles act like DIV tags in HTML, everything inside them will be
> rendered in its own space.
> -- Scott
I agree with Scott. I just wanted to mention that to add report based
columns, in case you don't know, you would do the following:
Click the Layout tab in BIDS >> select the Report drop-down at the top
>> select Report Properties... >> select the Layout tab >> select the
number of Columns and spacing between them.
Of course, if used in this scenario could yield negative formatting
results; however, it could be considered.
Regards,
Enrique Martinez
Sr. Software Consultant|||I created the rectangles but the report only shows the first record. Is
there something else I need to do or will this not work for what I want to do?
There are 53 records and the report should show 1 record per page.
"Orne" wrote:
> On Dec 7, 2:57 pm, Anonymous <Anonym...@.discussions.microsoft.com>
> wrote:
> > Is there a way to create a report where the data appears vertically in
> > multiple "columns" with lines around each column and multiple fields in each
> > column of differing data lengths.
> >
> > I can do this in Crystal Reports but can't seem to find a way to do it in SQL.
> >
> > The problem is that the data in one column affects the data in another
> > column as far as the formatting columns. I get extra white space.
> >
> > I can't concantenate all of the data together because I need to bold the
> > labels.
> >
> > Here is what I want:
> >
> > ColumnHeader1 ColumnHeader2
> > some data Label 1:
> > vs. This data will go past
> > other data one line
> >
> > Label 2:
> > This data can also be
> > multiple lines
> >
> > Here is what I get:
> >
> > ColumnHeader1 ColumnHeader2
> > some data Label 1:
> > vs. This data will go past
> > one line
> > other data
> > Label 2:
> > This data can also be
> > multiple lines
> >
> > Because the 2nd row in ColumnHeader2 is 2 lines it pushes the data in the
> > 2nd row in ColumnHeader1 down 2 lines as well.
> >
> > I have tried using tables, list boxes, and subreports. None of them work .
> > . . especially with trying to add lines around each column. The top line
> > will appear only on the first page and the bottom line only on the last page.
> > The left and right border lines also get messed up.
> Create two Rectangle objects side-by-side, then drag all of your
> Column 1 data into the left Rectangle, and drag all of the Column 2
> data into the right rectangle. Make sure that the two are Top
> aligned, and the right of the first rectangle is against the left of
> the second rectangle.
> Rectangles act like DIV tags in HTML, everything inside them will be
> rendered in its own space.
> -- Scott
>|||On Dec 10, 12:18 pm, Anonymous <Anonym...@.discussions.microsoft.com>
wrote:
> I created the rectangles but the report only shows the first record. Is
> there something else I need to do or will this not work for what I want to do?
> There are 53 records and the report should show 1 record per page.
>
> "Orne" wrote:
> > On Dec 7, 2:57 pm, Anonymous <Anonym...@.discussions.microsoft.com>
> > wrote:
> > > Is there a way to create a report where the data appears vertically in
> > > multiple "columns" with lines around each column and multiple fields in each
> > > column of differing data lengths.
> > > I can do this in Crystal Reports but can't seem to find a way to do it in SQL.
> > > The problem is that the data in one column affects the data in another
> > > column as far as the formatting columns. I get extra white space.
> > > I can't concantenate all of the data together because I need to bold the
> > > labels.
> > > Here is what I want:
> > > ColumnHeader1 ColumnHeader2
> > > some data Label 1:
> > > vs. This data will go past
> > > other data one line
> > > Label 2:
> > > This data can also be
> > > multiple lines
> > > Here is what I get:
> > > ColumnHeader1 ColumnHeader2
> > > some data Label 1:
> > > vs. This data will go past
> > > one line
> > > other data
> > > Label 2:
> > > This data can also be
> > > multiple lines
> > > Because the 2nd row in ColumnHeader2 is 2 lines it pushes the data in the
> > > 2nd row in ColumnHeader1 down 2 lines as well.
> > > I have tried using tables, list boxes, and subreports. None of them work .
> > > . . especially with trying to add lines around each column. The top line
> > > will appear only on the first page and the bottom line only on the last page.
> > > The left and right border lines also get messed up.
> > Create two Rectangle objects side-by-side, then drag all of your
> > Column 1 data into the left Rectangle, and drag all of the Column 2
> > data into the right rectangle. Make sure that the two are Top
> > aligned, and the right of the first rectangle is against the left of
> > the second rectangle.
> > Rectangles act like DIV tags in HTML, everything inside them will be
> > rendered in its own space.
> > -- Scott- Hide quoted text -
> - Show quoted text -
Oh, umm, I assumed you were using Table objects, not TextBox. The
table will repeat whatever is in its details section for every record
in your DataSet. Check the expression in your boxes; if it says
=First( Fields!... ) then it will only return the data in the first
record.
If you want one record per page, create a List object, and drag the
items into the list. right click on it and go to the List Properties,
and check the Page Break at end checkbox. I think that should create
your one record per page.
-- Scott|||On Dec 7, 2:57 pm, Anonymous <Anonym...@.discussions.microsoft.com>
wrote:
> Is there a way to create a report where the data appears vertically in
> multiple "columns" with lines around each column and multiple fields in each
> column of differing data lengths.
> I can do this in Crystal Reports but can't seem to find a way to do it in SQL.
> The problem is that the data in one column affects the data in another
> column as far as the formatting columns. I get extra white space.
> I can't concantenate all of the data together because I need to bold the
> labels.
> Here is what I want:
> ColumnHeader1 ColumnHeader2
> some data Label 1:
> vs. This data will go past
> other data one line
> Label 2:
> This data can also be
> multiple lines
> Here is what I get:
> ColumnHeader1 ColumnHeader2
> some data Label 1:
> vs. This data will go past
> one line
> other data
> Label 2:
> This data can also be
> multiple lines
> Because the 2nd row in ColumnHeader2 is 2 lines it pushes the data in the
> 2nd row in ColumnHeader1 down 2 lines as well.
> I have tried using tables, list boxes, and subreports. None of them work .
> . . especially with trying to add lines around each column. The top line
> will appear only on the first page and the bottom line only on the last page.
> The left and right border lines also get messed up.
Create two Rectangle objects side-by-side, then drag all of your
Column 1 data into the left Rectangle, and drag all of the Column 2
data into the right rectangle. Make sure that the two are Top
aligned, and the right of the first rectangle is against the left of
the second rectangle.
Rectangles act like DIV tags in HTML, everything inside them will be
rendered in its own space.
-- Scott

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.)