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
