Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

how to get all the values in a field

Status
Not open for further replies.

JavidRaj

Programmer
Nov 10, 2000
9
US
Hi,
In my report I want to show all the values for a particular field in the same place. for ex
i createa report like this

Group Names : groupview.group_name

where groupview is the view name in the db and group_name is the name of that field in that view.
say for ex the group_name field has the following values
Group1,Group2,Group3,Group1,Group4,Group2.......................

I want to show the values Group1,Group2,Group3,Group4 in the report at one place where i put the variable groupview.group_name
(if I put like the above it shows only Group1 not all others)

how to do this.

and also is there anyway I can retrieve the values which I gave in the url to the report.
like if i give
or {Groupview.Group_name}='Group2' or {Groupview.Group_name}='Group3'

it should show the values
Group1,Group2,Group3 in the report

any idea for this

thanks
Javid
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top