Adding commentary to a report

[#1]

Hello

I'm building some reports in QV for the users to export to PDF. They want to be able to add commentary to the report. So I've added an input text box. However there are two problems:

I can only display one line of text.

The box is not saved when you exit QV.

I really need these features to make the commentary box useable. Does anyone know a way of achieving this?

Many thanks.

[#2]

Hi James,

but must they add comment frequently?

Using some excel?

Or using a macro to export a file than read during next reload?

Stefano.

[#3]

They may not need to comment frequently. They want to be able to print the report to PDF, so they need to add comments into the application.

[#4 · Accepted solution]

Hi

Try taking input from a input box . Display the variable using a text box . If user want to enter a new line in comment recommend them to use \n character. It will create a newline in txt box

[Jason_Michaelides]

How about providing a simple Excel document for the commentary - maybe 3 columns for object/attribute, date and comment.  Then just point the QV doc to load from the spreadsheet.

Hope this helps,

Jason

[#6]

Thanks for your help

I guess it would work. But it might be tricky for the users to use it because they would need to know which cell in teh spreadsheet went with which part of the report. Also the application is set to update once per day, the users can't reload it themselves, so we'd have to keep doing a manual reload everytime they wanted to include their comments, which isn't practical.

[#7]

That works quite well. Is there a way to save the contents of the inbox so that the same commentary is there the next time they open the application?