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!

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

Parameter-multi-display on report header 1

Status
Not open for further replies.
mdahlen

mdahlen

Technical User
Feb 26, 2003
6
US
There is a dynamic parameter (numeric type) that is for locations--multi reponse. How can I convert those values to the name of the locations and display them in the report header?
So, parmeter values are 13000, 14000, 14288.
I want displayed on the report:
Locations: Hospital A, Hospital B, Clinic C
 
Sort by date Sort by votes
YOu could use a subreport with the same parameter linked from the main report. The sub report contains the table which relates key to hospital name. then just get subreport to list hospital names.

Ian
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Corinne30
  • Locked
  • Question
Running total based on beginning parameter value
Replies
0
Views
183
Corinne30
Corinne30
Corinne30
  • Locked
  • Question
Running total based on beginning parameter value
Replies
0
Views
186
Corinne30
Corinne30
milisql
  • Locked
  • Question
Column Header in CrossTab Report
Replies
1
Views
924
hilfy
hilfy
tlbrown88
  • Locked
  • Question
How does one get the results of a Calculation (SharedVar) on the same line as the Sub Report?
Replies
4
Views
635
tlbrown88
tlbrown88
jchewsmith
  • Locked
  • Question
Report filter to run report yeartodate through yesterday
Replies
0
Views
416
jchewsmith
jchewsmith

Part and Inventory Search

Sponsor

Back
Top