Diplaying Values from fields on the Same Textbox

Hi,
Is it possible to display values from different fields in the same textbox.I
have a field that returns system generated IDs and a field that returns ID
values that have been manually input by the user.
I want values from these fields to display on the same textbox as they act
Product Id for Products that shown on the invoice report.
Does anyone know how I can achieve this?
Regards,
--
Noels
"The Best thing in life is life"You can do this either with the textbox or the query. Let's say you have a
field called sys_id and manual_id.
With a query:
select convert(varchar(15), sys_id) + ' ' + manual_id as product_id from
sometable where ...
That would be my preferred way of handling this.
The other way is to set the textbox to an expression and in the expression
concatenate the two fields.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Noels" <noels@.gmail.com> wrote in message
news:7528B73A-5EF9-4449-A85E-2F816282A148@.microsoft.com...
> Hi,
> Is it possible to display values from different fields in the same
> textbox.I
> have a field that returns system generated IDs and a field that returns ID
> values that have been manually input by the user.
> I want values from these fields to display on the same textbox as they act
> Product Id for Products that shown on the invoice report.
> Does anyone know how I can achieve this?
> Regards,
> --
> Noels
> "The Best thing in life is life"|||Thank you so much,why didnt I think of that!
Noels
"The Best thing in life is life"
"Bruce L-C [MVP]" wrote:
> You can do this either with the textbox or the query. Let's say you have a
> field called sys_id and manual_id.
> With a query:
> select convert(varchar(15), sys_id) + ' ' + manual_id as product_id from
> sometable where ...
> That would be my preferred way of handling this.
> The other way is to set the textbox to an expression and in the expression
> concatenate the two fields.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Noels" <noels@.gmail.com> wrote in message
> news:7528B73A-5EF9-4449-A85E-2F816282A148@.microsoft.com...
> > Hi,
> >
> > Is it possible to display values from different fields in the same
> > textbox.I
> > have a field that returns system generated IDs and a field that returns ID
> > values that have been manually input by the user.
> >
> > I want values from these fields to display on the same textbox as they act
> > Product Id for Products that shown on the invoice report.
> >
> > Does anyone know how I can achieve this?
> >
> > Regards,
> > --
> > Noels
> > "The Best thing in life is life"
>
>