Hi Hashim,
Prompt-elements are not supported in Excel files as they can't change into an appropriate Excel object. You would have to place a report expression instead into the list that is used for the Excel export.
Before we dive deeper into that I'd like to point out that text prompts in a list don't allow you to enter values separately for each line. the prompt is tied to a parameter and this will be repeated for each row. Here's an example:
![](https://dw1.s81c.com//IMWUC/MessageImages/36753a6b79694d42a3d18416f1607b92.png)
If I now run the report and enter different values in the lines and hit "Reprompt" the last value will appear in all lines:
![](https://dw1.s81c.com//IMWUC/MessageImages/99de12d3e4c24039af3a76ded129782f.png)
![](https://dw1.s81c.com//IMWUC/MessageImages/5632c7d2588049eab734e7460996fd53.png)
Therefore the text prompt won't let you enter values for each line. Even if you mange it to pass the values to the Excel files, you will end up with this:
![](https://dw1.s81c.com//IMWUC/MessageImages/7d4c3731b44d4ac3be1f4e9c8965fde2.png)
If you want users to be able to enter values, I suggest to implement a stored procedure that writes back values to the database or user Apparo FastEdit - which comes free for one business case and a few users. You can look it up in the IBM Accelerator Catalog:
https://ibm.biz/acccatalog
There might be other solutions but you would need to use the Master Detail Relationships if that is even possible to link a parameter to each key of the list rows.
I don't have the time at the moment to try this out. I'm using Store Procedures to allow data input for users. Down side: STP are not supported in data modules, you would have to use Framework Manager instead.
Question?
------------------------------
Robert Dostal
Team Leader BI
GEMÜ Gebr. Müller Apparatebau GmbH & Co. KG
Ingelfingen
------------------------------
Original Message:
Sent: Sat May 18, 2024 07:41 AM
From: Hashim Raza
Subject: Add a Column in Cognos report at runtime, and will be available in Excel format.
HI Robert - i just added a Text prompt in my List in the Design Mode, and after Run the report i am able to write values there, but these values are not exported in Excel, while on browser we can write our values. we can say Write back there .
Thanks.
------------------------------
Hashim Raza
Original Message:
Sent: Fri May 10, 2024 02:36 AM
From: Robert Dostal
Subject: Add a Column in Cognos report at runtime, and will be available in Excel format.
Hi Hashim,
I assume you use a list data container in your report, correct? How did you add the column and what exactly do you mean with "place values in that column"? Is there some write back functionality?
------------------------------
Robert Dostal
Team Leader BI
GEMÜ Gebr. Müller Apparatebau GmbH & Co. KG
Ingelfingen
Original Message:
Sent: Wed May 08, 2024 12:54 PM
From: Hashim Raza
Subject: Add a Column in Cognos report at runtime, and will be available in Excel format.
Hi Team - i have added a Column in Cognos report and we are able to place values in that column, but when we extract in any format like Excel /PDF, that column remain blank.
any idea to solve this
Thanks.
------------------------------
Hashim Raza
------------------------------