append items to a dataset

Hi,
I have a dataset, which is used for a listbox to display items. I
need to append new static items to the ones returned by the dataset, without
making any changes to the original db. Can anyone help'
ThanksHi!
Not sure if this is exactly what you want, but if you edit the dataset
and then select the fields tab, you can add fields on that screen. For
'type' select calculated.
Bob
"Loui Mercieca" <loui@.gfi.com> wrote in message
news:eqgmsQymEHA.3868@.TK2MSFTNGP11.phx.gbl...
> Hi,
> I have a dataset, which is used for a listbox to display items. I
> need to append new static items to the ones returned by the dataset,
without
> making any changes to the original db. Can anyone help'
> Thanks
>|||Note: Right clicking in Report Designer's Fields Window will expose adding,
editing, or deleting fields.
You can combine static text with data returned from a query in a textbox by
using an expression:
="Some static text" & Fields!<FieldName>.Value
This notion can be extended to handle situations where the static text needs
to be applied dynamically.
Assume that field in the example is an integer:
=iif(Fields!<FieldName>.Value < 100, "The target was missed: " &
Fields!<FieldName>.Value, "The target was exceed: " &
Fields!<FieldName>.Value)
Please see using expression in SQL Server 2000 Reporting Services BOL.
--
Bruce Johnson [MSFT]
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Bob Hug" <JediMasterHug@._Remove_bobhug.com> wrote in message
news:%23308m6zmEHA.596@.TK2MSFTNGP11.phx.gbl...
> Hi!
> Not sure if this is exactly what you want, but if you edit the dataset
> and then select the fields tab, you can add fields on that screen. For
> 'type' select calculated.
> Bob
> "Loui Mercieca" <loui@.gfi.com> wrote in message
> news:eqgmsQymEHA.3868@.TK2MSFTNGP11.phx.gbl...
> > Hi,
> > I have a dataset, which is used for a listbox to display items.
I
> > need to append new static items to the ones returned by the dataset,
> without
> > making any changes to the original db. Can anyone help'
> >
> > Thanks
> >
> >
>