Report Parameters - multiple value labels

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

schmidtkaren - 27 Feb 2007 06:24 GMT

I have created a query for a parameter ie:
select id. name, type
from tablea
I would like to show both name & type in the value (drop down list for
user). How can I do that?

Signature

Karen
Systems Analyst

Reply to this Message

Amarnath - 27 Feb 2007 09:36 GMT

make sure you are using the same data type for name & type ie string
otherwise convert it to string.. you can give something like this
select id.name + ' ' + type as toshow from tablea a
and select the toshow from the report parameter "from query" and see to that
the parameter you are going to use, if it is just name or type, use "mid
func" to extract the string you want to use for the result set in the query.

Amarnath

> I have created a query for a parameter ie:
> select id. name, type
> from tablea
> I would like to show both name & type in the value (drop down list for
> user). How can I do that?

Reply to this Message

schmidtkaren - 27 Feb 2007 20:43 GMT

Thanks for your response. Sorry, I should have been more descriptive. I did
try stringing the fields together, but the name and type fields vary in
length so I get a very scattered looking drop down. Ie. where the name =
Audit of Energy and Type=Attest, in the list I get:

Audit of Energy Attest
Perform Measures Systems

However, I would like see the Names alligned and the Types alligned:
Name Type
Audit of Energy Attest
Perform Measures Systems

Signature

Systems Analyst
Office of the Auditor General of Alberta

> make sure you are using the same data type for name & type ie string
> otherwise convert it to string.. you can give something like this
[quoted text clipped - 10 lines]
> > I would like to show both name & type in the value (drop down list for
> > user). How can I do that?

Reply to this Message

David Bienstock - 27 Feb 2007 23:39 GMT

try

select right(' '+id.name,30) + ' ' + right(' ' +
type,30)
from tablea

you can change the amount of spaces and the max length (e.g. 30)

Signature

"Everyone knows something you don't know"

> Thanks for your response. Sorry, I should have been more descriptive. I did
> try stringing the fields together, but the name and type fields vary in
[quoted text clipped - 23 lines]
> > > I would like to show both name & type in the value (drop down list for
> > > user). How can I do that?

Reply to this Message

Amarnath - 28 Feb 2007 08:55 GMT

Yes you can refer the other post, basically you can pad with space and display.

Amarnath

Reply to this Message