List

Hi,
I would like to create a dynamic legenda.
Like this: ATV=Arbeids Tijd Verkorting, BV=Buitengewoon verlof, CRS=Cursus,
DET=Detachering, DIV=Diversen, DR=Dienstreis, ESV=Externe steunverlening,
FV=Flex Verlof, GER=Gereserveerd, HSP=Hospitaal, ISV=Interne steunverlening,
KAZ=Kazernedienst, LES=Les, MUT=Mutatie, OBV=Onbetaald Verlof,
ODD=Onderdeelsdienst
Therefor i have to get 2 fields in a textbox, showing all the records from
the tabel.
Now i get this:
ATV=Arbeids Tijd Verkorting,
BV=Buitengewoon verlof,
CRS=Cursus,
DET=Detachering,
DIV=Diversen,
DR=Dienstreis,
Etc.
How can i make these values to the place beside each other?
Gr.
MikeIF you want them displayed like your example below, use this:
=Fields!CodeField.Value & "=" & Fields!DescriptionField.Value
If you want them displayed side-by-side in columns, use a table.
--
Cheers,
'(' Jeff A. Stucker
\
Business Intelligence
www.criadvantage.com
---
"Mike Klaarhamer" <MikeKlaarhamer@.discussions.microsoft.com> wrote in
message news:F1AA7DB9-773D-4D84-BA86-2AE871F514B9@.microsoft.com...
> Hi,
> I would like to create a dynamic legenda.
> Like this: ATV=Arbeids Tijd Verkorting, BV=Buitengewoon verlof,
> CRS=Cursus,
> DET=Detachering, DIV=Diversen, DR=Dienstreis, ESV=Externe steunverlening,
> FV=Flex Verlof, GER=Gereserveerd, HSP=Hospitaal, ISV=Interne
> steunverlening,
> KAZ=Kazernedienst, LES=Les, MUT=Mutatie, OBV=Onbetaald Verlof,
> ODD=Onderdeelsdienst
> Therefor i have to get 2 fields in a textbox, showing all the records from
> the tabel.
> Now i get this:
> ATV=Arbeids Tijd Verkorting,
> BV=Buitengewoon verlof,
> CRS=Cursus,
> DET=Detachering,
> DIV=Diversen,
> DR=Dienstreis,
> Etc.
> How can i make these values to the place beside each other?
> Gr.
> Mike|||When i put =Fields!CodeField.Value & "=" & Fields!DescriptionField.Value & ",
" in a textbox, then i don't get the values beside eachother :(
Is there an property in the textbox where i can make this happen?
"Jeff A. Stucker" wrote:
> IF you want them displayed like your example below, use this:
> =Fields!CodeField.Value & "=" & Fields!DescriptionField.Value
> If you want them displayed side-by-side in columns, use a table.
> --
> Cheers,
> '(' Jeff A. Stucker
> \
> Business Intelligence
> www.criadvantage.com
> ---
> "Mike Klaarhamer" <MikeKlaarhamer@.discussions.microsoft.com> wrote in
> message news:F1AA7DB9-773D-4D84-BA86-2AE871F514B9@.microsoft.com...
> > Hi,
> > I would like to create a dynamic legenda.
> > Like this: ATV=Arbeids Tijd Verkorting, BV=Buitengewoon verlof,
> > CRS=Cursus,
> > DET=Detachering, DIV=Diversen, DR=Dienstreis, ESV=Externe steunverlening,
> > FV=Flex Verlof, GER=Gereserveerd, HSP=Hospitaal, ISV=Interne
> > steunverlening,
> > KAZ=Kazernedienst, LES=Les, MUT=Mutatie, OBV=Onbetaald Verlof,
> > ODD=Onderdeelsdienst
> >
> > Therefor i have to get 2 fields in a textbox, showing all the records from
> > the tabel.
> > Now i get this:
> > ATV=Arbeids Tijd Verkorting,
> > BV=Buitengewoon verlof,
> > CRS=Cursus,
> > DET=Detachering,
> > DIV=Diversen,
> > DR=Dienstreis,
> > Etc.
> >
> > How can i make these values to the place beside each other?
> >
> > Gr.
> >
> > Mike
>
>|||Not sure what you mean by "don't get values beside each other"... What are
you seeing?
--
Cheers,
'(' Jeff A. Stucker
\
Business Intelligence
www.criadvantage.com
---
"Mike Klaarhamer" <MikeKlaarhamer@.discussions.microsoft.com> wrote in
message news:6F51609A-C126-4BBE-BE29-896A225AB4AE@.microsoft.com...
> When i put =Fields!CodeField.Value & "=" & Fields!DescriptionField.Value &
> ",
> " in a textbox, then i don't get the values beside eachother :(
> Is there an property in the textbox where i can make this happen?
>
> "Jeff A. Stucker" wrote:
>> IF you want them displayed like your example below, use this:
>> =Fields!CodeField.Value & "=" & Fields!DescriptionField.Value
>> If you want them displayed side-by-side in columns, use a table.
>> --
>> Cheers,
>> '(' Jeff A. Stucker
>> \
>> Business Intelligence
>> www.criadvantage.com
>> ---
>> "Mike Klaarhamer" <MikeKlaarhamer@.discussions.microsoft.com> wrote in
>> message news:F1AA7DB9-773D-4D84-BA86-2AE871F514B9@.microsoft.com...
>> > Hi,
>> > I would like to create a dynamic legenda.
>> > Like this: ATV=Arbeids Tijd Verkorting, BV=Buitengewoon verlof,
>> > CRS=Cursus,
>> > DET=Detachering, DIV=Diversen, DR=Dienstreis, ESV=Externe
>> > steunverlening,
>> > FV=Flex Verlof, GER=Gereserveerd, HSP=Hospitaal, ISV=Interne
>> > steunverlening,
>> > KAZ=Kazernedienst, LES=Les, MUT=Mutatie, OBV=Onbetaald Verlof,
>> > ODD=Onderdeelsdienst
>> >
>> > Therefor i have to get 2 fields in a textbox, showing all the records
>> > from
>> > the tabel.
>> > Now i get this:
>> > ATV=Arbeids Tijd Verkorting,
>> > BV=Buitengewoon verlof,
>> > CRS=Cursus,
>> > DET=Detachering,
>> > DIV=Diversen,
>> > DR=Dienstreis,
>> > Etc.
>> >
>> > How can i make these values to the place beside each other?
>> >
>> > Gr.
>> >
>> > Mike
>>|||Sorry, my english is not that good :S
I see:
ATV=Arbeids Tijd Verkorting,
BV=Buitengewoon verlof,
CRS=Cursus,
DET=Detachering,
DIV=Diversen,
DR=Dienstreis,
Etc.
I would like:
ATV=Arbeids Tijd Verkorting, BV=Buitengewoon verlof, CRS=Cursus,
DET=Detachering, DIV=Diversen, DR=Dienstreis, ESV=Externe steunverlening,
FV=Flex Verlof, GER=Gereserveerd, HSP=Hospitaal, ISV=Interne steunverlening,
KAZ=Kazernedienst, LES=Les, MUT=Mutatie, OBV=Onbetaald Verlof,
ODD=Onderdeelsdienst
I hope you can help me...
Gr.
Mike
"Jeff A. Stucker" wrote:
> Not sure what you mean by "don't get values beside each other"... What are
> you seeing?
> --
> Cheers,
> '(' Jeff A. Stucker
> \
> Business Intelligence
> www.criadvantage.com
> ---
> "Mike Klaarhamer" <MikeKlaarhamer@.discussions.microsoft.com> wrote in
> message news:6F51609A-C126-4BBE-BE29-896A225AB4AE@.microsoft.com...
> > When i put =Fields!CodeField.Value & "=" & Fields!DescriptionField.Value &
> > ",
> > " in a textbox, then i don't get the values beside eachother :(
> > Is there an property in the textbox where i can make this happen?
> >
> >
> >
> > "Jeff A. Stucker" wrote:
> >
> >> IF you want them displayed like your example below, use this:
> >>
> >> =Fields!CodeField.Value & "=" & Fields!DescriptionField.Value
> >>
> >> If you want them displayed side-by-side in columns, use a table.
> >>
> >> --
> >> Cheers,
> >>
> >> '(' Jeff A. Stucker
> >> \
> >>
> >> Business Intelligence
> >> www.criadvantage.com
> >> ---
> >> "Mike Klaarhamer" <MikeKlaarhamer@.discussions.microsoft.com> wrote in
> >> message news:F1AA7DB9-773D-4D84-BA86-2AE871F514B9@.microsoft.com...
> >> > Hi,
> >> > I would like to create a dynamic legenda.
> >> > Like this: ATV=Arbeids Tijd Verkorting, BV=Buitengewoon verlof,
> >> > CRS=Cursus,
> >> > DET=Detachering, DIV=Diversen, DR=Dienstreis, ESV=Externe
> >> > steunverlening,
> >> > FV=Flex Verlof, GER=Gereserveerd, HSP=Hospitaal, ISV=Interne
> >> > steunverlening,
> >> > KAZ=Kazernedienst, LES=Les, MUT=Mutatie, OBV=Onbetaald Verlof,
> >> > ODD=Onderdeelsdienst
> >> >
> >> > Therefor i have to get 2 fields in a textbox, showing all the records
> >> > from
> >> > the tabel.
> >> > Now i get this:
> >> > ATV=Arbeids Tijd Verkorting,
> >> > BV=Buitengewoon verlof,
> >> > CRS=Cursus,
> >> > DET=Detachering,
> >> > DIV=Diversen,
> >> > DR=Dienstreis,
> >> > Etc.
> >> >
> >> > How can i make these values to the place beside each other?
> >> >
> >> > Gr.
> >> >
> >> > Mike
> >>
> >>
> >>
>
>|||Okay, now I understand exactly what you are asking. Unfortunately, I don't
know the answer.
Does anyone else know how to concatenate values from multiple rows into a
single line on a textbox?
--
Cheers,
'(' Jeff A. Stucker
\
Business Intelligence
www.criadvantage.com
---
"Mike Klaarhamer" <MikeKlaarhamer@.discussions.microsoft.com> wrote in
message news:301A5272-F993-43DD-8E92-900F4B886CEF@.microsoft.com...
> Sorry, my english is not that good :S
> I see:
> ATV=Arbeids Tijd Verkorting,
> BV=Buitengewoon verlof,
> CRS=Cursus,
> DET=Detachering,
> DIV=Diversen,
> DR=Dienstreis,
> Etc.
> I would like:
> ATV=Arbeids Tijd Verkorting, BV=Buitengewoon verlof, CRS=Cursus,
> DET=Detachering, DIV=Diversen, DR=Dienstreis, ESV=Externe steunverlening,
> FV=Flex Verlof, GER=Gereserveerd, HSP=Hospitaal, ISV=Interne
> steunverlening,
> KAZ=Kazernedienst, LES=Les, MUT=Mutatie, OBV=Onbetaald Verlof,
> ODD=Onderdeelsdienst
> I hope you can help me...
> Gr.
> Mike
>
> "Jeff A. Stucker" wrote:
>> Not sure what you mean by "don't get values beside each other"... What
>> are
>> you seeing?
>> --
>> Cheers,
>> '(' Jeff A. Stucker
>> \
>> Business Intelligence
>> www.criadvantage.com
>> ---
>> "Mike Klaarhamer" <MikeKlaarhamer@.discussions.microsoft.com> wrote in
>> message news:6F51609A-C126-4BBE-BE29-896A225AB4AE@.microsoft.com...
>> > When i put =Fields!CodeField.Value & "=" &
>> > Fields!DescriptionField.Value &
>> > ",
>> > " in a textbox, then i don't get the values beside eachother :(
>> > Is there an property in the textbox where i can make this happen?
>> >
>> >
>> >
>> > "Jeff A. Stucker" wrote:
>> >
>> >> IF you want them displayed like your example below, use this:
>> >>
>> >> =Fields!CodeField.Value & "=" & Fields!DescriptionField.Value
>> >>
>> >> If you want them displayed side-by-side in columns, use a table.
>> >>
>> >> --
>> >> Cheers,
>> >>
>> >> '(' Jeff A. Stucker
>> >> \
>> >>
>> >> Business Intelligence
>> >> www.criadvantage.com
>> >> ---
>> >> "Mike Klaarhamer" <MikeKlaarhamer@.discussions.microsoft.com> wrote in
>> >> message news:F1AA7DB9-773D-4D84-BA86-2AE871F514B9@.microsoft.com...
>> >> > Hi,
>> >> > I would like to create a dynamic legenda.
>> >> > Like this: ATV=Arbeids Tijd Verkorting, BV=Buitengewoon verlof,
>> >> > CRS=Cursus,
>> >> > DET=Detachering, DIV=Diversen, DR=Dienstreis, ESV=Externe
>> >> > steunverlening,
>> >> > FV=Flex Verlof, GER=Gereserveerd, HSP=Hospitaal, ISV=Interne
>> >> > steunverlening,
>> >> > KAZ=Kazernedienst, LES=Les, MUT=Mutatie, OBV=Onbetaald Verlof,
>> >> > ODD=Onderdeelsdienst
>> >> >
>> >> > Therefor i have to get 2 fields in a textbox, showing all the
>> >> > records
>> >> > from
>> >> > the tabel.
>> >> > Now i get this:
>> >> > ATV=Arbeids Tijd Verkorting,
>> >> > BV=Buitengewoon verlof,
>> >> > CRS=Cursus,
>> >> > DET=Detachering,
>> >> > DIV=Diversen,
>> >> > DR=Dienstreis,
>> >> > Etc.
>> >> >
>> >> > How can i make these values to the place beside each other?
>> >> >
>> >> > Gr.
>> >> >
>> >> > Mike
>> >>
>> >>
>> >>
>>|||I solved the problem with a Cursor, made in a stored procedure...
But i think there must be a more easy way to do this...
If not, then i hope it is possible in a next version of the program.
Mike
"Jeff A. Stucker" wrote:
> Okay, now I understand exactly what you are asking. Unfortunately, I don't
> know the answer.
> Does anyone else know how to concatenate values from multiple rows into a
> single line on a textbox?
> --
> Cheers,
> '(' Jeff A. Stucker
> \
> Business Intelligence
> www.criadvantage.com
> ---
> "Mike Klaarhamer" <MikeKlaarhamer@.discussions.microsoft.com> wrote in
> message news:301A5272-F993-43DD-8E92-900F4B886CEF@.microsoft.com...
> > Sorry, my english is not that good :S
> >
> > I see:
> > ATV=Arbeids Tijd Verkorting,
> > BV=Buitengewoon verlof,
> > CRS=Cursus,
> > DET=Detachering,
> > DIV=Diversen,
> > DR=Dienstreis,
> > Etc.
> >
> > I would like:
> > ATV=Arbeids Tijd Verkorting, BV=Buitengewoon verlof, CRS=Cursus,
> > DET=Detachering, DIV=Diversen, DR=Dienstreis, ESV=Externe steunverlening,
> > FV=Flex Verlof, GER=Gereserveerd, HSP=Hospitaal, ISV=Interne
> > steunverlening,
> > KAZ=Kazernedienst, LES=Les, MUT=Mutatie, OBV=Onbetaald Verlof,
> > ODD=Onderdeelsdienst
> >
> > I hope you can help me...
> >
> > Gr.
> >
> > Mike
> >
> >
> > "Jeff A. Stucker" wrote:
> >
> >> Not sure what you mean by "don't get values beside each other"... What
> >> are
> >> you seeing?
> >>
> >> --
> >> Cheers,
> >>
> >> '(' Jeff A. Stucker
> >> \
> >>
> >> Business Intelligence
> >> www.criadvantage.com
> >> ---
> >> "Mike Klaarhamer" <MikeKlaarhamer@.discussions.microsoft.com> wrote in
> >> message news:6F51609A-C126-4BBE-BE29-896A225AB4AE@.microsoft.com...
> >> > When i put =Fields!CodeField.Value & "=" &
> >> > Fields!DescriptionField.Value &
> >> > ",
> >> > " in a textbox, then i don't get the values beside eachother :(
> >> > Is there an property in the textbox where i can make this happen?
> >> >
> >> >
> >> >
> >> > "Jeff A. Stucker" wrote:
> >> >
> >> >> IF you want them displayed like your example below, use this:
> >> >>
> >> >> =Fields!CodeField.Value & "=" & Fields!DescriptionField.Value
> >> >>
> >> >> If you want them displayed side-by-side in columns, use a table.
> >> >>
> >> >> --
> >> >> Cheers,
> >> >>
> >> >> '(' Jeff A. Stucker
> >> >> \
> >> >>
> >> >> Business Intelligence
> >> >> www.criadvantage.com
> >> >> ---
> >> >> "Mike Klaarhamer" <MikeKlaarhamer@.discussions.microsoft.com> wrote in
> >> >> message news:F1AA7DB9-773D-4D84-BA86-2AE871F514B9@.microsoft.com...
> >> >> > Hi,
> >> >> > I would like to create a dynamic legenda.
> >> >> > Like this: ATV=Arbeids Tijd Verkorting, BV=Buitengewoon verlof,
> >> >> > CRS=Cursus,
> >> >> > DET=Detachering, DIV=Diversen, DR=Dienstreis, ESV=Externe
> >> >> > steunverlening,
> >> >> > FV=Flex Verlof, GER=Gereserveerd, HSP=Hospitaal, ISV=Interne
> >> >> > steunverlening,
> >> >> > KAZ=Kazernedienst, LES=Les, MUT=Mutatie, OBV=Onbetaald Verlof,
> >> >> > ODD=Onderdeelsdienst
> >> >> >
> >> >> > Therefor i have to get 2 fields in a textbox, showing all the
> >> >> > records
> >> >> > from
> >> >> > the tabel.
> >> >> > Now i get this:
> >> >> > ATV=Arbeids Tijd Verkorting,
> >> >> > BV=Buitengewoon verlof,
> >> >> > CRS=Cursus,
> >> >> > DET=Detachering,
> >> >> > DIV=Diversen,
> >> >> > DR=Dienstreis,
> >> >> > Etc.
> >> >> >
> >> >> > How can i make these values to the place beside each other?
> >> >> >
> >> >> > Gr.
> >> >> >
> >> >> > Mike
> >> >>
> >> >>
> >> >>
> >>
> >>
> >>
>
>