Newbie question - prompt user for data

[mjcomea]

I need to create what seems like a simple report that shows storage devices and their used capacity. This is very easy to do but I need to add a column to the table that shows the licensed capacity so I can then calculate the used vs licensed capacity. Licensed capacity needs to be input by the user on a per-device basis. Is there a simple way to do this?

[BigChris]

Just create a prompt for the user to type into, say ?Licensed Capacity? then in your query just bring that in as a column.

[mjcomea]

Every row needs a different entry. I've tried to figure out how to make a prompt that asked for each row but I couldn't figure it out.

[BigChris]

Sounds like you need a table in your database to hold those values then. Or alternatively perhaps a spreadsheet that you can bring into your report as external data...

[navissar]

There is, in fact, a very cute technique for creating repeating prompts and using their values. Like most cute techniques you get, it was developed by Paul. Check out the bottom part of this post: http://cognospaul.com/2014/01/02/creating-data-entry-page-cognos/