This content has been marked as final. Show 16 replies
Please search the forum before posting new question and also make sure add enough information when posting.
Shital Patel wrote:Edit the note field and change the display text as to Display As Text (Escape special Characters) and under conditional Display set the condition to Request = Expression 1 and in Expression 1 enter CSV
In interactive report how to include hidden column of report in download file(CSV).
For example if I have "Note" field,which is hidden in IR,but what if i need this field in downloaded .CSV file.
Shital Patel wrote:Thanks for mentioning the version.
I already have gone through all OTN forums as well your solution.It's not working in case of Interactive report on Application Express 4.0.2.00.07.... :( :(
OK, what do you mean by it's not working? can you please explain in bit more detail
I have followed all steps as you mentioned ,but its still not working.Can't find the field in downloaded CSV file :(
1.Have edited filed as Display As Text (Escape special Characters) . 2.where in conditional Type Request = Expression 1 and Expression 1 CSV (without quotes)
Edited by: Shital Patel on Jan 24, 2013 4:16 AM
Hey have just noticed one thing while downloading the csv file name is like nbsp;
I have specified Download->filename then filename is like filename.csv.
Is this the problem not checking the condition?
Edited by: Shital Patel on Jan 24, 2013 6:10 AM
Edited by: Shital Patel on Jan 24, 2013 6:25 AM
Shital Patel wrote:I don't need the whole URL, just wanted to know what's there in the place of REQUEST
Can't share link here.have tried on apex.oracle.there it's working fine.How come it's not working on my application?:(
f?p=110:4:1927438212600:CSV::: //this is sample csv download url, what's there in your URL in place of CSV
OK, I suspect the column is not set to display in the report.
can you try these things?
1. Edit the column note and remove the conditional display and set it to display always.
2. Run the page and go to IR Actions menu > Select Columns > include the Notes column to show in the IR report and Apply +(also save this as default report, only available for developers)+
3. For testing download the CSV and make sure the column is appearing in .csv
4. If it appears > then go back to report attributes > edit note column > and put the above condition back
i.e. under conditional Display set the condition to Request = Expression 1 and in Expression 1 enter CSV
5. Try csv download now and let me know