Combine Names

Hello.
A quick layout of what I am trying to do.
I have 3 fields in a table. There names are..
fname, lname and fullname.
What I would like to know is, how do I combine the first 2 fields to show
the results as the full name in the fullname field?
Is this possible. If so, can someone please explain.
Thank you so much.You can use a computed column, basically:
ALTER TABLE your_table DROP COLUMN fullname
ALTER TABLE your_table ADD fullname
AS fname + ' ' + lname
Jacco Schalkwijk
SQL Server MVP
"noixa1234" <noixa1234@.discussions.microsoft.com> wrote in message
news:300E0247-E903-44CD-A6AB-68A64D7489F5@.microsoft.com...
> Hello.
> A quick layout of what I am trying to do.
> I have 3 fields in a table. There names are..
> fname, lname and fullname.
> What I would like to know is, how do I combine the first 2 fields to show
> the results as the full name in the fullname field?
> Is this possible. If so, can someone please explain.
> Thank you so much.|||If the Fname and/or the Lname might be null, then you need to use the follow
ing
IsNull(FName+ ' ', '') + IsNull(LName, '')
If only the first name might be null then you can use
IsNull(FName+ ' ', '') + LName
Charly
"noixa1234" wrote:

> Hello.
> A quick layout of what I am trying to do.
> I have 3 fields in a table. There names are..
> fname, lname and fullname.
> What I would like to know is, how do I combine the first 2 fields to show
> the results as the full name in the fullname field?
> Is this possible. If so, can someone please explain.
> Thank you so much.|||Select FName, LName , FName + ' ' + LName as Fullname from <source table>
I assume FName and Lname are either char or varchar fields; you can simply
concatenate to create the full name.
regards,
Sarav...
"noixa1234" <noixa1234@.discussions.microsoft.com> wrote in message
news:300E0247-E903-44CD-A6AB-68A64D7489F5@.microsoft.com...
> Hello.
> A quick layout of what I am trying to do.
> I have 3 fields in a table. There names are..
> fname, lname and fullname.
> What I would like to know is, how do I combine the first 2 fields to show
> the results as the full name in the fullname field?
> Is this possible. If so, can someone please explain.
> Thank you so much.|||Here is an example:
use northwind
go
select employeeid, lastname, firstname
into dbo.t1
from dbo.employees
go
-- you do not need a computed column.
-- you can do the concatenation in a select statement
alter table dbo.t1
add fullname as lastname + ', ' + firstname
go
select * from dbo.t1
go
drop table dbo.t1
go
AMB
"noixa1234" wrote:

> Hello.
> A quick layout of what I am trying to do.
> I have 3 fields in a table. There names are..
> fname, lname and fullname.
> What I would like to know is, how do I combine the first 2 fields to show
> the results as the full name in the fullname field?
> Is this possible. If so, can someone please explain.
> Thank you so much.

Columns feature and page-break

I'm producing a report to be printed onto labels, and so am using the columns
feature in the layout.
I have a list around my textboxes displaying the data, and another list
surrounding this with a grouping and a page-break at the end of the group.
However the page-break is actually being rendered (into PDF) as a
column-break. That is, one group may finish half way down column 2 on page 1,
and then the next grup will start at the top of column 3 on page 1 instead of
column 1 of page 2.
If this is 'correct behaviour', does anyone know how I might effect a true
page-break?
Many thanks.
--
Mike StephenOn Mar 4, 4:38 am, Mike Stephen
<MikeStep...@.discussions.microsoft.com> wrote:
> I'm producing a report to be printed onto labels, and so am using the columns
> feature in the layout.
> I have a list around my textboxes displaying the data, and another list
> surrounding this with a grouping and a page-break at the end of the group.
> However the page-break is actually being rendered (into PDF) as a
> column-break. That is, one group may finish half way down column 2 on page 1,
> and then the next grup will start at the top of column 3 on page 1 instead of
> column 1 of page 2.
> If this is 'correct behaviour', does anyone know how I might effect a true
> page-break?
> Many thanks.
> --
> Mike Stephen
It seems like you might want to have the inner list control break
after a group as well. SSRS tends to be a little funny about rendering
columns when exported into PDF. Hope this is helpful. Sorry for the
delayed reply.
Regards,
Enrique Martinez
Sr. SQL Server Developer

Column Layout

I am just getting started with reportingservices and have it installed (SP2)
on my development machine (Win XP Pro SP2).
I created a simple report and set the layout to be 2 columns across.
It print previews as two columns in VS designer, but when viewing through
the report web interface, it only displays as a single column.
However, if I export it to PDF, it then renders the 2 columns correctly.
Is there a way to fix this?
Also, does anyone know of a news server that has this group on it, so it can
be accessed via Outlook Express?
It is not available on news.microsoft.com
TIAThe new group is located at msnews.microsoft.com .
Have you tried the sample reports to see if they work correctly?
"AVG" <AVG@.discussions.microsoft.com> wrote in message
news:72ED551C-4D61-4A5D-88F0-3402BFFA969E@.microsoft.com...
>I am just getting started with reportingservices and have it installed
>(SP2)
> on my development machine (Win XP Pro SP2).
> I created a simple report and set the layout to be 2 columns across.
> It print previews as two columns in VS designer, but when viewing through
> the report web interface, it only displays as a single column.
> However, if I export it to PDF, it then renders the 2 columns correctly.
> Is there a way to fix this?
> Also, does anyone know of a news server that has this group on it, so it
> can
> be accessed via Outlook Express?
> It is not available on news.microsoft.com
> TIA
>|||Thanks for the quick reply Mark. Outlook Express is much quicker than the
web interface.
The only sample report that does not work is the Foodmart. Apparently MS
forgot to include the datasource for it.
Anyway, none of the samples use the multiple column layout. They are all
single column.
I am not referring to simply two columns of data like productid and name. I
am referring to the columns property of the layout tab of the report
properties.
--
Alphonse Giambrone
Email: a-giam at customdatasolutions dot us
"Mark" <mis@.ifcfabricsnospam.com> wrote in message
news:ONsEgGNTFHA.2828@.TK2MSFTNGP10.phx.gbl...
> The new group is located at msnews.microsoft.com .
> Have you tried the sample reports to see if they work correctly?
> "AVG" <AVG@.discussions.microsoft.com> wrote in message
> news:72ED551C-4D61-4A5D-88F0-3402BFFA969E@.microsoft.com...
>>I am just getting started with reportingservices and have it installed
>>(SP2)
>> on my development machine (Win XP Pro SP2).
>> I created a simple report and set the layout to be 2 columns across.
>> It print previews as two columns in VS designer, but when viewing through
>> the report web interface, it only displays as a single column.
>> However, if I export it to PDF, it then renders the 2 columns correctly.
>> Is there a way to fix this?
>> Also, does anyone know of a news server that has this group on it, so it
>> can
>> be accessed via Outlook Express?
>> It is not available on news.microsoft.com
>> TIA
>|||I think this must be by design. Mine does the same, previews in 1 column but
exports & prints in multiple columns.
Maybe MSFT can comment.
"AVG" <NOSPAMa-giam@.example.invalid> wrote in message
news:emfUAQNTFHA.3696@.TK2MSFTNGP15.phx.gbl...
> Thanks for the quick reply Mark. Outlook Express is much quicker than the
> web interface.
> The only sample report that does not work is the Foodmart. Apparently MS
> forgot to include the datasource for it.
> Anyway, none of the samples use the multiple column layout. They are all
> single column.
> I am not referring to simply two columns of data like productid and name.
> I am referring to the columns property of the layout tab of the report
> properties.
> --
> Alphonse Giambrone
> Email: a-giam at customdatasolutions dot us
>
> "Mark" <mis@.ifcfabricsnospam.com> wrote in message
> news:ONsEgGNTFHA.2828@.TK2MSFTNGP10.phx.gbl...
>> The new group is located at msnews.microsoft.com .
>> Have you tried the sample reports to see if they work correctly?
>> "AVG" <AVG@.discussions.microsoft.com> wrote in message
>> news:72ED551C-4D61-4A5D-88F0-3402BFFA969E@.microsoft.com...
>>I am just getting started with reportingservices and have it installed
>>(SP2)
>> on my development machine (Win XP Pro SP2).
>> I created a simple report and set the layout to be 2 columns across.
>> It print previews as two columns in VS designer, but when viewing
>> through
>> the report web interface, it only displays as a single column.
>> However, if I export it to PDF, it then renders the 2 columns correctly.
>> Is there a way to fix this?
>> Also, does anyone know of a news server that has this group on it, so it
>> can
>> be accessed via Outlook Express?
>> It is not available on news.microsoft.com
>> TIA
>>
>|||I wouldn't mind so much if it did print correctly, but for me it does not
(except through the VS designer).
The only way I get the two columns (via reportserver) is to export to pdf.
Ok, Microsoft, any answers?
--
Alphonse Giambrone
Email: a-giam at customdatasolutions dot us
"Mark" <mis@.ifcfabricsnospam.com> wrote in message
news:%23hLRKkNTFHA.3308@.TK2MSFTNGP14.phx.gbl...
>I think this must be by design. Mine does the same, previews in 1 column
>but exports & prints in multiple columns.
> Maybe MSFT can comment.
> "AVG" <NOSPAMa-giam@.example.invalid> wrote in message
> news:emfUAQNTFHA.3696@.TK2MSFTNGP15.phx.gbl...
>> Thanks for the quick reply Mark. Outlook Express is much quicker than the
>> web interface.
>> The only sample report that does not work is the Foodmart. Apparently MS
>> forgot to include the datasource for it.
>> Anyway, none of the samples use the multiple column layout. They are all
>> single column.
>> I am not referring to simply two columns of data like productid and name.
>> I am referring to the columns property of the layout tab of the report
>> properties.
>> --
>> Alphonse Giambrone
>> Email: a-giam at customdatasolutions dot us
>>
>> "Mark" <mis@.ifcfabricsnospam.com> wrote in message
>> news:ONsEgGNTFHA.2828@.TK2MSFTNGP10.phx.gbl...
>> The new group is located at msnews.microsoft.com .
>> Have you tried the sample reports to see if they work correctly?
>> "AVG" <AVG@.discussions.microsoft.com> wrote in message
>> news:72ED551C-4D61-4A5D-88F0-3402BFFA969E@.microsoft.com...
>>I am just getting started with reportingservices and have it installed
>>(SP2)
>> on my development machine (Win XP Pro SP2).
>> I created a simple report and set the layout to be 2 columns across.
>> It print previews as two columns in VS designer, but when viewing
>> through
>> the report web interface, it only displays as a single column.
>> However, if I export it to PDF, it then renders the 2 columns
>> correctly.
>> Is there a way to fix this?
>> Also, does anyone know of a news server that has this group on it, so
>> it can
>> be accessed via Outlook Express?
>> It is not available on news.microsoft.com
>> TIA
>>
>>
>|||Multi-column layout is not supported in the HTML rendering extension.
--
Brian Welcker
Group Program Manager
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"AVG" <AVG@.discussions.microsoft.com> wrote in message
news:72ED551C-4D61-4A5D-88F0-3402BFFA969E@.microsoft.com...
>I am just getting started with reportingservices and have it installed
>(SP2)
> on my development machine (Win XP Pro SP2).
> I created a simple report and set the layout to be 2 columns across.
> It print previews as two columns in VS designer, but when viewing through
> the report web interface, it only displays as a single column.
> However, if I export it to PDF, it then renders the 2 columns correctly.
> Is there a way to fix this?
> Also, does anyone know of a news server that has this group on it, so it
> can
> be accessed via Outlook Express?
> It is not available on news.microsoft.com
> TIA
>|||Thanks Brian,
I am sure MS has a reason for it.
Is there any documentation available on features that are not supported in
the various rendering extensions?
One could waste a lot of time trying to figure things like this out.
--
Alphonse Giambrone
Email: a-giam at customdatasolutions dot us
"Brian Welcker [MSFT]" <bwelcker@.online.microsoft.com> wrote in message
news:%23c4zeEUTFHA.1040@.TK2MSFTNGP10.phx.gbl...
> Multi-column layout is not supported in the HTML rendering extension.
> --
> Brian Welcker
> Group Program Manager
> Microsoft SQL Server Reporting Services
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
> "AVG" <AVG@.discussions.microsoft.com> wrote in message
> news:72ED551C-4D61-4A5D-88F0-3402BFFA969E@.microsoft.com...
>>I am just getting started with reportingservices and have it installed
>>(SP2)
>> on my development machine (Win XP Pro SP2).
>> I created a simple report and set the layout to be 2 columns across.
>> It print previews as two columns in VS designer, but when viewing through
>> the report web interface, it only displays as a single column.
>> However, if I export it to PDF, it then renders the 2 columns correctly.
>> Is there a way to fix this?
>> Also, does anyone know of a news server that has this group on it, so it
>> can
>> be accessed via Outlook Express?
>> It is not available on news.microsoft.com
>> TIA
>|||There is a section in the docs but it is unfortunately not very complete.
I'll pass this suggestion to our doc team.
The reason it is not supported is that there is no easy way to calculate the
page size like there is on physical pages. I suppose we could take the
definition page breaks and cut it in half but this would result in different
sizes for each page.
--
Brian Welcker
Group Program Manager
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"AVG" <NOSPAMa-giam@.example.invalid> wrote in message
news:%23OYpquXTFHA.3840@.tk2msftngp13.phx.gbl...
> Thanks Brian,
> I am sure MS has a reason for it.
> Is there any documentation available on features that are not supported in
> the various rendering extensions?
> One could waste a lot of time trying to figure things like this out.
> --
> Alphonse Giambrone
> Email: a-giam at customdatasolutions dot us
>
> "Brian Welcker [MSFT]" <bwelcker@.online.microsoft.com> wrote in message
> news:%23c4zeEUTFHA.1040@.TK2MSFTNGP10.phx.gbl...
>> Multi-column layout is not supported in the HTML rendering extension.
>> --
>> Brian Welcker
>> Group Program Manager
>> Microsoft SQL Server Reporting Services
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>> "AVG" <AVG@.discussions.microsoft.com> wrote in message
>> news:72ED551C-4D61-4A5D-88F0-3402BFFA969E@.microsoft.com...
>>I am just getting started with reportingservices and have it installed
>>(SP2)
>> on my development machine (Win XP Pro SP2).
>> I created a simple report and set the layout to be 2 columns across.
>> It print previews as two columns in VS designer, but when viewing
>> through
>> the report web interface, it only displays as a single column.
>> However, if I export it to PDF, it then renders the 2 columns correctly.
>> Is there a way to fix this?
>> Also, does anyone know of a news server that has this group on it, so it
>> can
>> be accessed via Outlook Express?
>> It is not available on news.microsoft.com
>> TIA
>>
>

Column chart bug?

When I am designing a column chart, the chart looks exactly how I want
it to look in Layout view, but then changes in the Preview mode and
when viewed in Report Manager.
Specifically I want to do this:
In the chart Y axis tab, for the scale options:
Minimum .6
Maximum 1.3
Cross 1
The Layout looks correct - when Previewed the chart keeps starting at
the minimum of 0 (instead of the .6 minimum). Since my chart is to
show variance from 1 (below or above), this bug makes it useless (1 is
no longer centered in view - but is up near 1.3).
Any ideas or workarounds?
Thanks!Update: looks like if I use whole numbers, the chart behaves correctly. So -
I guess the question is, how can I use fractions to specify lower and upper
ranges? If I do go with whole numbers (multiply the data by 10) to get the
chart to look OK, can I change the displayed Y axis labels (by dividing them
by 10)?
"coldfact" wrote:
> When I am designing a column chart, the chart looks exactly how I want
> it to look in Layout view, but then changes in the Preview mode and
> when viewed in Report Manager.
> Specifically I want to do this:
> In the chart Y axis tab, for the scale options:
> Minimum .6
> Maximum 1.3
> Cross 1
> The Layout looks correct - when Previewed the chart keeps starting at
> the minimum of 0 (instead of the .6 minimum). Since my chart is to
> show variance from 1 (below or above), this bug makes it useless (1 is
> no longer centered in view - but is up near 1.3).
> Any ideas or workarounds?
> Thanks!
>|||Try this:
Minimum 0.6
Maximum 1.3
CrossAt 1.0
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"coldfact" <coldfact@.discussions.microsoft.com> wrote in message
news:E16862E2-6EBB-4422-A438-DD7EE8673F3F@.microsoft.com...
> Update: looks like if I use whole numbers, the chart behaves correctly.
So -
> I guess the question is, how can I use fractions to specify lower and
upper
> ranges? If I do go with whole numbers (multiply the data by 10) to get the
> chart to look OK, can I change the displayed Y axis labels (by dividing
them
> by 10)?
> "coldfact" wrote:
> > When I am designing a column chart, the chart looks exactly how I want
> > it to look in Layout view, but then changes in the Preview mode and
> > when viewed in Report Manager.
> >
> > Specifically I want to do this:
> > In the chart Y axis tab, for the scale options:
> > Minimum .6
> > Maximum 1.3
> > Cross 1
> >
> > The Layout looks correct - when Previewed the chart keeps starting at
> > the minimum of 0 (instead of the .6 minimum). Since my chart is to
> > show variance from 1 (below or above), this bug makes it useless (1 is
> > no longer centered in view - but is up near 1.3).
> >
> > Any ideas or workarounds?
> > Thanks!
> >|||Much thanks! It is the 1.0 (vs 1) that makes the difference...
:)
"Robert Bruckner [MSFT]" wrote:
> Try this:
> Minimum 0.6
> Maximum 1.3
> CrossAt 1.0
> --
> This posting is provided "AS IS" with no warranties, and confers no rights.
> "coldfact" <coldfact@.discussions.microsoft.com> wrote in message
> news:E16862E2-6EBB-4422-A438-DD7EE8673F3F@.microsoft.com...
> > Update: looks like if I use whole numbers, the chart behaves correctly.
> So -
> > I guess the question is, how can I use fractions to specify lower and
> upper
> > ranges? If I do go with whole numbers (multiply the data by 10) to get the
> > chart to look OK, can I change the displayed Y axis labels (by dividing
> them
> > by 10)?
> >
> > "coldfact" wrote:
> >
> > > When I am designing a column chart, the chart looks exactly how I want
> > > it to look in Layout view, but then changes in the Preview mode and
> > > when viewed in Report Manager.
> > >
> > > Specifically I want to do this:
> > > In the chart Y axis tab, for the scale options:
> > > Minimum .6
> > > Maximum 1.3
> > > Cross 1
> > >
> > > The Layout looks correct - when Previewed the chart keeps starting at
> > > the minimum of 0 (instead of the .6 minimum). Since my chart is to
> > > show variance from 1 (below or above), this bug makes it useless (1 is
> > > no longer centered in view - but is up near 1.3).
> > >
> > > Any ideas or workarounds?
> > > Thanks!
> > >
>
>|||Explanation: If at least one value of the axis settings is an integer, we
use a mode of the chart control to generate "nice" integer labels and not
default float labels like 0.05, 1.05, 2.05, etc. (which are determined based
on the minimum and maximum data point values of the chart).
If you really want float labels, make sure to either not specify values for
certain axis settings or specify them as float values rather than integer
values.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"coldfact" <coldfact@.discussions.microsoft.com> wrote in message
news:A3D8D209-6C1E-4930-B948-202466FDF30D@.microsoft.com...
> Much thanks! It is the 1.0 (vs 1) that makes the difference...
> :)
> "Robert Bruckner [MSFT]" wrote:
> > Try this:
> > Minimum 0.6
> > Maximum 1.3
> > CrossAt 1.0
> >
> > --
> > This posting is provided "AS IS" with no warranties, and confers no
rights.
> >
> > "coldfact" <coldfact@.discussions.microsoft.com> wrote in message
> > news:E16862E2-6EBB-4422-A438-DD7EE8673F3F@.microsoft.com...
> > > Update: looks like if I use whole numbers, the chart behaves
correctly.
> > So -
> > > I guess the question is, how can I use fractions to specify lower and
> > upper
> > > ranges? If I do go with whole numbers (multiply the data by 10) to get
the
> > > chart to look OK, can I change the displayed Y axis labels (by
dividing
> > them
> > > by 10)?
> > >
> > > "coldfact" wrote:
> > >
> > > > When I am designing a column chart, the chart looks exactly how I
want
> > > > it to look in Layout view, but then changes in the Preview mode and
> > > > when viewed in Report Manager.
> > > >
> > > > Specifically I want to do this:
> > > > In the chart Y axis tab, for the scale options:
> > > > Minimum .6
> > > > Maximum 1.3
> > > > Cross 1
> > > >
> > > > The Layout looks correct - when Previewed the chart keeps starting
at
> > > > the minimum of 0 (instead of the .6 minimum). Since my chart is to
> > > > show variance from 1 (below or above), this bug makes it useless (1
is
> > > > no longer centered in view - but is up near 1.3).
> > > >
> > > > Any ideas or workarounds?
> > > > Thanks!
> > > >
> >
> >
> >