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 strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

prompt for text vlues then add it into report

Status
Not open for further replies.

Cpreston

MIS
Mar 4, 2015
972
GB
Hi

I want to be able to add prompts to add text into a report (when report is refreshed).

So the user would be aske to enter

Pack Number
Description
Tally

and they then show on the report just as text.

I assume I do this through parameters but cant figure out how to do it, any ideas please

Thanks
 
Just make a prompt with set values. Then drop that prompt into the report where you you need it.
 
I have got this so far, how can I out spaces in between them please, all text is joined together currently

"Pack: " + {?Pack} + {?desc} + {?tally}

thanks

 
Hi

Its ok I managed it with this

"Pack: " + {?Pack} +" "+ {?desc} +" "+ {?tally}

Thanks
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top