Prompt for Criteria dispay as a Report Header

[Jay]

is anyone know how to you Prompt for Criteria dispay as a Report Header. I
have more than one values to use for Prompt for Criteria.

String array as retrieval arguments's datatype doesn't work so I am using
Prompt for Criteria

Thnaks in advance
Jay

["or_shoham"]

Not possible. Data entered into the prompt for criteria screen is entirely
invisible in the actual report.
Or

[Terry Dykstra]

The basic syntax is simply:

select * from mytable
where thecolumn in ('val1','val2').

What database are you using? With ASA you could use a list() function, e.g.
list(thecolumn), which would return "'val1','val2'" as the value. Then you
could display that column on your report.
For other databases like Oracle you can write a function to do the same
thing.

--
Terry Dykstra (TeamSybase)
Please state PB / OS / DB versions in your post.
SDN: http://www.sybase.com/developer/
http://www.pb9books.com

<Jay> wrote in message
news:5A82610F6BC1F125005477C185256D66.006CE6A785256D65@webforums...
> Is anyone know how do I use select statement with where clause for example
> is in('pc300','pc330')? because I can not use retrievel argument as
sttring
> array nor prompt for criteria because I want to dispaly those values on
> report header and none of them solution works.
>
> Thanks in advance
> Jay

[Jay]

I am using SQL Server.
I want user to type those values and display those values on Report Header

Thanks a lot
Jay

[dk]

Not true. Create a calculated field for the header - and the Prompt fields
are listed in the Columns section.

[Or Shoham]

Those are the retrieval arguements, not the prompt for criteria..
Or

dk wrote in message news:<75E98FAC427FD3760056A5CD85256D6C.006CE6A785256D65@webforums>...